date_trunc('day',block_timestamp) as day,

instructions[0]:programId as programs_name,

case

when programs_name ='FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe4975bi2epH' then 'Pyth Oracle'

when programs_name='9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' then 'Serum DEX V3'

when programs_name='mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' then 'Mango Markets V3'

when programs_name='DtmE9D2CSB4L5D6A15mraeEjrGMm6auWVzgaD8hK2tZM' then 'Switchboard Oracle'

when programs_name='SW1TCH7qEPTdLsDHRgPuMQjbQxKdH2aBStViMFnt64f' then 'Switchboard V2'

end as programs,

count(tx_id) as tx_count

from solana.core.fact_transactions

WHERE day >= '2022-01-01'

and programs is NOT NULL

and succeeded = true

group by 1,2

order by 3 DESC