> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# polygon_v1_ethereum

> Tables in tt-contracts.polygon_v1_ethereum

## 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.

<Accordion title="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.            |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.polygon_v1_ethereum.RootChain_NewHeaderBlock_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***