Query editor
-- Polymarket "Up or Down" PRICE markets, Sep 2026 - settlement source by taker-side volume.-- Scope: price markets only (category crypto/finance); non-price 'up or down' excluded.WITH market AS (SELECT DISTINCTquestion,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'WHEN STRPOS(LOWER(market_description), 'binance') > 0 THEN 'Binance candle (CEX)'ELSE 'other / unspecified'END AS oracleFROM polymarket_polygon.market_detailsWHERE LOWER(question) LIKE '%up or down%'AND category IN ('crypto', 'finance') -- price markets onlyAND market_end_time >= TIMESTAMP '2026-08-25'AND market_end_time < TIMESTAMP '2026-10-08'),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)SELECTm.oracle,SUM(t.volume_usd) AS volume_usd,SUM(t.volume_usd) / SUM(SUM(t.volume_usd)) OVER () AS share_of_volume,COUNT(DISTINCT m.question) AS marketsFROM market mJOIN trades t ON t.question = m.questionGROUP BY 1ORDER BY volume_usd DESC