Query editor
WITH fees_negrisk AS (SELECTDATE_TRUNC('day', evt_block_time) AS d,SUM(CAST(amount AS DOUBLE)) / 1e6 AS fee_usdFROM polymarket_polygon.NegRiskCtfExchange_evt_FeeChargedWHERE evt_block_time >= TIMESTAMP '2026-03-01'AND evt_block_time < TIMESTAMP '2026-04-03'GROUP BY 1),fees_ctf AS (SELECTDATE_TRUNC('day', evt_block_time) AS d,SUM(CAST(amount AS DOUBLE)) / 1e6 AS fee_usdFROM polymarket_polygon.CTFExchange_evt_FeeChargedWHERE evt_block_time >= TIMESTAMP '2026-03-01'AND evt_block_time < TIMESTAMP '2026-04-03'GROUP BY 1),fees_combined AS (SELECTCOALESCE(n.d, c.d) AS d,COALESCE(n.fee_usd, 0) AS negrisk_fee,COALESCE(c.fee_usd, 0) AS ctf_fee,COALESCE(n.fee_usd, 0) + COALESCE(c.fee_usd, 0) AS total_feeFROM fees_negrisk nFULL OUTER JOIN fees_ctf c ON n.d = c.d),activity AS (SELECTCAST(block_time AS DATE) AS d,SUM(amount) AS total_volume,COUNT(*) AS trade_count,COUNT(DISTINCT taker) AS active_usersFROM polymarket_polygon.market_tradesWHERE block_time >= TIMESTAMP '2026-03-01'AND block_time < TIMESTAMP '2026-04-03'AND block_month >= DATE '2026-03-01'GROUP BY 1)SELECTCAST(f.d AS DATE) AS trade_date,ROUND(f.negrisk_fee, 0) AS negrisk_fee_usd,ROUND(f.ctf_fee, 0) AS ctf_fee_usd,ROUND(f.total_fee, 0) AS total_fee_usd,ROUND(a.total_volume / 1e6, 1) AS volume_M,a.trade_count,a.active_usersFROM fees_combined fLEFT JOIN activity a ON CAST(f.d AS DATE) = a.dWHERE CAST(f.d AS DATE) < DATE '2026-04-03'ORDER BY 1