🔹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.

The 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

Distribution of Beacon Chain Consensus Income grouped by withdrawal wallets. https://app.allium.so/s/sTht8Q9U