Afonso_Diaz2023-06-15 11:45 PM
    Updated 2023-06-15
    with t as (
    select
    tx_id,
    block_timestamp,
    signers[0] as user,
    case
    when program_id = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA' then 'MarginFi'
    when program_id = 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD' then 'Zeta'
    else 'Jupiter'
    end as platform
    from solana.core.fact_events
    where program_id in (
    'JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph',
    'JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB',
    'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA',
    'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD',
    'JUP6i4ozu5ydDCnLiMogSckDPpbtr7BJ4FtzYWkb5Rk',
    'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo'
    )
    )

    select
    platform,
    count(distinct tx_id) as transactions,
    count(distinct user) as users,
    transactions / count(distinct block_timestamp::date) as daily_average_transactions,
    users / count(distinct block_timestamp::date) as daily_average_users
    from t
    where block_timestamp::date >= current_date - 60
    group by 1
    Run a query to Download Data