DATE_TRUNC('month', block_timestamp) AS month,

platform,

SUM(amount_in_usd) AS total_volume_usd,

COUNT(tx_hash) AS total_transactions,

COUNT(DISTINCT swapper) AS active_wallets

FROM

aptos.defi.ez_dex_swaps

WHERE

block_timestamp >= '2024-10-01'

AND block_timestamp < CURRENT_DATE

GROUP BY

platform, month

ORDER BY month ASC