TheDocumentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
solana.staking.epoch_schedule table is an epoch dimension table for the Solana network. It contains one row per epoch with precise start/end timestamps derived from onchain block data. Solana epochs are fixed at 432,000 slots (~2 days, though actual duration varies with slot timing). Use to answer “when will my staking rewards arrive?” and “when does my deactivation clear?” without heuristic slot-arithmetic hacks.
Table columns
| Column Name | Description | Type | Example |
|---|---|---|---|
| epoch | The epoch number (= floor(slot / 432000)) | number | 750 |
| epoch_status | Whether the epoch is completed or still in progress. Historical epochs before epoch 90 are hardcoded as completed since they have no block timestamps. | varchar | completed |
| first_slot | First slot that produced a block in this epoch | number | 324000000 |
| last_slot | Last slot that produced a block in this epoch | number | 324431999 |
| first_block_height | Block height of the first block produced in this epoch | number | 299000000 |
| last_block_height | Block height of the last block produced in this epoch | number | 299380000 |
| blocks_count | Number of blocks produced in this epoch | number | 380001 |
| epoch_start_timestamp | Block timestamp of the first block produced in this epoch | timestamp_ntz | 2024-03-20 00:00:00 |
| epoch_end_timestamp | 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. | timestamp_ntz | 2024-03-22 02:30:00 |
| est_epoch_end_timestamp | 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. | timestamp_ntz | 2024-03-22 02:30:00 |
| epoch_duration_minutes | Duration of the epoch in minutes (epoch_end_timestamp - epoch_start_timestamp). NULL for the ongoing epoch. | float | 2550.5 |
| _created_at | Timestamp when the record was first created | timestamp_ntz | 2024-03-20 00:01:00 |
| _updated_at | Timestamp when the record was last updated | timestamp_ntz | 2024-03-22 02:31:00 |