select date(first_use) as day , COUNT ( DISTINCT program_id) as unique_programs, sum(unique_programs) over (order by day) as cumulative_programs
from
(select program_id, min(block_timestamp) as first_use, count(*) as total_calls from
(select * from solana.transactions
where block_timestamp > '2022-01-01')
GROUP by 1)
GROUP by 1
ORDER by 1
limit 100