SELECT

DATE_TRUNC('month', block_timestamp) AS month,

SUM(amount_in_usd) AS TotalSwapVolume

FROM

flow.defi.ez_dex_swaps

GROUP BY

month

)

SELECT

month,

TotalSwapVolume,

LAG(TotalSwapVolume) OVER (ORDER BY month) AS PreviousVolume,

((TotalSwapVolume - LAG(TotalSwapVolume) OVER (ORDER BY month)) / NULLIF(LAG(TotalSwapVolume) OVER (ORDER BY month), 0)) * 100 AS GrowthPercentage

FROM

MonthlyVolume

WHERE

TotalSwapVolume IS NOT NULL

ORDER BY

month;