Table Details
Identify the staking entities behind Beacon Chain validators with
beacon.validator.entities.
Entities CoverageBeacon validators entities identified: ~ 80% (Feb 2025)
Validator
Entities
Was this page helpful?
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
| Property | Value |
|---|---|
| Table Name | beacon.validator.entities |
| Table Status | Production-Ready |
| Unique Key | validator_index |
| Clustering Key(s) | round(validator_index, -3) |
| Search Optimization | validator_index, withdrawal_address |
beacon.validator.entities.
select
date_trunc('week', slot_timestamp) as date,
nvl(entity, 'unlabeled') as label,
sum(consensus_income) as weekly_income
from beacon.validator.income
left join beacon.validator.entities on entities.pubkey = income.pubkey
group by 1,2
| Column Name | Data Type | Description |
|---|---|---|
| validator_index | NUMBER(38,0) | 916,865 |
| pubkey | VARCHAR(16777216) | 0xb20cbf80ded11e4089be8ff68c3150aa19f1a5dc064450a1a10097194f1d09d470261c183d8ca44717a4da7cafa11c4f |
| entity | VARCHAR(16777216) | okx |
| category | VARCHAR(16777216) | cex |
| last_status | VARCHAR(16777216) | active_ongoing |
| address | VARCHAR(16777216) | 0x5a0036bcab4501e70f086c634e2958a8beae3a11 |
| funder | VARCHAR(16777216) | 0x5a0036bcab4501e70f086c634e2958a8beae3a11 |
| staking_contract | VARCHAR(16777216) | 0x00000000219ab540356cbb839cbe05303d7705fa |
| withdrawal_credentials | VARCHAR(16777216) | 0x010000000000000000000000e839a3e9efb32c6a56ab7128e51056585275506c |
| withdrawal_prefix | VARCHAR(16777216) | 0x01 |
| withdrawal_address | VARCHAR(16777216) | 0xe839a3e9efb32c6a56ab7128e51056585275506c |
| activation_epoch | VARCHAR(16777216) | 230889 |
| exit_epoch | VARCHAR(16777216) | -1 |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
Was this page helpful?