Query editor
WITH weekly_aggregate AS (SELECTDATE_TRUNC('week', block_time) AS week,amm_name,SUM(input_usd) AS total_volumeFROM jupiter_solana.aggregator_swapsWHEREamm_name IN ('Raydium amm', 'Raydium CLMM', 'Raydium CP')AND block_time >= CURRENT_TIMESTAMP - INTERVAL '6' MONTHGROUP BYDATE_TRUNC('week', block_time),amm_name)SELECTweek,amm_name,SUM(total_volume) OVER (PARTITION BY week, amm_name ORDER BY week) AS cumulative_volumeFROM weekly_aggregateORDER BYweek, amm_name;