SELECT

platform AS PlatformName,

DATE_TRUNC('week', block_timestamp) AS WeekStart,

SUM(amount_in_usd) AS TotalVolumeUSD

FROM

polygon.defi.ez_dex_swaps

WHERE

block_timestamp >= DATEADD(MONTH, -3, CURRENT_DATE)

GROUP BY

platform, WeekStart

),

CumulativeVolume AS (

SELECT

WeekStart,

PlatformName,

TotalVolumeUSD,

SUM(TotalVolumeUSD) OVER (PARTITION BY PlatformName ORDER BY WeekStart) AS CumulativeVolumeUSD

FROM

WeeklyVolume

WeekStart AS Week,

PlatformName AS Platform,

TotalVolumeUSD AS TotalVolumeUSD,

CumulativeVolumeUSD AS CumulativeVolumeUSD

CumulativeVolume

ORDER BY

Week DESC, TotalVolumeUSD DESC;