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

### Table Details

| Property            | Value                                              |
| ------------------- | -------------------------------------------------- |
| Table Name          | `beacon.raw.balances_daily`                        |
| Table Status        | Production-Ready                                   |
| Unique Key          | `slot_timestamp`, `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)      | 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                                                                                            |
| raw\_balance                   | VARCHAR(16777216) | Validator balance as an integer in **gwei** (1e9 gwei = 1 ETH).                                    |
| balance                        | FLOAT             | Balance of the validator.                                                                          |
| effective\_balance             | FLOAT             | Effective balance of the validator.                                                                |
| raw\_effective\_balance        | VARCHAR(16777216) | Effective balance at stake in **gwei**.                                                            |
| status                         | VARCHAR(16777216) | Current status of the validator.                                                                   |
| pubkey                         | VARCHAR(16777216) | 0xb20cbf80ded11e4089be8ff68c3150aa19f1a5dc064450a1a10097194f1d09d470261c183d8ca44717a4da7cafa11c4f |
| withdrawal\_credentials        | VARCHAR(16777216) | 0x010000000000000000000000e839a3e9efb32c6a56ab7128e51056585275506c                                 |
| withdrawal\_prefix             | VARCHAR(16777216) | 0x01                                                                                               |
| withdrawal\_address            | VARCHAR(16777216) | 0xe839a3e9efb32c6a56ab7128e51056585275506c                                                         |
| 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) | 230889                                                                                             |
| exit\_epoch                    | VARCHAR(16777216) | -1                                                                                                 |
| withdrawable\_epoch            | VARCHAR(16777216) | Epoch when validator can withdraw.                                                                 |
| execution\_optimistic          | BOOLEAN           | If the slot/epoch is executed optimistically.                                                      |
| finalized                      | BOOLEAN           | If the slot/epoch is finalized.                                                                    |
| unique\_id                     | VARCHAR(16777216) | date-2023-05-10\_validator\_index-459015                                                           |
| \_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.                                      |