Analyzing Twitch streams with Materialize: what gaming streams started in the last 15 min?

twitch_temporal_filter.sql

CREATE MATERIALIZED VIEW mv_stream_15min AS
SELECT title,
       user_name,
       game_name,
       started_at
FROM v_twitch_stream
WHERE game_id IS NOT NULL
  --Use temporal filters to filter events with 
  --a sliding window of 15 minutes (900000 miliseconds)
  AND (mz_logical_timestamp() >= (extract('epoch' from started_at)*1000)::bigint 
  AND mz_logical_timestamp() < (extract('epoch' from started_at)*1000)::bigint + 900000);