> ## 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.

# Balances Eod

### Table Details

| Property            | Value                                              |
| ------------------- | -------------------------------------------------- |
| Table Name          | `hyperevm.rwa.balances_eod`                        |
| Table Status        | Production-Ready                                   |
| Unique Key          | `block_date`, `address`, `token_address`           |
| Clustering Key(s)   | `block_date, _short_address, _short_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(42)       | Stellar account (G...) or contract (C...) address that holds the balance.               |
| token\_address                  | VARCHAR(42)       | 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.                                  |
| \_has\_error                    | NUMBER(38,0)      | Whether an error was encountered when fetching this balance snapshot.                   |
| \_short\_address                | VARCHAR(4)        | A shortened version of the address used for indexing.                                   |
| \_short\_token\_address         | VARCHAR(4)        | A shortened version of the token address used for indexing.                             |
| \_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.                   |

### Related Docs

* [EVM RWA Balances Eod](/historical-data/supported-blockchains/evm/core-schemas/rwa/balances-eod)