Query editor
WITH src AS (SELECT DISTINCTquestion,market_start_time,market_end_time,CASEWHEN STRPOS(LOWER(market_description), 'chainlink') > 0 THEN 'Chainlink (crypto, 5/15-min)'WHEN STRPOS(LOWER(market_description), 'pyth') > 0 THEN 'Pyth (single stocks, metals)'WHEN STRPOS(LOWER(market_description), 'wall street journal') > 0OR STRPOS(LOWER(market_description), 'wsj') > 0 THEN 'WSJ close (indices)'ELSE 'Binance candle page (hourly crypto) & other'END AS resolution_sourceFROM polymarket_polygon.market_detailsWHERE LOWER(question) LIKE '%up or down%'AND market_end_time >= TIMESTAMP '2026-08-25'AND market_end_time < TIMESTAMP '2026-10-08')SELECTquestion,ROUND(date_diff('minute', market_start_time, market_end_time) / 60.0, 1) AS duration_hours,market_start_time,market_end_timeFROM srcWHERE resolution_source = 'Binance candle page (hourly crypto) & other'ORDER BY duration_hours DESCLIMIT 30