Concat('VEXT','->',symbol_out) as swap_pair,

PLATFORM,

count(distinct tx_hash) as "Swaps",

count(distinct ORIGIN_FROM_ADDRESS) as "Traders",

sum(AMOUNT_IN_USD) as "Total volume in USD",

avg(AMOUNT_IN_USD) as "Avg. volume in USD"

from ethereum.defi.ez_dex_swaps

where TOKEN_IN = lower ('0xB2492E97a68a6E4B9E9a11B99F6C42E5aCCD38c7')

group by 1,2 having swap_pair is not null

union all

select

Concat(symbol_in,'->','VEXT') as swap_pair,

PLATFORM,

count(distinct tx_hash) as "Swaps",

count(distinct ORIGIN_FROM_ADDRESS) as "Traders",

sum(AMOUNT_OUT_USD) as "Total volume in USD",

avg(AMOUNT_OUT_USD) as "Avg. volume in USD"

from ethereum.defi.ez_dex_swaps

where TOKEN_OUT = lower ('0xB2492E97a68a6E4B9E9a11B99F6C42E5aCCD38c7')

group by 1,2 having swap_pair is not null