pool_name,

count(distinct tx_hash) as Swap,

count(distinct sender) as Swappers,

sum(case when amount_in_usd is null then amount_out_usd else amount_in_usd end) as Volume_usd

from base.defi.ez_dex_swaps

where platform like 'aerodrome'

group by 1

having Volume_usd is not null

and volume_usd > 100000

order by 4 desc