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.
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
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 modified 3mo ago