symbol_in,

count(distinct(tx_hash)) as tx_num,

sum(amount_in_usd) as amount_usd

from optimism.velodrome.ez_swaps

where block_timestamp >= current_date - {{ days }}

group by symbol_in

having amount_usd > 0

order by amount_usd desc

limit 10