Index

The beacon.validator.index table gives an index of Beacon Chain validator index, pubkey, withdrawal credentials and withdrawal address of each validator.

This table updates daily with newly activated validators.

Sample Query

Finding the total number of validators that have withdrawal address to Lido Withdrawal Vaults

select 
    withdrawal_address, 
    count(distinct validator_index) as validators
from beacon.validator.index
where withdrawal_address = '0xb9d7934878b5fb9610b3fe8a5e441e8fad7e293f' -- Lido Withdrawal Vault
group by 1

Table Columns

Column Name

Description

Example

validator_index

Unique index of validator.

524,079

pubkey

The validator's BLS public key, uniquely identifying them. _48-bytes, hex encoded with 0x prefix, case insensitive.

0x91b392a184c10fae87a8ce1eaf23fd5b62369efe67b93d123feee2a757191e85bc0d99892c65f3657ce18b0533c120a8

withdrawal_credentials

The root of withdrawal credentials.

0x010000000000000000000000b9d7934878b5fb9610b3fe8a5e441e8fad7e293f

withdrawal_prefix

The first byte of this credential is known as the withdrawal prefix. This value is currently either 0x00 or 0x01.

0x01

withdrawal_address

ETH1 Withdrawal address specified in withdrawal credentials, applicable for validators with 0x01 withdrawal credentials only.

0xb9d7934878b5fb9610b3fe8a5e441e8fad7e293f

last_status

Last updated status.

active_ongoing

activation_epoch

Epoch when validator activated. FAR_FUTURE_EPOCH if not activated.

182804

exit_epoch

Epoch when validator exited. FAR_FUTURE_EPOCH if not exited.

18446744073709551615

updated_at

Timestamp when entry was last updated.

2023-06-26 02:22:38.183 +0000

Last updated 8 months ago