SELECT

date_trunc('week', block_timestamp) as week,

count(DISTINCT tx_hash) as events,

COUNT(DISTINCT WITHDRAWER) as users,

avg(AMOUNT_WITHDRAWN) as avg_withdraw_usd,

sum(AMOUNT_WITHDRAWN) as total_withdraw_usd

FROM ethereum.maker.ez_withdrawals

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