> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Balances Daily EST

> Daily validator balances on the Beacon Chain with Eastern Time end-of-day snapshots.

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

```sql theme={null}
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

```sql theme={null}
select
    *
from beacon.raw.balances_daily_est
where validator_index in (1, 1000, 145)
order by slot_timestamp_est desc
```