Table Details
| Property | Value |
|---|---|
| Table Name | stellar.rwa.balances_eod |
| Table Status | Production-Ready |
| Unique Key | block_date, address, token_address |
| Clustering Key(s) | block_date, token_address |
| Search Optimization | address, token_address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(16777216) | Blockchain this record belongs to; always stellar. |
| address | VARCHAR(16777216) | Stellar account (G…) or contract (C…) address that holds the balance. |
| token_address | VARCHAR(16777216) | Asset identifier of the RWA token. |
| token_name | VARCHAR(16777216) | Full name of the RWA token. |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the RWA token. |
| token_decimals | NUMBER(38,0) | Number of decimal places used to normalize the token’s raw amounts. |
| raw_balance_str | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision. |
| raw_balance | FLOAT | Token balance in the token’s smallest unit (not decimal-adjusted). |
| balance_str | VARCHAR(16777216) | Normalized token balance stored as a string for full precision. |
| balance | FLOAT | Token balance normalized by the token’s decimal precision (raw_balance / 10^decimals). |
| block_date | TIMESTAMP_NTZ(9) | Calendar date of the ledger at which this end-of-day balance was captured. |
| block_timestamp | TIMESTAMP_NTZ(9) | Close time of the ledger at which this balance was captured. |
| block_number | NUMBER(38,0) | Sequence number of the ledger at which this balance was captured. |
| block_hash | VARCHAR(16777216) | Hash of the ledger at which this balance was captured. |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that last changed this balance. |
| _account_short | VARCHAR(4) | Internal helper: shortened form of the account address. |
| _asset_id_short | VARCHAR(4) | Internal helper: shortened form of the asset identifier. |
| _rwa_token_created_at | TIMESTAMP_NTZ(9) | Internal pipeline timestamp: when this token was added to the RWA registry. |
| _balances_created_at | TIMESTAMP_NTZ(9) | Internal pipeline timestamp: when the underlying balance record was created. |
| _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. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |