Table Details
| Property | Value |
|---|---|
| Table Name | xrp_ledger.raw.fungible_balances |
| Table Status | Production-Ready |
| Unique Key | ledger_close_time, transaction_hash, account, token_id |
| Clustering Key(s) | to_date("ledger_close_time") |
| Search Optimization | account |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| account | VARCHAR(16777216) | The address that owns this balance |
| raw_balance | FLOAT | The raw balance amount denoted in drops (smallest unit of XRP) |
| raw_balance_str | VARCHAR(16777216) | The raw balance amount as a string representation, preserving precision for large numbers. |
| balance | FLOAT | The normalized balance amount, typically converted to standard units (XRP or token units). |
| token_name | VARCHAR(16777216) | The human-readable name of the token/currency. For XRP, this is typically “XRP”. For issued tokens, this is the currency code. |
| token_issuer | VARCHAR(16777216) | The account that issued this token (AccountID). For XRP, this field is null. For issued tokens, this is the account that created the currency. |
| token_id | VARCHAR(16777216) | Unique identifier for the token, combining currency code and issuer. |
| token_code | VARCHAR(16777216) | The three-letter currency code (ISO 4217 format) or hex code for the token. “XRP” for the native currency. |
| ledger_entry_type | VARCHAR(16777216) | The type of ledger entry that contains this balance. AccountRoot for native XRP, RippleState for other currencies. |
| ledger_entry_index | VARCHAR(16777216) | The index of this specific ledger entry within the ledger. |
| ledger_index | NUMBER(38,0) | The sequence number of the ledger that contains this balance data. |
| ledger_close_time | TIMESTAMP_NTZ(9) | The timestamp when the ledger was closed, indicating when this balance was recorded. |
| ledger_hash | VARCHAR(16777216) | The hash of the ledger header, serving as a unique identifier for the ledger. |
| transaction_hash | VARCHAR(16777216) | The hash of the transaction that last modified this balance. |
| transaction_index | NUMBER(38,0) | The index of the transaction within the ledger that last modified this balance. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated in the database. |