Query editor
WITH m AS (SELECT DISTINCTquestion,category,tags,market_description,market_start_time,market_end_time,date_diff('minute', market_start_time, market_end_time) AS dur_minFROM polymarket_polygon.market_detailsWHERE LOWER(question) LIKE '%up or down%'AND market_end_time >= TIMESTAMP '2026-09-01'AND market_end_time < TIMESTAMP '2026-10-13')SELECTcategory,COUNT(*) AS markets,ROUND(MIN(dur_min) / 60.0, 1) AS min_hours,ROUND(APPROX_PERCENTILE(dur_min, 0.5) / 60.0, 1) AS median_hours,ROUND(MAX(dur_min) / 60.0, 1) AS max_hours,ARBITRARY(question) AS sample_questionFROM mGROUP BY 1ORDER BY markets DESC