Table Details
| Property | Value |
|---|---|
| Table Name | near.unhydrated.fungible_balances_eod |
| Table Status | Production-Ready |
| Unique Key | block_date, address, token_address, account_id |
| Clustering Key(s) | block_date, _short_address, _short_token_address |
| Search Optimization | address, token_address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR(16777216) | NEAR account that holds the token balance. |
| token_address | VARCHAR(16777216) | Contract account of the fungible token, or the native NEAR sentinel for unwrapped NEAR. |
| account_id | VARCHAR(16777216) | NEAR account ID associated with this balance (same as address for most wallets). |
| token_type | VARCHAR(16777216) | Token category (native or ft). |
| raw_balance_str | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision. |
| block_date | TIMESTAMP_NTZ(9) | Date of the snapshot (block_timestamp truncated to day). |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block this end-of-day snapshot is taken from. |
| block_height | NUMBER(38,0) | Height of the block this end-of-day snapshot is taken from. |
| block_hash | VARCHAR(16777216) | Hash of the block this end-of-day snapshot is taken from. |
| _short_address | VARCHAR(64) | Truncated address used for clustering and search. |
| _short_token_address | VARCHAR(64) | Truncated token address used for clustering and search. |
| _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. |