MLDZMNmng1
    Updated 2023-04-10
    select
    min(block_timestamp) as first_txn,
    count(distinct SIGNERS[0]) as no_users,
    Count(distinct tx_id) as no_txn,
    no_txn/no_users as transaction_per_user,
    no_users/count(distinct date_trunc(day, block_timestamp)) as average_user_day,
    no_users/count(distinct date_trunc('week', block_timestamp)) as average_user_week

    from solana.core.fact_events

    where SUCCEEDED='TRUE'
    and PROGRAM_ID = '4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg'

    Run a query to Download Data