itsxenuxNew NFT Mints Magic Eden new projects
    Updated 2022-05-15
    WITH
    secondary_sales as (
    SELECT
    block_timestamp::date as date,
    n.mint,
    m.label
    FROM flipside_prod_db.solana.fact_nft_sales n
    LEFT OUTER JOIN flipside_prod_db.solana.dim_labels m ON n.mint = m.address
    WHERE marketplace ilike '%magic eden%'
    and SUCCEEDED = 'TRUE'
    ),
    mind as (
    SELECT
    label,
    min(date) as min_date
    FROM secondary_sales
    GROUP BY 1
    )

    SELECT min_date, COUNT(DISTINCT label) as new_collections
    from mind
    WHERE min_date >= '2022-01-01'
    GROUP BY 1

    Run a query to Download Data