Query editor
WITH created_markets AS (SELECTcondition_id,MIN(TRY(from_iso8601_timestamp(market_start_time))) AS created_ts,MAX(resolved_on_timestamp) AS resolved_tsFROM polymarket_polygon.market_detailsWHERE condition_id IS NOT NULLAND market_start_time IS NOT NULLGROUP BY 1),trade_rollup AS (SELECTcondition_id,COUNT(*) AS trade_events,SUM(amount) AS total_volume_usdFROM 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,cm.created_ts,cm.resolved_ts,COALESCE(tr.total_volume_usd, 0) AS total_volume_usd,COALESCE(tr.trade_events, 0) AS trade_events,CASEWHEN cm.resolved_ts IS NULL THEN NULLELSE COALESCE(tr.total_volume_usd, 0)/ GREATEST(DATE_DIFF('day', cm.created_ts, cm.resolved_ts), 1)END AS volume_per_day_usdFROM 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 volume_per_day_usd >= 100) AS markets_gt_100_per_day,COUNT(*) FILTER (WHERE volume_per_day_usd >= 1000) AS markets_gt_1k_per_day,COUNT(*) FILTER (WHERE volume_per_day_usd >= 10000) AS markets_gt_10k_per_day,COUNT(*) FILTER (WHERE volume_per_day_usd >= 100000) AS markets_gt_100k_per_day,COUNT(*) FILTER (WHERE volume_per_day_usd >= 1000000) AS markets_gt_1m_per_day,COUNT(*) FILTER (WHERE trade_events > 0) AS markets_with_any_trades,COUNT(*) FILTER (WHERE resolved_ts IS NOT NULL) AS markets_resolvedFROM markets_2025GROUP BY 1ORDER BY 1;