'Swap out' as "swap type",

concat(symbol_in, ' - ', symbol_out) as Pool,

PLATFORM,

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_out = lower('0x4d224452801ACEd8B2F0aebE155379bb5D594381')

and AMOUNT_out_USD is not null

and symbol_in is not null

and symbol_out is not null

group by 1,2,3

union

select

'Swap in' as "swap type",

concat(symbol_in, ' - ', symbol_out) as Pool,

PLATFORM,

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_in = lower('0x4d224452801ACEd8B2F0aebE155379bb5D594381')

and AMOUNT_in_USD is not null

and symbol_in is not null

and symbol_out is not null

group by 1,2,3