blockchain,

count(*) as Trade_number,

sum(AMOUNT_IN_USD) as Trade_volume ,

count(distinct ORIGIN_FROM_ADDRESS) as User_number,

avg(AMOUNT_IN_USD) as Average_volume_per_transaction ,

Trade_volume/User_number as Average_volume_per_user,

count(distinct POOL_NAME) as Pools_number

from

((select

'arbitrum' as blockchain ,

AMOUNT_IN_USD,

ORIGIN_FROM_ADDRESS,

from

arbitrum.defi.ez_dex_swaps

where

PLATFORM like '%trader%'

and

union all

(select

'Avalanche' as blockchain ,

AMOUNT_IN_USD,

ORIGIN_FROM_ADDRESS,

from

Avalanche.defi.ez_dex_swaps

where

PLATFORM like '%trader%'

and