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