| account_id | VARCHAR(16777216) | Stellar account (G-address) whose balance this snapshot describes. |
| asset_type | VARCHAR(16777216) | Asset type: native, credit_alphanum4, or credit_alphanum12. |
| asset_id | VARCHAR(16777216) | Composite code:issuer identifier of the asset for non-native assets. |
| asset_code | VARCHAR(16777216) | Asset code for a classic asset. |
| asset_issuer | VARCHAR(16777216) | Issuer G-address for a classic asset. |
| token_id | NUMBER(38,0) | Identifier of the Soroban token for contract-based assets. |
| raw_balance_str | VARCHAR(16777216) | Balance in stroops, stored as a string for full precision. |
| raw_balance | NUMBER(38,0) | Balance in stroops (not decimal-adjusted). |
| raw_minimum_balance | NUMBER(38,0) | Minimum required balance for this account in stroops, based on subentry count and base reserve. |
| raw_available_balance | NUMBER(38,0) | Available balance (total minus liabilities and minimum reserve) in stroops. |
| raw_liabilities_selling | NUMBER(38,0) | Selling liabilities on this account or trustline, in stroops. |
| raw_liabilities_buying | NUMBER(38,0) | Buying liabilities on this account or trustline, in stroops. |
| raw_pre_balance_str | VARCHAR(16777216) | Balance before this change, in stroops, stored as a string for full precision. |
| raw_pre_balance | NUMBER(38,0) | Balance before this change was applied, in stroops. |
| last_modified_ledger_sequence | NUMBER(38,0) | Ledger sequence in which this entry was most recently modified. |
| ledger_close_time | TIMESTAMP_NTZ(9) | Time when the ledger containing this change closed and was finalized. |
| ledger_hash | VARCHAR(16777216) | Hash of the ledger containing this change. |
| ledger_sequence | NUMBER(38,0) | Sequence number of the ledger containing this change. |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this change. |
| transaction_index | NUMBER(38,0) | Position of the transaction within its ledger. |
| ledger_entry_change_index | NUMBER(38,0) | Sequential index of this change within the transaction’s ledger entry changes. |
| ledger_entry_type | VARCHAR(16777216) | Numeric type of the affected LedgerEntry (e.g. account, trustline, contract data). |
| ledger_entry_type_str | VARCHAR(16777216) | Human-readable name of the LedgerEntry type. |
| ledger_entry_change_type | VARCHAR(16777216) | Type of change applied to this ledger entry (created, updated, removed, state). |
| ledger_entry_change_reason_str | VARCHAR(16777216) | Human-readable description of the reason for this ledger entry change. |
| ledger_entry_change_reason | VARCHAR(16777216) | Reason code for this ledger entry change. |
| post_ledger_entry | VARIANT | State of the ledger entry after this change was applied. |
| pre_ledger_entry | VARIANT | State of the ledger entry before this change was applied. |
| _extra_fields | VARIANT | Catch-all of additional source fields not mapped to a dedicated column. |
| unique_id | VARCHAR(16777216) | Deterministic unique identifier for this row. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
