count (distinct tx_hash) as tx_count,

sum (case when symbol_in = 'WETH' then amount_in*-1 end) as sell,

sum (case when symbol_out = 'WETH' then amount_out end) as buy,

sum (case when symbol_in = 'WETH' then amount_in *-1 when symbol_out = 'WETH' then amount_out end) as Net_Volume

from ethereum.core.ez_dex_swaps

where block_timestamp >= '2022-11-01'

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