The tokens_solana.nft table contains metadata for non-fungible tokens (NFTs) on the Solana blockchain indexed on Dune. This dataset provides essential information about Solana NFTs, including:

  • The NFT mint address and associated accounts
  • Token details such as name, symbol, and URI
  • Creator and collection information
  • Transaction details of the NFT creation

Utility

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

  • Identify and track NFTs on the Solana blockchain
  • Retrieve essential NFT information for display and analysis
  • Access creator and collection data for comprehensive NFT insights

The table contains the following columns:

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

Network Coverage

This table covers NFT metadata for the Solana blockchain.

Sample Queries

Query Solana NFTs

This query returns NFTs on the Solana blockchain:

SELECT
    account_mint,
    token_name,
    token_symbol,
    token_uri
FROM tokens_solana.nft
LIMIT 100

Find NFTs from a specific collection

This query finds all NFTs from a specific collection on Solana:

SELECT
    account_mint,
    token_name,
    token_symbol,
    token_uri
FROM tokens_solana.nft
WHERE collection_mint = 'your_collection_mint_address_here'
LIMIT 50

List NFTs by a specific creator

This query lists NFTs created by a specific verified creator on Solana:

SELECT
    account_mint,
    token_name,
    token_symbol,
    token_uri,
    call_block_time
FROM tokens_solana.nft
WHERE verified_creator = 'your_creator_address_here'
ORDER BY call_block_time DESC
LIMIT 50