Table Details
| Property | Value |
|---|---|
| Table Name | aptos.staking.validator_stake_daily |
| Table Status | Production-Ready |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| date | TIMESTAMP_NTZ(9) | The date of the stake snapshot |
| pool_address | VARCHAR(16777216) | The address of the validator’s stake pool |
| operator_address | VARCHAR(16777216) | The address of the validator operator |
| delegated_voter | VARCHAR(16777216) | The address of the delegated voter for this validator |
| operator_commission_pct | FLOAT | The commission percentage charged by the validator operator |
| met_minimum_stake | BOOLEAN | Boolean indicating if the validator meets the minimum stake requirement (1M APT) |
| is_active_node | BOOLEAN | Boolean indicating if the validator has any active or inactive stake |
| is_delegation_pool | BOOLEAN | Boolean indicating if the validator accepts delegations |
| total_stake | FLOAT | The total amount of stake in the validator’s pool (active_stake + active_pending_stake + inactive_stake + inactive_pending_stake) |
| total_delegations | FLOAT | The total amount of delegated stake in the validator’s pool (active_delegations + inactive_delegations) |
| total_rewards | FLOAT | The total rewards earned by the validator on this date |
| active_stake | FLOAT | The amount of active stake in the validator’s pool |
| active_pending_stake | FLOAT | The amount of pending active stake in the validator’s pool |
| inactive_stake | FLOAT | The amount of inactive stake in the validator’s pool |
| inactive_pending_stake | FLOAT | The amount of pending inactive stake in the validator’s pool |
| active_delegations | FLOAT | The amount of active delegated stake in the validator’s pool |
| inactive_delegations | FLOAT | The amount of inactive delegated stake in the validator’s pool |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |