date_trunc('day',block_timestamp) as date,

count (distinct tx_hash) as tx_count,

sum (case when symbol_in = 'WETH' then amount_in else amount_out end) Volume,

case

when symbol_in = 'WETH' then 'Swap From (SELL) WETH'

when symbol_out = 'WETH' then 'Swap To (BUY) WETH'

end as swap_type

from ethereum.core.ez_dex_swaps

where block_timestamp >= '2022-11-01'

and (symbol_in = 'WETH' or symbol_out = 'WETH')

group by 1,4

order by 1 asc