monad.gov Table: dim_epochs Type: View
What
Dimension table for staking epochs. Each epoch starts when the EpochChanged event fires. Block ranges are derived from consecutive epoch change events. Epochs are variable length (~5.5 hours) based on consensus rounds, not fixed block counts.Columns
| Column Name | Data Type | Description |
|---|---|---|
| EPOCH | NUMBER | Epoch number |
| EPOCH_START_BLOCK | NUMBER | First block of this epoch (block where EpochChanged event fired) |
| EPOCH_END_BLOCK | NUMBER | Last block of this epoch (block before next epoch started, or current max block for latest epoch) |
| EPOCH_BLOCK_COUNT | NUMBER | Number of blocks in this epoch |
| EPOCH_START_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this epoch started |
| EPOCH_END_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this epoch ended (NULL for current epoch) |
| EPOCH_DURATION_SECONDS | NUMBER | Duration of epoch in seconds (NULL for current epoch) |
| EPOCH_CHANGE_TX_HASH | TEXT | Transaction hash of the EpochChanged event that started this epoch |