platform,

'Swap in' as "swap type",

concat('HFT', ' - ', symbol_out) as "Pool",

count(distinct tx_hash) as "count of swap",

count(distinct ORIGIN_FROM_ADDRESS) as "count of swapper",

sum(AMOUNT_out_USD) as "volume (USD) of swap"

from ethereum.core.ez_dex_swaps

where TOKEN_IN = lower('0xb3999F658C0391d94A37f7FF328F3feC942BcADC')

and AMOUNT_out_USD is not null

group by 1,2,3

union

select

platform,

'Swap out' as "swap type",

concat(symbol_in, ' - ', 'HFT') as "Pool",

count(distinct tx_hash) as "count of swap",

count(distinct ORIGIN_to_ADDRESS) as "count of swapper",

sum(AMOUNT_in_USD) as "volume (USD) of swap"

from ethereum.core.ez_dex_swaps

where TOKEN_out = lower('0xb3999F658C0391d94A37f7FF328F3feC942BcADC')

and AMOUNT_in_USD is not null

group by 1,2,3