symbol_in as "Symbol swapped",

count (DISTINCT tx_hash) as "Total swap",

count (trader) as "Total unique traders",

sum (amount_in) as "Total tokens swapped",

sum (amount_in_usd) as "Total tokens swapped (USD)"

from near.defi.ez_dex_swaps

where block_timestamp >= '2024-0-01 00:00:00.000'

and block_timestamp < '2024-08-01 00:00:00.000'

GROUP by 1

order by 2 desc

limit 10