select POOL_NAME

,sum(AMOUNT_OUT_USD) as volume

,count(distinct TX_HASH) as swaps

,count(distinct ORIGIN_FROM_ADDRESS) as swappers

,volume/swappers as "VOLUME PER SWAPPER"

,volume/swaps as "VOLUME PER SWAPS"

from base.defi.ez_dex_swaps

where PLATFORM='baseswap'

and AMOUNT_OUT_USD is not null

group by 1

order by 2 desc