Skip to main content
The tokens_solana.fungible table contains metadata for fungible tokens on the Solana blockchain indexed on Dune. This dataset provides essential information about Solana tokens, including:
  • The token mint address
  • The token name and symbol
  • The number of decimals used by the token
  • Additional metadata such as token URI and creation details

​
Utility

The Solana fungible token metadata table offers valuable information for token analysis and integration, allowing you to:
  • Identify tokens on the Solana blockchain
  • Retrieve essential token information for calculations and display
  • Access additional metadata for more comprehensive token analysis

​
Table Schema

ColumnTypeDescription
token_mint_addressVARCHARFungible token mint address
address_prefixVARCHARAddress prefix for indexing
decimalsBIGINTNumber of decimal places for the token
nameVARCHARToken name
symbolVARCHARToken symbol
token_uriVARCHARToken metadata URI
metadata_programVARCHARProgram used for creating token metadata
token_versionVARCHARToken program version (spl_token, token2022)
init_txVARCHARTransaction that initialized the mint
created_atTIMESTAMPWhen the token mint was created

​
Network Coverage

This table covers fungible token metadata for the Solana blockchain.

​
Sample Queries

Query Solana fungible tokens This query returns fungible tokens on the Solana blockchain: 
SELECT
    token_mint_address,
    symbol,
    name,
    decimals
FROM tokens_solana.fungible
LIMIT 100
Find tokens with a specific symbol This query finds all tokens with the symbol “USDC” on Solana: 
SELECT
    token_mint_address,
    symbol,
    name,
    decimals,
    created_at
FROM tokens_solana.fungible
WHERE symbol = 'USDC'
List tokens with non-standard decimal places This query lists tokens that don’t use the standard 9 decimal places on Solana: 
SELECT
    token_mint_address,
    symbol,
    name,
    decimals
FROM tokens_solana.fungible
WHERE decimals != 9
ORDER BY decimals DESC
LIMIT 50