Staking
Validator Stake Daily
Daily snapshots of validator stake metrics on Aptos, including active stake, pending stake, inactive stake, and delegation information. This model provides a comprehensive view of validator performance and stake distribution over time.
| Column Name | Description |
|---|---|
| date | The date of the stake snapshot |
| pool_address | The address of the validator’s stake pool |
| operator_address | The address of the validator operator |
| delegated_voter | The address of the delegated voter for this validator |
| operator_commission_pct | The commission percentage charged by the validator operator |
| met_minimum_stake | Boolean indicating if the validator meets the minimum stake requirement (1M APT) |
| is_active_node | Boolean indicating if the validator has any active or inactive stake |
| is_delegation_pool | Boolean indicating if the validator accepts delegations |
| total_stake | The total amount of stake in the validator’s pool (active_stake + active_pending_stake + inactive_stake + inactive_pending_stake) |
| total_delegations | The total amount of delegated stake in the validator’s pool (active_delegations + inactive_delegations) |
| total_rewards | The total rewards earned by the validator on this date |
| active_stake | The amount of active stake in the validator’s pool |
| active_pending_stake | The amount of pending active stake in the validator’s pool |
| inactive_stake | The amount of inactive stake in the validator’s pool |
| inactive_pending_stake | The amount of pending inactive stake in the validator’s pool |
| active_delegations | The amount of active delegated stake in the validator’s pool |
| inactive_delegations | The amount of inactive delegated stake in the validator’s pool |
| _created_at | Timestamp when this record was created |
| _updated_at | Timestamp when this record was last updated |