ZookUnique Solana Programs per Day
    Updated 2022-07-05
    with transactions as (
    select
    block_timestamp,
    tx_id,
    instructions[0]:programId::string as program_id
    from solana.core.fact_transactions
    where block_timestamp >= '2022-01-01'
    and block_timestamp < CURRENT_DATE
    and SUCCEEDED = 'TRUE'
    )

    SELECT
    date_trunc('day', block_timestamp) as day,
    count(distinct(program_id)) as nb_contracts
    from transactions
    group by 1
    order by 1 desc

    --Q92. One way to track developer growth in an ecosystem is through the number of unique contracts used.
    --Create a visualization of the number of unique programs used per day since the beginning of January.
    --What type of programs are the most popular,
    --and what programs seem to be gaining in popularity over that timeframe?
    --Does it appear that development is still ongoing in the bear market?
    Run a query to Download Data