flipside

    Solana Unique Programs
    KaskoazulSolana Unique Programs
    Updated 2022-02-11
    SELECT
    date_trunc('DAY', block_timestamp) as DATE,
    count(distinct program_id) as Unique_Programs
    FROM
    solana.transactions
    WHERE
    succeeded = 'TRUE'
    AND DATE >= '2022-01-01'
    GROUP BY 1

    Run a query to Download Data