MLDZMNAB.program
    Updated 2022-09-25
    select
    date_trunc('day', first_transaction_stamp) as day,
    program,
    count (distinct sender) as new_users,
    sum(new_users) over (partition by program order by day) as cum_new_users
    from (
    select
    distinct t.signers[0] as sender,
    l.Label as program,
    min(block_timestamp) as first_transaction_stamp
    from solana.core.fact_transactions t join solana.core.dim_labels l on t.instructions[0]:programId = l.address
    where t.block_timestamp>='2022-05-01'
    and l.label_subtype != 'token_contract'
    and l.LABEL_TYPE in ('defi','dex')
    and l.label != 'solana'
    and t.succeeded = TRUE
    group by 1,2
    )
    group by 1,2
    Run a query to Download Data