nitsDaily New Users
    Updated 2022-07-06
    with a as
    (SELECT date(f_u) as day , COUNT(DISTINCT tx_signer)as total_signers,
    sum(total_signers) over (order by day) as cumulative_new_users
    from
    (SELECT tx_signer , min(block_timestamp) as f_u from mdao_near.transactions
    GROUP by 1)
    where day >= CURRENT_DATE -90
    GROUP by 1 )

    SELECT *,
    cumulative_new_users_-cumulative_new_users_ as net_joiners_in_past_30_days
    from
    (SELECT date(f_u) as day_ , COUNT(DISTINCT tx_signer)as total_signers_,
    sum(total_signers_) over (order by day_) as cumulative_new_users_ from
    (SELECT tx_signer , min(block_timestamp) as f_u from mdao_near.transactions
    GROUP by 1)
    where day_ >= CURRENT_DATE -90
    GROUP by 1 )
    inner join a
    on day = day_+30
    -- LIMIT 10
    Run a query to Download Data