select

instructions[0]:programId as program_id,

min(block_timestamp) as min_date

from solana.core.fact_transactions

GROUP BY program_id

select

date_trunc('day',min_date) as date,

count(distinct program_id) as protocols_launched,

sum(protocols_launched) over (order by date) as protocols_launched_cumulative

from programs

GROUP BY date

order by date