DATE_TRUNC('month', block_timestamp) AS month,

platform,

symbol_in || '/' || symbol_out AS trading_pair,

SUM(amount_in_usd) AS pair_volume_usd,

COUNT(tx_hash) AS pair_transactions

FROM

aptos.defi.ez_dex_swaps

WHERE

block_timestamp >= '2024-10-01'

AND block_timestamp < CURRENT_DATE

AND amount_in_usd IS NOT NULL

GROUP BY

1, 2, 3

ORDER BY 1 ASC