Query editor
WITH m AS (SELECT DISTINCTquestion,date_diff('minute', market_start_time, market_end_time) AS dur_min,CASEWHEN regexp_like(question, '\d{1,2}:\d{2}[AP]M-\d{1,2}:\d{2}[AP]M') THEN 'A) has minute range (X:XX-Y:YY)'WHEN regexp_like(question, ', \d{1,2}(AM|PM) ET') THEN 'B) single time (, 7PM ET)'WHEN LOWER(question) LIKE '%up or down on %' THEN 'C) up or down on <date>'ELSE 'D) other'END AS title_patternFROM 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')SELECTtitle_pattern,COUNT(*) AS markets,ROUND(MIN(dur_min)/60.0, 1) AS min_h,ROUND(APPROX_PERCENTILE(dur_min, 0.5)/60.0, 1) AS median_h,ROUND(MAX(dur_min)/60.0, 1) AS max_h,ARBITRARY(question) AS sampleFROM mGROUP BY 1ORDER BY 1