Fungible Balances - Allium Documentation Hub

Table Details

Property	Value
Table Name	`tron.assets.fungible_balances`
Table Status	Production-Ready
Unique Key	`block_timestamp::date`, `_address_short`, `_token_address_short`, `address`, `token_address`, `block_number`, `unique_id`
Clustering Key(s)	`block_timestamp::date, _address_short, _token_address_short`
Search Optimization	`_address_short`, `address`, `_token_address_short`, `token_address`

Model Caveats

Tron balances are derived by netting all token transfers for each account (summing incoming credits and subtracting outgoing debits), because Tron does not support point-in-time balance queries for TRC20 contracts. As a result, balances are subject to the following caveats:

Balance Changes Without Transfers: Certain operations may modify token balances without generating a transfer event, such as direct contract interactions that adjust balances internally and bypass the standard transfer log. Some older TRC20 contracts or legacy blocks may not emit standard transfer events, so balances for these contracts might not be accurately captured.
Rebasing Tokens: Rebasing tokens automatically adjust their total supply, which changes individual balances without explicit transfer events. Balances that rely solely on transfer events can drift for these tokens.
Null Balances: The zero address T9yD14Nj9j7xAB4dbGeiX9h8unkKHxuWwb shows negative balances for most TRC20 tokens, because event logs represent the zero address as the sender during token mints even though it never held the assets.

Table Columns

Column Name	Data Type	Description
token_type	VARCHAR(16777216)	Identifies whether the balance record is for a `native` or `erc20` token
address	VARCHAR(34)	The wallet address holding the tokens
token_address	VARCHAR(34)	Contract address of the token
token_name	VARCHAR(134217728)	Name of the token
token_symbol	VARCHAR(134217728)	Symbol of the token
raw_balance_str	VARCHAR(134217728)	Token balance, unnormalized, as string to retain precision
raw_balance	FLOAT	Token balance, unnormalized
balance_str	VARCHAR(134217728)	Token balance as string to retain precision
balance	FLOAT	Token balance, normalized
usd_balance	FLOAT	Token balance, normalized, in USD
usd_exchange_rate	FLOAT	Exchange rate used for USD conversion
transaction_hash	VARCHAR(66)	Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.
transaction_index	NUMBER(38,0)	Zero-based position of the transaction within its block. The first transaction in a block has index 0.
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block
block_number	NUMBER(38,0)	Number of the block
block_hash	VARCHAR(66)	Hash of the block
unique_id	VARCHAR(134217728)	Unique identifier combining block, address, token address
_address_short	VARCHAR(34)	Short prefix of the address for search optimization.
_token_address_short	VARCHAR(34)	Shortened display form of the token contract address (first and last N characters with ellipsis).
_pseudo_global_order	NUMBER(38,0)	Internal ordering key for Tron events that may lack explicit block-level ordering. Used for consistent incremental processing.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated
_changed_since_full_refresh	BOOLEAN	Indicates if the record has changed since the last full data refresh.

EVM Assets Fungible Balances

​Table Details

​Model Caveats

​Table Columns

​Related Docs

Table Details

Model Caveats

Table Columns

Related Docs