select

date(block_timestamp) as date,

program_id,

signers [0] as signer

from

solana.core.fact_events

where

succeeded = TRUE

and (

program_id = 'CndyV3LdqHUfDLmE5naZjVN8rBZz4tqhdefbAnjHG3JR'

or program_id = 'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ'

or program_id = 'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ'

or program_id = 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s'

or program_id = 'hausS13isiafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk'

or program_id = 'auctxRXPeJoc4817jDhf4HbjnhEcr1cCXenosMhK5R8'

or program_id = 'gdrpGjVffourzkdDRrQmySw4aTHr8a3xmQzzxSwFD1a'

or program_id = 'Guard1JwRhJkVH6XZhzoYxeBVQe872VH6QggF4BWmS9g'

) -- slect dates to make this easier

and date < DATE('2023-01-01')

and date >= DATE('2022-01-01')

date,

case

when program_id = 'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ' then 'candyV2'

when program_id = 'CndyV3LdqHUfDLmE5naZjVN8rBZz4tqhdefbAnjHG3JR' then 'candyV3'

when program_id = 'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ' then 'candyV1'

when program_id = 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s' then 'metadata'

when program_id = 'hausS13isiafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk' then 'auction house one?'

when program_id = 'auctxRXPeJoc4817jDhf4HbjnhEcr1cCXenosMhK5R8' then 'acution house two?'

when program_id = 'gdrpGjVffourzkdDRrQmySw4aTHr8a3xmQzzxSwFD1a' then 'gumdrop'

when program_id = 'Guard1JwRhJkVH6XZhzoYxeBVQe872VH6QggF4BWmS9g' then 'gaurd'

else program_id

end as program,

count(signer) as instructions,