Table Details
| Property | Value |
|---|---|
| Table Name | beacon.raw.deposits |
| Table Status | Production-Ready |
| Unique Key | slot_timestamp, unique_id |
| Clustering Key(s) | slot_timestamp::date |
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. |
| deposit_amount | VARCHAR(134217728) | 0 |
| deposit_amount_raw | VARCHAR(134217728) | Raw amount of ETH deposited. |
| pubkey | VARCHAR(134217728) | 0xb20cbf80ded11e4089be8ff68c3150aa19f1a5dc064450a1a10097194f1d09d470261c183d8ca44717a4da7cafa11c4f |
| withdrawal_credentials | VARCHAR(134217728) | 0x010000000000000000000000e839a3e9efb32c6a56ab7128e51056585275506c |
| withdrawal_prefix | VARCHAR(134217728) | 0x01 |
| withdrawal_address | VARCHAR(134217728) | 0xe839a3e9efb32c6a56ab7128e51056585275506c |
| signature | VARCHAR(134217728) | 0x82a96e6e9a0ed5e55f6e6df5d1cb0c90d42ebf03b30dba2c202b8decc9261b077552794b89c8e330bb64256bbb9a5c9a012bb211bbd02ca01b2472cba8d5f033e0deef4de4617bcafa4c706db43333ba417c92a97c3bb9c9c1edfea088654c82 |
| proofs | ARRAY | __ |
| eth1_block_hash | VARCHAR(134217728) | 0xc0efee09619b108b8c184d7c4981b96bcef8fe63e6887f3ee20728d5ca6d6e67 |
| eth1_block_number | NUMBER(38,0) | 17,030,996 |
| eth1_block_timestamp | TIMESTAMP_NTZ(9) | 2023-04-12 09:19:47 |
| unique_id | VARCHAR(134217728) | 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. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |