Consensus Income

Fetch granular beacon chain consensus income by validator and slot time ranges.

The beacon.validator.consensus_income combines all the rewards that can be earned by validators on the Beacon chain.

Currently, this includes attestation rewards (distributed each Epoch), block rewards (distributed each slot) for the validator that successfully proposed a block, and sync committee rewards (post Altair upgrade) for the validator that is selected to sync committee.

This table does NOT contain execution rewards that are received by validators on the execution layer.

Query Example

Fetching validator income for a list of validators between 2 timestamps.

select *
from beacon.validator.consensus_income 
where 1=1 
and validator_index in (897919, 897920)
and slot_timestamp >= '2025-01-01' and slot_timestamp <= '2025-02-01'

Table Columns

Column Name	Description
slot_number	Slot number of the balance snapshot.
slot_timestamp	Slot timestamp of balance snapshot.
validator_index	Unique index of the validator.
reward_type	Type of reward. Currently includes attestation_total_rewards (attestation rewards from beacon.raw.total_rewards), block_rewards (block rewards from beacon.raw.block_rewards), and sync_committee_rewards (sync committee rewards from beacon.raw.sync_committee_rewards).
raw_amount	Raw amount of reward, in string to retain precision.
amount	Amount of reward normalized.
finalized	If the slot/epoch is finalized.
execution_optimistic	If the slot/epoch is executed optimistically.
_created_at	Timestamp of the entry creation.
_updated_at	Timestamp of the entry update.