Entities

Entities CoverageBeacon validators entities identified: ~ 80% (Feb 2025)

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

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

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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Sample Queries

Table Columns

​Sample Queries

​Table Columns

Sample Queries

Table Columns