> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# polkadot.stakings

> Polkadot staking data — validator nominations, staking rewards, and slash events.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## Table description

The `polkadot.stakings` table includes all the data necessary to compute staking-related metrics for Validators, Nominators, Pools, and Pool Members.  This is currently supported for Polkadot and Kusama Relay Chain only.

## Table Schema

| Column                        | Type             | Description                                                                    |
| ----------------------------- | ---------------- | ------------------------------------------------------------------------------ |
| `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                          |

## Table Sample

<TableSample tableSchema="polkadot" tableName="stakings" />