Skip to main content

Table Description

The beacon.validator_day_summaries table is indexed from Lido. Stores daily summaries of validator activity on the Beacon Chain, including balance changes, rewards, attestations, and sync committee messages.

Column Descriptions

ColumnTypeDescription
block_datedateDate corresponding to the summary period.
validator_indexbigintUnique identifier for the validator.
start_timestamptimestampTimestamp marking the beginning of the summary period.
start_balancebigintValidator’s balance at the start of the period, measured in Gwei.
start_effective_balancebigintValidator’s effective balance at the start of the period, used for reward calculations, measured in Gwei.
capital_changebigintNet change in the validator’s balance due to deposits or withdrawals during the period, measured in Gwei.
reward_changebigintNet rewards earned by the validator during the period, measured in Gwei.
effective_balance_changebigintChange in the validator’s effective balance during the period, measured in Gwei.
proposalsbigintNumber of block proposals assigned to the validator during the period.
proposals_includedbigintNumber of the validator’s proposed blocks that were included in the chain during the period.
attestationsbigintNumber of attestations made by the validator during the period.
attestations_includedbigintNumber of the validator’s attestations that were included in the chain during the period.
attestations_source_timelybigintNumber of the validator’s attestations that were timely for the source checkpoint during the period.
attestations_target_correctbigintNumber of the validator’s attestations that correctly identified the target checkpoint during the period.
attestations_target_timelybigintNumber of the validator’s attestations that were timely for the target checkpoint during the period.
attestations_head_correctbigintNumber of the validator’s attestations that correctly identified the head block during the period.
attestations_head_timelybigintNumber of the validator’s attestations that were timely for the head block during the period.
attestations_inclusion_delaydoubleAverage delay (in slots) between the validator’s attestation and its inclusion in the chain during the period.
sync_committee_messagesbigintNumber of sync committee messages signed by the validator during the period.
sync_committee_messages_includedbigintNumber of the validator’s sync committee messages that were included in the chain during the period.
withdrawalsbigintNumber of withdrawals made by the validator during the period.
updated_attimestampLast time the record was updated.
ingested_attimestampTime when the record was ingested

Table Sample