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 Models:

​
Raw Data

Table NameDescriptionFreshness
beacon.raw.blocksEssential block-level data.hourly
beacon.raw.withdrawalsValidator withdrawals data from Beacon Chain. Includes partial and full withdrawal.hourly
beacon.raw.depositsDeposits into the ETH staking, derived from beacon.raw.blocks.hourly
beacon.raw.attestationsSlot-level Attestation data, derived from beacon.raw.blockshourly
beacon.raw.consolidationsConsolidations of validator balances post Pectra upgrade.hourly
beacon.raw.block_rewardsSlot-level rewards for blocks that were successfully proposed.hourly
beacon.raw.sync_committee_rewardsSlot-level rewards for selected validators participating in the sync committee.hourly
beacon.raw.total_rewardsEpoch-level attestation rewards for active validators.hourly
beacon.raw.ideal_rewardsEpoch-level ideal rewards from attestations for active validators.hourly
beacon.raw.validator_dutiesValidator duties data fetched by epoch.hourly

​
Validator data

Table NameDescriptionFreshness
beacon.validator.balancesDaily snapshot of active validators on Beacon Chain (last slot daily).daily
beacon.validator.balances_latestLatest snapshot of active validators on Beacon Chain.hourly
beacon.validator.consensus_incomeThis model combines all validator income data into one table (block_rewards, sync_committee_rewards, total_rewards)hourly
beacon.validator.consensus_income_dailyAggregates beacon.validator.consensus_income by validator daily.daily
beacon.validator.entitiesBeacon chain entities labelsdaily
beacon.validator.income*Consensus and execution layer income of active validators on Beacon Chain.daily
beacon.validator.indexList of validators by index, pubkey, ETH1 withdrawal address.hourly
beacon.validator.queueDaily validator queue, derived from beacon.validator.balances.daily
beacon.validator.queue_latestHourly validator queue latest, derived from beacon.validator.balances_latest.hourly
*Execution layer income is derived from ethereum.raw.block_rewards. This model is updated hourly.

​
Solutions

Accounting: Granular validator income by validator: beacon.validator.consensus_income There 3 sources of validator rewards currently:
  • beacon.raw.block_rewards: Slot-level rewards for blocks that were successfully proposed.
  • beacon.raw.total_rewards: Epoch-level attestation rewards for active validators.
  • beacon.raw.sync_committee_rewards: Slot-level rewards for selected validators participating in the sync committee.
We combine all 3 sources in the modelbeacon.validator.consensus_income 
select * from beacon.validator.consensus_income
where validator_index = '649117'
Insights: 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