> ## 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" />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.