Staking
Pool Balances Daily
Daily snapshots of NEAR Protocol staking pool balances and metrics
Overview
Thenear.staking.pool_balances_daily model provides daily snapshots of staking validator pool balances and share information.
It captures the end-of-day state for each validator pool based on the epoch events and stake balances change when delegators perform actions to alter (increase/decrease) their stake.
It includes all validators, including idle and inactive validators.
The model is updated daily.
Key Features
Daily Aggregation
- Captures the final state of each pool at the end of each day
- Provides a consistent view for day-over-day comparisons
- Simplifies time-series analysis of pool metrics
Balance Tracking
- Monitors both NEAR and USD-denominated balances
- Maintains precision with string representations
- Tracks exchange rates for historical value analysis
Share Management
- Records total shares outstanding
- Tracks share-to-NEAR exchange rates
- Enables accurate calculation of delegator positions
Column Description
Unique Key:date, pool_id
| Column | Type | Description |
|---|---|---|
| date | TIMESTAMP | Date of the balance snapshot |
| pool_id | STRING | Identifier of the staking pool |
| balance_str | STRING | Pool’s NEAR balance (string format for precision) |
| balance | FLOAT | Pool’s NEAR balance (float format) |
| usd_balance | NUMERIC | USD equivalent of the pool’s NEAR balance |
| usd_exchange_rate | NUMERIC | NEAR to USD exchange rate |
| shares_str | STRING | Total shares in the pool (string format) |
| shares | NUMERIC | Total number of shares in the pool |
| shares_exchange_rate | NUMERIC | Exchange rate between shares and NEAR |
| last_activity_block_timestamp | TIMESTAMP | Timestamp of the pool’s last activity |
Use Cases
This model is particularly useful for:- Historical analysis of validator performance and stake distribution trends
- Day-over-day pool comparisons and growth tracking
- Simplified time-series analysis for staking metrics and delegation patterns