sum(coalesce(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS volume,

count(*) AS Swaps,

Count(DISTINCT ORIGIN_FROM_ADDRESS) AS traders,

Avg(coalesce(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS "AVg Swap Size"

base.defi.ez_dex_swaps

platform like 'aerodrome%'

and (

symbol_in in ('uSOL', 'uSEI', 'uDOGE', 'uSUI', 'uAPT', 'uBTC','uNEAR')

or symbol_out in ('uSOL', 'uSEI', 'uDOGE', 'uSUI', 'uAPT', 'uBTC','uNEAR')

)