with main as (
select
tx_hash,
symbol_in,
symbol_out,
nvl(amount_in_usd, amount_out_usd) as amount_usd
from avalanche.defi.ez_dex_swaps
where block_timestamp between '2024-01-01' and CURRENT_DATE
)
select
symbol_in as token,
count(distinct tx_hash) as total_swaps
from main
group by 1
order by total_swaps desc
limit 10;