headitmanagernumber of unique programs used per day since the beginning of January
    Updated 2022-02-10
    select date_trunc('day', block_timestamp) as datetime , count(distinct (program_id)) as COUNT from solana.transactions WHERE
    block_timestamp :: date >= '2022-01-01' and block_timestamp :: date <= '2022-01-31'
    group by datetime
    order by datetime asc




    Run a query to Download Data