Skip to main content

​
Tables

​
BeaconDepositContract_DepositEvent_event

Ethereum 2.0 (Beacon Chain) validator deposit events from the official deposit contract, recording 32 ETH stakes with validator public keys, withdrawal credentials, and BLS signatures. Used for tracking validator activations, staking patterns, and analyzing the transition from proof-of-work to proof-of-stake.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_pubkeySTRINGBLS12-381 public key of the validator being registered for Ethereum 2.0 staking. Hex-encoded 96-character string (48 bytes) uniquely identifying the validator on the Beacon Chain.
in_withdrawal_credentialsSTRINGBLS12-381 withdrawal credentials for the validator, determining where staked ETH can be withdrawn. Hex-encoded 32-byte value beginning with 0x00 for BLS credentials or 0x01 for execution layer addresses.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_signatureSTRINGCryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressremovedin_indexin_amountin_pubkeylog_indexblock_numberin_signatureblock_timestamptransaction_hashin_withdrawal_credentials
0x00000000219ab540356cbb839cbe05303d7705fafalse0x21af0300000000000x00405973070000000xa3bbee8e30504b082c1b165286381914a52546098f624ffeb1592bd11658c9d02c8f0ea2684e50a1947834b464c13545341132557170x94dc4c5c6039035d5c9470ca529d73fe449063776034fffefe12f7c17bb0b97351de731faec4f7e0b6e232589036832214f9a9d090eed0ba9bf9a1175698e0f13be42ccff7634b745350f903b22aece8e42f1fc8c543b33debd9bef6863136912021-09-19T10:53:32.000Z0xde804ad1345a39b8a5a3aebf9e9cf411bef7cc09970ea9102c7b5aa65fe3056d0x0032874960b7d0f9c4a0fccd31e5e28e11bb4f955e0ce6c8084316e80b70a76b
0x00000000219ab540356cbb839cbe05303d7705fafalse0x20af0300000000000x00405973070000000xb801009317cb49c100bcba6571e9b5f15457f00529f3647cb749bf08747ebeb998f5155bbaec76882ec282f68cacf5ac320132557170x810fc5a84e35e6c8b6093cfa8bace9458c425fa6a84b75edd0d03d03fce38c77721c39f5ac19bb7cf324fbdde218987b156337b325777c810ba34d355b82b5811acc6cc9c7ed77b5f4c3048da9f4fa925ee5fe044c774e298e3b5067aef52bf72021-09-19T10:53:32.000Z0x09394ac05d094707c1736c2e5bde62af038f30c816f4836db828fa4e8fb1f5620x0017acd60d1146b48a50986a5b53625b28e8df23c924e56dd10d4d5b9023dd36
0x00000000219ab540356cbb839cbe05303d7705fafalse0x5faf0300000000000x00405973070000000x8b8c292fd218d006613011577cb6fa461660e5e0853b0f89d24e6eb33e82a248f7880e3a6b70d16087d19ff14274b4c8267132584470x88caecea086afef5e1cbb4eac35fc1591cb898b59ae9c884aacb81e363f3e933cbcd62af3e75cc501ec10a51f86eba60024e14c20c9da53c86ed0962150df27938d3c7d584ebcf9fed394968fadb4cc5ee20b53133ffa039cc346d9761c3b7652021-09-19T20:49:08.000Z0x658f0ecf38805307688395962bc3085869bfd34c30ae5bc0858e22d39afc01860x004f58172d06b6d54c015d688511ad5656450933aff85dac123cd09410a0825c
Query with partition filter
SELECT *
FROM `tt-contracts.ethereum_v1_ethereum.BeaconDepositContract_DepositEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100