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 NameDescription
slot_numberSlot number of the balance snapshot.
slot_timestampSlot timestamp of balance snapshot.
validator_indexUnique index of the validator.
reward_typeType 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_amountRaw amount of reward, in string to retain precision.
amountAmount of reward normalized.
finalizedIf the slot/epoch is finalized.
execution_optimisticIf the slot/epoch is executed optimistically.
_created_atTimestamp of the entry creation.
_updated_atTimestamp of the entry update.