NuveveCryptoArchivedNFT Collections By Volume
    Updated 2022-11-17
    with nfts as (
    select
    address,
    address_name
    from polygon.core.dim_labels
    where label_type = 'nft'
    )

    select
    nfts.address_name as nft,
    count(trade.tx_hash) as tx_volume
    from polygon.core.fact_token_transfers as trade
    inner join nfts on trade.contract_address = nfts.address
    group by nfts.address_name
    order by 2 desc
    Run a query to Download Data