Query editor
WITH created_markets AS (SELECTcondition_id,MIN(TRY(from_iso8601_timestamp(market_start_time))) AS created_tsFROM polymarket_polygon.market_detailsWHERE condition_id IS NOT NULLAND market_start_time IS NOT NULLGROUP BY 1),trade_rollup AS (SELECTcondition_id,SUM(amount) AS total_volume_usd,COUNT(*) AS trade_eventsFROM polymarket_polygon.market_tradesWHERE action = 'CLOB trade'AND amount > 0GROUP BY 1),markets_2025 AS (SELECTdate_trunc('month', cm.created_ts) AS month,cm.condition_id,COALESCE(tr.total_volume_usd, 0) AS total_volume_usd,COALESCE(tr.trade_events, 0) AS trade_eventsFROM created_markets cmLEFT JOIN trade_rollup trON cm.condition_id = tr.condition_idWHERE cm.created_ts >= TIMESTAMP '2025-01-01'AND cm.created_ts < TIMESTAMP '2026-01-01')SELECTmonth,COUNT(*) AS total_markets_created,COUNT(*) FILTER (WHERE total_volume_usd < 10000) AS markets_less_10k,COUNT(*) FILTER (WHERE total_volume_usd >= 10000) AS markets_gt_10k,COUNT(*) FILTER (WHERE total_volume_usd >= 100000) AS markets_gt_100k,COUNT(*) FILTER (WHERE total_volume_usd >= 1000000) AS markets_gt_1m,COUNT(*) FILTER (WHERE total_volume_usd >= 10000000) AS markets_gt_10m,ROUND(SUM(total_volume_usd), 0) AS total_volume_usd,ROUND(SUM(total_volume_usd) / COUNT(*), 2) AS avg_volume_per_market,COUNT(*) FILTER (WHERE trade_events > 0) AS markets_with_any_tradesFROM markets_2025GROUP BY 1ORDER BY 1;