strawbettySol NFT projects
    Updated 2022-05-19
    with mints_2022 as(
    select mint, trunc(block_timestamp, 'day') as Date
    from flipside_prod_db.solana.fact_nft_mints
    where succeeded = TRUE
    and Date >= '2022-01-01'
    order by Date asc
    )

    select Date, count(distinct label) as solana_projects
    from mints_2022 a
    join flipside_prod_db.solana.dim_labels b on a.mint = b.address
    group by Date
    order by Date
    Run a query to Download Data