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.

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.
withdrawable_epochintegerEpoch when validator can withdraw.
withdrawable_timestamptimestampTimestamp when validator can withdraw.
hours_to_withdrawnumericEstimated time in hours to withdraw.
balancenumericBalance of the validator.
effective_balancenumericEffective balance of the validator.
withdrawal_credentialsstringWithdrawal credentials is a 32-byte field associated with every validator, initially set during deposit, for verifying the destination of valid withdrawals.
execution_optimisticbooleanExecution optimistic.
finalizedbooleanThis will be false given that we are fetching the latest state.

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
I