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