SELECT

date_trunc('week', block_timestamp) as week,

count(DISTINCT tx_hash) as events,

COUNT(DISTINCT LIQUIDITY_PROVIDER) as users,

avg(CASE WHEN TOKEN0_SYMBOL LIKE 'WETH' THEN AMOUNT0_USD ELSE AMOUNT1_USD END) as avg_withdraw_usd,

sum(CASE WHEN TOKEN0_SYMBOL LIKE 'WETH' THEN AMOUNT0_USD ELSE AMOUNT1_USD END) as total_withdraw_usd

FROM ethereum.uniswapv3.ez_lp_actions

WHERE TOKEN0_SYMBOL LIKE 'WETH'

OR TOKEN1_PRICE LIKE 'WETH'

GROUP BY 1

SELECT

*,

avg(total_withdraw_usd) OVER(ORDER BY week

ROWS BETWEEN 5 PRECEDING AND CURRENT ROW )

as moving_average

FROM tab1