Query editor
WITH ranked_traders AS (SELECTtrader_id,COUNT(*) AS swaps,SUM(CASE WHEN block_time >= NOW() - INTERVAL '1' DAY THEN amount_usd ELSE 0 END) AS volume_24_hour,SUM(CASE WHEN block_time >= NOW() - INTERVAL '7' DAY THEN amount_usd ELSE 0 END) AS volume_7_day,SUM(amount_usd) AS volume_totalFROM dex_solana.tradesWHEREtrade_source = 'T1TANpTeScyeqVzzgNViGDNrkQ6qHz9KrSBS4aNXvGT'AND block_time >= TIMESTAMP '2025-10-01 00:00:00'GROUP BY trader_id)SELECTROW_NUMBER() OVER (ORDER BY volume_total DESC) AS position,trader_id,swaps,volume_24_hour,volume_7_day,volume_totalFROM ranked_tradersORDER BY volume_total DESCLIMIT 300;