Query editor
WITH sports_trades AS (SELECTblock_time,DATE(block_time) AS day,amount,maker,takerFROM polymarket_polygon.market_tradesWHEREaction = 'CLOB trade'AND amount > 0AND lower(coalesce(question, '')) LIKE '% vs %'AND block_time >= TIMESTAMP '2025-01-01'AND block_time < TIMESTAMP '2026-01-01'),-- explode maker / taker into one trader columntrader_sides AS (SELECTday,block_time,maker AS trader,amountFROM sports_tradesUNION ALLSELECTday,block_time,taker AS trader,amountFROM sports_trades),trader_day AS (SELECTday,trader,COUNT(*) AS trades,SUM(amount) AS total_bet_usd,AVG(amount) AS avg_bet_usd,approx_percentile(amount, 0.5) AS median_bet_usd,MIN(block_time) AS first_trade_time,MAX(block_time) AS last_trade_timeFROM trader_sidesWHERE trader IS NOT NULLGROUP BY 1, 2)SELECT *FROM trader_dayORDER BY day, total_bet_usd DESC;