> ## 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_ethereum
> Tables in tt-contracts.hop_v1_ethereum
## Tables
### L1Bridge\_TransferSentToL2\_event
Cross-chain transfer initiation events from Hop Protocol's Ethereum L1 bridge, capturing token transfers sent to Layer 2 networks including Polygon, Gnosis Chain, and Base. Records include transfer amounts, destination chain IDs, recipient addresses, slippage parameters (amountOutMin), and optional relayer fees for analyzing bridge activity and cross-chain flow patterns.
| 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_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_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. |
| `in_relayer` | `STRING` | Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_relayerFee` | `STRING` | Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token's smallest denomination. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_relayer | in\_deadline | block\_number | in\_recipient | in\_relayerFee | block\_timestamp | in\_amountOutMin | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ---------- | ----------- | ------------------------------------------ | ------------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0x3666f603cc164936c1b87e207f36beba4ac5f18a | false | 26350869 | 352 | 100 | 0x0000000000000000000000000000000000000000 | 1693791978193 | 18009952 | 0x53108ac329d0559428df6b19b150b185936dbf19 | 0 | 2023-08-28T01:46:35.000Z | 26219114 | 0x7805c6db54105dd2859d32db918b8dc4b0877d92e192ea8aef1d99feb64594d4 |
| 0x3666f603cc164936c1b87e207f36beba4ac5f18a | false | 1601993471 | 384 | 100 | 0x0000000000000000000000000000000000000000 | 1693834132386 | 18013446 | 0x2e73b131d3308333d8b80929994f795b32022635 | 0 | 2023-08-28T13:29:11.000Z | 1593983503 | 0xfb11c694008ff32a2a71cb3cf99282ba4a600a2bffeae7b52f54525225b220c5 |
| 0x3666f603cc164936c1b87e207f36beba4ac5f18a | false | 1000000000 | 190 | 100 | 0x0000000000000000000000000000000000000000 | 1693840446854 | 18013964 | 0x163e427123125ca77d194634cf7dd39698225393 | 0 | 2023-08-28T15:14:23.000Z | 995000000 | 0x2f4ca12023f693368e895752b763fb6cd870ef0a8af639e971853e2935588eb0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_ethereum.L1Bridge_TransferSentToL2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L1BridgeDAI\_TransferSentToL2\_event
DAI token bridge transfer events from Ethereum L1 to Layer 2 networks via Hop Protocol, capturing cross-chain transfers to Polygon (chainId 137) and Arbitrum (chainId 42161) with transfer amounts, recipients, slippage protection minimums, and optional relayer configurations.
| 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_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_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. |
| `in_relayer` | `STRING` | Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_relayerFee` | `STRING` | Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token's smallest denomination. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_relayer | in\_deadline | block\_number | in\_recipient | in\_relayerFee | block\_timestamp | in\_amountOutMin | transaction\_hash |
| ------------------------------------------ | ------- | ---------------------- | ---------- | ----------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ |
| 0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1 | false | 96276864173750000000 | 258 | 137 | 0x0000000000000000000000000000000000000000 | 1681548558 | 17044528 | 0xeeb8825088f87a3efe1804a5f478410c0d09b162 | 0 | 2023-04-14T09:26:23.000Z | 91462808006884713198 | 0x582a3c4af1c52afd46d2160bac2f3f700855fb1a0c28b8d0a3c84ded295c6d9d |
| 0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1 | false | 9912500000000000000 | 419 | 137 | 0x0000000000000000000000000000000000000000 | 1681531189 | 17042939 | 0x8978849fc3b2e46b2940f9cbb8f67930db68e704 | 0 | 2023-04-14T04:00:11.000Z | 9428180952498706193 | 0xc56e1d4d7f1bf08bcf70265e2e87abdc5dec3920e8013c2ac6e577fbbc18ff64 |
| 0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1 | false | 1135389072057500000000 | 154 | 137 | 0x0000000000000000000000000000000000000000 | 1681550100 | 17044476 | 0x280f19702a5fe91d1e741d570d5b457cf9b40980 | 0 | 2023-04-14T09:15:23.000Z | 1078692336273951844567 | 0xf9f85b97da793f4673f1ecc528e6ec0eab6c431bd8177793a347e12c796736ba |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_ethereum.L1BridgeDAI_TransferSentToL2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L1BridgeETH\_TransferSentToL2\_event
ETH bridge transfer events from Hop Protocol's Ethereum mainnet (L1) contract sending assets to Layer 2 chains like Optimism (chain ID 10). Used for tracking cross-chain ETH transfers including transfer amounts, recipient addresses, relayer fees, and minimum output requirements.
| 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_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_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. |
| `in_relayer` | `STRING` | Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_relayerFee` | `STRING` | Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token's smallest denomination. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_relayer | in\_deadline | block\_number | in\_recipient | in\_relayerFee | block\_timestamp | in\_amountOutMin | transaction\_hash |
| ------------------------------------------ | ------- | ------------------- | ---------- | ----------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------ | ------------------------------------------------------------------ |
| 0xb8901acb165ed027e32754e0ffe830802919727f | false | 7000000000000000 | 281 | 10 | 0x0000000000000000000000000000000000000000 | 1660404831 | 15289542 | 0x64ebde2e66d3101e12973f407d97fdacbdb5c313 | 0 | 2022-08-06T15:33:53.000Z | 6959136133201953 | 0x8749ce5a076d2e989261b43b520bea6805c877b9ef0ee25fe929327fc95bf558 |
| 0xb8901acb165ed027e32754e0ffe830802919727f | false | 4800000000000000 | 55 | 10 | 0x0000000000000000000000000000000000000000 | 1660384491 | 15288033 | 0x7ffb4964631d98c796996022056f28c66d386daf | 0 | 2022-08-06T09:54:57.000Z | 4770580498017894 | 0x9f7dc26d0973f6d3507ac2d1fadf512105aab91cc83cc9f3f466220b6f5c1b23 |
| 0xb8901acb165ed027e32754e0ffe830802919727f | false | 1000000000000000000 | 183 | 10 | 0x0000000000000000000000000000000000000000 | 1660379719 | 15287693 | 0x77337dfe579a03a07a475870db443d65127f0769 | 0 | 2022-08-06T08:35:49.000Z | 994609396680085636 | 0x48c3837d004948ac82a4c76d76a2957c7b7fef75b9aa6bb8849b44404de22b0c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_ethereum.L1BridgeETH_TransferSentToL2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L1BridgeHOP\_TransferSentToL2\_event
Cross-chain bridge transfer events from Hop Protocol's Ethereum Layer 1 (L1) contract, recording token transfers initiated to Layer 2 networks (Optimism chain ID 10, Arbitrum chain ID 42161). Captures transfer amounts, recipient addresses, minimum output amounts, relayer fees, and deadline timestamps for analyzing bridge flow volumes and user migration patterns between Ethereum and L2s.
| 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_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_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. |
| `in_relayer` | `STRING` | Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_relayerFee` | `STRING` | Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token's smallest denomination. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_relayer | in\_deadline | block\_number | in\_recipient | in\_relayerFee | block\_timestamp | in\_amountOutMin | transaction\_hash |
| ------------------------------------------ | ------- | ----------------------- | ---------- | ----------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------------- | ------------------------------------------------------------------ |
| 0x914f986a44acb623a277d6bd17368171fcbe4273 | false | 32966967887802886312582 | 96 | 10 | 0x881296edcb252080bd476c464ceb521d08df7631 | 1695732349 | 18219147 | 0x0a6c69327d517568e6308f1e1cd2fd2b2b3cd4bf | 0 | 2023-09-26T09:45:59.000Z | 32802133048363870846976 | 0xa425bb03c1dfe3bf8dbcde851915647d906102afe8ef882a7ab1f4e64ea9bd4b |
| 0x914f986a44acb623a277d6bd17368171fcbe4273 | false | 30861373004320085347663 | 293 | 10 | 0x881296edcb252080bd476c464ceb521d08df7631 | 1691871603 | 17851116 | 0x1b56403289ce09ed7afe2e11b220cf373cb043a0 | 0 | 2023-08-05T20:20:11.000Z | 30707066139298484920924 | 0x098d93f182f9cd37f206732ebd957b91553a3be3aedae0c6b4ea1260f229131f |
| 0x914f986a44acb623a277d6bd17368171fcbe4273 | false | 46745224851920307089767 | 233 | 42161 | 0x881296edcb252080bd476c464ceb521d08df7631 | 1691858987 | 17850069 | 0x6baaf66d5e46bea788a28abe8ebbec54108181b1 | 0 | 2023-08-05T16:49:59.000Z | 46511498727660705554318 | 0x360f2b5f292235cdf55434edf5a0552bc96a264ac6d1d18f5da1ca770f595115 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_ethereum.L1BridgeHOP_TransferSentToL2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L1BridgeMAGIC\_TransferSentToL2\_event
TransferSentToL2 events from Hop Protocol's Ethereum L1 bridge contract for MAGIC token transfers to Layer 2 networks (Arbitrum One chain ID 42161, Arbitrum Nova chain ID 42170). Records bridge deposits with transfer amounts, recipients, slippage protection parameters, optional relayer fees, and destination chain identifiers for tracking cross-chain MAGIC token flows.
| 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_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_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. |
| `in_relayer` | `STRING` | Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_relayerFee` | `STRING` | Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token's smallest denomination. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_relayer | in\_deadline | block\_number | in\_recipient | in\_relayerFee | block\_timestamp | in\_amountOutMin | transaction\_hash |
| ------------------------------------------ | ------- | ---------------------- | ---------- | ----------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ |
| 0xf074540eb83c86211f305e145eb31743e228e57d | false | 1436175589887602468271 | 281 | 42161 | 0xa251e7519cbcf76e33d4672d2218e3cbcceb6d60 | 1692433367 | 17897567 | 0xb8d622a8cccff1f4c8955a23ed0e8434bf334675 | 0 | 2023-08-12T08:22:59.000Z | 1430344768923437360967 | 0x3ab0caf70c94102ec7481486bc1e85af3be7a91d4b718bcc311d075fea1278fe |
| 0xf074540eb83c86211f305e145eb31743e228e57d | false | 100000000000000000 | 58 | 42170 | 0x0000000000000000000000000000000000000000 | 0 | 17480733 | 0x924ac9910c09a0215b06458653b30471a152022f | 0 | 2023-06-14T21:04:47.000Z | 0 | 0x3f69273d8d5d4ec46d02c8a54b08dba8c796e28a317c62e6f545eeba143adcae |
| 0xf074540eb83c86211f305e145eb31743e228e57d | false | 1369778742085666232035 | 179 | 42161 | 0xa251e7519cbcf76e33d4672d2218e3cbcceb6d60 | 1696057781 | 18196939 | 0x7737d3742ddc67f1443b40cbe6d401d649d3906a | 0 | 2023-09-23T07:09:47.000Z | 1365146867281860527971 | 0x3bada052f5ae5e7670fd4284d036d79aa3d2485dea389da618cb689278be2a77 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_ethereum.L1BridgeMAGIC_TransferSentToL2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L1BridgeMATIC\_TransferSentToL2\_event
MATIC token transfers initiated from Ethereum (Layer 1) to Polygon (chain ID 137) via the Hop Protocol bridge. Captures transfer amounts, recipient addresses, slippage parameters (amountOutMin), and optional relayer fees for cross-chain bridging analytics.
| 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_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_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. |
| `in_relayer` | `STRING` | Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_relayerFee` | `STRING` | Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token's smallest denomination. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_relayer | in\_deadline | block\_number | in\_recipient | in\_relayerFee | block\_timestamp | in\_amountOutMin | transaction\_hash |
| ------------------------------------------ | ------- | --------------------- | ---------- | ----------- | ------------------------------------------ | ------------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ |
| 0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2 | false | 530700000000000000000 | 211 | 137 | 0x0000000000000000000000000000000000000000 | 1631300579 | 13154534 | 0x533a8499dcf5ad415b8606b6c34cbac7640e03fc | 0 | 2021-09-03T19:04:29.000Z | 528270942968009511500 | 0x69eca08e2c6850e7498132bd5c1937d84c1964644487ed552d6fe4fa58751915 |
| 0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2 | false | 145396527990000000000 | 218 | 137 | 0x0000000000000000000000000000000000000000 | 1631246278 | 13150465 | 0xb9e95651a78907fd5bb8bc37fc5138669314ed93 | 0 | 2021-09-03T03:58:36.000Z | 144701683528322744523 | 0xcf6e0a035e29cdf42c09fccb4634890a59e4125f1ea9ec27497514d26dac8fea |
| 0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2 | false | 59888480662308574000 | 188 | 137 | 0x0000000000000000000000000000000000000000 | 1683920738070 | 17246030 | 0x837e44a6552828e97011f2f9dd29ce435150764c | 0 | 2023-05-12T19:25:59.000Z | 59284190506016637976 | 0xb5b07cb28c67e0884bafdee7563b48f99be96ee625d05455ad4bef90b39ccda3 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_ethereum.L1BridgeMATIC_TransferSentToL2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L1BridgeRETH\_TransferSentToL2\_event
Hop Protocol V1 rETH (Rocket Pool ETH) bridge transfer events from Ethereum L1 to Layer 2 destinations including Optimism and Arbitrum. Contains transfer amounts, recipient addresses, relayer fees, and minimum output amounts for analyzing cross-chain rETH bridging activity.
| 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_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_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. |
| `in_relayer` | `STRING` | Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_relayerFee` | `STRING` | Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token's smallest denomination. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_relayer | in\_deadline | block\_number | in\_recipient | in\_relayerFee | block\_timestamp | in\_amountOutMin | transaction\_hash |
| ------------------------------------------ | ------- | ------------------ | ---------- | ----------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------ | ------------------------------------------------------------------ |
| 0x87269b23e73305117d0404557badc459ced0dbec | false | 460212677362178823 | 410 | 10 | 0xd38b96277df34f1f7ac5965f86016e7d02c4ca94 | 1692102251 | 17913171 | 0xae1c38847fb90a13a2a1d7e5552ccd80c62c6508 | 0 | 2023-08-14T12:45:23.000Z | 455772966097918017 | 0x84bd9a099b3041a7abd2e44812dd7e9d3d76a25f38d934135d1558134be905c9 |
| 0x87269b23e73305117d0404557badc459ced0dbec | false | 762140197888193410 | 191 | 10 | 0xd38b96277df34f1f7ac5965f86016e7d02c4ca94 | 1692098080 | 17912722 | 0x1941ec212c143b19fa708714eea6d9e05fa4a2a5 | 0 | 2023-08-14T11:15:23.000Z | 758598381832492169 | 0xefc706e5f521cd5da9674a6b28b402360a53bd4b921a4c62fdfd8e6c90c6789e |
| 0x87269b23e73305117d0404557badc459ced0dbec | false | 700000000000000000 | 155 | 42161 | 0xd38b96277df34f1f7ac5965f86016e7d02c4ca94 | 1692098010 | 17912719 | 0x1941ec212c143b19fa708714eea6d9e05fa4a2a5 | 0 | 2023-08-14T11:14:47.000Z | 696318102526676144 | 0x612b5132d935de1055195775abd7a6b077d3d9bf46eebdb7b04a705ff5f3c63d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_ethereum.L1BridgeRETH_TransferSentToL2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L1BridgeSNX\_TransferSentToL2\_event
SNX token bridge transfers from Ethereum mainnet to Optimism (chain ID 10) via Hop Protocol, capturing amount, recipient, relayer fees, and minimum output parameters for analyzing cross-chain Synthetix token migration activity.
| 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_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_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. |
| `in_relayer` | `STRING` | Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_relayerFee` | `STRING` | Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token's smallest denomination. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_relayer | in\_deadline | block\_number | in\_recipient | in\_relayerFee | block\_timestamp | in\_amountOutMin | transaction\_hash |
| ------------------------------------------ | ------- | ----------------------- | ---------- | ----------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------------- | ------------------------------------------------------------------ |
| 0x893246facf345c99e4235e5a7bbee7404c988b96 | false | 5538365411987161454761 | 313 | 10 | 0x547d28cdd6a69e3366d6ae3ec39543f09bd09417 | 1671250364 | 16151839 | 0x72159d5ec288cba0aaf7f5b67b8325f440070fff | 0 | 2022-12-10T04:13:11.000Z | 5497997919080846178247 | 0xa906c7ff0ba2690993ff3189ccfaf7ec36bd8ce2c3e24ea9f594576ecdd9b4f9 |
| 0x893246facf345c99e4235e5a7bbee7404c988b96 | false | 131095794665136772138 | 50 | 10 | 0x547d28cdd6a69e3366d6ae3ec39543f09bd09417 | 1671287020 | 16154880 | 0xf1696ec04262085c24a9c8b86fc7d9bbd14b9dc3 | 0 | 2022-12-10T14:23:59.000Z | 130113541521231070674 | 0x70d68cbd2232dade1829370e8460c245d66b1842606c21cd33cc8f00eda65fb5 |
| 0x893246facf345c99e4235e5a7bbee7404c988b96 | false | 25000000000000000000000 | 358 | 10 | 0x547d28cdd6a69e3366d6ae3ec39543f09bd09417 | 1671244806 | 16151380 | 0x0b4c8694d1832937328f541854317969b86601fc | 0 | 2022-12-10T02:40:35.000Z | 24829323276156262751171 | 0x49c3cde52e29e3c8b02bd747a43f71b598ceb059252245595efc018f6014286b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_ethereum.L1BridgeSNX_TransferSentToL2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L1BridgeSUSD\_TransferSentToL2\_event
sUSD token bridge transfer events from Ethereum Layer 1 to Optimism (chain ID 10) via Hop Protocol. Tracks bridge amount, recipient address, slippage parameters, and optional relayer details for analyzing cross-chain sUSD flows.
| 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_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_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. |
| `in_relayer` | `STRING` | Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_relayerFee` | `STRING` | Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token's smallest denomination. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_relayer | in\_deadline | block\_number | in\_recipient | in\_relayerFee | block\_timestamp | in\_amountOutMin | transaction\_hash |
| ------------------------------------------ | ------- | ---------------------- | ---------- | ----------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ |
| 0x36443fc70e073fe9d50425f82a3ee19fef697d62 | false | 2036670399640929105727 | 446 | 10 | 0x547d28cdd6a69e3366d6ae3ec39543f09bd09417 | 1683718340 | 17179919 | 0xc789026a0f0b15c532c77405491331997f2b2bbc | 0 | 2023-05-03T11:32:23.000Z | 2030359921960304828885 | 0x1fad710548c4dcf2517ed59eb789353ad83d997211a49b75489abfa0278bc09c |
| 0x36443fc70e073fe9d50425f82a3ee19fef697d62 | false | 8036504913093173114757 | 168 | 10 | 0x547d28cdd6a69e3366d6ae3ec39543f09bd09417 | 1688794735 | 17597188 | 0xa4cc5fd6f8d58a1a8f89f654cc5797463b8c6c59 | 0 | 2023-07-01T05:39:11.000Z | 7973999474665358529896 | 0x1177cb12dd7bc78e20e4b4f975411bdf2337e885d42d096a7e990df708941934 |
| 0x36443fc70e073fe9d50425f82a3ee19fef697d62 | false | 188605575452129094646 | 300 | 10 | 0x547d28cdd6a69e3366d6ae3ec39543f09bd09417 | 1694799029 | 18093197 | 0xaa30e3f0da0363397c0bcd62636c9ad2c4690e18 | 0 | 2023-09-08T17:30:35.000Z | 187696350227315520903 | 0x1ba0b6aa90d575f735e5bed97a1e4acc436bfbd810ab43ca94a9c9cbf1090bf2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_ethereum.L1BridgeSUSD_TransferSentToL2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L1BridgeUSDT\_TransferSentToL2\_event
USDT bridge transfer events from Hop Protocol's Ethereum L1 bridge contract to Layer 2 networks (Optimism, Polygon). Records cross-chain USDT transfers including amounts, destination chains, recipients, slippage parameters, and optional relayer details for analyzing bridge flow patterns.
| 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_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_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. |
| `in_relayer` | `STRING` | Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_relayerFee` | `STRING` | Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token's smallest denomination. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_relayer | in\_deadline | block\_number | in\_recipient | in\_relayerFee | block\_timestamp | in\_amountOutMin | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ---------- | ----------- | ------------------------------------------ | ------------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0x3e4a3a4796d16c0cd582c382691998f7c06420b6 | false | 140037110 | 378 | 10 | 0x0000000000000000000000000000000000000000 | 1694126557073 | 18037605 | 0x7dd1ff5a759706e8ff5ae0a64986653f6b157dad | 0 | 2023-08-31T22:42:59.000Z | 139215164 | 0x1083e9f4ae9e2d05319d0ca7a39abf3821e0771fd7d0acd17162d4015bdc565e |
| 0x3e4a3a4796d16c0cd582c382691998f7c06420b6 | false | 1000000 | 222 | 137 | 0x0000000000000000000000000000000000000000 | 1694130559757 | 18037935 | 0x2ea5c5b4ce93ab06e199449eee48e0561834c327 | 0 | 2023-08-31T23:49:35.000Z | 995000 | 0x8fc95c5d7d4217726542fc66f308e2213fb2a7f7633c94e2a6543217539fd1ed |
| 0x3e4a3a4796d16c0cd582c382691998f7c06420b6 | false | 1000085007 | 220 | 137 | 0x0000000000000000000000000000000000000000 | 1694081033463 | 18033840 | 0x6f23d9c2417f66de8ba085265d159142cb060af2 | 0 | 2023-08-31T10:04:11.000Z | 995957078 | 0x94928fe9695763cf0e7198b8c539eb800925f85b9d2bccdff63cb699f3553c76 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_ethereum.L1BridgeUSDT_TransferSentToL2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L1BridgeWBTC\_TransferSentToL2\_event
Ethereum mainnet (L1) events recording WBTC transfers initiated through Hop Protocol bridge to Layer 2 destinations including Arbitrum, Optimism, Polygon, and Gnosis Chain. Contains transfer amounts, recipient addresses, destination chain identifiers, relayer fee parameters, and deadline timestamps for analyzing cross-chain WBTC flow patterns.
| 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_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_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. |
| `in_relayer` | `STRING` | Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_relayerFee` | `STRING` | Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token's smallest denomination. |
| address | removed | in\_amount | log\_index | in\_chainId | in\_relayer | in\_deadline | block\_number | in\_recipient | in\_relayerFee | block\_timestamp | in\_amountOutMin | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ---------- | ----------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0xb98454270065a31d71bf635f6f7ee6a518dfb849 | false | 1000 | 466 | 42161 | 0x0000000000000000000000000000000000000000 | 9999999999 | 14578752 | 0xfefec7d3eb14a004029d278393e6ab8b46fb4fca | 0 | 2022-04-13T18:30:21.000Z | 1 | 0x0b6729270e5fe2829f02a61bc8a1a26398819eecbef79887de9d47a193b5e9ab |
| 0xb98454270065a31d71bf635f6f7ee6a518dfb849 | false | 100 | 565 | 137 | 0x0000000000000000000000000000000000000000 | 0 | 14077787 | 0xfefec7d3eb14a004029d278393e6ab8b46fb4fca | 0 | 2022-01-25T23:34:45.000Z | 0 | 0x3fa15164b46900c26083a82a53d3a61743f90563b5de8ea6336c853a2caaed8b |
| 0xb98454270065a31d71bf635f6f7ee6a518dfb849 | false | 1000 | 68 | 10 | 0x0000000000000000000000000000000000000000 | 0 | 13477589 | 0x924ac9910c09a0215b06458653b30471a152022f | 0 | 2021-10-24T02:42:01.000Z | 0 | 0xa024cb78a701f86183aba4cd8e4163a2bd32ffc5d432195d03b334aeda06382d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_ethereum.L1BridgeWBTC_TransferSentToL2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***