select
symbol_in as symbol,
count (distinct tx_hash) as swaps_count,
count (distinct origin_from_address) as swappers_count,
sum (amount_out_usd) as volume_usd
from ethereum.core.ez_dex_swaps
where token_out = '0xd01ef7c0a5d8c432fc2d1a85c66cf2327362e5c6' --aETHb
group by symbol
having volume_usd > 0
and symbol_in is not null
order by volume_usd desc
limit 10