Data Retention Notice: This data is not backfilled and will be regularly
pruned. Historical pending consolidation data may not be available for past
epochs.
beacon.raw.pending_consolidations_enriched provides epoch-level data on pending consolidations waiting to process in the beacon chain, enriched with detailed validator information for both source and target validators.
This data is only available post-Pectra upgrade.
Table Column
Unique Key:slot_number, pending_consolidation_index
| Column Name | Description |
|---|---|
| slot_number | Beacon Chain slot number of when the pending consolidation state was indexed |
| slot_timestamp | Beacon Chain slot timestamp of slot when the pending consolidation state was indexed |
| pending_consolidation_index | Array index of the pending consolidation for the given epoch |
| pending_consolidation_count | Total count of pending consolidations at this slot |
| has_pending_consolidations | Boolean flag indicating whether there are pending consolidations |
| source_index | Validator index of the source validator being consolidated |
| source_pubkey | The source validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| source_balance | The source validator’s balance in ETH |
| source_raw_balance | The source validator’s balance in gwei (1e9 gwei = 1 ETH on Beacon Chain) |
| source_effective_balance | The source validator’s effective balance in ETH used for consensus calculations |
| source_raw_effective_balance | The source validator’s effective balance in gwei |
| source_slashed | Boolean flag indicating whether the source validator has been slashed |
| source_status | The source validator’s status (e.g., active_ongoing, exited_unslashed, exited_slashed) |
| source_activation_epoch | Epoch when the source validator was activated |
| source_activation_eligibility_epoch | Epoch when the source validator became eligible for activation |
| source_exit_epoch | Epoch when the source validator exited or will exit |
| source_withdrawable_epoch | Epoch when the source validator’s balance becomes withdrawable |
| source_withdrawal_credentials | Source validator’s withdrawal credentials, a 32-byte field for verifying the destination of valid withdrawals |
| target_index | Validator index of the target validator receiving the consolidation |
| target_pubkey | The target validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| target_balance | The target validator’s balance in ETH |
| target_raw_balance | The target validator’s balance in gwei (1e9 gwei = 1 ETH on Beacon Chain) |
| target_effective_balance | The target validator’s effective balance in ETH used for consensus calculations |
| target_raw_effective_balance | The target validator’s effective balance in gwei |
| target_slashed | Boolean flag indicating whether the target validator has been slashed |
| target_status | The target validator’s status (e.g., active_ongoing, exited_unslashed, exited_slashed) |
| target_activation_epoch | Epoch when the target validator was activated |
| target_activation_eligibility_epoch | Epoch when the target validator became eligible for activation |
| target_exit_epoch | Epoch when the target validator exited or will exit |
| target_withdrawable_epoch | Epoch when the target validator’s balance becomes withdrawable |
| target_withdrawal_credentials | Target validator’s withdrawal credentials, a 32-byte field for verifying the destination of valid withdrawals |
| execution_optimistic | It’s true if the response references an unverified execution payload. The optimistic information may be invalidated at a later time. If the field is not present, assume the false value |
| finalized | Indicates whether the response data is finalized |
| _created_at | Timestamp of the pending consolidation data creation |
| _updated_at | Timestamp of the pending consolidation data update |