| slot_number | NUMBER(38,0) | Slot number of the balance snapshot. |
| slot_timestamp | TIMESTAMP_NTZ(9) | Slot timestamp of balance snapshot. |
| validator_index | NUMBER(38,0) | Unique index of the validator. |
| total_income | FLOAT | Total income = consensus + execution income. |
| consensus_income | FLOAT | Consensus layer (Beacon Chain) income. |
| execution_income | FLOAT | Execution layer income, if validator proposed the block and the builder sent MEV rewards. |
| execution_income_pbs | FLOAT | PBS blocks income — MEV payout transfer from block builder to proposer fee recipient. |
| execution_income_non_pbs | FLOAT | Non-PBS blocks income — assuming no MEV payout in those blocks. |
| current_balance | FLOAT | Validator balance at current date timestamp. |
| previous_balance | FLOAT | Validator balance at the previous date timestamp. |
| withdrawal_amount | FLOAT | Total ETH withdrawn for the validator on the current date (0 if none). |
| deposit_amount | FLOAT | Total ETH deposited for the validator on the current date (0 if none). |
| status | VARCHAR(16777216) | Current validator status. Only active validators included. |
| is_slashed | BOOLEAN | Whether the validator was slashed (no longer active). |
| pubkey | VARCHAR(98) | Validator’s BLS public key (48 bytes, hex-encoded with 0x prefix). |
| withdrawal_prefix | VARCHAR(16777216) | First byte of the withdrawal credential (0x00 or 0x01). |
| withdrawal_address | VARCHAR(42) | ETH1 withdrawal address, applicable for 0x01 withdrawal credentials. |
| current_effective_balance | FLOAT | Effective staked balance at current date. |
| previous_effective_balance | FLOAT | Effective staked balance at previous date. |
| unique_id | VARCHAR(16777216) | Unique ID for the income entry. |
| slot_change | NUMBER(38,0) | Slot difference from previous date to current date. |
| _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. |
