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

> Realtime tracking of NEAR Protocol staking pool balances and metrics

# Overview

The `near.staking.pool_balances` model provides realtime tracking of staking pool balances and shares based on event logging.
It captures the state of validator pools at each balance-changing event.

This model is updated hourly.

## Use Cases

This model is particularly useful for:

* Tracking historical stake changes across validators
* Accounting shares to NEAR exchange rates across time

## Relationship with Daily Balances

This model serves as the source for the `near.staking.pool_balances_daily` model, which provides daily snapshots of staking validator pool balances.
While this model captures realtime events and balance changes, the daily model aggregates this data to provide end-of-day state for each validator pool.

Key differences:

* This model tracks every balance-changing event (delegation events)
* The daily model provides a single snapshot of the last balance entry per day per pool
* This model includes complete transaction tracing

For daily aggregated views of pool balances, refer to the [NEAR Daily Pool Balances](/historical-data/supported-blockchains/other-ecosystems/near/staking/pool-balances-daily) model.

## Column Description

Unique Key: `unique_id`

| Column                           | Type      | Description                                          |
| -------------------------------- | --------- | ---------------------------------------------------- |
| block\_timestamp                 | TIMESTAMP | Timestamp of the block containing the balance update |
| pool\_id                         | VARCHAR   | Identifier of the staking pool                       |
| balance\_str                     | VARCHAR   | Pool's NEAR balance (string format for precision)    |
| balance                          | FLOAT     | Pool's NEAR balance (float format)                   |
| usd\_balance                     | FLAOT     | USD equivalent of the pool's NEAR balance            |
| usd\_exchange\_rate              | FLAOT     | NEAR to USD exchange rate at time of update          |
| shares\_str                      | VARCHAR   | Total shares in the pool (string format)             |
| shares                           | FLAOT     | Total number of shares in the pool                   |
| shares\_exchange\_rate           | FLAOT     | Exchange rate between shares and NEAR                |
| last\_activity\_block\_timestamp | TIMESTAMP | Timestamp of the pool's last activity                |
| transaction\_hash                | VARCHAR   | Hash of the transaction causing the balance update   |
| transaction\_index               | BIGINT    | Index of the transaction within the block            |
| receipt\_id                      | VARCHAR   | Unique identifier of the receipt                     |
| receipt\_index                   | BIGINT    | Index of the receipt within the block                |
| receipt\_outcome\_index          | BIGINT    | Index of the receipt outcome                         |
| log\_index                       | BIGINT    | Index of the log within the receipt                  |
| pseudo\_global\_index            | BIGINT    | Global ordering index                                |
| unique\_id                       | VARCHAR   | Unique identifier for the balance update event       |