blockchain,

TO_CHAR(block_timestamp, 'YYYY-MM') AS Month,

SUM(amount_in_usd) AS TotalMonthlyVolume

crosschain.defi.ez_dex_swaps

blockchain IN ('ethereum', 'solana')

AND block_timestamp BETWEEN '2024-07-01' AND '2024-09-30'

GROUP BY

blockchain,

TO_CHAR(block_timestamp, 'YYYY-MM')

ORDER BY

blockchain,

Month;