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