flipside

    Number of unique programs used per day
    OneDataAnalystNumber of unique programs used per day
    Updated 2022-07-06
    SELECT Date_trunc('day',Block_timestamp) AS date, COUNT(DISTINCT PROGRAM_ID) AS Program_counts
    FROM solana.core.fact_events
    WHERE DATE >= '2022-01-01'
    AND DATE < CURRENT_DATE
    GROUP BY 1

    Run a query to Download Data