Latest snapshot of validator stakes and metrics from the Polygon PoS network
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 |