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

> Tables in tt-contracts.hop_v1_base

## 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                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
  | 0x022c5ce6f1add7423268d41e08df521d5527c2a0 | false   | 0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f | 0          | 12         | 1            | 10209425      | 29088247       | 2024-02-06T08:29:57.000Z | 29125130         | 0x9c065cbe04bdecdf1863c7fae3d156c2c8975ec6d0ebb7aad4de69a01c94e92f |
  | 0x022c5ce6f1add7423268d41e08df521d5527c2a0 | false   | 0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f | 0          | 30         | 1            | 10213886      | 111947247      | 2024-02-06T10:58:39.000Z | 112083795        | 0x909af4db90f95734806341cc5df38ddce774c8a4f5a7ea2c8ac71e606471bf33 |
  | 0x022c5ce6f1add7423268d41e08df521d5527c2a0 | false   | 0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f | 0          | 17         | 1            | 10213668      | 121425000      | 2024-02-06T10:51:23.000Z | 121575369        | 0xf90cd234b9e60df750cdff4f589d2920bae717d033ddca7105c51ab50de3c3ef |
</Accordion>

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

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.hop_v1_base.L2Amm_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                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | ----------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
  | 0x0ce6c85cf43553de10fc56ceca0aef6ff0dd444d | false   | 0x10541b07d8ad2647dc6cd67abd4c03575dade261 | 0          | 66         | 1            | 10255580      | 5000000000000000  | 2024-02-07T10:08:27.000Z | 4994568625310303  | 0x38e0309756aca276ed101e04ec2c6c04d908099ffa38b23c6f982b7415def512 |
  | 0x0ce6c85cf43553de10fc56ceca0aef6ff0dd444d | false   | 0x10541b07d8ad2647dc6cd67abd4c03575dade261 | 0          | 74         | 1            | 10275105      | 993000000000000   | 2024-02-07T20:59:17.000Z | 991480673487586   | 0x1a48627d8d91568f3c3d1d5ff121e3b3c56254a5fc143662e932ae3006c5674d |
  | 0x0ce6c85cf43553de10fc56ceca0aef6ff0dd444d | false   | 0x10541b07d8ad2647dc6cd67abd4c03575dade261 | 0          | 63         | 1            | 10269617      | 24000000000000000 | 2024-02-07T17:56:21.000Z | 23963559979093570 | 0x7a2bdf9cce156cbf73b2a98680ec38d509240f8a854563548472b84d6f2bd48b |
</Accordion>

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

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.hop_v1_base.L2AmmETH_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                                                  |
  | ------------------------------------------ | ------- | --------- | ---------- | ---------- | ----------- | ------------- | ------------- | ------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0x46ae9bab8cea96610807a275ebd36f8e916b5c61 | false   | 13        | 104194129  | 40         | 10          | 1702043678408 | 7324777       | 441444        | 0x5278973d51d3bc8e59a9a0d9e95218bfe4cc4ee4 | 0xb2fce32805e9304d8d2a3838d186de0e1ab5b376c1557e9063cb3f2d0761dc61 | 2023-12-01T13:55:01.000Z | 103179258        | 0x409baf958e945490e5faefa6b5d4634c7b5671a7f39f5a9b16b28e82fc4d2568 | 0xb9509696664fdc5e9501aa11fc474d61296305cfc5e64051527b6b6d3c5b0cb6 |
  | 0x46ae9bab8cea96610807a275ebd36f8e916b5c61 | false   | 14        | 34277363   | 13         | 10          | 1701525874    | 7325070       | 490641        | 0x1de21737f386aa8740a8d7aef022abd6588f5f99 | 0xac8319e7f9302c8e779c4658e9712608c4bfda84407ab2517cfba4300db89584 | 2023-12-01T14:04:47.000Z | 33595028         | 0xda9e5a0737f827084eb7b1383e03e9f02ac2af1af3bf506c7de1b5293369dbbf | 0x2244163a0806a68234d12d1fe01cc21e4ceb7a0e1077c6ef487542b80e1b42fa |
  | 0x46ae9bab8cea96610807a275ebd36f8e916b5c61 | false   | 15        | 100092516  | 11         | 10          | 1701529587    | 7326930       | 544604        | 0x00409fc839a2ec2e6d12305423d37cd011279c09 | 0x906ff32711949fdb2c8ff5ae34de98bd652a526d8cecf46ae2eb993462a1e00e | 2023-12-01T15:06:47.000Z | 98983797         | 0x3a569ffeba513f1e3c0739005649a1fb34f2e975f66a7806bf7d19d191d7ade0 | 0x4d8ef309130ac03ad2693048c13c98b72ec188ba4ef4032570a898b99a44f6fa |
</Accordion>

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

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.hop_v1_base.L2Bridge_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                                                  |
  | ------------------------------------------ | ------- | --------- | ----------------- | ---------- | ----------- | ------------ | ------------- | ---------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0x3666f603cc164936c1b87e207f36beba4ac5f18a | false   | 693       | 22614978210847770 | 6          | 1           | 0            | 6449054       | 3308554477969348 | 0xd8cc1b1555276310842f4a68ae16e673854d911c | 0x58ae07bd7509593a598397502f4f215bb7cd63f41a8c6f2ff923791635b37a63 | 2023-11-11T07:24:15.000Z | 0                | 0xa010d2b988dab1597a455962a0ef337c2637d2341483900a703aa07428c606ec | 0x2c26a277652023ee8a41dcc1cd6918d37289875c169d2a5acd5bc92cbed9aa35 |
  | 0x3666f603cc164936c1b87e207f36beba4ac5f18a | false   | 721       | 12231537131067331 | 6          | 1           | 0            | 6464657       | 6357160199633843 | 0xd79f8b51a1ed5c6a8150a37c5409421052e8894c | 0x3c065a7f8dc2661a7ecdb1efb6d800f44b8824855e5f6a3e61cf959c6007d2ed | 2023-11-11T16:04:21.000Z | 0                | 0x41be615fb8f32c23315c75b1af0083d90de1a4fc64203a96876f23e1ed8d4952 | 0xd038881f659a5b49da94440cc36ec933f00f806e5edc48a88b0ea088d8065a4c |
  | 0x3666f603cc164936c1b87e207f36beba4ac5f18a | false   | 662       | 58415776221125859 | 6          | 1           | 0            | 6439179       | 4308852529690146 | 0xc81541301c331a314eba06530ca28dd727707170 | 0x571916cf5e0c3db9205911562dbdb31b770cdbd8622a54f9ee48c90b46ccbf37 | 2023-11-11T01:55:05.000Z | 0                | 0xfafe3a3a95f24f1846a74df2748a23cee94b323fe4316fc81b070257edd80e47 | 0x8538a405ed1c452314d2083ce6ad77173b97cea06943857e02c4d675bc552895 |
</Accordion>

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

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

***

### L2BridgeHOP\_TransferSent\_event

Cross-chain transfer events from Hop Protocol's Layer 2 bridge on Base, tracking outbound transfers with amounts, fees, recipient addresses, and destination chain identifiers. Used for analyzing bridge volume, bonder fee economics, and cross-chain asset flows between Base and other networks like Optimism (chain ID 10), Arbitrum (42161), and Polygon (137).

<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                                                  |
  | ------------------------------------------ | ------- | --------- | ----------------------- | ---------- | ----------- | ------------ | ------------- | -------------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ----------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0xe22d2bedb3eca35e6397e0c6d62857094aa26f52 | false   | 6         | 177196438887613891383   | 18         | 10          | 1704904653   | 8755255       | 8444801771209099123  | 0xc960338b529e0353f570f62093fd362b8fb55f0b | 0xc323a4d8777d12391c4fe90bedf3a83c15a48ae987588c1535abe1fe4393f7bb | 2024-01-03T16:37:37.000Z | 167865654921966722803   | 0xeec4b868f3048a0f33291639d2e2af7c7c29afaa5fc7b4bb47b534c98ea54b3e | 0x45134aeff797e40eda3e8e9be0f775f0d593208745b0b6e8abefdbae85b230ae |
  | 0xe22d2bedb3eca35e6397e0c6d62857094aa26f52 | false   | 5         | 8318501625621866610688  | 16         | 10          | 1704297494   | 8748674       | 29556411954797957519 | 0x0a6c69327d517568e6308f1e1cd2fd2b2b3cd4bf | 0x476c61ad911d4459891cf2203d2266c07f88b2fc63ae4f119f5a8871d887a150 | 2024-01-03T12:58:15.000Z | 8276909117493757345792  | 0xe1b19d75ed8fc5813bfe027dc103ef5029fecaf959c2039a48837590bc17808e | 0x712228548b2ea07c430b7e2109ca0ca0cb134e6279119fdfbca88b0142683775 |
  | 0xe22d2bedb3eca35e6397e0c6d62857094aa26f52 | false   | 2         | 10293912487405914423296 | 23         | 42161       | 1704280472   | 8740163       | 23840265150556050995 | 0x0a6c69327d517568e6308f1e1cd2fd2b2b3cd4bf | 0x5d35cf39916bf536860db4bd5bd5606c2bd53d12305c29716617c1b7922bfb83 | 2024-01-03T08:14:33.000Z | 10242442924968883781632 | 0xae9eb5963235d0fefef06193c4c7e04d4e8a95fa3414775ce47cb7998f62658c | 0x64a75619299f884fe11220810e3e7dda752a5b6cf9b40cd9c503b75219dc862b |
</Accordion>

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

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

***