binhachonNew NFT Mints - Same day
    Updated 2022-05-16
    with mint_list as (
    select
    date_trunc('day', block_timestamp) as mint_time,
    flipside_prod_db.solana.fact_nft_mints.mint,
    project_name
    from flipside_prod_db.solana.fact_nft_mints
    left join flipside_prod_db.solana.dim_nft_metadata on (flipside_prod_db.solana.fact_nft_mints.mint = flipside_prod_db.solana.dim_nft_metadata.mint)
    where date_trunc('day', block_timestamp) >= '2022-01-01'
    and succeeded = 'TRUE'
    ),
    sales_list as (
    select
    date_trunc('day', block_timestamp) as sales_time,
    mint
    from flipside_prod_db.solana.fact_nft_sales
    where date_trunc('day', block_timestamp) >= '2022-01-01'
    and marketplace ilike '%magic eden%'
    ),
    first_sales as (
    select
    sales_list.*,
    project_name
    from sales_list
    inner join mint_list on (sales_time = mint_time and sales_list.mint = mint_list.mint)
    )
    select
    sales_time,
    count(distinct project_name) as number_of_new_project
    from first_sales
    group by 1

    Run a query to Download Data