Use Cases
- Calculate validator performance and returns
- Analyze reward distribution patterns
- Compare validator commission strategies
- Track delegator earnings over time
- Monitor network reward economics
- Evaluate validator profitability
Table Schema
| Column Name | Data Type | Description |
|---|---|---|
| operator_address | VARCHAR | The validator’s operator address |
| total_rewards | DECIMAL | Total rewards distributed (commission + delegator rewards) |
| validator_commission | DECIMAL | Amount of rewards taken as commission by the validator |
| delegator_rewards | DECIMAL | Amount of rewards distributed to delegators |
| transaction_hash | VARCHAR | Hash of the transaction containing the reward distribution |
| transaction_index | INTEGER | Index of the transaction in the block |
| log_index | INTEGER | Index of the event log in the transaction |
| block_timestamp | TIMESTAMP | Timestamp of the block containing the reward distribution |
| block_number | INTEGER | Block number containing the reward distribution |
| block_hash | VARCHAR | Hash of the block containing the reward distribution |
| unique_id | VARCHAR | Unique identifier for the reward distribution event |