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

# Jetton Balances Eod

### Table Details

| Property            | Value                                      |
| ------------------- | ------------------------------------------ |
| Table Name          | `ton.unhydrated.jetton_balances_eod`       |
| Table Status        | Production-Ready                           |
| Unique Key          | `block_date`, `address`, `token`           |
| Clustering Key(s)   | `block_date, _short_address, _short_token` |
| Search Optimization | `address`, `token`                         |

### Table Columns

| Column Name           | Data Type         | Description                                                                                                                                                                   |
| --------------------- | ----------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| address               | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies.                        |
| token                 | VARCHAR(16777216) | Address or identifier of a token. Context-dependent alias used in models where the column is named `token` rather than `token_address`.                                       |
| raw\_balance\_str     | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision. Avoids floating-point truncation for tokens with very large integer balances.                      |
| block\_date           | TIMESTAMP\_NTZ(9) | Calendar date (UTC) derived from block\_timestamp. Used as a partition key in incremental models.                                                                             |
| block\_timestamp      | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                                                       |
| masterchain\_seqno    | NUMBER(38,0)      | Sequence number on the masterchain.                                                                                                                                           |
| transaction\_hash     | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                                                                   |
| pseudo\_global\_order | NUMBER(38,0)      | Internal ordering key combining block slot and transaction index to define a globally-consistent event ordering on Solana. Used for incremental processing and deduplication. |
| \_short\_address      | VARCHAR(16777216) | Truncated version of the address column used as a clustering/partition key. Contains only the first few bytes of the address to improve query performance on large tables.    |
| \_short\_token        | VARCHAR(16777216) | Shortened display form of the token contract address for this record.                                                                                                         |
| \_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.                                                                                                                 |