Identify Beacon Chain validators metrics with beacon.validators.entities

Entities Coverage

Beacon validators entities identified: ~ 80% (Feb 2025)

​
Sample Queries

Identifying the distribution of Beacon Chain incomes amongst active validators.

select 

    date_trunc('week', slot_timestamp) as date,

    nvl(entity, 'unlabeled') as label,

    sum(consensus_income) as daily_income

from beacon.validator.income 

    left join beacon.validator.entities on entities.pubkey = income.pubkey

group by 1,2

​
Table Columns

Unique key : validator_index

Column NameDescriptionExample
validator_indexUnique index of validator.916,865
pubkeyThe validator’s BLS public key, uniquely identifying them. _48-bytes, hex encoded with 0x prefix, case insensitive.0xb20cbf80ded11e4089be8ff68c3150aa19f1a5dc064450a1a10097194f1d09d470261c183d8ca44717a4da7cafa11c4f
entityName of the entity.okx
categoryCategory of the entity.cex
last_statusLast status of the validator.active_ongoing
addressMainnet transaction signer of the initial deposit.0x5a0036bcab4501e70f086c634e2958a8beae3a11
funderMainnet ETH Funder of the initial deposit.0x5a0036bcab4501e70f086c634e2958a8beae3a11
staking_contractStaking contract that the validator deposited the ETH into. Most staking contract will be the Beacon Chain Deposit Contract.0x00000000219ab540356cbb839cbe05303d7705fa
withdrawal_credentialsThe root of withdrawal credentials.0x010000000000000000000000e839a3e9efb32c6a56ab7128e51056585275506c
withdrawal_prefixThe first byte of this credential is known as the withdrawal prefix. This value is currently either 0x00 or 0x01.0x01
withdrawal_addressETH1 Withdrawal address specified in withdrawal credentials, applicable for validators with 0x01 withdrawal credentials only.0xe839a3e9efb32c6a56ab7128e51056585275506c
activation_epochEpoch when validator activated. FAR_FUTURE_EPOCH if not activated.230889
exit_epochExit epoch, if applicable.-1
updated_atTimestamp of entry update.2023-10-08 23:59:59.000 +0000