ML6Total unique Solana Programs of 2022
    Updated 2022-07-04
    SELECT count(distinct PROGRAM_ID)
    from solana.core.fact_events where date_trunc('day', block_timestamp) > '2022-01-01'
    and program_id not in (SELECT PROGRAM_ID
    from solana.core.fact_events where date_trunc('day', block_timestamp) < '2022-01-01')
    Run a query to Download Data