select

BLOCK_TIMESTAMP::date as day,

'Sell ETH' as swap_type,

count(distinct tx_hash) as no_transfer,

count(distinct SENDER) as no_sender,

sum(AMOUNT_IN) as total_volume,

avg(AMOUNT_IN) as avg_volume,

sum(total_volume) over (order by day) as cum_volume

from ethereum.core.ez_dex_swaps

where BLOCK_TIMESTAMP>='2023-04-01'

and SYMBOL_IN='WETH'

group by 1

union all

select

BLOCK_TIMESTAMP::date as day,

'Buy ETH' as swap_type,

count(distinct tx_hash) as no_transfer,

count(distinct SENDER) as no_sender,

sum(AMOUNT_out) as total_volume,

avg(AMOUNT_out) as avg_volume,

sum(total_volume) over (order by day) as cum_volume

from ethereum.core.ez_dex_swaps

where BLOCK_TIMESTAMP>='2023-04-01'

and SYMBOL_OUT='WETH'

group by 1