Table Details
| Property | Value |
|---|---|
| Table Name | beacon.raw.withdrawals |
| Table Status | Production-Ready |
| Unique Key | slot_timestamp, withdrawal_index |
| Clustering Key(s) | slot_timestamp::date |
| Search Optimization | validator_index, withdrawal_address |
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. |
| withdrawal_index | NUMBER(38,0) | 4,111,065 |
| validator_index | NUMBER(38,0) | 916,865 |
| withdrawal_amount | VARCHAR(16777216) | 0.012449812 |
| withdrawal_amount_raw | NUMBER(38,0) | Raw amount of ETH withdrawn. |
| withdrawal_address | VARCHAR(42) | 0xe839a3e9efb32c6a56ab7128e51056585275506c |
| eth1_block_hash | VARCHAR(16777216) | 0xc0efee09619b108b8c184d7c4981b96bcef8fe63e6887f3ee20728d5ca6d6e67 |
| eth1_block_number | NUMBER(38,0) | 17,030,996 |
| eth1_block_timestamp | TIMESTAMP_NTZ(9) | 2023-04-12 09:19:47 |
| _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. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |