> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Token Metadata

> Metadata for fungible tokens on the Solana blockchain.

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

| Column | Type | Description |
| - | - | - |
| `token_mint_address` | `VARCHAR` | Fungible token mint address |
| `address_prefix` | `VARCHAR` | Address prefix for indexing |
| `decimals` | `BIGINT` | Number of decimal places for the token |
| `name` | `VARCHAR` | Token name |
| `symbol` | `VARCHAR` | Token symbol |
| `token_uri` | `VARCHAR` | Token metadata URI |
| `metadata_program` | `VARCHAR` | Program used for creating token metadata |
| `token_version` | `VARCHAR` | Token program version (spl\_token, token2022) |
| `init_tx` | `VARCHAR` | Transaction that initialized the mint |
| `created_at` | `TIMESTAMP` | When the token mint was created |

[https://dune.com/embeds/3419983/5785629?table\_schema\_t6f0df=tokens\_solana\&table\_name\_t6f0df=fungible](https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=tokens_solana\&table_name_t6f0df=fungible)

### 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:

```sql theme={null}
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:

```sql theme={null}
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:

```sql theme={null}
SELECT
    token_mint_address,
    symbol,
    name,
    decimals
FROM tokens_solana.fungible
WHERE decimals != 9
ORDER BY decimals DESC
LIMIT 50
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.