NuveveCryptoArchivedUsers That Get Into Polygon NFTs Every Month
    Updated 2023-04-13
    with nfts as (
    select
    address,
    address_name
    from polygon.core.dim_labels
    where label_type = 'nft'
    ),

    traders as (
    select
    date_trunc('month', trade.block_timestamp) as month,
    count(distinct(trade.to_address))/30 as users
    from polygon.core.fact_token_transfers as trade
    inner join nfts on trade.contract_address = nfts.address
    group by month
    )

    select
    avg(users) as users
    from traders

    Run a query to Download Data