Query editor
-- Polymarket "Up or Down" PRICE markets, Sep 2026.-- Frequency : from Polymarket's own tags (5M / 15M / 1H / 4H / Daily) - authoritative, not title-parsed.-- Source : parsed from each market's resolution rules (market_description).-- Volume : taker-side only, to avoid double-counting maker + taker legs.-- Scope : price markets only (category crypto/finance); non-price 'up or down' (elections, approval) excluded.WITH market AS ( -- one row per market: frequency + settlement sourceSELECT 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, 'Daily') OR contains(tags, 'Daily-Close') THEN '5) daily'ELSE '6) other'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'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' -- buffer around Sep for month-edge marketsAND market_end_time < TIMESTAMP '2026-10-08'),trades AS ( -- September taker-side volume per marketSELECT 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.frequency,m.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 1, 2ORDER BY volume_usd DESC