Consensus Income

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.

Refer to the ethereum.raw.block_rewards model for execution layer rewards.

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.

Balances Daily Entities

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Query Example

Table Columns

​Query Example

​Table Columns

Query Example

Table Columns