Balances Daily EST

The beacon.raw.balances_daily_est table provides daily validator balances for all validators on the Beacon Chain using an Eastern Time end-of-day boundary. Each row is one validator’s state for that EST calendar day (snapshot at 23:59:59 in the slot_timestamp_est / slot alignment used for this table). Column definitions match beacon.raw.balances_daily, with an additional slot_timestamp_est field for the snapshot time in Eastern Time.

Use Cases: Auditing, Accounting & Research

Auditing and compliance: Track balance changes day over day; use withdrawal_address, epoch fields, and finalized / execution_optimistic for reconciliation and certainty of state. Accounting and financial analysis: Daily snapshots in EST for reporting aligned to US Eastern business dates; use balance / raw_balance deltas between consecutive days for accruals. Research and network analytics: Study lifecycle transitions via status and epoch columns; aggregate by date(slot_timestamp_est) for EST-dated network metrics.

Table Columns

Clustering Key: to_date(slot_timestamp_est) (or equivalent on your warehouse) Search Optimization: validator_index Unique Key: unique_id

Column Name	Description
slot_number	Beacon Chain slot number for the end-of-day snapshot.
slot_timestamp	Beacon Chain slot timestamp (UTC).
slot_timestamp_est	Snapshot time in Eastern Time (end-of-day EST for the reporting date).
validator_index	Index of the validator in the Beacon validator registry.
raw_balance	Validator balance as an integer in gwei (1e9 gwei = 1 ETH).
balance	Validator balance in ETH (float).
effective_balance	Effective balance at stake in ETH.
raw_effective_balance	Effective balance at stake in gwei.
status	Validator status (for example `active_ongoing`, `withdrawal_done`, `exited_unslashed`, `exited_slashed`, `pending_queued`, `pending_initialized`).
pubkey	Validator BLS public key (48 bytes, hex with `0x` prefix).
withdrawal_credentials	32-byte withdrawal credentials from the deposit (hex).
withdrawal_prefix	Credential type prefix (for example `0x01` for execution / address withdrawals).
withdrawal_address	Execution-layer withdrawal address when applicable (hex).
slashed	Whether the validator has been slashed.
activation_eligibility_epoch	Epoch when the validator became eligible for activation.
activation_epoch	Epoch when the validator was activated.
exit_epoch	Epoch when the validator exited or will exit (`18446744073709551615` means “not set” / far future in consensus encoding).
withdrawable_epoch	Epoch when balance becomes withdrawable (same sentinel applies when not applicable).
execution_optimistic	Execution optimistic flag when present; may be empty depending on upstream payload metadata.
finalized	Whether the beacon data for this row is finalized.
unique_id	Stable row id, for example `date-2026-03-28-validator_index-2067035`.
_created_at	When this row was written in Allium.
_updated_at	When this row was last updated in Allium.

Sample Queries

Query 1: Total validators, balance, and effective balance by EST day

select
    date(slot_timestamp_est) as snapshot_day_est,
    status,
    count(*) as validators,
    sum(balance) as total_balance,
    sum(effective_balance) as total_effective_balance
from beacon.raw.balances_daily_est
group by snapshot_day_est, status
order by snapshot_day_est desc

Query 2: Balances for a set of validators

select
    *
from beacon.raw.balances_daily_est
where validator_index in (1, 1000, 145)
order by slot_timestamp_est desc

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Use Cases: Auditing, Accounting & Research

Table Columns

Sample Queries

Query 1: Total validators, balance, and effective balance by EST day

Query 2: Balances for a set of validators

​Use Cases: Auditing, Accounting & Research

​Table Columns

​Sample Queries

​Query 1: Total validators, balance, and effective balance by EST day

​Query 2: Balances for a set of validators

Use Cases: Auditing, Accounting & Research

Table Columns

Sample Queries

Query 1: Total validators, balance, and effective balance by EST day

Query 2: Balances for a set of validators