LTirrellsol_contract-creation
    Updated 2023-02-02
    WITH unique_programs AS (
    SELECT
    distinct program_id as program
    from
    solana.core.fact_events
    ),
    program_creation_date as (
    select
    program_id,
    min(block_timestamp :: date) as creation_date
    from
    solana.core.fact_events
    where
    program_id in (
    select
    program
    from
    unique_programs
    )
    group by
    program_id
    )
    select
    creation_date,
    count(distinct program_id) as programs
    from
    program_creation_date
    WHERE
    creation_date :: DATE >= '2022-01-01'
    group by
    creation_date
    order by
    creation_date ASC


    Run a query to Download Data