The tokens.nft table contains metadata for NFTs across all EVM-compatible networks indexed on Dune. This dataset provides essential information about NFTs, including:

  • The blockchain on which the NFT exists
  • The contract address of the NFT
  • The name of the NFT collection
  • The symbol of the NFT collection
  • The standard used by the NFT (e.g., ERC721, ERC1155)

Utility

The NFT metadata table offers valuable information for NFT analysis and integration, allowing you to:

  • Identify NFT collections across different blockchains
  • Retrieve essential NFT information for calculations and display
  • Cross-reference NFT data with other tables like tokens.nft_transfers

The table contains the following columns:

Datatypes on Snowflake datashare are different in some cases, read more here.

Network Coverage

NFT metadata is available for all EVM-compatible networks indexed by Dune.

Sample Queries

Query NFT collections on a specific blockchain

This query returns NFT collections on the Ethereum blockchain:

SELECT
    contract_address,
    name,
    symbol,
    standard
FROM tokens.nft
WHERE blockchain = 'ethereum'
LIMIT 100

Find NFTs with a specific standard across blockchains

This query finds all NFTs using the ERC721 standard across different blockchains:

SELECT
    blockchain,
    contract_address,
    name,
    symbol
FROM tokens.nft
WHERE standard = 'erc721'

List NFT collections with a specific keyword in their name

This query lists NFT collections that have “Punk” in their name:

SELECT
    blockchain,
    contract_address,
    name,
    symbol,
    standard
FROM tokens.nft
WHERE name LIKE '%Punk%'
ORDER BY blockchain, name
LIMIT 50