Fungible Tokens - Allium Documentation Hub

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

Table Details

Property	Value
Table Name	`solana.raw.fungible_tokens`
Table Status	Production-Ready
Unique Key	`address`
Search Optimization	`address`

Isolating Fungible Tokens

Token Standard:
Only include tokens where token_standard is either null, 'Fungible', 'token_ext', or 'FungibleAsset'.
Edition Account:
Only include tokens where edition_acc is null or equals 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s' (the default edition account for fungible tokens).
Decimals:
Exclude rows where decimals is 0.
** Specific Protocol Exclusions:**
Exclude liquidity position from Orca whirlpool, Raydium CLMM, Meteora.

Table Columns

Column Name	Data Type	Description
address	VARCHAR(16777216)	The mint address of the token.
name	VARCHAR(16777216)	The display name of the token.
symbol	VARCHAR(16777216)	The ticker symbol of the token.
decimals	NUMBER(38,0)	Number of decimal places the token uses.
logo_uri	VARCHAR(16777216)	URI to the token’s logo image.
token_creation_block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block in which this SPL token was first created.
token_init_block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block in which this SPL token account was initialized.
mint_authority	VARCHAR(16777216)	Address authorized to mint new tokens for this SPL token. Null if minting is permanently disabled.
create_signer	VARCHAR(16777216)	The signer authority that created this account or resource.
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the record was created.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the record was last updated.