address,

address_name,

project_name

from polygon.core.dim_labels

where LABEL_TYPE='nft'

and (label_subtype = 'token_contract' or label_subtype = 'general_contract')

),

first_sales as (

SELECT

from_address,

min(block_timestamp::date) as min_date

from flipside_prod_db.polygon.udm_events a

join polygon_nft n on a.contract_address = n.address

group by 1

),

all_users as (select

from_address,

min(block_timestamp::date) as min_all_date

from flipside_prod_db.polygon.udm_events

group by 1)

select count(distinct n.from_address)

from first_sales n

join all_users a on a.min_all_date = n.min_date

where n.from_address =a.from_address