Overview

The near.staking.shares_exchange_rate model tracks the exchange rates between staking shares and NEAR tokens across validators. This model is updated at every epoch.

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

Column Description

Unique Key: unique_id

Column	Type	Description
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block containing the exchange rate update
block_height	BIGINT	Height of the block containing the exchange rate update
epoch_number	BIGINT	Number of the epoch
event_type	VARCHAR	Type of event that triggered the exchange rate update
pool_id	VARCHAR	Identifier of the staking pool
shares_exchange_rate	VARCHAR	Exchange rate between shares and NEAR (string format for precision)
receipt_id	VARCHAR	Unique identifier of the receipt
pseudo_global_index	BIGINT	Global ordering index receipts in NEAR

Pool Epoch Rewards Overview

⌘I