> ## 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_arbitrum
> Tables in tt-contracts.hop_v1_arbitrum
## 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.
| 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. |
| address | removed | in\_buyer | in\_soldId | log\_index | in\_boughtId | block\_number | in\_tokensSold | block\_timestamp | in\_tokensBought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0x10541b07d8ad2647dc6cd67abd4c03575dade261 | false | 0x6dd3c3a01c0c28fe2a19fcb9c16609c048a6bd94 | 1 | 3 | 0 | 17465492 | 509720689 | 2022-07-12T07:29:37.000Z | 509466785 | 0x6c56ef4ba3af824b205a3422fb44b47a1aa3a5601227308f883cf17df920a183 |
| 0x10541b07d8ad2647dc6cd67abd4c03575dade261 | false | 0xad7d89528e399d232b58636d3bc64432007c7938 | 1 | 3 | 0 | 17465968 | 509780490 | 2022-07-12T07:40:13.000Z | 509525785 | 0x3ef1cd23357d76308ca857401b21503b6876b322f22eadc22e9f7f3e3ae829de |
| 0x10541b07d8ad2647dc6cd67abd4c03575dade261 | false | 0x31b48d410003ab480bd66398f6e0712c55e11587 | 1 | 3 | 0 | 17484624 | 5456535 | 2022-07-12T14:12:20.000Z | 5454978 | 0x91205c05bf2b6b130df8a95269e741c92c24ed019a48acb0824651e381b679c8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2Amm_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2AmmDAI\_TokenSwap\_event
Token swap events from Hop Protocol's DAI Automated Market Maker (AMM) pool on Arbitrum L2. Captures trades between pool token IDs with amounts sold and bought, used for analyzing liquidity pool trading activity and price impact.
| 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. |
| address | removed | in\_buyer | in\_soldId | log\_index | in\_boughtId | block\_number | in\_tokensSold | block\_timestamp | in\_tokensBought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | --------------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ |
| 0xa5a33ab9063395a90ccbea2d86a62eccf27b5742 | false | 0xe7f40bf16ab09f4a6906ac2caa4094ad2da48cc2 | 0 | 175 | 1 | 84590924 | 40001634665072433728 | 2023-04-26T19:47:39.000Z | 39986959719085903295 | 0x737b6b270cfef3d80fbebcbadcf0c42ade9634f543ed3885364b943b43433a61 |
| 0xa5a33ab9063395a90ccbea2d86a62eccf27b5742 | false | 0xe7f40bf16ab09f4a6906ac2caa4094ad2da48cc2 | 0 | 8 | 1 | 84518063 | 195879496003750000000 | 2023-04-26T14:44:08.000Z | 195811841198043317858 | 0xc67bfc1e1e76e81d9347e148d53ab6889cecb341adc03ff72dc35cccbe90a027 |
| 0xa5a33ab9063395a90ccbea2d86a62eccf27b5742 | false | 0xe7f40bf16ab09f4a6906ac2caa4094ad2da48cc2 | 0 | 5 | 1 | 84458937 | 46521343700442941148 | 2023-04-26T10:38:56.000Z | 46504832429514683045 | 0x3446f3e3e5097d192969097614421a9dc5af511a95b57a402de281a2216de193 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2AmmDAI_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| address | removed | in\_buyer | in\_soldId | log\_index | in\_boughtId | block\_number | in\_tokensSold | block\_timestamp | in\_tokensBought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | ------------------- | ------------------------ | ------------------- | ------------------------------------------------------------------ |
| 0x652d27c0f72771ce5c76fd400edd61b406ac6d97 | false | 0xba9e95050bfbf8c9aedb9ff583958e376f101e4b | 0 | 3 | 1 | 141448645 | 600000000000000 | 2023-10-17T16:20:01.000Z | 599499524448910 | 0xfbfd1238b79bbe7939edfd9507b1acbfce88552afa5242d97fe370f56a5bc45f |
| 0x652d27c0f72771ce5c76fd400edd61b406ac6d97 | false | 0x281a12a299026557ece523f2bf6dbcaea9cdc4ac | 0 | 3 | 1 | 141473174 | 6250000000000000000 | 2023-10-17T18:18:32.000Z | 6243466736491417904 | 0x787b169e147fee8e3676e85f1d13faddd44ed90abf9a95a66197c97b6106d2f7 |
| 0x652d27c0f72771ce5c76fd400edd61b406ac6d97 | false | 0xba9e95050bfbf8c9aedb9ff583958e376f101e4b | 0 | 4 | 1 | 141448484 | 600000000000000 | 2023-10-17T16:19:15.000Z | 599499539868387 | 0x010aeb0edad27a6302ee3a29474976bef13b492014508e14455eac3a7feb2e45 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2AmmETH_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2AmmMAGIC\_TokenSwap\_event
Token swap events from Hop Protocol's MAGIC token automated market maker (AMM) pool on Arbitrum. Records swaps between pool tokens (soldId/boughtId) with amounts, buyer addresses, and execution prices for analyzing liquidity provision and trading 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_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. |
| address | removed | in\_buyer | in\_soldId | log\_index | in\_boughtId | block\_number | in\_tokensSold | block\_timestamp | in\_tokensBought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | ---------------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ |
| 0xffe42d3ba79ee5ee74a999cad0c60ef1153f0b82 | false | 0xa0de2f67bafcc8f82895a9d18e909944e2f7d73b | 0 | 3 | 1 | 117831642 | 66000000000000000000 | 2023-08-03T19:05:22.000Z | 65785680639726008296 | 0xdab8af675b77a513d55e6fc73a55dc485fc6315fa1669556e1aa1ae337bfc452 |
| 0xffe42d3ba79ee5ee74a999cad0c60ef1153f0b82 | false | 0x50a3a623d00fd8b8a4f3cbc5aa53d0bc6fa912dd | 0 | 6 | 1 | 117619770 | 81813759451866123763 | 2023-08-03T04:08:41.000Z | 81619354555849841742 | 0x67a4096ae98b522708d8f5dea01033d06daa6936746d09e00669b6ecfb6ffc11 |
| 0xffe42d3ba79ee5ee74a999cad0c60ef1153f0b82 | false | 0x50a3a623d00fd8b8a4f3cbc5aa53d0bc6fa912dd | 0 | 6 | 1 | 117819010 | 1000000000000000000000 | 2023-08-03T18:11:07.000Z | 996613038632243076747 | 0x4a60a0bd47e5a7ba8f1421abd6beec8523422daf8e84cb4923b401a40958c5c6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2AmmMAGIC_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2AmmRETH\_TokenSwap\_event
Token swap events from Hop Protocol's rETH (Rocket Pool ETH) automated market maker pool on Arbitrum. Records swaps between pool tokens (soldId/boughtId 0 and 1) with amounts, buyer addresses, and exchange rates for analyzing liquidity provider performance and trading volumes.
| 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. |
| address | removed | in\_buyer | in\_soldId | log\_index | in\_boughtId | block\_number | in\_tokensSold | block\_timestamp | in\_tokensBought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | ------------------- | ------------------------ | ------------------- | ------------------------------------------------------------------ |
| 0x0ded0d521ac7b0d312871d18ea4fde79f03ee7ca | false | 0x16e08c02e4b78b0a5b3a917ff5feaedd349a5a95 | 0 | 8 | 1 | 262394898 | 9956288183905813 | 2024-10-10T15:39:53.000Z | 9958269863979290 | 0x6fb4c7177d22afddf853fa89db9b99d7b2a339dd12f4ba9cea220ffb5ad2373c |
| 0x0ded0d521ac7b0d312871d18ea4fde79f03ee7ca | false | 0x16e08c02e4b78b0a5b3a917ff5feaedd349a5a95 | 0 | 6 | 1 | 124011429 | 400000000000000000 | 2023-08-23T00:11:09.000Z | 399781750979617324 | 0xc20f730376742097fec5a7db6c31ec70615d79c6a3539569dc606e9a7bee393c |
| 0x0ded0d521ac7b0d312871d18ea4fde79f03ee7ca | false | 0x16e08c02e4b78b0a5b3a917ff5feaedd349a5a95 | 0 | 7 | 1 | 124024610 | 9185146587565487079 | 2023-08-23T01:16:37.000Z | 9177813658442400290 | 0x9886ca687507601041b16676a637259dcbd9a077c1a25d1efb6657649f55eca4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2AmmRETH_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2AmmUSDT\_TokenSwap\_event
Token swap events from Hop Protocol's USDT Automated Market Maker (AMM) on Arbitrum Layer 2. Captures trade execution details including buyer addresses, token amounts exchanged, and pool token IDs for analyzing liquidity pool trading activity and price slippage.
| 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. |
| address | removed | in\_buyer | in\_soldId | log\_index | in\_boughtId | block\_number | in\_tokensSold | block\_timestamp | in\_tokensBought | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0x18f7402b673ba6fb5ea4b95768aabb8aad7ef18a | false | 0x549bcac7403dac509158e59dd6d247420b904c09 | 1 | 39 | 0 | 282885531 | 1098669 | 2024-12-09T06:23:47.000Z | 1094965 | 0xf387276d867d112b5becae295d60654538494c0e0d38943e0b8e6fbd169d5f37 |
| 0x18f7402b673ba6fb5ea4b95768aabb8aad7ef18a | false | 0xcb0a4177e0a60247c0ad18be87f8edff6dd30283 | 1 | 9 | 0 | 282966792 | 5000000000 | 2024-12-09T12:03:41.000Z | 4982940877 | 0xeffdd30599829a7c070a6b81929fc28cd9d947301a738cfb106765288e114c5e |
| 0x18f7402b673ba6fb5ea4b95768aabb8aad7ef18a | false | 0xcb0a4177e0a60247c0ad18be87f8edff6dd30283 | 1 | 17 | 0 | 282922705 | 15767969 | 2024-12-09T08:59:13.000Z | 15718510 | 0x00940c2d591b0ca429292219d356635da3e0318cb6ec1a40cf38653f2ae5897d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2AmmUSDT_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2AmmWBTC\_TokenSwap\_event
*No description available.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2AmmWBTC_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| 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 |
| ------------------------------------------ | ------- | --------- | ---------- | ---------- | ----------- | ------------ | ------------- | ------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x0e0e3d2c5c292161999474247956ef542cabf8dd | false | 57 | 499492583 | 8 | 1 | 0 | 77110420 | 9990123 | 0x4275e0a2d6974b54a2d2f1c7cbf7291c2777527b | 0x4fb270d937f7e11ab4345bc45b31b7cbfb2984fcaa7bfc024c6083675af691b2 | 2023-04-04T23:49:30.000Z | 0 | 0x179ecca96a42c70a8e6f5aebe68a205020eb5ab61673d0ae9048870cf6e8d295 | 0x0f3231497da8945899382d1fddb42afa850a13f9709326b747251a70787d8fc3 |
| 0x0e0e3d2c5c292161999474247956ef542cabf8dd | false | 24 | 1019164604 | 8 | 1 | 0 | 76997434 | 12494123 | 0x6f70f8eab808f5ef9eb4794119f542adf514a476 | 0x657597d609e6301482d65c4631fac43d26e8db57348f1eeac7b8308f11b86cfc | 2023-04-04T15:47:43.000Z | 0 | 0x0a01fee60f60d1de0b52d4b4c3f20341868de8c9e1a2c3dea2d529e89da085b1 | 0xa41e8d8373d06b2429bbb3d7772944103d635290e51bf197101276762b95177f |
| 0x0e0e3d2c5c292161999474247956ef542cabf8dd | false | 31 | 2995789585 | 8 | 1 | 0 | 77031023 | 14583123 | 0xe4aaa62deca5b96bc3f056ffb6c40d209c6015ff | 0x60d1c5bdde912c6c4624b01249ce1e5ecdfb12a6e424324c0c0336b6d5908b35 | 2023-04-04T18:07:40.000Z | 0 | 0xe713f2211605616e76e11347b6997a0f3a36a0d2696f2372f07144ff0bfe2da9 | 0xaa18126e5b4cb8511d564edab7aa0e27d3f3ca556db86d3208a1e3f8f3b1fcd4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2Bridge_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeDAI\_TransferSent\_event
DAI token transfer events sent from Hop Protocol's Arbitrum L2 bridge to destination chains (Ethereum mainnet, Optimism, Gnosis). Records cross-chain bridge transfers with amounts, bonder fees, recipients, and unique transfer identifiers for tracking DAI movements across Layer 2 networks.
| 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. |
| 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 |
| ------------------------------------------ | ------- | --------- | ---------------------- | ---------- | ----------- | ------------ | ------------- | -------------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x7ac115536fe3a185100b2c4de4cb328bf3a58ba6 | false | 18 | 4503061113407992364143 | 14 | 1 | 0 | 34624104 | 14786393161961152123 | 0x56b421c0aaca80be6447b7c330222c5a1ce27d4f | 0xa46fd6d577d838956cde9cc6d7259a5df63f28b55c673b303c244820bc5c2b4f | 2022-11-02T05:12:33.000Z | 0 | 0x9ee4a3af823ddce5659a5fa4a96fc6fc40d8da35f66b9eb0779f1e02be98771f | 0x5cb39e2de3b90c29d037f801f8ed9c976a4586a4d5a33705c14eeab91f51531b |
| 0x7ac115536fe3a185100b2c4de4cb328bf3a58ba6 | false | 21 | 7007255559042538258861 | 6 | 1 | 0 | 34734989 | 21696642380983192123 | 0x12e838f846ffdade34b2e006f84117a370d71687 | 0x3ef1c51e820a6c0370edb2b7c25c61e7fb97583a105b882a37d9f3a9cdc926c9 | 2022-11-02T15:44:24.000Z | 0 | 0x7c0b25671af00e31d3595cfebcadb7be9bc9d755a6db2d57324dfdc0b92e7800 | 0x4f45701eef300a4693d0b1db2bfdad686453f9f624f876d38a4727f27d39938f |
| 0x7ac115536fe3a185100b2c4de4cb328bf3a58ba6 | false | 19 | 6005448869518412952 | 22 | 1 | 0 | 34678946 | 2699230669737739970 | 0x83db022d29fe7ce7fa977e5721cd4c6a315b6d8d | 0x1c494c278e641f6b2ce3cb7456c8322077fbac469930f1c22ec9b68462540983 | 2022-11-02T10:38:12.000Z | 0 | 0xa0845f8d660bb8b5baf00d51b07d618e9821f96c0956cf2f103919599e4dc7d3 | 0xabab51bb9dbd754064ef07dcb4edb7e7557432015e4bd7a7fff4f0d7d3cf3522 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2BridgeDAI_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| 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 |
| ------------------------------------------ | ------- | --------- | ------------------ | ---------- | ----------- | ------------ | ------------- | ---------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x3749c4f034022c39ecaffaba182555d4508caccc | false | 118 | 119884390066621325 | 7 | 1 | 0 | 12452979 | 1823809199284123 | 0xa01d644810a7149df86dd9265c7c0f94fb75c718 | 0x2cb3e0aa42bd0ba98eebef89bad1c0b6c7ba868a9bfd1ccd5c75fea2ee4b7cc3 | 2022-05-19T05:53:10.000Z | 0 | 0xbfb3e10ff12f7371409e633db3703524810b8d7077a0f66ee2e779c0b20f2bc7 | 0x025a2484043c57d16a26fefa4c97609516a8eb4b6da4935081f56fc2c3307346 |
| 0x3749c4f034022c39ecaffaba182555d4508caccc | false | 223 | 99912314006304045 | 7 | 1 | 0 | 12489586 | 4731057653705123 | 0xf503c4cac2b5a27f68eee197efb94e6fdeaa48d1 | 0x24def3503adbb8bedb60347442498f5c378b1e7133b9219c1056cc11bace0af0 | 2022-05-19T14:30:12.000Z | 0 | 0x1a6c3e07577540ed01b2129c2c1aea1d6dc456d30684b346b685adc9efb8d86a | 0x916900828d2ef65a214d16f0d1e73f1fe6489e9723400d368cfb2fe634d406d5 |
| 0x3749c4f034022c39ecaffaba182555d4508caccc | false | 261 | 999387959065837464 | 7 | 1 | 0 | 12512064 | 5196065756337123 | 0xececafb3fea380ed39264a7ac86a3af846375aff | 0xa68c3805a77d7ac5792edba61f53f0c61c0b2d3e50645152429fdf790577166a | 2022-05-19T21:34:42.000Z | 0 | 0x9749bd17d770a5551326e9d8c44731414cf13192a0a48af4d810ee56f291f299 | 0x0d9bb7456942f07f835c3f207ee755aa4ed81b1ba8df8e24aba329b4602282b6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2BridgeETH_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeHOP\_TransferSent\_event
TransferSent events from Hop Protocol bridge on Arbitrum, recording cross-chain token transfers with destination chain ID, transfer amounts, bonder fees, and recipient addresses. Used for tracking bridge volume, fee analysis, and cross-chain transfer flow between Arbitrum and other chains (Ethereum mainnet, Optimism, Base).
| 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. |
| 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 |
| ------------------------------------------ | ------- | --------- | ----------------------- | ---------- | ----------- | ------------ | ------------- | -------------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ----------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x25fb92e505f752f730cad0bd4fa17ece4a384266 | false | 0 | 10523921118246795462259 | 18 | 8453 | 1729072041 | 261966690 | 21207045013982241123 | 0x34327028c727613872cd80122b9a489a4b9c0bfa | 0x54b1bf2a7118c20645e6eb804478e464321d36c8097e101cbc625d2a82c8ce73 | 2024-10-09T09:47:30.000Z | 10450094467641579243824 | 0x1c4128ccfb9216e50d4471b60406813eb2e6cc3e621a211fadedfeb40564e3ad | 0xeda64d83f33702a3ab0f9a0fd34d80a4b33eb5b79703d1c86dece59abf1e9e8a |
| 0x25fb92e505f752f730cad0bd4fa17ece4a384266 | false | 7 | 18826142120305078326867 | 1 | 10 | 1729098881 | 262073643 | 17780593471640220123 | 0xb9096d6db733d5971ebd4b901398e6e33bd7cc70 | 0x6cd28c263e1050ec8894bf3f54a32d58e32287a87b7394357b885765c4813133 | 2024-10-09T17:14:53.000Z | 18714230816231912715109 | 0x6894534eb3a4179b931a24498cccbdc0f06aaa7547fb570dd515f2db719632b3 | 0xa06dfaaf0b1dad5b8b2895ab80a2c0bf59ca10e91f17d79f6fb121ad2f48d7be |
| 0x25fb92e505f752f730cad0bd4fa17ece4a384266 | false | 36 | 1710844515915420356530 | 37 | 10 | 1682958719 | 81455428 | 3756733410498980252 | 0x4cb6f0ef0eeb503f8065af1a6e6d5dd46197d3d9 | 0x4abd7d9f003d755d13e8fab7f261c59ee069468f71c0ce1c323cb441ad9ed140 | 2023-04-17T16:31:59.000Z | 0 | 0x61642ce43de78ef572d06eccf8956098ab45a5d63d680110be745381e5c59e09 | 0x5db353632fa2855d964be189b9c01240d22fd9424a223bf915a017a2fcdd6c5f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2BridgeHOP_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeMAGIC\_TransferSent\_event
TransferSent events from Hop Protocol's MAGIC token bridge on Arbitrum Layer 2, recording cross-chain transfers with bonder fees, transfer amounts, destination chain identifiers, and recipient addresses. Used for tracking MAGIC token bridge flows between Arbitrum and other chains (Ethereum mainnet, Arbitrum Nova) in the Hop liquidity network.
| 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. |
| 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 |
| ------------------------------------------ | ------- | --------- | ---------------------- | ---------- | ----------- | ------------ | ------------- | ------------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0xea5abf2c909169823d939de377ef2bf897a6ce98 | false | 4 | 939555423141328096333 | 18 | 1 | 0 | 228590910 | 6771175638101079126 | 0x0a6c69327d517568e6308f1e1cd2fd2b2b3cd4bf | 0x59386c3584706c592ee4e1394bbfed10742833c078431fb7254833f0b8808b52 | 2024-07-04T06:55:24.000Z | 0 | 0xf2a83a3cb6d49d474adf7a37a67677378c3c43c6b0ceb71676e503ea6b451ae5 | 0x47ed29793d778fcd63144443966cc213bbba4d4ff41cb88c76868d94899cd359 |
| 0xea5abf2c909169823d939de377ef2bf897a6ce98 | false | 41 | 1004336303738989177085 | 8 | 1 | 0 | 138558885 | 4764427862354884123 | 0x7737d3742ddc67f1443b40cbe6d401d649d3906a | 0xde0e5ee8e69739480c86dc04e04fd7478cd80ff198d687f84f792ecc657139f9 | 2023-10-07T23:26:34.000Z | 0 | 0xf5eb958eed17d2e76407520d554599aa4b9c07c30137905cefebb829f0b1464a | 0x44cf47b6bbacedf62c6d04a55295934b2ab6cd9d269f2b04ed137cd6b6926588 |
| 0xea5abf2c909169823d939de377ef2bf897a6ce98 | false | 3 | 1000277861977195401 | 9 | 42170 | 1713231673 | 199063354 | 345725744652730123 | 0x9c2694293154f17b37b0715f2e4068298cd2eb2c | 0x1b2f6281f8c52485dd16052c0fb503d7a91e2971dc48389e61e8298db5ca0246 | 2024-04-09T01:41:18.000Z | 650942501259542376 | 0xf1545dd8ec02f13cc133e7518007b625ec9131ff404e799580487d8e44e2b564 | 0xf7b8a0a245dcc08be572c7f0968a3207c481b3369a11b681dee521f513af59ea |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2BridgeMAGIC_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeRETH\_TransferSent\_event
Outbound bridge transfer events for rETH (Rocket Pool ETH) from Arbitrum to other chains via Hop Protocol. Used to track cross-chain transfers including amounts, bonder fees, destination chain IDs, and recipient addresses for analyzing rETH bridge activity and liquidity 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_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. |
| 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 |
| ------------------------------------------ | ------- | --------- | ------------------ | ---------- | ----------- | ------------ | ------------- | ---------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0xc315239cfb05f1e130e7e28e603cea4c014c57f0 | false | 7 | 23218025716570137 | 8 | 1 | 0 | 142067561 | 1565528897916123 | 0xa034ef98a17e753a31cf864c1f8a09c8563835ea | 0xd1fa18e87453e811913b569a50e248a33614ba291d3026bec0cb9cf12615edef | 2023-10-19T17:28:50.000Z | 0 | 0x80cf584a81a63016c6ef96c671879eaca33918536f849f7763b3c680a3f24d00 | 0xce1aea08f5e530fd8cecd7b1fd01a6316018f819489317cb994680b80fb0f015 |
| 0xc315239cfb05f1e130e7e28e603cea4c014c57f0 | false | 8 | 928926400731391139 | 8 | 1 | 0 | 101263714 | 3912024360765123 | 0x21c4943a6060eb4c33f8b270562b535c7261015e | 0x08867664cda975086a3d3e769a9e073d5604099f980a34329b74cbf8d8d25a58 | 2023-06-15T01:45:28.000Z | 0 | 0x124bdbe90ad6b2ef9678ffa8fb350c4545b9f21914c93fda4a197c18fbc56ff2 | 0x296a495985a3c22ed6136a107140eb6ebc837382f2dce490445c06d1ac305ee6 |
| 0xc315239cfb05f1e130e7e28e603cea4c014c57f0 | false | 10 | 157629117309774640 | 8 | 1 | 0 | 183999687 | 5230463231185123 | 0x835762e2ea797b067417292953c82897e853d561 | 0x0253a6ad9ae23c99a92819e410877b9b0f90b41bcc7fa0e878dd8cbf48c738ed | 2024-02-24T13:02:26.000Z | 0 | 0xa24c1881fa59d4225eafeb5d48978448b3d70816834098fb2d0b2d8a0e98ad57 | 0xc1c7de716aaee45d95e62ef0370cfdd4a1bc7cb51762ad5d4f7fe5c915fcd9bb |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2BridgeRETH_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeUSDT\_TransferSent\_event
Transfer initiation events from Hop Protocol's USDT bridge on Arbitrum Layer 2. Records outbound cross-chain transfers with destination chain IDs (Ethereum mainnet, Optimism, Polygon), amounts, bonder fees, and recipient addresses for analyzing bridge volume and fee economics.
| 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. |
| 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 |
| ------------------------------------------ | ------- | --------- | ----------- | ---------- | ----------- | ------------ | ------------- | ------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x72209fe68386b37a40d6bca04f78356fd342491f | false | 1 | 947473793 | 8 | 1 | 0 | 3531514 | 56094123 | 0x50cf9e9854da4302babee8f8134736e85cb5d696 | 0x3bdab64a69391ca87197480c8371c69aad98eb0662f825654f1733cc7166b9cd | 2021-12-03T10:30:40.000Z | 0 | 0xa9d9fd8aea4af1f4abbb12ce863abebdc5dedfe0510060eb0076add6ff31a478 | 0x64db8bfbd07c5df79759f2f2a156b4836a3c0d142382990b0a3e7240a866d5f7 |
| 0x72209fe68386b37a40d6bca04f78356fd342491f | false | 3 | 4216000515 | 8 | 1 | 0 | 3546115 | 65542123 | 0x20366b9e058663260d7bda2ee42cec6adc4f643c | 0x5e00d40a3bcf426b9ae0593ec2b45b2337b229d9814d21cbbb3352c839b282aa | 2021-12-03T23:23:21.000Z | 0 | 0x7a50ca4adefc4948126f30a7e0483604bd7737a840a2672dcfcb41d9d73f466b | 0x6a918d044fb5527005db611caa6fa148a6656fdf5b1296e7cce76eab88ba071d |
| 0x72209fe68386b37a40d6bca04f78356fd342491f | false | 2 | 58196990432 | 8 | 1 | 0 | 3543774 | 235176123 | 0x575e3fa1608ec75e20d91b383f15186d1228fe98 | 0xc301d8a34fcfbc9d7006967cfe98fa35b6d8a4d4a9a68167131423d8e3b88b2f | 2021-12-03T20:47:19.000Z | 0 | 0xde3cedf342687c41192f800ff1bb5a9fc8385bb0a218a3a8bebf6b413846726a | 0xd07c572366a86aec04b06fe8382d9fd0e83b3332eae29a8e9d3ee2a4a48b463e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2BridgeUSDT_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeWBTC\_TransferSent\_event
*No description available.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.L2BridgeWBTC_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| address | in\_user | removed | in\_reward | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x755569159598f3702bdd7dff6233a317c156d3dd | 0xa7b11111e9720f4cb50f7cf1b9fd9bd8cea88740 | false | 125118484463758478 | 1 | 119179515 | 2023-08-07T22:18:47.000Z | 0x72e9e3115349d345dbb2643b8f4b0f6fa4f9059f2a34072ac10ea39a4ed0d955 |
| 0x755569159598f3702bdd7dff6233a317c156d3dd | 0x797e5a59fddd4b0f818833d78d0ce6224bd37121 | false | 8275209990536879433 | 1 | 119071537 | 2023-08-07T14:25:02.000Z | 0x7cdf55cdadbff7534ea5551db51f021f148fa78ba195afeae41ad3d97b31c963 |
| 0x755569159598f3702bdd7dff6233a317c156d3dd | 0x708c8673f83e87c1ff398f0a474f2167797f8258 | false | 20765102973731801 | 1 | 118960685 | 2023-08-07T06:38:05.000Z | 0x486578da2a44322f3f31a4d856a9b32d044b94510ddb4a87de510485436d8625 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_arbitrum.StakingRewards_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***