marquMango v4 - [users] new users alpha/beta copy
    Updated 2023-04-16
    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
    Run a query to Download Data