MLDZMNCompare1
    Updated 2023-04-11
    select
    case
    when PROGRAM_ID in ('ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD') then 'Zeta'
    when PROGRAM_ID in ('dammHkt7jmytvbS3nHTxQNEcP59aE57nxwV21YdqEDNm','dRiftyHA39MWEi3m9aunc5MzRF1JYuBsbn6VPcn33UH') then 'Drift'
    when PROGRAM_ID in ('4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg') then 'Mango Markets'
    end as programs,
    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 BLOCK_TIMESTAMP >= '2023-01-01'
    group by 1 having programs is not null
    Run a query to Download Data