Sync Committee Rewards - Allium Documentation Hub

Table Details

Property	Value
Table Name	`beacon.raw.sync_committee_rewards`
Table Status	Production-Ready
Unique Key	`slot_number`, `validator_index`
Clustering Key(s)	`to_date("slot_timestamp")`

The beacon.raw.sync_committee_rewards table contains rewards for individual validators participating in the sync committee after the Altair upgrade.

Beacon Chain Sync Committee Rewards

The sync committee, a key feature of the Altair hard fork, consists of 512 validators randomly selected every 256 epochs (~27 hours). Validators in the sync committee sign the block header of the new head of the chain at each slot. The sync committee helps light clients track the chain of beacon block headers. Unlike block proposal and attestation duties, which require access to the active validator set, sync committees are updated infrequently and stored in the beacon state. This table is indexed from the /eth/v1/beacon/rewards/sync_committee/{block_id} RPC Method. This table only contains finalized slots and includes slots from 2375680 (Epoch 74240) onwards. Sync committee rewards are only present for slots where a block was proposed; missed slots have no sync committee rewards.

Table Columns

Column Name	Data Type	Description
slot_number	NUMBER(38,0)	Slot number of the state where the pending deposits to beacon chain is fetched.
slot_timestamp	TIMESTAMP_NTZ(9)	Slot timestamp of the state where the pending deposits to beacon chain is fetched.
validator_index	NUMBER(38,0)	916,865
reward	VARCHAR(16777216)	21968
execution_optimistic	BOOLEAN	If the slot/epoch is executed optimistically.
finalized	BOOLEAN	If the slot/epoch is finalized.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.

EVM

​Table Details

​Beacon Chain Sync Committee Rewards

​Table Columns

Table Details

Beacon Chain Sync Committee Rewards

Table Columns