MLDZMNmngo5
    Updated 2023-04-11
    select
    date_trunc('day', first_transaction_stamp) as date,
    count (distinct sender) as new_users,
    sum(new_users) over (order by date) as total_new_users
    from (
    select
    distinct signers[0] as sender,
    min(block_timestamp) as first_transaction_stamp
    from solana.core.fact_events
    where PROGRAM_ID='4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg'
    and SUCCEEDED='TRUE'
    and BLOCK_TIMESTAMP>='2023-01-01'
    group by 1
    )
    group by 1
    Run a query to Download Data