​
Use Cases

  • Analyze validator performance and stake trends over time
  • Track network participation and decentralization metrics
  • Monitor changes in commission rates
  • Perform historical analysis of staking rewards

This table provides a daily snapshot of validator stakes and related metrics on the Polygon Proof of Stake (PoS) network, including self-stake, delegated stake, rewards, and validator status.

​
Table Schema

Column NameData TypeDescription
dateDATEThe date of the stake snapshot (UTC)
validator_idINTEGERUnique identifier assigned to the validator by the Polygon network
total_stakeDECIMALTotal amount of MATIC (POL) tokens staked (validator self-stake + delegated stake)
validator_stakeDECIMALAmount of MATIC (POL) tokens self-staked by the validator
delegator_stakeDECIMALTotal amount of MATIC (POL) tokens staked by delegators to this validator
rewardDECIMALAccumulated validator rewards in MATIC (POL), including block rewards and commission from delegators
delegators_rewardDECIMALAccumulated rewards in MATIC (POL) for delegators, excluding validator commission
validator_statusINTEGERCurrent status of validator (0=Inactive, 1=Active, 2=Locked, 3=Unstaked)
commission_rateINTEGERPercentage of delegator rewards claimed by validator as commission (in basis points, 100 = 1%)
last_commission_updateINTEGERBlock number when validator last updated their commission rate
last_block_timestampTIMESTAMPTimestamp of the block when the validator stake was recorded
last_block_numberINTEGERBlock number of the block when the validator stake was recorded
last_block_hashSTRINGHash of the block when the validator stake was recorded
last_transaction_hashSTRINGHash of the transaction when the validator stake was recorded
_created_atTIMESTAMPTimestamp of when the record was created
_updated_atTIMESTAMPTimestamp of when the record was updated