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