select count (distinct tx_hash) as TX,
sum (case when symbol_in = 'WETH' then amount_in*-1 end) as "SELL_Volume",
sum (case when symbol_out = 'WETH' then amount_out end) as "Buy_Volume"
from ethereum.core.ez_dex_swaps
where block_timestamp >= '2022-10-25'
and (symbol_in = 'WETH' or symbol_out = 'WETH')