Table Details
| Property | Value |
|---|---|
| Table Name | solana_devnet.staking.epoch_schedule |
| Table Status | Beta 🌱 |
| Unique Key | epoch |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| epoch | NUMBER(38,0) | The epoch number (= floor(slot / 432000)) |
| epoch_status | VARCHAR(9) | Whether the epoch is completed or still in progress. Historical epochs before epoch 90 are hardcoded as completed since they have no block timestamps. |
| first_slot | NUMBER(38,0) | First slot that produced a block in this epoch |
| last_slot | NUMBER(38,0) | Last slot that produced a block in this epoch |
| first_block_height | NUMBER(38,0) | Block height of the first block produced in this epoch |
| last_block_height | NUMBER(38,0) | Block height of the last block produced in this epoch |
| blocks_count | NUMBER(38,0) | Number of blocks produced in this epoch |
| epoch_start_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the first block produced in this epoch |
| epoch_end_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the first block of the next epoch (i.e. the true epoch boundary). NULL while the current epoch is still in progress. |
| est_epoch_end_timestamp | TIMESTAMP_NTZ(9) | Projected end timestamp for the ongoing epoch, calculated by adding the rolling average duration of the preceding 6 epochs to epoch_start_timestamp. NULL for completed epochs. |
| epoch_duration_minutes | NUMBER(38,0) | Duration of the epoch in minutes (epoch_end_timestamp - epoch_start_timestamp). NULL for the ongoing epoch. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when the record was first created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when the record was last updated |