Skip to main content

Table Details

PropertyValue
Table Namebeacon_hoodi.raw.deposits
Table StatusBeta 🌱

Table Columns

Column NameData TypeDescription
slot_numberNUMBER(38,0)Beacon Chain slot the block.
slot_timestampTIMESTAMP_NTZ(9)Beacon Chain slot timestamp of the block.
deposit_amountVARCHAR(16777216)Amount of ETH deposited, normalized
deposit_amount_rawVARCHAR(16777216)Amount of ETH deposited in raw format (gwei). To convert to ETH, divide by 10^9.
pubkeyVARCHAR(16777216)BLSPubkey.
withdrawal_credentialsVARCHAR(16777216)Commitment to pubkey for withdrawals. Withdrawal prefixes relate to the withdrawal credentials provided when deposits are made for validators.
withdrawal_prefixVARCHAR(16777216)The first byte of this credential is known as the withdrawal prefix. This value is currently either 0x00 or 0x01.
withdrawal_addressVARCHAR(16777216)#N/A
signatureVARCHAR(16777216)Deposit signature.
proofsARRAYArray of proof
eth1_block_hashVARCHAR(16777216)The block hash of the Ethereum 1.0 block.
eth1_block_numberNUMBER(38,0)The block number of the Ethereum 1.0 block.
eth1_block_timestampTIMESTAMP_NTZ(9)The Unix timestamp of the Ethereum 1.0 block.
unique_idVARCHAR(16777216)Unique ID for the deposit event.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of the attestation data update.