CASE WHEN split(PLATFORM , '-') [0] != 'trader' THEN split(PLATFORM , '-')[0] ELSE CONCAT(split(PLATFORM , '-')[0] ,split(PLATFORM , '-') [1]) END AS "DEX name",

sum(AMOUNT_OUT_USD) as "Total trade volume" ,

count(*) as "Number of trades" ,

count(Distinct ORIGIN_FROM_ADDRESS) as "Number of users" ,

avg(AMOUNT_OUT_USD) as "Average volume per trade" ,

"Total trade volume"/"Number of users" as "Average volume per user" ,

count(distinct POOL_NAME) as "Total pool number"

from

Arbitrum.defi.ez_dex_swaps

where

and

group by 1

order by 2 desc