date_trunc('{{Timeframe}}', BLOCK_TIMESTAMP) AS date,

'withdraw' AS Action,

sum(case

when TOKEN0_SYMBOL='WETH' then AMOUNT0_ADJUSTED

when TOKEN0_SYMBOL='WETH' then AMOUNT1_ADJUSTED

else null end) AS "ETH Amount",

avg("ETH Amount") over (order by date, date rows between 6 preceding and current row) as "7 Week MA",

max(case

when TOKEN0_SYMBOL='WETH' then AMOUNT0_ADJUSTED

when TOKEN0_SYMBOL='WETH' then AMOUNT1_ADJUSTED

else null end) AS "highest ETH withdarw"

from ethereum.uniswapv3.ez_lp_actions

where date >= '2022-01-01'

and ACTION='DECREASE_LIQUIDITY'

group by 1, 2