Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Details
| Property | Value |
|---|---|
| Table Name | stellar_testnet.raw.balance_snapshots |
| Table Status | Beta 🌱 |
| Unique Key | ledger_close_time, unique_id |
| Clustering Key(s) | to_date("ledger_close_time") |
| Search Optimization | account_id, asset_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| account_id | VARCHAR(16777216) | The Stellar account address (G…) holding the balance, or null for contract balances. |
| asset_type | VARCHAR(16777216) | Type of asset (native, credit_alphanum4, credit_alphanum12, contract). |
| asset_id | VARCHAR(16777216) | Unique identifier of the asset (asset code:issuer, or contract id). |
| asset_code | VARCHAR(16777216) | Code of the credit asset (e.g. “USDC”), null for native XLM. |
| asset_issuer | VARCHAR(16777216) | Address of the asset’s issuer account, null for native XLM. |
| token_id | NUMBER(38,0) | Contract address (C…) if the balance is for a Soroban token, null otherwise. |
| raw_balance_str | VARCHAR(16777216) | Balance as a string (preserves precision for large numbers). |
| raw_balance | NUMBER(38,0) | Balance as a numeric value (in stroops for native; smallest unit for credit assets). |
| raw_minimum_balance | NUMBER(38,0) | Minimum required balance for the account (reserves + selling liabilities). |
| raw_available_balance | NUMBER(38,0) | Balance available for use (raw_balance minus minimum and selling liabilities). |
| raw_liabilities_selling | NUMBER(38,0) | Selling liabilities held against this balance from open offers. |
| raw_liabilities_buying | NUMBER(38,0) | Buying liabilities held against this balance from open offers. |
| raw_pre_balance_str | VARCHAR(16777216) | Previous balance as a string before this change. |
| raw_pre_balance | NUMBER(38,0) | Previous balance as a numeric value before this change. |
| last_modified_ledger_sequence | NUMBER(38,0) | Ledger sequence at which this entry was last modified. |
| ledger_close_time | TIMESTAMP_NTZ(9) | Time the ledger that produced this snapshot was closed (Unix timestamp). |
| ledger_hash | VARCHAR(16777216) | Hash of the ledger that produced this snapshot. |
| ledger_sequence | NUMBER(38,0) | Sequence number of the ledger that produced this snapshot. |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this snapshot, if any. |
| transaction_index | NUMBER(38,0) | Position of the transaction within its ledger. |
| ledger_entry_change_index | NUMBER(38,0) | Position of this change within the ledger entry change list. |
| ledger_entry_type | VARCHAR(16777216) | Numeric type of the ledger entry (account, trustline, contract_data, etc.). |
| ledger_entry_type_str | VARCHAR(16777216) | String name of the ledger entry type. |
| ledger_entry_change_type | VARCHAR(16777216) | Numeric type of change (created, updated, removed, state). |
| ledger_entry_change_reason_str | VARCHAR(16777216) | Human-readable reason for the change (operation, fee, etc.). |
| ledger_entry_change_reason | VARCHAR(16777216) | Numeric reason code for the change. |
| post_ledger_entry | VARIANT | The full ledger entry after the change, as JSON. |
| pre_ledger_entry | VARIANT | The full ledger entry before the change, as JSON. |
| _extra_fields | VARIANT | Additional fields not normalised into named columns, as JSON. |
| unique_id | VARCHAR(16777216) | A synthetic primary key for this snapshot 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. |