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.

More about Beacon Chain

​
Beacon Chain Tables:

Schemas TablesDescriptionDescription
Validatorbalances, income, index, entitiesDaily validator income and APR calculated, validator balances as well as index for mapping validators to ETH1 withdrawal address.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		Raw block data, attestations, deposits, withdrawal on Beacon Chain.

​
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