platform,

'Swap in' as "swap type",

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

date_trunc('hour',block_timestamp) as "date(hour)",

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('0x44108f0223A3C3028F5Fe7AEC7f9bb2E66beF82F')

and AMOUNT_out_USD is not null

group by 1,2,3,4

union

select

platform,

'Swap out' as "swap type",

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

date_trunc('hour',block_timestamp) as "date(hour)",

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('0x44108f0223A3C3028F5Fe7AEC7f9bb2E66beF82F')

and AMOUNT_in_USD is not null

group by 1,2,3,4