Table Details
| Property | Value |
|---|---|
| Table Name | near.staking.delegator_balances_latest_beta |
| Table Status | Production-Ready |
| Unique Key | delegator_id, pool_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| note | VARCHAR(65) | Additional note or annotation for the interest rate record (e.g., protocol-specific context). |
| delegator_id | VARCHAR(16777216) | Identifier of the delegator involved in the event. |
| pool_id | VARCHAR(16777216) | Protocol-specific identifier for a liquidity pool. For Balancer V2 this is a bytes32 pool ID; for Uniswap V4 this is derived from the pool key hash. |
| shares_balance_str | VARCHAR(16777216) | Staking pool shares balance as a string for lossless precision. |
| latest_shares_exchange_rate | VARCHAR(16777216) | Latest exchange rate between pool shares and NEAR tokens, reflecting accumulated rewards. |
| balance_str | VARCHAR(16777216) | Normalized token balance stored as a string for full precision. Equivalent to balance but avoids floating-point truncation. |
| balance | FLOAT | Sum of end-of-day token balances for this address_type. |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block that last changed this balance. |
| first_activity_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the first recorded staking activity for this delegator. |