solana.raw.fungible_tokens table contains the raw list of all fungible tokens on Solana.
Note:
The SPL standard on Solana is flexible and supports both fungible tokens (like USDC, USDT, etc.) and non-fungible tokens (NFTs). As a result, we apply a filter logic (described below) to isolate the “ERC20-like” fungible tokens.
Isolating Fungible Tokens
-
Token Standard:
Only include tokens wheretoken_standardis eithernull,'Fungible','token_ext', or'FungibleAsset'. -
Edition Account:
Only include tokens whereedition_accisnullor equals'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s'(the default edition account for fungible tokens). -
Decimals:
Exclude rows wheredecimalsis0. -
** Specific Protocol Exclusions:**
Exclude liquidity position from Orca whirlpool, Raydium CLMM, Meteora.
Table Columns
| Column | Description | Type | Example |
|---|---|---|---|
| address | The mint address of the token. | varchar | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v |
| name | The display name of the token. | varchar | USD Coin |
| symbol | The ticker symbol of the token. | varchar | USDC |
| decimals | Number of decimal places the token uses. | number | 6 |
| logo_uri | URI to the token’s logo image. | varchar | https://raw.githubusercontent.com/… |
| _created_at | Timestamp when the record was created. | timestamp_ntz | 2023-04-25 15:55:07 |
| _updated_at | Timestamp when the record was last updated. | timestamp_ntz | 2023-05-01 12:00:00 |