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

> Midnight stake pool operator 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 historical status records for stake pool operators (SPOs) by epoch.

## Column Descriptions

| Column Name | Data Type | Description |
| - | - | - |
| **spo\_hist\_sk** | bigint | Primary key for the SPO history row. |
| **spo\_sk** | varchar | Stake pool operator key / identifier. |
| **epoch\_no** | bigint | Epoch number for this status record. |
| **status** | varchar | SPO status in the epoch. |
| **valid\_from** | bigint | Start of validity for this status. |
| **valid\_to** | bigint | End of validity for this status. |
| **\_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_history" />


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