> ## 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.

# SPO Stake History

> Midnight stake pool stake history

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

This table contains stake snapshots for Midnight pools, including live and active stake and delegator counts.

## Column Descriptions

| Column Name          | Data Type     | Description                                        |
| -------------------- | ------------- | -------------------------------------------------- |
| **id**               | bigint        | Internal stake history identifier.                 |
| **pool\_id**         | varchar       | Pool identifier.                                   |
| **mainchain\_epoch** | bigint        | Mainchain epoch associated with the snapshot.      |
| **live\_stake**      | decimal(38,0) | Live stake for the pool.                           |
| **active\_stake**    | decimal(38,0) | Active stake for the pool.                         |
| **live\_delegators** | bigint        | Number of live delegators.                         |
| **live\_saturation** | double        | Live saturation ratio for the pool.                |
| **declared\_pledge** | decimal(38,0) | Declared pledge amount.                            |
| **live\_pledge**     | decimal(38,0) | Live pledge amount.                                |
| **recorded\_at**     | timestamp     | Timestamp when the snapshot was recorded.          |
| **\_updated\_at**    | timestamp     | Timestamp when this record was last updated.       |
| **\_ingested\_at**   | timestamp     | Timestamp when this record was ingested into Dune. |

## Table Sample

<TableSample tableSchema="midnight" tableName="spo_stake_history" />