platform,

COUNT(DISTINCT tx_hash) AS total_swaps,

SUM(amount_in_usd) AS total_volume,

COUNT(DISTINCT trader) AS unique_users

FROM near.defi.ez_dex_swaps

WHERE block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'

GROUP BY platform

ORDER BY total_swaps DESC;