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

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

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               |

<TableSample tableSchema="tokens_solana" tableName="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
```