nitsUnique Programs interacted with since Janurry
    Updated 2022-02-10
    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
    Run a query to Download Data