year | INTEGER | Calendar year of the record (partition column) |
month | INTEGER | Calendar month of the record (partition column) |
section | VARCHAR | The pallet section for this staking record (e.g. Staking, NominationPools) |
storage | VARCHAR | The specific storage item being tracked (e.g. Validators, Nominators) |
block_number | BIGINT | The block number at which this staking snapshot was taken |
ts | TIMESTAMP | Timestamp of the staking snapshot |
era | BIGINT | The staking era number |
address_ss58 | VARCHAR | SS58-encoded address of the validator, nominator, or pool member |
address_pubkey | VARBINARY | Public key of the validator, nominator, or pool member |
block_hash | VARBINARY | Hash of the block at which the snapshot was taken |
submitted_in | BIGINT | The era in which the nominator’s nomination was submitted |
suppressed | BOOLEAN | Whether the validator is suppressed (excluded from election) |
validator_total | DOUBLE | Total stake backing this validator (own + nominated) |
validator_own | DOUBLE | Validator’s own bonded stake |
validator_commission | DOUBLE | Validator’s commission rate (0.0 to 1.0) |
validator_reward_shares | DOUBLE | Proportion of total staking rewards earned by this validator |
validator_reward_points | BIGINT | Reward points earned by this validator in the era |
validator_staking_rewards | DOUBLE | Staking rewards earned by this validator in the era |
total_staked | DOUBLE | Total amount staked across all validators in the era |
total_reward_points | BIGINT | Total reward points across all validators in the era |
total_staking_rewards | DOUBLE | Total staking rewards distributed in the era |
nominationpools_id | BIGINT | Nomination pool ID |
nominationpools_total | DOUBLE | Total staked in the nomination pool |
nominationpools_member_cnt | BIGINT | Number of members in the nomination pool |
nominationpools_commission | DOUBLE | Commission rate of the nomination pool |
nominationpools_rewardpools | VARCHAR | JSON-encoded reward pool data for the nomination pool |
member_bonded | DOUBLE | Amount bonded by a pool member |
member_unbonded | DOUBLE | Amount in the process of unbonding for a pool member |
member_share | DOUBLE | Pool member’s share of the pool’s total stake |
targets | ARRAY(VARCHAR) | List of validator addresses targeted by this nominator |
pv | VARCHAR | Protocol version or parameter value |
track | VARCHAR | Governance track for OpenGov-related staking data |
updated_at | TIMESTAMP | When this record was last updated in the database |
ingested_at | TIMESTAMP | When this record was first ingested into the database |
