select SYMBOL_OUT as token_bought

,count(distinct TX_HASH) as swaps

,count(distinct ORIGIN_FROM_ADDRESS) as buyers

,sum(AMOUNT_OUT_USD) as volume

from base.defi.ez_dex_swaps

where PLATFORM='aerodrome'

and AMOUNT_IN_USD is not null

group by 1

order by 2 desc

limit 10