Query editor
WITH m AS (SELECT DISTINCTquestion,-- minute-range form, e.g. 7:40PM-7:45PMregexp_extract(question, '(\d{1,2}:\d{2}[AP]M)-(\d{1,2}:\d{2}[AP]M)', 1) AS min_start,regexp_extract(question, '(\d{1,2}:\d{2}[AP]M)-(\d{1,2}:\d{2}[AP]M)', 2) AS min_end,-- hour-range form, e.g. 3PM-4PMregexp_extract(question, '(\d{1,2}[AP]M)-(\d{1,2}[AP]M)', 1) AS hr_start,regexp_extract(question, '(\d{1,2}[AP]M)-(\d{1,2}[AP]M)', 2) AS hr_endFROM polymarket_polygon.market_detailsWHERE LOWER(question) LIKE '%bitcoin up or down%'AND market_end_time >= TIMESTAMP '2026-09-01'AND market_end_time < TIMESTAMP '2026-10-13'),w AS (SELECTquestion,CASEWHEN min_start <> '' THEN (date_diff('minute', date_parse(min_start,'%h:%i%p'), date_parse(min_end,'%h:%i%p')) + 1440) % 1440WHEN hr_start <> '' THEN (date_diff('minute', date_parse(hr_start,'%h%p'), date_parse(hr_end,'%h%p')) + 1440) % 1440END AS window_minFROM m)SELECTCASEWHEN window_min = 5 THEN '1) 5-min window'WHEN window_min = 15 THEN '2) 15-min window'WHEN window_min > 15 AND window_min <= 60 THEN '3) hourly window'WHEN window_min > 60 THEN '4) multi-hour window'WHEN regexp_like(question, ', \d{1,2}(AM|PM) ET') THEN '5) daily (single ET time)'ELSE '6) other / no window in title'END AS window_bucket,COUNT(*) AS markets,ARBITRARY(question) AS sampleFROM wGROUP BY 1ORDER BY 1