Epoch Schedule

The 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 Details

Property	Value
Table Name	`solana.staking.epoch_schedule`
Table Status	Production-Ready
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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

Table Details

Table Columns

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

​Table Details

​Table Columns

Table Details

Table Columns