Overview

The near.staking.pool_epoch_rewards model tracks rewards received by staking pools for each epoch. It provides detailed information about rewards distribution and pool performance across epochs. This model is updated at every epoch.

Use Cases

This model is particularly useful for:

Calculating pool performance
Tracking epoch returns and rewards distribution for active validators
Monitoring validator effectiveness
Computing effective APY rates based on rewards and staked amount across active validators

Column Description

Unique Key: unique_id

Column	Type	Description
block_timestamp	TIMESTAMP	Timestamp of the block containing the reward distribution
block_height	INTEGER	Height of the block containing the reward distribution
epoch_number	INTEGER	Number of the epoch for which rewards were distributed
pool_id	STRING	Identifier of the staking pool
total_rewards_received_str	STRING	Total rewards received (string format for precision)
total_rewards_received	NUMERIC	Total rewards received by the pool
total_rewards_received_usd	NUMERIC	USD equivalent of rewards received
total_staked_balance_str	STRING	Total staked balance (string format)
total_staked_balance	NUMERIC	Total staked balance in the pool
total_staked_balance_usd	NUMERIC	USD equivalent of total staked balance
total_number_of_shares_str	STRING	Total number of shares (string format)
total_number_of_shares	NUMERIC	Total number of shares in the pool
usd_exchange_rate	NUMERIC	NEAR to USD exchange rate
shares_exchange_rate	NUMERIC	Exchange rate between shares and NEAR
transaction_hash	STRING	Hash of the reward distribution transaction
transaction_index	INTEGER	Index of the transaction within the block
receipt_id	STRING	Unique identifier of the receipt
receipt_index	INTEGER	Index of the receipt within the block
receipt_outcome_index	INTEGER	Index of the receipt outcome
log_index	INTEGER	Index of the log within the receipt
pseudo_global_index	INTEGER	Global ordering index
unique_id	STRING	Unique identifier for the reward event

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Pool Epoch Rewards

Overview

Use Cases

Column Description

​Overview

​Use Cases

​Column Description

Overview

Use Cases

Column Description