flipside

    Daily used unique Solana Programs of 2022
    ML6Daily used unique Solana Programs of 2022
    Updated 2022-07-04
    SELECT date,count(DISTINCT PROGRAM_ID) as unique_programs from ( SELECT block_timestamp::date as date,PROGRAM_ID
    from solana.core.fact_events
    where block_timestamp::date >= '2022-01-01' and SUCCEEDED = 'TRUE')
    GROUP by date
    Run a query to Download Data