MLDZMNmngo8
    Updated 2022-10-16
    with tb1 as (select
    *
    from solana.core.fact_events
    WHERE succeeded = 'True'
    and program_id = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
    and block_timestamp>='2022-10-01'
    )

    select
    BLOCK_TIMESTAMP::date as day,
    count(tx_id) as no_txn,
    count(distinct SIGNERS[0]) as no_users
    from solana.core.fact_transactions
    where tx_id in (select tx_id from tb1)
    and BLOCK_TIMESTAMP>='2022-10-01'
    and SUCCEEDED='TRUE'
    group by 1
    order by 1
    Run a query to Download Data