> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Pool Balances Daily

> Daily snapshots of NEAR Protocol staking pool balances and metrics

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

| 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