Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Epoch level validator rewards and performance metrics
| Property | Value |
|---|---|
| Table Name | iota.staking.validator_rewards |
| Table Status | Production-Ready |
| Unique Key | epoch, validator_address |
| Clustering Key(s) | checkpoint_timestamp::date |
| Search Optimization | validator_address |
iota.staking.validator_rewards model provides detailed information about rewards and performance metrics for each validator per epoch. It only inclues data post-IOTA migration to the Move ecosystem.
| Column Name | Data Type | Description |
|---|---|---|
| checkpoint_date | TIMESTAMP_NTZ(9) | Date and time of the checkpoint |
| epoch | NUMBER(38,0) | The epoch number |
| validator_address | VARCHAR(16777216) | Address of the validator |
| commission_rate | FLOAT | Percentage of rewards taken by the validator as commission |
| voting_power | NUMBER(38,0) | Validator’s voting power in the consensus mechanism |
| apr | FLOAT | Annual Percentage Rate for staking with this validator (calculated) |
| stake | FLOAT | Total amount of IOTA staked with this validator |
| pool_staking_reward | FLOAT | Rewards from transaction fees and stake subsidies allocated to this pool |
| staking_reward | FLOAT | Total staking rewards earned by this validator’s pool in this epoch |
| pool_exchange_rate | FLOAT | Exchange rate between pool tokens and IOTA for this validator’s pool |
| pool_token_amount | FLOAT | Amount of pool tokens in this validator’s staking pool |
| iota_amount | FLOAT | Amount of IOTA tokens in this validator’s staking pool |
| reference_gas_survey_quote | FLOAT | Gas price quote submitted by this validator for the network gas survey |
| tallying_rule_global_score | FLOAT | Performance score assigned to this validator based on the tallying rule |
| tallying_rule_reporters | VARIANT | List of validator addresses that reported on this validator’s performance |
| checkpoint_sequence | NUMBER(38,0) | Sequence number of the checkpoint |
| checkpoint_timestamp | TIMESTAMP_NTZ(9) | Timestamp of when the checkpoint was created |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when the record was created in the database |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when the record was last updated in the database |
Was this page helpful?