with
v4_users as (
select
date_trunc('day',block_timestamp) as date,
count(distinct signers[0]) as users,
avg(users) over (order by date rows between 6 preceding and current row) as avg_7d,
avg(users) over (order by date rows between 13 preceding and current row) as avg_14d,
avg(users) over (order by date rows between 29 preceding and current row) as avg_30d
from solana.core.fact_events
where succeeded
and program_id = '4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg' -- mv4
and block_timestamp > '2022-12-08'
group by 1
)
select *
from v4_users