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