date_trunc('day', block_timestamp) as date,

sum(CASE WHEN symbol_in LIKE 'WETH' then amount_in END) sell_token_vol,

sum(CASE WHEN symbol_out LIKE 'WETH' then amount_out END) buy_token_vol,

sum(CASE

WHEN symbol_in LIKE 'WETH' then -1 * amount_in

WHEN symbol_out LIKE 'WETH' then amount_out

END) as token_net_vol,

count(DISTINCT (CASE WHEN symbol_in LIKE 'WETH' or symbol_out LIKE 'WETH' THEN tx_hash END)) as token_swap_tx,

sum(sell_token_vol) over (order by date) as cum_sell_token_vol,

sum(buy_token_vol) over (order by date) as cum_buy_token_vol,

sum(token_net_vol) over (order by date) as cum_token_net_vol,

sum(token_swap_tx) over (order by date) as cum_token_swap_tx

FROM ethereum.core.ez_dex_swaps

where block_timestamp::date >= CURRENT_DATE - 31

AND block_timestamp::date <= CURRENT_DATE - 1

GROUP by 1