flipside

    Solana daily unique programs
    m0rt3zaSolana daily unique programs
    Updated 2022-07-02
    SELECT
    block_timestamp::date as date,
    COUNT(DISTINCT program_id) as program_count
    FROM solana.core.fact_events
    WHERE block_timestamp > '2022-01-01'
    GROUP BY date
    ORDER BY date
    Run a query to Download Data