🔹Beacon Chain

Get the performance, income and metrics of validators on Beacon Chain.

The Beacon Chain introduced the consensus logic and block gossip protocol which now secures Ethereum. The Beacon Chain introduced proof-of-stake to Ethereum.

This keeps Ethereum secure and earns validators more ETH in the process.

LogoThe Beacon Chain | ethereum.orgethereum.org

Beacon Chain Tables:

Schemas
Tables
Description

Validator

balances, income, index, entities

Daily validator income and APR calculated, validator balances as well as index for mapping validators to ETH1 withdrawal address.

Raw

blocks, withdrawals, deposits, attestations,

attestation_rewards_daily ideal_rewards, total_rewards,

block_rewards, sync_committee_rewards

Raw block data, attestations, deposits, and withdrawals on Beacon Chain. Rewards for Validator: Block rewards for slot proposed, epoch-level attestation rewards, daily aggregated attestation rewards, and sync committee rewards

Solutions

Deep dive into validator metrics

Querying our beacon.validator.income to explore validator income for insights into validator performance across time.

E.g. exploring the distribution of consensus income to the Lido Withdrawal vault

select 
    date_trunc('week', income.slot_timestamp) as date,
    nvl(entity, 'unlabeled') as entity,
    count(distinct  entities.validator_index) as validators,
    sum(consensus_income) as income 
from beacon.validator.income 
left join beacon.validator.entities on entities.validator_index = income.validator_index
where consensus_income > 0 
group by 1,2
order by 1 desc

Beacon Chain Consensus Income by Entity

Last updated