select SYMBOL_IN as token_sold

,count(distinct ORIGIN_FROM_ADDRESS) as sellers

,sum(AMOUNT_IN_USD) as volume

,count(distinct TX_HASH) as swaps

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