​

Overview

The near.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