date_trunc('day',block_timestamp) as date,

platform,

'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 >='2023-01-01' and date <='2023-01-16'

and SYMBOL_IN='WETH'

and event_name = 'Swap'

group by 1,2

union all

select

date_trunc('day',block_timestamp) as date,

platform,

'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 >='2023-01-01' and date <='2023-01-16'

and SYMBOL_OUT='WETH'

and event_name = 'Swap'

group by 1,2