Query editor
WITH market AS (SELECT DISTINCT question, market_description, tagsFROM 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'AND STRPOS(LOWER(market_description), 'chainlink') = 0AND STRPOS(LOWER(market_description), 'pyth') = 0AND STRPOS(LOWER(market_description), 'wsj') = 0AND STRPOS(LOWER(market_description), 'wall street journal') = 0AND STRPOS(LOWER(market_description), 'binance') = 0),trades AS (SELECT question, SUM(amount) AS volume_usdFROM polymarket_polygon.market_tradesWHERE block_month = DATE '2026-09-01'AND is_taker_side = trueAND LOWER(question) LIKE '%up or down%'GROUP BY question)SELECT m.question, t.volume_usd, m.market_descriptionFROM market mJOIN trades t ON t.question = m.questionORDER BY t.volume_usd DESC