Skip to main content

​
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.
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_proposerSTRINGEthereum 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_headerBlockIdSTRINGUnique identifier for the Polygon checkpoint header block submitted to Ethereum. Incrementing numeric value representing sequential checkpoint submissions on the RootChain contract.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_startSTRINGPolygon 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_endSTRINGPolygon block number marking the end of the checkpoint range submitted to Ethereum. Represents the last Polygon block included in this header block submission.
in_rootSTRINGMerkle 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.
in_endaddressin_rootremovedin_startin_rewardlog_indexin_proposerblock_numberblock_timestampin_headerBlockIdtransaction_hash
43283290x86e4dc95c7fbdbf52e33d563bbdb00823894c2870x8daeb80a4ee224ce220ee7bb5e437423e545362b06e0cb12e64765b6942afc6bfalse4327562201880000000000000000002210x0375b2fc7140977c9c76d45421564e354ed42277108374262020-09-11T00:54:12.000Z477300000x86f16a795d4cd40333d05315f0b989903b09b185f9f90340cefc22987b421714
43493210x86e4dc95c7fbdbf52e33d563bbdb00823894c2870xf158ffc4d3919152716d322b5d765888de3d1997d23d455fa6fed7ad70c00b5efalse4349066201880000000000000000001810x0375b2fc7140977c9c76d45421564e354ed42277108407022020-09-11T12:57:26.000Z479500000xbe0546c422f4f265a1e0a49c38db0929fe41a0f10c66a0a82c64d4572a3af08e
43598170x86e4dc95c7fbdbf52e33d563bbdb00823894c2870xe6cf5cc1288127dcd1cedcf1a14ae8c1dd3f4e27c7c210d0f76bab9ca7f75e87false4358794201880000000000000000001450x0375b2fc7140977c9c76d45421564e354ed42277108423102020-09-11T18:53:14.000Z481100000x6b4124ca89e8e159f74699a95f587e9fe11e1887b1a90d0e69bf77f848b322ee
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