Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Daily aggregation of validator stakes and related metrics on the Polygon Proof of Stake (PoS) network
| Property | Value |
|---|---|
| Table Name | polygon.staking.validator_stake_daily |
| Table Status | Production-Ready |
| Unique Key | date, validator_id |
| Column Name | Data Type | Description |
|---|---|---|
| date | TIMESTAMP_NTZ(9) | The date of the stake snapshot (UTC) |
| validator_id | NUMBER(38,0) | Unique identifier assigned to the validator by the Polygon network |
| total_stake | FLOAT | Total amount of MATIC (POL) tokens staked (validator self-stake + delegated stake) |
| validator_stake | FLOAT | Amount of MATIC (POL) tokens self-staked by the validator |
| delegator_stake | FLOAT | Total amount of MATIC (POL) tokens staked by delegators to this validator |
| reward | FLOAT | Accumulated validator rewards in MATIC (POL), including block rewards and commission from delegators |
| delegators_reward | FLOAT | Accumulated rewards in MATIC (POL) for delegators, excluding validator commission |
| initial_reward_per_stake | FLOAT | Initial reward-per-stake at the time of the validator’s activation, in MATIC (POL) |
| activation_epoch | NUMBER(38,0) | Epoch at which the validator was activated |
| deactivation_epoch | NUMBER(38,0) | Epoch at which the validator was deactivated (0 if still active) |
| jail_time | NUMBER(38,0) | Epoch until which the validator is jailed (0 if not jailed) |
| signer | VARCHAR(16777216) | Validator’s signer address |
| contract_address | VARCHAR(16777216) | Address of the validator’s stake-manager contract |
| validator_status | NUMBER(38,0) | Current status of validator (0=Inactive, 1=Active, 2=Locked, 3=Deactivated) |
| commission_rate | NUMBER(38,0) | Percentage of delegator rewards claimed by validator as commission (in basis points, 100 = 1%) |
| last_commission_update | NUMBER(38,0) | Block number when validator last updated their commission rate |
| extra_fields | VARIANT | Raw JSON of all fields returned by the validators() state call, for forward compatibility |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the end-of-day block at which the validator state was read |
| block_number | NUMBER(38,0) | Block number of the end-of-day block at which the validator state was read |
| block_hash | VARCHAR(16777216) | Hash of the end-of-day block at which the validator state was read |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the record was created |
0x5e3ef299fddf15eaa0432e6e66473ace8c13d908) once per day, providing a complete snapshot of every validator regardless of trace activity.
last_* columns have been removed and replaced with block_* columns; an extra_fields column has been added. Stake and reward types and denominations are unchanged. Daily row counts will increase as all validators are now represented each day regardless of activity.Was this page helpful?