Query editor
-- Polymarket Active Wallets — V1 (polymarket_polygon.*) + V2 (polymarket_v2_polygon.*)---- V2 cutover: 2026-04-28. V1 went silent that day; explicit date guards keep-- V1 and V2 from double-counting around the boundary.---- V2 multiplexes both CTF and NegRisk onto the same `ctfexchange_evt_orderfilled`-- table; we split them back out by contract_address so the V1 column names-- (`ctf_dau`, `neg_risk_dau`) stay meaningful end-to-end.-- V2 CTF Exchange: 0xE111180000d2663C0091e4f400237545B87B996B-- V2 NegRisk Exchange: 0xe2222d279d744050d28e00520010520000310F59---- Maker-only across both V1 and V2 for numerical continuity.WITH bounds AS (SELECT DATE '2024-01-01' AS start_date, CURRENT_DATE AS end_date),cutover AS (SELECT DATE '2026-04-28' AS d),ctf_wallets AS (-- V1 CTFSELECT DATE_TRUNC('{{date_active_wallets}}', evt_block_time) AS date, maker AS walletFROM polymarket_polygon.CTFExchange_evt_OrderFilled tCROSS JOIN bounds bWHERE t.evt_block_time >= b.start_dateAND t.evt_block_time < b.end_dateAND t.evt_block_date <= (SELECT d FROM cutover)UNION ALL-- V2 CTF (filtered by contract_address)SELECT DATE_TRUNC('{{date_active_wallets}}', evt_block_time) AS date, maker AS walletFROM polymarket_v2_polygon.ctfexchange_evt_orderfilled tCROSS JOIN bounds bWHERE t.evt_block_time >= b.start_dateAND t.evt_block_time < b.end_dateAND t.evt_block_date >= (SELECT d FROM cutover)AND t.contract_address = 0xE111180000d2663C0091e4f400237545B87B996B),neg_risk_wallets AS (-- V1 NegRiskSELECT DATE_TRUNC('{{date_active_wallets}}', evt_block_time) AS date, maker AS walletFROM polymarket_polygon.NegRiskCtfExchange_evt_OrderFilled tCROSS JOIN bounds bWHERE t.evt_block_time >= b.start_dateAND t.evt_block_time < b.end_dateAND t.evt_block_date <= (SELECT d FROM cutover)UNION ALL-- V2 NegRisk (filtered by contract_address)SELECT DATE_TRUNC('{{date_active_wallets}}', evt_block_time) AS date, maker AS walletFROM polymarket_v2_polygon.ctfexchange_evt_orderfilled tCROSS JOIN bounds bWHERE t.evt_block_time >= b.start_dateAND t.evt_block_time < b.end_dateAND t.evt_block_date >= (SELECT d FROM cutover)AND t.contract_address = 0xe2222d279d744050d28e00520010520000310F59),