Overview
Thenear.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 |