Table Details
| Property | Value |
|---|---|
| Table Name | ton.unhydrated.native_fungible_balances_eod |
| Table Status | Production-Ready |
| Unique Key | block_date, account |
| Clustering Key(s) | block_date, _short_account |
| Search Optimization | account |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| account | VARCHAR(16777216) | Hedera account ID in the format {shard}.{realm}.{num}. Identifies a specific Hedera account. |
| 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. |
| mc_block_seqno | NUMBER(38,0) | The masterchain block sequence number |
| 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_account | VARCHAR(16777216) | Shortened display form of the account 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. |