Query editor
WITH markets AS (SELECTcondition_id,TRY(from_iso8601_timestamp(market_start_time)) AS created_tsFROM polymarket_polygon.market_detailsWHEREcondition_id IS NOT NULLAND market_start_time IS NOT NULL),dedup AS (-- ensure exactly one timestamp per marketSELECTcondition_id,MIN(created_ts) AS created_tsFROM marketsWHERE created_ts IS NOT NULLGROUP BY 1)SELECTdate_trunc('month', created_ts) AS month,COUNT(*) AS markets_createdFROM dedupWHERE created_ts >= TIMESTAMP '2025-01-01'AND created_ts < TIMESTAMP '2026-01-01'GROUP BY 1ORDER BY 1;