Query editor
WITH pumpdotfun_volume AS (SELECTDATE_TRUNC('week', block_time) AS dt,SUM(amount_usd) AS weekly_volume_usd,COUNT(*) AS total_trades,'Pumpdotfun' AS platformFROM dex_solana.tradesWHEREproject = 'pumpdotfun'AND block_time >= DATE_ADD('week', -100, NOW())AND DATE_TRUNC('week', block_time) < DATE_TRUNC('week', NOW())GROUP BY DATE_TRUNC('week', block_time))SELECTdt AS date,weekly_volume_usd AS weekly_volume,weekly_volume_usd AS weekly_volume_usd,SUM(weekly_volume_usd) OVER (PARTITION BY platform ORDER BY dt ASC) AS cumulative_volume_usd,platformFROM pumpdotfun_volumeORDER BY date DESC, platform ASC;