SELECT

date_trunc('week', block_timestamp) as week,

count(DISTINCT tx_hash) as events,

COUNT(DISTINCT DEPOSITOR_ADDRESS) as users,

avg(WITHDRAWN_USD) as avg_withdraw_usd,

sum(WITHDRAWN_USD) as total_withdraw_usd

FROM ethereum.aave.ez_withdraws

WHERE symbol 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