KARTODTop 30 most active Solana programs, last 30 days
    Updated 2022-07-03
    SELECT
    '<a href=https://solscan.io/account/' || INSTRUCTIONS[0]:programId || '>' || 'Solscan' || '</a>' AS program
    , CASE
    WHEN INSTRUCTIONS[0]:programId = 'FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe4975bi2epH' THEN 'Pyth Oracle Program'
    WHEN INSTRUCTIONS[0]:programId = '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' THEN 'Serum Dex v3'
    WHEN INSTRUCTIONS[0]:programId = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA' THEN 'Token Program'
    WHEN INSTRUCTIONS[0]:programId = 'CuieVDEDtLo7FypA9SbLM9saXFdb1dsshEkyErMqkRQq' THEN 'Serum Bot'
    WHEN INSTRUCTIONS[0]:programId = '7Sur3cy2efJGv8Qomn35p5k6HqMMcE8juWMBX8sCc96r' THEN 'Pyth Oracle Bot'
    WHEN INSTRUCTIONS[0]:programId = '2V7t5NaKY7aGkwytCWQgvUYZfEr9XMwNChhJEakTExk6' THEN 'Pyth Oracle Bot'
    WHEN INSTRUCTIONS[0]:programId = 'Y2akr3bXHRsqyP1QJtbm9G9N88ZV4t1KfaFeDzKRTfr' THEN 'Pyth Oracle Bot'
    WHEN INSTRUCTIONS[0]:programId = 'F42dQ3SMssashRsA4SRfwJxFkGKV1bE3TcmpkagX8vvX' THEN 'Pyth Oracle Bot'
    WHEN INSTRUCTIONS[0]:programId = 'FZsgu4Gv9fn1iUm5v7iW3p9joX9HJcmxgXdRCqCGxpfE' THEN 'Pyth Oracle Bot'
    WHEN INSTRUCTIONS[0]:programId = '26LYr2NRPprQ7aq6HTyAvrWxhouH8c9KLv1KumtRTJu2' THEN 'Pyth Oracle Bot'
    WHEN INSTRUCTIONS[0]:programId = 'HfeFy4G9r77iyeXdbfNJjYw4z3NPEKDL6YQh3JzJ9s9f' THEN 'Pyth Oracle Bot'
    WHEN INSTRUCTIONS[0]:programId = 'GVXRSBjFk6e6J3NbVPXohDJetcTjaeeuykUpbQF8UoMU' THEN 'Pyth Oracle'
    WHEN INSTRUCTIONS[0]:programId = 'H6ARHf6YXhGYeQfUzQNGk6rDNnLBQKrenN712K4AQJEG' THEN 'Pyth Oracle'
    WHEN INSTRUCTIONS[0]:programId = '8RMnV1eD55iqUFJLMguPkYBkq8DCtx81XcmAja93LvRR' THEN 'Pyth Oracle'
    WHEN INSTRUCTIONS[0]:programId = 'JBu1AL4obBcCMqKBBxhpWCNUt136ijcuMZLFvTP7iWdB' THEN 'Pyth Oracle'
    WHEN INSTRUCTIONS[0]:programId = '5ALDzwcRJfSyGdGyhP3kP628aqBNHZzLuVww7o9kdspe' THEN 'Pyth Oracle'
    WHEN INSTRUCTIONS[0]:programId = '9aiGb2qTGB7xxrEWRrHtzgzBYTfq4y51hQGHrYxxJWna' THEN 'Pyth Oracle Bot'
    WHEN INSTRUCTIONS[0]:programId = '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8' THEN 'Raydium Liquidity Pool v4 Program'
    WHEN INSTRUCTIONS[0]:programId = '11111111111111111111111111111111' THEN 'System Program'
    WHEN INSTRUCTIONS[0]:programId = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' THEN 'Mango Markets v3'
    WHEN INSTRUCTIONS[0]:programId = 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' THEN 'Jupiter Aggregator v2'
    WHEN INSTRUCTIONS[0]:programId = 'GCQ2KPaxKeweMdHcJtfdFd88o1mQvntA1oPSBkSfJwQp' THEN 'Unknown'
    WHEN INSTRUCTIONS[0]:programId = 'DtmE9D2CSB4L5D6A15mraeEjrGMm6auWVzgaD8hK2tZM' THEN 'Switchboard Oracle'
    WHEN INSTRUCTIONS[0]:programId = 'SW1TCH7qEPTdLsDHRgPuMQjbQxKdH2aBStViMFnt64f' THEN 'Unknown'
    WHEN INSTRUCTIONS[0]:programId = 'GDDMwNyyx8uB6zrqwBFHjLLG3TBYk2F8Az4yrQC5RzMp' THEN 'Unknown'
    WHEN INSTRUCTIONS[0]:programId = 'Zo1ggzTUKMY5bYnDvT5mtVeZxzf2FaLTbKkmvGUhUQk' THEN 'Unknown'
    WHEN INSTRUCTIONS[0]:programId = '5JQ8Mhdp2wv3HWcfjq9Ts8kwzCAeBADFBDAgBznzRsE4' THEN 'Unknown'
    WHEN INSTRUCTIONS[0]:programId = 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL' THEN 'Associated Token Account Program'
    WHEN INSTRUCTIONS[0]:programId = 'D3z8BLmMnPD1LaKwCkyCisM7iDyw9PsXXmvatUwjCuqT' THEN 'Unknown'
    WHEN INSTRUCTIONS[0]:programId = 'Memo1UhkJRfHyvLMcVucJwxXeuD728EqVDDwQDxFMNo' THEN 'Memo Program'
    WHEN INSTRUCTIONS[0]:programId = 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD' THEN 'Zeta DEX'
    WHEN INSTRUCTIONS[0]:programId = 'DzpARSggzEgNc2HLdrMEguSf9KGPh5RG1NMBqNnF8ZuU' THEN 'Serum'
    WHEN INSTRUCTIONS[0]:programId = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8' THEN 'Magic Eden'
    Run a query to Download Data