Query editor
SELECT DISTINCTquestion,ROUND(date_diff('minute', market_start_time, market_end_time)/60.0, 2) AS dur_hours,market_start_time,market_end_timeFROM polymarket_polygon.market_detailsWHERE LOWER(question) LIKE '%up or down%'AND (LOWER(question) LIKE '%hour%' OR LOWER(question) LIKE '%hourly%')AND market_end_time >= TIMESTAMP '2026-09-01'AND market_end_time < TIMESTAMP '2026-10-13'ORDER BY market_start_time DESCLIMIT 30