Tables
RootChain_NewHeaderBlock_event
Polygon sidechain checkpoint submissions to Ethereum mainnet, recording Merkle root hashes and block ranges as validators commit Polygon state to the RootChain contract. Used to analyze validator activity, checkpoint frequency, and the bridge security mechanism between Polygon and Ethereum.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_proposer | STRING | Ethereum address of the validator who proposed this Polygon checkpoint to the RootChain contract. Hex-encoded, 0x-prefixed 40-character string identifying the checkpoint proposer eligible for rewards. |
in_headerBlockId | STRING | Unique identifier for the Polygon checkpoint header block submitted to Ethereum. Incrementing numeric value representing sequential checkpoint submissions on the RootChain contract. |
in_reward | STRING | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
in_start | STRING | Polygon block number marking the start of the checkpoint range being submitted to Ethereum mainnet. Represents the first Polygon block included in this checkpoint batch. |
in_end | STRING | Polygon block number marking the end of the checkpoint range submitted to Ethereum. Represents the last Polygon block included in this header block submission. |
in_root | STRING | Merkle root hash of the Polygon checkpoint submitted to Ethereum for the block range. Hex-encoded, 0x-prefixed 64-character hash representing the state snapshot of Polygon sidechain blocks. |
Sample Data
Sample Data
| in_end | address | in_root | removed | in_start | in_reward | log_index | in_proposer | block_number | block_timestamp | in_headerBlockId | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4328329 | 0x86e4dc95c7fbdbf52e33d563bbdb00823894c287 | 0x8daeb80a4ee224ce220ee7bb5e437423e545362b06e0cb12e64765b6942afc6b | false | 4327562 | 20188000000000000000000 | 221 | 0x0375b2fc7140977c9c76d45421564e354ed42277 | 10837426 | 2020-09-11T00:54:12.000Z | 47730000 | 0x86f16a795d4cd40333d05315f0b989903b09b185f9f90340cefc22987b421714 |
| 4349321 | 0x86e4dc95c7fbdbf52e33d563bbdb00823894c287 | 0xf158ffc4d3919152716d322b5d765888de3d1997d23d455fa6fed7ad70c00b5e | false | 4349066 | 20188000000000000000000 | 181 | 0x0375b2fc7140977c9c76d45421564e354ed42277 | 10840702 | 2020-09-11T12:57:26.000Z | 47950000 | 0xbe0546c422f4f265a1e0a49c38db0929fe41a0f10c66a0a82c64d4572a3af08e |
| 4359817 | 0x86e4dc95c7fbdbf52e33d563bbdb00823894c287 | 0xe6cf5cc1288127dcd1cedcf1a14ae8c1dd3f4e27c7c210d0f76bab9ca7f75e87 | false | 4358794 | 20188000000000000000000 | 145 | 0x0375b2fc7140977c9c76d45421564e354ed42277 | 10842310 | 2020-09-11T18:53:14.000Z | 48110000 | 0x6b4124ca89e8e159f74699a95f587e9fe11e1887b1a90d0e69bf77f848b322ee |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.polygon_v1_ethereum.RootChain_NewHeaderBlock_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100