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