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

# hop_v1_polygon

> Tables in tt-contracts.hop_v1_polygon

## Tables

### L2Amm\_TokenSwap\_event

Token swap events from Hop Protocol Layer 2 Automated Market Maker (AMM) contracts. Records buyer address, sold and bought token identifiers with pool positions, and raw token amounts exchanged between pool assets.

<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_buyer`         | `STRING`    | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.                                |
  | `in_tokensSold`    | `STRING`    | Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.                  |
  | `in_tokensBought`  | `STRING`    | Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.              |
  | `in_soldId`        | `STRING`    | Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.            |
  | `in_boughtId`      | `STRING`    | Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.   |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_buyer                                  | in\_soldId | log\_index | in\_boughtId | block\_number | in\_tokensSold | block\_timestamp         | in\_tokensBought | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
  | 0x5c32143c8b198f392d01f8446b754c181224ac26 | false   | 0x09b17dbcd8ac17ed5d2d6bd22ecb8eb68759cb4b | 1          | 148        | 0            | 32322745      | 543386         | 2022-08-25T23:06:10.000Z | 543140           | 0x23ecb271efffd313f85b84ae516a9b488accfce340d1a7583731f231ab21e60b |
  | 0x5c32143c8b198f392d01f8446b754c181224ac26 | false   | 0x09b17dbcd8ac17ed5d2d6bd22ecb8eb68759cb4b | 0          | 214        | 1            | 32322338      | 1081761        | 2022-08-25T22:47:54.000Z | 1081384          | 0x375770b0c9042252598fc21c2eb8823c1621d1c83df9d4ee1c07ba698c1126fb |
  | 0x5c32143c8b198f392d01f8446b754c181224ac26 | false   | 0x1dab8da475acce5ef82dc6a0ab21cf758f18a8b8 | 1          | 129        | 0            | 32304115      | 6298306        | 2022-08-25T11:22:44.000Z | 6295094          | 0x51d0b94e52c9c08b33e8f1f40575e57b1954c9f66fd777786c654d02a8a190cd |
</Accordion>

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

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

***

### L2AmmDAI\_TokenSwap\_event

Token swap events from Hop Protocol's DAI Automated Market Maker (AMM) pool on Polygon. Records swaps between hTokens and canonical DAI with buyer addresses, token amounts, and pool token IDs for analyzing liquidity pool activity and cross-chain bridge utilization.

<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_buyer`         | `STRING`    | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.                                |
  | `in_tokensSold`    | `STRING`    | Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.                  |
  | `in_tokensBought`  | `STRING`    | Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.              |
  | `in_soldId`        | `STRING`    | Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.            |
  | `in_boughtId`      | `STRING`    | Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.   |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_buyer                                  | in\_soldId | log\_index | in\_boughtId | block\_number | in\_tokensSold         | block\_timestamp         | in\_tokensBought       | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | ---------------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ |
  | 0x25fb92e505f752f730cad0bd4fa17ece4a384266 | false   | 0x28529fec439cff6d7d1d5917e956dee62cd3be5c | 1          | 442        | 0            | 64746128      | 4800000000000000000000 | 2024-11-26T07:42:17.000Z | 4771942851100531000129 | 0x44c031938f610bfec18cbd28a9c3e793065168226f881dce93c81bb20b00d4ef |
  | 0x25fb92e505f752f730cad0bd4fa17ece4a384266 | false   | 0x28529fec439cff6d7d1d5917e956dee62cd3be5c | 1          | 425        | 0            | 64746128      | 9164129510209373593592 | 2024-11-26T07:42:17.000Z | 9127717472428178918454 | 0x44c031938f610bfec18cbd28a9c3e793065168226f881dce93c81bb20b00d4ef |
  | 0x25fb92e505f752f730cad0bd4fa17ece4a384266 | false   | 0x28529fec439cff6d7d1d5917e956dee62cd3be5c | 1          | 550        | 0            | 64733248      | 361449209744077645768  | 2024-11-26T00:01:47.000Z | 361464885214737504389  | 0x59d79283c4bed818f9816ac57f908f1221542b281cfb217e54f85df34f420d65 |
</Accordion>

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

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

***

### L2AmmETH\_TokenSwap\_event

Token swap events from Hop Protocol's Layer 2 automated market maker (AMM) pools for ETH pairs. Records buyer address, token indices, and raw quantities exchanged between pool tokens.

<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_buyer`         | `STRING`    | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.                                |
  | `in_tokensSold`    | `STRING`    | Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.                  |
  | `in_tokensBought`  | `STRING`    | Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.              |
  | `in_soldId`        | `STRING`    | Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.            |
  | `in_boughtId`      | `STRING`    | Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.   |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_buyer                                  | in\_soldId | log\_index | in\_boughtId | block\_number | in\_tokensSold  | block\_timestamp         | in\_tokensBought | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | --------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
  | 0x266e2dc3c4c59e42aa07afee5b09e964cffe6778 | false   | 0x0f6b5c480fdc3a1fafb1321b68c759873e677451 | 1          | 370        | 0            | 75755084      | 603211145553542 | 2025-08-28T10:09:57.000Z | 602364845204485  | 0x8357a1afe2ad56886855427e31b56f2f6b9c8d253dbf17485b7785ed2be2d34c |
  | 0x266e2dc3c4c59e42aa07afee5b09e964cffe6778 | false   | 0x2bd79c4b155808ac80623a7bf5d866a02b55a6be | 1          | 466        | 0            | 75750796      | 324183342446779 | 2025-08-28T07:38:05.000Z | 323728876022214  | 0x63651cae8912e7f35d23b6ffd7960659f153c2143c6cdda4110908ea382b0a12 |
  | 0x266e2dc3c4c59e42aa07afee5b09e964cffe6778 | false   | 0x3611b82c7b13e72b26eb0e9be0613bee7a45ac7c | 1          | 315        | 0            | 75755675      | 99661036345160  | 2025-08-28T10:30:53.000Z | 99521206281445   | 0x9923630ab5fa02b590fad9e7f0d39d75e9525a350dc6d6f3a882db12d3189553 |
</Accordion>

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

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

***

### L2AmmMATIC\_TokenSwap\_event

Token swap events from Hop Protocol's MATIC automated market maker (AMM) on Polygon L2. Records swaps between canonical and hToken MATIC with buyer addresses, sold/bought amounts, and token IDs for analyzing bridge liquidity pool trading activity.

<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_buyer`         | `STRING`    | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.                                |
  | `in_tokensSold`    | `STRING`    | Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.                  |
  | `in_tokensBought`  | `STRING`    | Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.              |
  | `in_soldId`        | `STRING`    | Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.            |
  | `in_boughtId`      | `STRING`    | Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.   |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_buyer                                  | in\_soldId | log\_index | in\_boughtId | block\_number | in\_tokensSold        | block\_timestamp         | in\_tokensBought      | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | --------------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ |
  | 0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1 | false   | 0x3d9ee32b4d8c5f4232b48a4d05e9325b23fe7a61 | 1          | 790        | 0            | 45285086      | 5618518407252169999   | 2023-07-20T01:18:04.000Z | 5610213951984584941   | 0xba97a3b739f8a80adb79b4522fed53aecb7d5d5d7cea9528e0110d94a9155e45 |
  | 0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1 | false   | 0x884d1aa15f9957e1aeaa86a82a72e49bc2bfcbe3 | 1          | 506        | 0            | 45307280      | 257725000000000000000 | 2023-07-20T14:41:14.000Z | 257406807447326643570 | 0x670c239c5346315a09b6c43de4d8440dcb0e313427aaaa7ec9a9c1b43a36c4a0 |
  | 0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1 | false   | 0x884d1aa15f9957e1aeaa86a82a72e49bc2bfcbe3 | 1          | 797        | 0            | 45285329      | 2107406085838735024   | 2023-07-20T01:26:52.000Z | 2104289664521227682   | 0x27984882c3b5b54e67e92134c9f9d005599ed9133c2355f9147e3333f4b900a1 |
</Accordion>

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

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

***

### L2AmmUSDT\_TokenSwap\_event

Token swap events from Hop Protocol's USDT Automated Market Maker (AMM) pool on Polygon Layer 2. Records token exchanges between pool assets with sold/bought amounts and token identifiers for analyzing liquidity pool trading activity.

<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_buyer`         | `STRING`    | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.                                |
  | `in_tokensSold`    | `STRING`    | Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.                  |
  | `in_tokensBought`  | `STRING`    | Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.              |
  | `in_soldId`        | `STRING`    | Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.            |
  | `in_boughtId`      | `STRING`    | Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.   |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_buyer                                  | in\_soldId | log\_index | in\_boughtId | block\_number | in\_tokensSold | block\_timestamp         | in\_tokensBought | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
  | 0xb2f7d27b21a69a033f85c42d5eb079043baadc81 | false   | 0x8741ba6225a6bf91f9d73531a98a89807857a2b3 | 1          | 151        | 0            | 37088532      | 81281645       | 2022-12-21T07:07:48.000Z | 81293171         | 0x6abfbafe1c00d563e0db22c21fcc3d7362233cae09ec6514ee4e66126b23c210 |
  | 0xb2f7d27b21a69a033f85c42d5eb079043baadc81 | false   | 0x8741ba6225a6bf91f9d73531a98a89807857a2b3 | 1          | 16         | 0            | 37114657      | 5735838        | 2022-12-21T22:27:53.000Z | 5739140          | 0x4093d0834cb538b75365f6cf6ca16875068caff314f8e560d9c4047cca02c1d5 |
  | 0xb2f7d27b21a69a033f85c42d5eb079043baadc81 | false   | 0x8741ba6225a6bf91f9d73531a98a89807857a2b3 | 1          | 839        | 0            | 37077696      | 28000000000    | 2022-12-21T00:51:52.000Z | 28008592937      | 0x38f9ce59923fe0d7c945789b4b30c29cb96b304959ba0c962e47c894bf930af7 |
</Accordion>

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

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

***

### L2AmmWBTC\_TokenSwap\_event

*No description available.*

<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_buyer`         | `STRING`    | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.                                |
  | `in_tokensSold`    | `STRING`    | Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.                  |
  | `in_tokensBought`  | `STRING`    | Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.              |
  | `in_soldId`        | `STRING`    | Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.            |
  | `in_boughtId`      | `STRING`    | Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.   |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

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

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

***

### L2Bridge\_TransferSent\_event

Cross-chain transfer initiation events from Hop Protocol L2 bridges recording amount, recipient, destination chain, bonder fee, and transfer identifiers. Used for tracking bridge transactions and calculating cross-chain transfer costs.

<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_transferId`    | `STRING`    | Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.                                                        |
  | `in_chainId`       | `STRING`    | Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155. |
  | `in_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                               |
  | `in_transferNonce` | `STRING`    | Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.                     |
  | `in_bonderFee`     | `STRING`    | Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token's smallest denomination.       |
  | `in_index`         | `STRING`    | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).                          |
  | `in_amountOutMin`  | `STRING`    | Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.                |
  | `in_deadline`      | `STRING`    | Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.                                                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_index | in\_amount | log\_index | in\_chainId | in\_deadline | block\_number | in\_bonderFee | in\_recipient                              | in\_transferId                                                     | block\_timestamp         | in\_amountOutMin | in\_transferNonce                                                  | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------- | ---------- | ---------- | ----------- | ------------ | ------------- | ------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0x25d8039bb044dc227f741a9e381ca4ceae2e6ae8 | false   | 3         | 21657977   | 163        | 1           | 0            | 27740710      | 14732123      | 0x2722764f04c605e378261ebd577434ebeb4c3746 | 0xfb5b7c5ff7814cf1f30c51ebb660448aa53e09334cb26a7f5b31af1a95c50a2c | 2022-04-30T03:28:27.000Z | 0                | 0x2e01e4f1e6a83a90a3a79b256dd594ad47db697bc3952c3937b4859a91a7f5ba | 0xf1c31e680aba1c3598935a911c510787071a4ea37394e6e5b028787e4f7f99f8 |
  | 0x25d8039bb044dc227f741a9e381ca4ceae2e6ae8 | false   | 6         | 74432838   | 239        | 1           | 0            | 27748441      | 13110123      | 0x6255e5d2b3f82e4025959c1a3e8f19fefe087cc2 | 0x11653f39a2ee546ffa9477c2451df634ee17b80de40dfd206e6f9142d7bc5271 | 2022-04-30T08:11:51.000Z | 0                | 0x668d2935b76f66ce2c0fd7f021da94ab7e0665837ec43333346a73d6f8910289 | 0x3c5dfc9ede36b8d442221774a0da45834f3fa77418b3733941343330b173fcc5 |
  | 0x25d8039bb044dc227f741a9e381ca4ceae2e6ae8 | false   | 16        | 233313821  | 329        | 1           | 0            | 27761328      | 25706123      | 0xa844e772716caa96faed692b123f65f7d882d0d6 | 0x7b24a8f76bedf71ac6569edc5cfce6799ede20b2003ae8b60c611edbfb8c16af | 2022-04-30T16:12:46.000Z | 0                | 0x3b9fb15e3b350c195b7d1e4fbf5a4469968617842064decaf87ff38fc195c5da | 0x2b6ef36f1ee2b3c4392ab8062fad8b1c6ce251af01d7d5e166a9e5265690c17b |
</Accordion>

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

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

***

### L2BridgeDAI\_TransferSent\_event

Outbound DAI transfer events from Hop Protocol's Layer 2 bridge contract on Polygon, capturing cross-chain transfers to Ethereum mainnet and Optimism with transfer amounts, bonder fees, recipient addresses, and unique transfer identifiers.

<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_transferId`    | `STRING`    | Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.                                                        |
  | `in_chainId`       | `STRING`    | Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155. |
  | `in_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                               |
  | `in_transferNonce` | `STRING`    | Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.                     |
  | `in_bonderFee`     | `STRING`    | Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token's smallest denomination.       |
  | `in_index`         | `STRING`    | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).                          |
  | `in_amountOutMin`  | `STRING`    | Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.                |
  | `in_deadline`      | `STRING`    | Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.                                                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_index | in\_amount            | log\_index | in\_chainId | in\_deadline  | block\_number | in\_bonderFee       | in\_recipient                              | in\_transferId                                                     | block\_timestamp         | in\_amountOutMin    | in\_transferNonce                                                  | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------- | --------------------- | ---------- | ----------- | ------------- | ------------- | ------------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0xecf268be00308980b5b3fcd0975d47c4c8e1382a | false   | 27        | 369849536745651943017 | 225        | 1           | 0             | 29968298      | 4790152599676184123 | 0xd9a3ea0acdb41a12e871482a8eef99a017e38bf4 | 0xa72cd102e361360cbffc2032b674ebe82b96b25b7b7aadff9ac986f8e4c51b12 | 2022-06-25T03:52:30.000Z | 0                   | 0xbce4ea4d5892e88963b913f365dff54adaea57c09614871421deff179b73407f | 0x1452904b18222f9ebc1d0530aadb1002f21fb111f96ded7c47af24251251744e |
  | 0xecf268be00308980b5b3fcd0975d47c4c8e1382a | false   | 57        | 997779696585400976    | 205        | 10          | 1656134146586 | 29969893      | 434897800962701577  | 0x813e16e4cd95c2cc74af6be7e4850937e10705a6 | 0x025a5a1611c369961082aca03d621720156539265ebe2a30e9f0fa624cd857fd | 2022-06-25T04:56:08.000Z | 534029656855727313  | 0xe8cf27607d634c9439de2da46dd9f5c8fecc9ecf154dc2ee52a5909eb8a4f91f | 0x44264509012cce2343f468f76dcf38bad7f7270584020d9f194b5678534503cd |
  | 0xecf268be00308980b5b3fcd0975d47c4c8e1382a | false   | 58        | 9996998067098214546   | 274        | 10          | 1656244217    | 29980214      | 387235814670058889  | 0xd88c972516714c6cb182c08cc4116dd3d5056f86 | 0x2c277d814c2b9f09b48d9395a9bbc393b5a6d8b6129674de1fe6e320fb4f757c | 2022-06-25T12:12:13.000Z | 9315237824863147411 | 0x1446fb2fb6a6daf897876d73057bcabe30f55cb3edc8ae0875eafaf109d7fcd5 | 0x70d38f04af8ef0546caf4686220d5f410fae54b761efab079f145e57323f622c |
</Accordion>

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

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

***

### L2BridgeETH\_TransferSent\_event

ETH transfer events emitted by Hop Protocol Layer 2 bridge contracts when cross-chain transfers are initiated. Contains transfer amount, bonder fee, destination chain ID, recipient address, and unique transfer identifiers for tracking asset flows between networks.

<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_transferId`    | `STRING`    | Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.                                                        |
  | `in_chainId`       | `STRING`    | Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155. |
  | `in_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                               |
  | `in_transferNonce` | `STRING`    | Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.                     |
  | `in_bonderFee`     | `STRING`    | Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token's smallest denomination.       |
  | `in_index`         | `STRING`    | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).                          |
  | `in_amountOutMin`  | `STRING`    | Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.                |
  | `in_deadline`      | `STRING`    | Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.                                                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_index | in\_amount        | log\_index | in\_chainId | in\_deadline | block\_number | in\_bonderFee    | in\_recipient                              | in\_transferId                                                     | block\_timestamp         | in\_amountOutMin | in\_transferNonce                                                  | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------- | ----------------- | ---------- | ----------- | ------------ | ------------- | ---------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0xb98454270065a31d71bf635f6f7ee6a518dfb849 | false   | 530       | 60219996571624945 | 169        | 1           | 0            | 53060430      | 3367783266144123 | 0x0353ee54aa1d88f962d5d806d0856fe25dbdc568 | 0x2212018c9edac78387a11f67377d50c07db56fc9107abf213db6bc3816571a37 | 2024-02-03T03:11:42.000Z | 0                | 0x907db9ef6ec9bc0a23f4d6fbe65e98b10ee41ec6c41c8836483480f38591588f | 0xca17399dd3b7bb72e4863b9acb5f7829b04747802a701674eb841cd439e6518e |
  | 0xb98454270065a31d71bf635f6f7ee6a518dfb849 | false   | 582       | 21215918838260374 | 439        | 1           | 0            | 53070436      | 2401335055026006 | 0x0c7d841966696af4d1aff9a56424ab938626a443 | 0x01e9a0d1abfb3b4860be7917a4e0cb30a1ce91a8b42b42d1eafad90a496470d9 | 2024-02-03T09:20:36.000Z | 0                | 0xb401fba47386d36e61a01b1dce3a544ef8d80d8ba5bafec64724a50bb0914e70 | 0xe5b8b037d210f32d560146480b306d7068440a0a1182b43ab9eeba4953ca3ec0 |
  | 0xb98454270065a31d71bf635f6f7ee6a518dfb849 | false   | 656       | 4357043529658591  | 390        | 1           | 0            | 53083737      | 3614135287993205 | 0xb4881e8f7d139956c732b2cdcd09c4195359f0e8 | 0xabb2988dd6705636b09ad0af0e1b348818f52bc6377853a00a0885df06af44c0 | 2024-02-03T17:27:49.000Z | 0                | 0x3d6dc3767ce63f556269e22ca9cbb95f2ada72beecf46476640072caf59f9007 | 0x0f555c99fa74639b5922ea80735dc97079fd6a10250046bc4f6a29b5add63120 |
</Accordion>

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

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

***

### L2BridgeMATIC\_TransferSent\_event

MATIC token transfer events sent from Hop Protocol's Layer 2 bridge on Polygon to Ethereum mainnet (chain ID 1). Records include transfer amounts, bonder fees, recipient addresses, and unique transfer identifiers for tracking cross-chain bridge transactions.

<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_transferId`    | `STRING`    | Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.                                                        |
  | `in_chainId`       | `STRING`    | Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155. |
  | `in_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                               |
  | `in_transferNonce` | `STRING`    | Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.                     |
  | `in_bonderFee`     | `STRING`    | Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token's smallest denomination.       |
  | `in_index`         | `STRING`    | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).                          |
  | `in_amountOutMin`  | `STRING`    | Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.                |
  | `in_deadline`      | `STRING`    | Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.                                                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_index | in\_amount             | log\_index | in\_chainId | in\_deadline | block\_number | in\_bonderFee        | in\_recipient                              | in\_transferId                                                     | block\_timestamp         | in\_amountOutMin | in\_transferNonce                                                  | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------- | ---------------------- | ---------- | ----------- | ------------ | ------------- | -------------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0x553bc791d746767166fa3888432038193ceed5e2 | false   | 210       | 1408772500408682792684 | 282        | 1           | 0            | 58829184      | 10098176904433562801 | 0x062f3d74aa609cb4156acaa00a7b253e262b4a56 | 0x26342b0ac5c1174bbd68d79d6b1934484bf7baa8b0bd1d11d53e47d50c9af80d | 2024-07-01T13:14:07.000Z | 0                | 0x99bbd316da8836e5bfaea25b93a8a84d003c94152f5f17121bb3661f3b2989f0 | 0x4a314d5f229cadf473edd1bcf19fc178aba3087f19f450928a9414671b6e781f |
  | 0x553bc791d746767166fa3888432038193ceed5e2 | false   | 221       | 270800647313948479236  | 397        | 1           | 0            | 58846137      | 3860045770368786534  | 0x206dc6fb3b98b3ba0369650656b454837ba06a2a | 0x859366b325eb7d301c9bcdc76d8215988ee1fc3baaefaac45b37eae74b84c7df | 2024-07-01T23:21:33.000Z | 0                | 0x9aeb9fee16724c962e86a772f6c39dc093515a8a6e7a5c3eb66ee27af4b9e890 | 0x2de48f51c85bab1edf7746402f63a58b6a834c2c560b294bca3bbd1c5fa26877 |
  | 0x553bc791d746767166fa3888432038193ceed5e2 | false   | 216       | 115140908564818948046  | 100        | 1           | 0            | 58838511      | 16038629181832956287 | 0x26eae1288f7f5c77b23ede18d138d097f5ebf1c5 | 0x89a9b737aae2617d6186d1354e0233501722643635bbfe3b3fa2f0da34f07524 | 2024-07-01T18:46:39.000Z | 0                | 0xd64bbe37babab12f345e90c0cd24c4dad027b9c04d789539ca599bef6fd0d170 | 0x683ff029d9ca01ffc95cd350ec992c9660faba9bf3bbb6ab6b0a53d0f583329c |
</Accordion>

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

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

***

### L2BridgeUSDT\_TransferSent\_event

USDT bridge transfer events sent from Hop Protocol's Layer 2 bridge on Polygon to destination chains (primarily Ethereum mainnet and Arbitrum). Records transfer amounts, bonder fees, recipient addresses, and unique transfer identifiers for tracking cross-chain USDT movements.

<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_transferId`    | `STRING`    | Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.                                                        |
  | `in_chainId`       | `STRING`    | Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155. |
  | `in_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                               |
  | `in_transferNonce` | `STRING`    | Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.                     |
  | `in_bonderFee`     | `STRING`    | Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token's smallest denomination.       |
  | `in_index`         | `STRING`    | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).                          |
  | `in_amountOutMin`  | `STRING`    | Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.                |
  | `in_deadline`      | `STRING`    | Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.                                                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_index | in\_amount | log\_index | in\_chainId | in\_deadline | block\_number | in\_bonderFee | in\_recipient                              | in\_transferId                                                     | block\_timestamp         | in\_amountOutMin | in\_transferNonce                                                  | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------- | ---------- | ---------- | ----------- | ------------ | ------------- | ------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0x6c9a1acf73bd85463a46b0afc076fbdf602b690b | false   | 15        | 977399     | 220        | 1           | 0            | 69804984      | 450814        | 0x6ec6d1da62bf276f0bae82532c33cce02db694a3 | 0xad2a3b26b7c75727713439b63f35fbf2cc8cba545bd9447defb30af6e2fd5cac | 2025-04-02T12:25:39.000Z | 0                | 0x3495798927e1c165e738fe1d92b465ae21064f3c4b3191dd13bc18ef2f8d3ed6 | 0x62cee581d9c8aa6747549205312cbdd837f9fa55822ef0682e283236f8c72fb4 |
  | 0x6c9a1acf73bd85463a46b0afc076fbdf602b690b | false   | 17        | 1066726    | 666        | 1           | 0            | 69816673      | 457175        | 0x6e41ca1c55a7fbd1b5ea5e338e479f15237eff76 | 0x34da73969f36a037351f0bb530b43d398d2e9fa54753b5cb810dcf424765fc5c | 2025-04-02T19:19:40.000Z | 0                | 0xfa1cb1b3656c9fd2cd71032bdefa017c4b51ebc175e8d114e6a632359aa3460e | 0x6baf95156dc10da679a791180ae49bd20d5f65b873bfd43ee6adf87907f60d97 |
  | 0x6c9a1acf73bd85463a46b0afc076fbdf602b690b | false   | 18        | 34518439   | 233        | 1           | 0            | 69820221      | 932465        | 0x7d6f869601b0c817eb08f991f07a7db3fd55c4be | 0x030f7cf117f0b0abeb3fb9701fab76fbde66f0c837d5a534e7bc785de62bafaa | 2025-04-02T21:25:22.000Z | 0                | 0x94a9ce7f14ff40996567d35e61bfaec6124a3905915cff586d04257ba47cd7e5 | 0xc3b30077f72178129b1f2f64c60a047576d7fde9d30220e0dc5bb1553e143554 |
</Accordion>

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

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

***

### L2BridgeWBTC\_TransferSent\_event

WBTC (Wrapped Bitcoin) transfer events from Hop Protocol's Layer 2 bridge on Polygon, capturing cross-chain transfers to Ethereum mainnet (chain ID 1) with amounts, bonder fees, and recipient addresses. Used for tracking WBTC bridge flow volume and fee analysis.

<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_transferId`    | `STRING`    | Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.                                                        |
  | `in_chainId`       | `STRING`    | Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155. |
  | `in_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                               |
  | `in_transferNonce` | `STRING`    | Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.                     |
  | `in_bonderFee`     | `STRING`    | Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token's smallest denomination.       |
  | `in_index`         | `STRING`    | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).                          |
  | `in_amountOutMin`  | `STRING`    | Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.                |
  | `in_deadline`      | `STRING`    | Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.                                                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_index | in\_amount | log\_index | in\_chainId | in\_deadline | block\_number | in\_bonderFee | in\_recipient                              | in\_transferId                                                     | block\_timestamp         | in\_amountOutMin | in\_transferNonce                                                  | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------- | ---------- | ---------- | ----------- | ------------ | ------------- | ------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0x91bd9ccec64fc22475323a0e55d58f7786587905 | false   | 0         | 100        | 213        | 1           | 0            | 24164565      | 25            | 0xfefec7d3eb14a004029d278393e6ab8b46fb4fca | 0x3608640d46fd719cbcdef5c7b3927e4bcec29b486ac648e7d3f21f263b049126 | 2022-01-25T23:43:38.000Z | 0                | 0xaab5d9a86883b6867359d0de1d5869db334f42655c9e7cf77e9ce144fab5ce91 | 0xc538dd4431fc3ab0b21a83e3f06b4c0fa0c22e46e4686d482fa200ba42438a7a |
  | 0x91bd9ccec64fc22475323a0e55d58f7786587905 | false   | 0         | 10         | 136        | 1           | 0            | 30492829      | 5             | 0xfefec7d3eb14a004029d278393e6ab8b46fb4fca | 0x680084de6c19854cf4ae00024efe2f8f6cdd4c8c377746168d06dd51fdfea086 | 2022-07-08T18:17:10.000Z | 0                | 0xb6fa47e4d2869c28781c78e96a780d70601eb1ffed2f48130b4d93fba1c1bab9 | 0x2564e81c2700e70efbe19a29d3ce4228745c4f2cbd4a3dddbd1debec5c9be961 |
</Accordion>

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

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

***

### StakingRewards\_RewardPaid\_event

Reward distribution events from StakingRewards contracts recording when staked positions earn incentives. Contains recipient address, reward amount, and optional token or position identifiers for tracking yield distribution across protocols.

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_reward`        | `STRING`    | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.                                    |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_reward          | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x297e5079df8173ae1696899d3eacd708f0af82ce | 0xfa043b360ab0c98644c1312594a091a758920b44 | false   | 9240030437424       | 293        | 56190233      | 2024-04-24T06:45:07.000Z | 0x0162340bd8955859509022306aa2291cf38577633ecd6dca3d4c25c71756fa7e |
  | 0x297e5079df8173ae1696899d3eacd708f0af82ce | 0x38b3349d3c1454754f12848621fe590f2163c427 | false   | 153976790967514224  | 195        | 56205031      | 2024-04-24T16:03:48.000Z | 0xa73e2af36a4f5c3c0310269cec19989d4e07fa1fc0f53df9d5adfb8d371dae21 |
  | 0x297e5079df8173ae1696899d3eacd708f0af82ce | 0xfa043b360ab0c98644c1312594a091a758920b44 | false   | 1232320749371097712 | 349        | 56190178      | 2024-04-24T06:43:07.000Z | 0xeb4aff775c5bfae7159e241f05205b35de77776c553817a93b9008e008234215 |
</Accordion>

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

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

***