CoinConverseUnique Programs the 5 most commonly used programs over that timeframe
    Updated 2022-02-10
    SELECT CASE
    WHEN program_id = 'FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe4975bi2epH' THEN 'Pyth Oracle'
    WHEN program_id = '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' THEN 'Serum DEX V3'
    WHEN program_id = 'DtmE9D2CSB4L5D6A15mraeEjrGMm6auWVzgaD8hK2tZM' THEN 'Switchboard Oracle'
    WHEN program_id = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' THEN 'Mango Markets V3'
    WHEN program_id = 'GDDMwNyyx8uB6zrqwBFHjLLG3TBYk2F8Az4yrQC5RzMp' THEN 'GDDMwNyyx8uB6zrqwBFHjLLG3TBYk2F8Az4yrQC5RzMp'
    END AS program_name, date_trunc('day', block_timestamp) AS dt, COUNT(tx_id) AS num_txs
    FROM solana.transactions
    WHERE block_timestamp :: date >= '2022-01-01' AND SUCCEEDED = 'TRUE' AND program_name IS NOT NULL
    GROUP BY dt, program_name
    ORDER BY dt
    Run a query to Download Data