Skip to main content

Table Details

PropertyValue
Table Namebeacon_hoodi.raw.pending_deposits
Table StatusBeta 🌱
Clustering Key(s)to_date("slot_timestamp")

Table Columns

Column NameData TypeDescription
slot_numberNUMBER(38,0)Beacon Chain slot number of when the pending deposit state was indexed
slot_timestampTIMESTAMP_NTZ(9)Beacon Chain slot timestamp of slot when the pending deposit state was indexed
epoch_numberNUMBER(38,0)Epoch number of when the pending deposit state was indexed
pubkeyVARCHAR(16777216)The validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive.
amountVARCHAR(16777216)The amount of ETH deposited in gwei (1e9 gwei = 1 ETH on Beacon Chain).
withdrawal_credentialsVARCHAR(16777216)Withdrawal credentials is a 32-byte field associated with every validator, initially set during deposit, for verifying the destination of valid withdrawals.
signatureVARCHAR(16777216)The BLS signature that aggregates the signatures of individual validators.
execution_optimisticBOOLEANIt’s true if the response references an unverified execution payload. The optimistic information may be invalidated at a later time. If the field is not present, assume the false value
finalizedBOOLEANIndicates whether the response data is finalized
pending_deposit_indexNUMBER(38,0)Array index of the pending deposit for the given epoch.
slotNUMBER(38,0)The slot number where the deposit is made into beacon chain.
_created_atTIMESTAMP_NTZ(9)Timestamp of the pending deposit data creation.
_updated_atTIMESTAMP_NTZ(9)Timestamp of the pending deposit data update.