flipside

    No of unique programs since the beginning of January 2022
    Mufasa No of unique programs since the beginning of January 2022
    Updated 2022-07-06
    SELECT block_timestamp::date as date, COUNT(distinct INSTRUCTIONS[0]:programId) as number_of_programs
    FROM solana.core.fact_transactions
    WHERE date >= '2022-01-01'
    AND succeeded = 'TRUE'
    GROUP BY date
    ORDER BY number_of_programs DESC
    Run a query to Download Data