date_trunc('day',block_timestamp) as date,

'Swap FROM ETH' as swap_type,

count(distinct tx_hash) as swaps,

count(distinct SENDER) as swappers,

sum(AMOUNT_IN) as volume_ETH,

sum(amount_in_usd) as volume_USD,

sum(volume_ETH) over (order by date) as cum_volume_eth,

sum(volume_USD) over (order by date) as cum_volume_USD

from ethereum.core.ez_dex_swaps

where date >='2022-11-01'

and SYMBOL_IN='WETH'

group by 1

union all

select

date_trunc('day',block_timestamp) as date,

'Swap TO ETH' as swap_type,

count(distinct tx_hash) as swaps,

count(distinct SENDER) as swappers,

sum(AMOUNT_out) as volume_ETH,

sum(amount_out_usd) as volume_USD,

sum(volume_ETH) over (order by date) as cum_volume_eth,

sum(volume_USD) over (order by date) as cum_volume_USD

from ethereum.core.ez_dex_swaps

where date >='2022-11-01'

and SYMBOL_OUT='WETH'

group by 1