Entities

Identify Beacon Chain validators metrics with beacon.validators.entities

Entities Coverage

Beacon validators entities identified: ~ 75% (April 2024)

Sample Queries

Identifying 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

Column Name	Description	Example
validator_index	Unique index of validator.	916,865
pubkey	The validator's BLS public key, uniquely identifying them. _48-bytes, hex encoded with 0x prefix, case insensitive.	0xb20cbf80ded11e4089be8ff68c3150aa19f1a5dc064450a1a10097194f1d09d470261c183d8ca44717a4da7cafa11c4f
entity	Name of the entity.	okx
category	Category of the entity.	cex
last_status	Last status of the validator.	active_ongoing
address	Mainnet transaction signer of the initial deposit.	0x5a0036bcab4501e70f086c634e2958a8beae3a11
funder	Mainnet ETH Funder of the initial deposit.	0x5a0036bcab4501e70f086c634e2958a8beae3a11
staking_contract	Staking contract that the validator deposited the ETH into. Most staking contract will be the Beacon Chain Deposit Contract.	0x00000000219ab540356cbb839cbe05303d7705fa
withdrawal_credentials	The root of withdrawal credentials.	0x010000000000000000000000e839a3e9efb32c6a56ab7128e51056585275506c
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.	0xe839a3e9efb32c6a56ab7128e51056585275506c
activation_epoch	Epoch when validator activated. FAR_FUTURE_EPOCH if not activated.	230889
exit_epoch	Exit epoch, if applicable.	-1
updated_at	Timestamp of entry update.	2023-10-08 23:59:59.000 +0000