flipside

    Solana Unique Program Ids
    MilesFinchSolana Unique Program Ids
    Updated 2022-03-14
    SELECT date_trunc('day', block_timestamp) as date, COUNT (distinct program_id) as n_program
    FROM solana.transactions
    WHERE date >= '2022-01-01'
    and date <= '2022-03-13'
    AND succeeded = 'TRUE'
    GROUP BY date
    ORDER BY n_program DESC
    Run a query to Download Data