Use Cases
- Identify top validators by stake amount or delegation
- Evaluate validator commission rates for delegation decisions
- Monitor validator status changes
- Analyze the relationship between validator self-stake and delegated stake
Table Schema
| Column Name | Data Type | Description |
|---|---|---|
| validator_id | INTEGER | Unique identifier assigned to the validator by the Polygon network |
| validator_stake | DECIMAL | Amount of MATIC (POL) tokens self-staked by the validator |
| delegator_stake | DECIMAL | Total amount of MATIC (POL) tokens staked by delegators to this validator |
| reward | DECIMAL | Accumulated validator rewards in MATIC (POL), including block rewards and commission |
| delegators_reward | DECIMAL | Accumulated rewards in MATIC (POL) for delegators, excluding validator commission |
| initial_reward_per_stake | DECIMAL | Initial reward rate per staked MATIC (POL) token when validator joined |
| activation_epoch | INTEGER | Epoch number when the validator was activated in the network |
| deactivation_epoch | INTEGER | Epoch number when the validator was deactivated (if applicable) |
| jail_time | TIMESTAMP | Timestamp when validator was jailed for poor performance or misbehavior (if applicable) |
| signer | VARCHAR | Ethereum address of the validator’s signer node that participates in block production |
| contract_address | VARCHAR | Ethereum address of the validator’s staking contract |
| validator_status | INTEGER | Current status of validator (0=Inactive, 1=Active, 2=Locked, 3=Unstaked) |
| commission_rate | INTEGER | Percentage of delegator rewards claimed by validator as commission (in basis points, 100 = 1%) |
| last_commission_update | INTEGER | Block number when validator last updated their commission rate |
| block_timestamp | TIMESTAMP | Timestamp of the block when the validator stake was recorded |
| block_number | INTEGER | Block number of the block when the validator stake was recorded |
| block_hash | VARCHAR | Hash of the block when the validator stake was recorded |
| transaction_hash | VARCHAR | Hash of the transaction when the validator stake was recorded |
| transaction_index | INTEGER | Index of the transaction when the validator stake was recorded |
| trace_address | VARCHAR | Address of the validator’s contract |
| trace_id | VARCHAR | Hash of the transaction when the validator stake was recorded |
| _created_at | TIMESTAMP | Timestamp of when the record was created |
| _updated_at | TIMESTAMP | Timestamp of when the record was updated |