SalehPolygon NFT-How many Polygon users started off with NFTs?
    Updated 2022-07-15
    with lst_nft as (
    select
    address
    -- LABEL_SUBTYPE
    from polygon.core.dim_labels
    where LABEL_TYPE='nft'
    and (label_subtype = 'token_contract' or label_subtype = 'general_contract')

    )
    ,lst_first_buy as (
    select
    TO_ADDRESS as buyer
    ,min(block_timestamp::date) as first_buy_date_nft
    from flipside_prod_db.polygon.udm_events u
    join lst_nft on lst_nft.address = u.CONTRACT_ADDRESS
    where EVENT_NAME='transfer'
    and AMOUNT_USD>0
    and TO_ADDRESS not in ('0x0000000000000000000000000000000000000000' ,'0x00000000000b69ec332f49b7c4d2b101f93c3bed'
    ,'0x00000000000b69ec332f49b7c4d2b101f93c3bed','0x00000000000b186ebef1ac9a27c7eb16687ac2a9'
    ,'0x000000000000000000000000000000000000dead','0x0000000000000000000000000000000000000001')
    group by 1
    order by 1

    )
    ,lst_first_tx as (
    select
    from_address as user
    ,min(block_timestamp::date) as first_date_tx
    from flipside_prod_db.polygon.udm_events u
    where
    from_address not in ('0x0000000000000000000000000000000000000000' ,'0x00000000000b69ec332f49b7c4d2b101f93c3bed'
    ,'0x00000000000b69ec332f49b7c4d2b101f93c3bed','0x00000000000b186ebef1ac9a27c7eb16687ac2a9'
    ,'0x000000000000000000000000000000000000dead','0x0000000000000000000000000000000000000001')
    group by 1
    order by 1
    Run a query to Download Data