KaskoazulSolana Top 5 Programs
    Updated 2022-02-11
    SELECT
    CASE program_id
    WHEN 'FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe4975bi2epH' THEN 'Pyth Oracle'
    WHEN '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' THEN 'Serum DEX V3'
    WHEN 'DtmE9D2CSB4L5D6A15mraeEjrGMm6auWVzgaD8hK2tZM' THEN 'Switchboard Oracle'
    WHEN 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' THEN 'Mango Markets V3'
    WHEN '11111111111111111111111111111111' THEN 'Wrapped SOL'
    WHEN 'GDDMwNyyx8uB6zrqwBFHjLLG3TBYk2F8Az4yrQC5RzMp' THEN 'N/A'
    END AS Program_name,
    program_id,
    count(program_id) as Number_of_transactions
    FROM
    solana.transactions
    WHERE
    succeeded = 'TRUE'
    AND block_timestamp >= '2022-01-01'
    GROUP BY 1, 2
    ORDER BY 3 DESC
    LIMIT 5

    Run a query to Download Data