DATE_TRUNC('month', block_timestamp) AS month,

CASE

WHEN GROUPING(platform) = 1 THEN 'ALL PLATFORMS'

ELSE platform

END AS platform,

SUM(amount_in_usd) AS total_volume_usd

aptos.defi.ez_dex_swaps

block_timestamp >= '2024-10-01'

AND block_timestamp < '2025-01-01'

GROUP BY

GROUPING SETS (

(DATE_TRUNC('month', block_timestamp)), -- Total volume for all platforms by month

(platform) -- Total volume by platform for combined months

)

ORDER BY

month ASC,

platform ASC;