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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_pubkey | STRING | BLS12-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_credentials | STRING | BLS12-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_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
in_signature | STRING | Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key. |
in_index | STRING | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
Sample Data
Sample Data
| address | removed | in_index | in_amount | in_pubkey | log_index | block_number | in_signature | block_timestamp | transaction_hash | in_withdrawal_credentials |
|---|---|---|---|---|---|---|---|---|---|---|
| 0x00000000219ab540356cbb839cbe05303d7705fa | false | 0x21af030000000000 | 0x0040597307000000 | 0xa3bbee8e30504b082c1b165286381914a52546098f624ffeb1592bd11658c9d02c8f0ea2684e50a1947834b464c13545 | 341 | 13255717 | 0x94dc4c5c6039035d5c9470ca529d73fe449063776034fffefe12f7c17bb0b97351de731faec4f7e0b6e232589036832214f9a9d090eed0ba9bf9a1175698e0f13be42ccff7634b745350f903b22aece8e42f1fc8c543b33debd9bef686313691 | 2021-09-19T10:53:32.000Z | 0xde804ad1345a39b8a5a3aebf9e9cf411bef7cc09970ea9102c7b5aa65fe3056d | 0x0032874960b7d0f9c4a0fccd31e5e28e11bb4f955e0ce6c8084316e80b70a76b |
| 0x00000000219ab540356cbb839cbe05303d7705fa | false | 0x20af030000000000 | 0x0040597307000000 | 0xb801009317cb49c100bcba6571e9b5f15457f00529f3647cb749bf08747ebeb998f5155bbaec76882ec282f68cacf5ac | 320 | 13255717 | 0x810fc5a84e35e6c8b6093cfa8bace9458c425fa6a84b75edd0d03d03fce38c77721c39f5ac19bb7cf324fbdde218987b156337b325777c810ba34d355b82b5811acc6cc9c7ed77b5f4c3048da9f4fa925ee5fe044c774e298e3b5067aef52bf7 | 2021-09-19T10:53:32.000Z | 0x09394ac05d094707c1736c2e5bde62af038f30c816f4836db828fa4e8fb1f562 | 0x0017acd60d1146b48a50986a5b53625b28e8df23c924e56dd10d4d5b9023dd36 |
| 0x00000000219ab540356cbb839cbe05303d7705fa | false | 0x5faf030000000000 | 0x0040597307000000 | 0x8b8c292fd218d006613011577cb6fa461660e5e0853b0f89d24e6eb33e82a248f7880e3a6b70d16087d19ff14274b4c8 | 267 | 13258447 | 0x88caecea086afef5e1cbb4eac35fc1591cb898b59ae9c884aacb81e363f3e933cbcd62af3e75cc501ec10a51f86eba60024e14c20c9da53c86ed0962150df27938d3c7d584ebcf9fed394968fadb4cc5ee20b53133ffa039cc346d9761c3b765 | 2021-09-19T20:49:08.000Z | 0x658f0ecf38805307688395962bc3085869bfd34c30ae5bc0858e22d39afc0186 | 0x004f58172d06b6d54c015d688511ad5656450933aff85dac123cd09410a0825c |
Example Query
Example Query
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