> ## 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 🌱

> Daily validator balance snapshots on the Beacon Hoodi testnet (UTC end-of-day).

The `beacon_hoodi.raw.balances_daily` table provides daily snapshots of validator balances on the **Ethereum Hoodi** consensus layer (testnet). It mirrors the shape of [`beacon.raw.balances_daily`](/historical-data/supported-blockchains/evm/beacon-chain/raw/balances-daily) on mainnet: each row is one validator’s state for a calendar day, with the snapshot taken at the **last slot of the day in UTC** (for example `2026-03-28 23:59:59.000` on `slot_timestamp`).

**Beacon Hoodi is in Beta.** Types below reflect the current Snowflake schema; `raw_balance` and `raw_effective_balance` are stored as **strings** so large integer amounts stay exact—cast them (for example to `NUMBER` or `FLOAT`) when you compute.

### Table details

| Property            | Value                             |
| ------------------- | --------------------------------- |
| Table Name          | `beacon_hoodi.raw.balances_daily` |
| Table Status        | Beta 🌱                           |
| Clustering Key(s)   | `to_date("slot_timestamp")`       |
| Search Optimization | `validator_index`                 |
| Unique Key          | `unique_id`                       |

### Use cases

**Test and staging**: Validate queries, dashboards, and migrations against Hoodi before pointing them at mainnet `beacon.raw.*` tables.

**Daily accounting and reconciliation**: Per-validator daily balances; aggregate by `date(slot_timestamp)` for network-level rollups.

**Performance tracking**: Day-over-day deltas on `balance` / `raw_balance` for rewards, slashing, and exits.

### Table columns

| Column Name                    | Data Type         | Description                                                                                                                                        |
| ------------------------------ | ----------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| slot\_number                   | NUMBER(38,0)      | Beacon Chain slot number for the end-of-day snapshot.                                                                                              |
| slot\_timestamp                | TIMESTAMP\_NTZ(9) | Timestamp of that slot (UTC), typically **23:59:59** on the snapshot calendar day.                                                                 |
| validator\_index               | NUMBER(38,0)      | Index of the validator in the Beacon validator registry.                                                                                           |
| raw\_balance                   | VARCHAR           | Validator balance in **gwei** as a string (1e9 gwei = 1 ETH); string-typed for precision.                                                          |
| balance                        | FLOAT             | Validator balance in **ETH**.                                                                                                                      |
| effective\_balance             | FLOAT             | Effective balance at stake in **ETH** (reward and penalty weighting).                                                                              |
| raw\_effective\_balance        | VARCHAR           | Effective balance at stake in **gwei**, as a string for precision.                                                                                 |
| status                         | VARCHAR           | Validator status (for example `active_ongoing`, `withdrawal_done`, `exited_unslashed`, `exited_slashed`, `pending_queued`, `pending_initialized`). |
| pubkey                         | VARCHAR           | Validator BLS public key (48 bytes, hex with `0x` prefix).                                                                                         |
| withdrawal\_credentials        | VARCHAR           | 32-byte withdrawal credentials from the deposit (hex).                                                                                             |
| withdrawal\_prefix             | VARCHAR           | Credential prefix (for example `0x01` for execution-address withdrawals).                                                                          |
| withdrawal\_address            | VARCHAR           | Execution-layer withdrawal address when applicable (hex).                                                                                          |
| slashed                        | BOOLEAN           | Whether the validator has been slashed.                                                                                                            |
| activation\_eligibility\_epoch | VARCHAR           | Epoch when the validator became eligible for activation (string-encoded; `FAR_FUTURE_EPOCH` / max-uint style when not applicable).                 |
| activation\_epoch              | VARCHAR           | Epoch when the validator was activated.                                                                                                            |
| exit\_epoch                    | VARCHAR           | Epoch when the validator exited or will exit.                                                                                                      |
| withdrawable\_epoch            | VARCHAR           | Epoch when balance becomes withdrawable.                                                                                                           |
| execution\_optimistic          | BOOLEAN           | Optimistic execution payload flag when set; may be null if absent (treat per your warehouse semantics).                                            |
| finalized                      | BOOLEAN           | Whether the beacon data for this row is finalized.                                                                                                 |
| unique\_id                     | VARCHAR           | Stable row id, for example `date-2026-03-28-validator_index-2067035`.                                                                              |
| \_created\_at                  | TIMESTAMP\_NTZ(9) | When this row was written in Allium.                                                                                                               |
| \_updated\_at                  | TIMESTAMP\_NTZ(9) | When this row was last updated in Allium.                                                                                                          |

### Sample queries

#### Query 1: Daily network-wide metrics (UTC days)

```sql theme={null}
select
    date(slot_timestamp) as snapshot_day,
    count(*) as total_validators,
    sum(balance) as total_balance_eth,
    sum(effective_balance) as total_effective_balance_eth,
    avg(balance) as avg_balance_per_validator,
    countif(status = 'active_ongoing') as active_validators
from beacon_hoodi.raw.balances_daily
group by snapshot_day
order by snapshot_day desc
limit 30
```

#### Query 2: One validator’s daily history

```sql theme={null}
select
    date(slot_timestamp) as snapshot_day,
    balance,
    effective_balance,
    status,
    balance - lag(balance) over (partition by validator_index order by slot_timestamp) as daily_balance_change_eth
from beacon_hoodi.raw.balances_daily
where validator_index = 12345
order by snapshot_day desc
limit 90
```

#### Query 3: Slashed validators

```sql theme={null}
select
    date(slot_timestamp) as snapshot_day,
    validator_index,
    pubkey,
    balance,
    effective_balance,
    status
from beacon_hoodi.raw.balances_daily
where slashed = true
order by snapshot_day desc
```