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

### Table Details

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

### 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) | Beacon Chain slot timestamp (UTC).                                                                                                                 |
| slot\_timestamp\_est           | TIMESTAMP\_NTZ(9) | Snapshot time in **Eastern Time** (end-of-day EST for the reporting date).                                                                         |
| validator\_index               | NUMBER(38,0)      | Index of the validator in the Beacon validator registry.                                                                                           |
| raw\_balance                   | VARCHAR(16777216) | Validator balance as an integer in **gwei** (1e9 gwei = 1 ETH).                                                                                    |
| balance                        | FLOAT             | Validator balance in **ETH** (float).                                                                                                              |
| effective\_balance             | FLOAT             | Effective balance at stake in **ETH**.                                                                                                             |
| raw\_effective\_balance        | VARCHAR(16777216) | Effective balance at stake in **gwei**.                                                                                                            |
| status                         | VARCHAR(16777216) | Validator status (for example `active_ongoing`, `withdrawal_done`, `exited_unslashed`, `exited_slashed`, `pending_queued`, `pending_initialized`). |
| pubkey                         | VARCHAR(16777216) | Validator BLS public key (48 bytes, hex with `0x` prefix).                                                                                         |
| withdrawal\_credentials        | VARCHAR(16777216) | 32-byte withdrawal credentials from the deposit (hex).                                                                                             |
| withdrawal\_prefix             | VARCHAR(16777216) | Credential type prefix (for example `0x01` for execution / address withdrawals).                                                                   |
| withdrawal\_address            | VARCHAR(16777216) | Execution-layer withdrawal address when applicable (hex).                                                                                          |
| slashed                        | BOOLEAN           | Whether the validator has been slashed.                                                                                                            |
| activation\_eligibility\_epoch | VARCHAR(16777216) | Epoch when the validator became eligible for activation.                                                                                           |
| activation\_epoch              | VARCHAR(16777216) | Epoch when the validator was activated.                                                                                                            |
| exit\_epoch                    | VARCHAR(16777216) | Epoch when the validator exited or will exit (`18446744073709551615` means “not set” / far future in consensus encoding).                          |
| withdrawable\_epoch            | VARCHAR(16777216) | Epoch when balance becomes withdrawable (same sentinel applies when not applicable).                                                               |
| execution\_optimistic          | BOOLEAN           | Execution optimistic flag when present; may be empty depending on upstream payload metadata.                                                       |
| finalized                      | BOOLEAN           | Whether the beacon data for this row is finalized.                                                                                                 |
| unique\_id                     | VARCHAR(16777216) | 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.                                                                                                          |

### Related Docs

* [Beacon Raw Balances Daily Est](/historical-data/supported-blockchains/evm/beacon/raw/balances-daily-est)