⚫
Beacon Chain
Ethereum staking
Schemas | Tables | Description |
|---|---|---|
Validator | balances, income, index | Daily validator income and APR calculated, validator balances as well as index for mapping validators to ETH1 withdrawal address. |
Raw | blocks, withdrawals, deposits, attestations | Raw block data, attestations, deposits, withdrawal on Beacon Chain. |
Generate reports of validator income and performance with a click of a button.
Beacon Chain Staking Report - Get daily income and 7/30/90D income of APR of validators under a group of withdrawal addresses
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 Lido Withdrawal vault
select
date(slot_timestamp) as date,
case
when withdrawal_address = '0xb9d7934878b5fb9610b3fe8a5e441e8fad7e293f' then 'Lido' -- Lido Withdrawal Vault
when withdrawal_address is null then 'No Addr' else 'Others' end as label,
sum(consensus_income) as daily_income
from beacon.validator.income
where consensus_income > 0
group by 1,2
order by 1 desc
Distribution of Beacon Chain Consensus Income grouped by withdrawal wallets.
Last modified 2mo ago