Staking
Pool Epoch Rewards
Tracking of rewards distributed to NEAR Protocol staking pools per epoch
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 |