flipside

    Total unique programs used since the beginning of January per day
    Yousefi_1994Total unique programs used since the beginning of January per day
    Updated 2022-07-05
    select
    block_timestamp::date as days,
    count(distinct program_id) as number_of_program
    from solana.core.fact_events
    where block_timestamp::date >= '2022-01-01'
    and succeeded = true
    group by days
    order by days
    Run a query to Download Data