-- block_timestamp,

-- tx_id,

-- instructions[0]:programId::string as program

date(block_timestamp) as date,

count(distinct instructions[0]:programId::string) as contract

from solana.core.fact_transactions --t,

-- lateral flatten(input=> t.instructions)

where year(block_timestamp) = 2022

group by 1