Query editor
WITH md AS ( -- market -> frequency (from tags) + oracle (from rules text)SELECT DISTINCTquestion,CASEWHEN contains(tags, '5M') THEN '1) 5 min'WHEN contains(tags, '15M') THEN '2) 15 min'WHEN contains(tags, '1H') THEN '3) 1 hour'WHEN contains(tags, '4H') THEN '4) 4 hours'WHEN contains(tags, '1D') THEN '5) daily'ELSE '6) other / untagged'END AS frequency,CASEWHEN STRPOS(LOWER(market_description), 'chainlink') > 0 THEN 'Chainlink'WHEN STRPOS(LOWER(market_description), 'pyth') > 0 THEN 'Pyth'WHEN STRPOS(LOWER(market_description), 'wsj') > 0OR STRPOS(LOWER(market_description), 'wall street journal') > 0 THEN 'WSJ'ELSE 'other/unspecified'END AS oracleFROM 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')SELECTmd.frequency,md.oracle,SUM(t.amount) AS volume_usd,COUNT(DISTINCT t.question) AS marketsFROM polymarket_polygon.market_trades tJOIN md ON md.question = t.questionWHERE t.block_month = DATE '2026-09-01'AND t.is_taker_side = trueAND LOWER(t.question) LIKE '%up or down%'GROUP BY 1, 2ORDER BY 1, volume_usd DESC