DATE_TRUNC('week', date) AS week,

protocol,

chain,

SUM(volume) AS TotalWeeklyVolume,

SUM(SUM(volume)) OVER (PARTITION BY protocol ORDER BY DATE_TRUNC('week', date)) AS CumulativeVolume

FROM external.defillama.fact_dex_volume

WHERE chain ILIKE 'solana'

AND protocol ILIKE 'raydium'

GROUP BY DATE_TRUNC('week', date), protocol, chain

ORDER BY week DESC, protocol;