Table Columns
Unique Key:account, token_id
| Column Name | Data Type | Description |
|---|---|---|
| account | VARCHAR | The address that owns this balance |
| raw_balance | FLOAT | The raw balance amount denoted in drops (smallest unit of XRP) |
| raw_balance_str | VARCHAR | 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 | 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 | 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 | Unique identifier for the token, combining currency code and issuer. |
| token_code | VARCHAR | The three-letter currency code (ISO 4217 format) or hex code for the token. “XRP” for the native currency. |
| ledger_entry_type | VARCHAR | The type of ledger entry that contains this balance. AccountRoot for native XRP, RippleState for other currencies. |
| ledger_entry_index | VARCHAR | The index of this specific ledger entry within the ledger. |
| ledger_index | BIGINT | 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 | The hash of the ledger header, serving as a unique identifier for the ledger. |
| transaction_hash | VARCHAR | The hash of the transaction that last modified this balance. |
| transaction_index | BIGINT | 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. |