platform,

SUM(amount_in_usd) AS "total_swap_volume",

COUNT(DISTINCT tx_hash) AS "total_swaps",

COUNT(DISTINCT origin_from_address) AS "total_users"

avalanche.defi.ez_dex_swaps

block_timestamp >= '2024-01-01'

AND block_timestamp <= '2024-12-31'

GROUP BY

platform

ORDER BY

"total_swap_volume" DESC;