Skip to main content
The beacon.validator.exit_queue_latest model provides the estimated epoch and timestamp where a validator is expected to exit. This model is derived from beacon.validator.balances_latest and is updated approximately every 30 minutes. The state of the validator will indicate which epoch it is expected to exit and available for withdrawal.

Schema

Column NameTypeDescription
statusstringCurrent status of the validator.
validator_indexintegerUnique index of the validator.
pubkeystringThe validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive.
exit_epochintegerEpoch when validator exited.
exit_timestamptimestampTimestamp when validator exited.
hours_to_exitnumericEstimated time in hours to exit based on the current time at the time of querying the data.
withdrawable_epochintegerEpoch when validator can withdraw.
withdrawable_timestamptimestampTimestamp when validator can withdraw.
hours_to_withdrawnumericEstimated time in hours to withdraw based on the current time at the time of querying the data.
balancenumericBalance of the validator.
effective_balancenumericEffective balance of the validator.
withdrawal_credentialsstringIt’s a 32-byte field in each validator’s record that specifies the withdrawal destination and type.
w

Example Query

This query shows the estimated exit timestamp and hours to exit for a given validator.
SELECT
  pubkey,
  exit_epoch,
  hours_to_exit,
  exit_timestamp,
  datediff('hours', current_timestamp, exit_timestamp) as hours_to_exit
FROM beacon.validator.exit_queue_latest
WHERE pubkey in ('') -- Insert validator pubkey here