> ## 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_optimism
> Tables in tt-contracts.hop_v1_optimism
## 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0x3c0ffaca566fccfd9cc95139fef6cba143795963 | false | 0xb57e7e8840a97db1e022655ee766fd9c36f6b70d | 1 | 8 | 0 | 111262679 | 4550974797 | 2023-10-24T05:08:55.000Z | 4549920236 | 0xc01f143e18f5ee781ef005004e19edad64c6aa7fa3539a44b24ff0aec6ded18b |
| 0x3c0ffaca566fccfd9cc95139fef6cba143795963 | false | 0x2a10666194f6795642eef32f759b1040693c5bba | 1 | 15 | 0 | 111286895 | 2700271 | 2023-10-24T18:36:07.000Z | 2697486 | 0x9c4e1249e26025e3f9f98101ed5efe2971b0088f8774927f35d8936972f03084 |
| 0x3c0ffaca566fccfd9cc95139fef6cba143795963 | false | 0x2ad09850b0ca4c7c1b33f5acd6cbabcab5d6e796 | 1 | 14 | 0 | 111280151 | 128544953 | 2023-10-24T14:51:19.000Z | 128392242 | 0xa165dcd2f19317b9b31e6a7c196d82214504e4efa78a554a01a3d79a3e463494 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.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 Optimism Layer 2. Captures swap details including buyer address, token IDs traded, quantities sold and bought for analyzing DAI bridging liquidity 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | --------------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ |
| 0xf181ed90d6cfac84b8073fdea6d34aa744b41810 | false | 0x2ef2284a784c1fa06f95919fab978e87da18bc66 | 1 | 3 | 0 | 14979806 | 195103693527197357641 | 2022-07-19T08:59:48.000Z | 194745846169469905274 | 0x729376fdc51f9915b497b1d4bac50c4fa20c633343b8fe3d196fc347cd3efe9f |
| 0xf181ed90d6cfac84b8073fdea6d34aa744b41810 | false | 0xecf4e16e2903c21e95dafe74e31682d1b8ffe111 | 1 | 3 | 0 | 15035907 | 57350836290314909244 | 2022-07-19T19:14:55.000Z | 57249786000526611772 | 0xf87b57cf3289af40af5808e289684af595084be6d90318cf7a11ba0f9127f748 |
| 0xf181ed90d6cfac84b8073fdea6d34aa744b41810 | false | 0xb3c68a491608952cb1257fc9909a537a0173b63b | 1 | 8 | 0 | 14950007 | 20000000000000000000 | 2022-07-19T03:22:55.000Z | 19963091743964820400 | 0xa1df5ef59cccfc1d631d81eefb28ae21b113f8e146aba00aa7dddafee6aaf6f4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | ----------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 0xaa30d6bba6285d0585722e2440ff89e23ef68864 | false | 0x86ca30bef97fb651b8d866d45503684b90cb3312 | 0 | 32 | 1 | 68811078 | 1942397562408720 | 2023-01-18T01:45:52.000Z | 1943541995616917 | 0x6a1ee18fbd82e427fd0155d0180e684234792ce3fe0d7879b6c4ceee2af65580 |
| 0xaa30d6bba6285d0585722e2440ff89e23ef68864 | false | 0x86ca30bef97fb651b8d866d45503684b90cb3312 | 0 | 53 | 1 | 68860672 | 31588052781439860 | 2023-01-18T08:01:46.000Z | 31602180220351967 | 0x12197379579964a3a4ac976bbe0d7077817deb6aace7a4b8874fde79269046a9 |
| 0xaa30d6bba6285d0585722e2440ff89e23ef68864 | false | 0x86ca30bef97fb651b8d866d45503684b90cb3312 | 0 | 30 | 1 | 68869087 | 4314016220058119 | 2023-01-18T08:45:06.000Z | 4315241405326984 | 0xe664448adc921cf42bb3be17003fb9b7869cfcb61197a5313bf710f667527a34 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.L2AmmETH_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 Automated Market Maker (AMM) pool on Optimism. Tracks swaps between rETH and its Hop-bridged equivalent with buyer addresses, token amounts, and pool token IDs for analyzing cross-chain liquidity and bridge 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_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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | ------------------ | ------------------------ | ------------------ | ------------------------------------------------------------------ |
| 0x9dd8685463285ad5a94d2c128bda3c5e8a6173c8 | false | 0x68b48d5d8bf85aa0cf2ca7f3cb3c72fbbbece547 | 1 | 24 | 0 | 108017138 | 855348410746329586 | 2023-08-10T02:04:13.000Z | 858292923955674182 | 0x11a16db956842d8f90a6b0f8172a3629e0d8b334250496151c653e7c7d3a583a |
| 0x9dd8685463285ad5a94d2c128bda3c5e8a6173c8 | false | 0x19b2162ca4c2c6f08c6942bfb846ce5c396acb75 | 1 | 8 | 0 | 108025999 | 48833931250000000 | 2023-08-10T06:59:35.000Z | 49000964599553487 | 0xc9d19ededa37c3780a2e73733e4d27211b051b85ad56c1891a994060a4a3ab08 |
| 0x9dd8685463285ad5a94d2c128bda3c5e8a6173c8 | false | 0x19b2162ca4c2c6f08c6942bfb846ce5c396acb75 | 0 | 19 | 1 | 108024990 | 161660738704920832 | 2023-08-10T06:25:57.000Z | 160981489498770740 | 0x41b309b5e8aa1a6e10520214cbbdf3b9b91b9ccc7b7ad0b79c8d265ecbd0fa20 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.L2AmmRETH_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2AmmSNX\_TokenSwap\_event
Token swap events from Hop Protocol's SNX (Synthetix) automated market maker pool on Optimism. Records swaps between two token IDs with buyer addresses and exchange amounts for analyzing liquidity pool trading 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_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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | ---------------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ |
| 0x1990bc6dfe2ef605bfc08f5a23564db75642ad73 | false | 0xd007058e9b58e74c33c6bf6fbcd38baab813cbb6 | 0 | 2 | 1 | 94868523 | 8000000000000000000000 | 2023-04-28T00:23:00.000Z | 8001727796584697488494 | 0xb7243942abed672b5ac3b3f2ddf8e1067dc2e1ec428f1141f14b87a8af1b72b0 |
| 0x1990bc6dfe2ef605bfc08f5a23564db75642ad73 | false | 0x746bb7befd31d9052bb8eba7d5dd74c9acf54c6d | 0 | 2 | 1 | 95090172 | 20000000000000000000 | 2023-04-28T19:50:25.000Z | 20001437437061355973 | 0xffdd2a56f5b9cd3bcc628d01035d3db46c7f0c10b91a910ceb7af1d129344368 |
| 0x1990bc6dfe2ef605bfc08f5a23564db75642ad73 | false | 0xf11ebb94ec986ea891aec29cff151345c83b33ec | 1 | 8 | 0 | 94979254 | 605298516540000000000 | 2023-04-28T10:26:35.000Z | 604775442053241471119 | 0x1bbd08606393ae81909239081ba84ef26e5fc6512d2aa8920ffd644588278d10 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.L2AmmSNX_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2AmmSUSD\_TokenSwap\_event
Token swap events from Hop Protocol's sUSD automated market maker (AMM) pool on Optimism. Records swaps between pool token pairs (soldId/boughtId) with buyer addresses and token amounts for analyzing liquidity pool trading 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_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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | ---------------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ |
| 0x8d4063e82a4db8cdaed46932e1c71e03ca69bede | false | 0xed2ab188a15e45255e4bc4973a4fa152f8578cd6 | 1 | 3 | 0 | 109860899 | 3004178749287137446 | 2023-09-21T18:22:55.000Z | 3001939405980648467 | 0xe43a7b1d8a9df51e89b598b3f64e4388ed937a8cd6f0e2a08dacafb3fd487fea |
| 0x8d4063e82a4db8cdaed46932e1c71e03ca69bede | false | 0x5763a0b54aa391d7b2255b2f824cef80e8f343d0 | 1 | 5 | 0 | 109852637 | 999939631690234903365 | 2023-09-21T13:47:31.000Z | 999200221155515509201 | 0x887fbf33b846e5615adf47ed25d58e4dd456d867da0c4047dd94d0e6e8cda9fd |
| 0x8d4063e82a4db8cdaed46932e1c71e03ca69bede | false | 0x5763a0b54aa391d7b2255b2f824cef80e8f343d0 | 0 | 29 | 1 | 109852497 | 1000000000000000000000 | 2023-09-21T13:42:51.000Z | 999939631690234903365 | 0x94b361ecaf93a75854af7a5d054c884681b6f206c141119d8a41de2d5f6fecb1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.L2AmmSUSD_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) pool on Optimism Layer 2. Tracks swaps between token IDs (hUSDT and canonical USDT) with buyer addresses and amounts for analyzing cross-chain bridge liquidity and trading volume.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------ | ------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0xec4b41af04cf917b54aeb6df58c0f8d78895b5ef | false | 0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f | 0 | 38 | 1 | 112393770 | 1945393 | 2023-11-19T09:31:57.000Z | 1944840 | 0xb8e0e6e363c8391d0a19083d62701cb4b9871a9e7334ebd7dd6f92d11b2717df |
| 0xec4b41af04cf917b54aeb6df58c0f8d78895b5ef | false | 0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f | 0 | 7 | 1 | 112403110 | 13411857 | 2023-11-19T14:43:17.000Z | 13409194 | 0x1565763e902571add114aeaecbedf64e65c9a1b44318c516d46770302b23fc4c |
| 0xec4b41af04cf917b54aeb6df58c0f8d78895b5ef | false | 0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f | 0 | 27 | 1 | 112412676 | 700139666 | 2023-11-19T20:02:09.000Z | 700077112 | 0x2e0ab7df3a0af4ffc719cc6e083dac94b225a5dc8852ed1028131ee166a7b283 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.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_optimism.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 |
| ------------------------------------------ | ------- | --------- | ----------- | ---------- | ----------- | ------------ | ------------- | ------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0xa81d244a1814468c734e5b4101f7b9c0c577a8fc | false | 0 | 19365499000 | 8 | 1 | 0 | 3980233 | 45854123 | 0x8d9f950c23b73edf79ce52f74c6fb589cd2cbd90 | 0xe8dabe714c34c59bc7780838191cb81e59356dc918d6f4285dd9ba68e49ea55e | 2022-02-28T11:35:26.000Z | 0 | 0xaaa326d54d6d7b3ac9beb22679823eea4e9cf8771c3dfed2da598c7a4b948d83 | 0xa52c15fac0ca723444a987f3e2e59f6fa66e82cde3a36c0a6ba410e9d8506992 |
| 0xa81d244a1814468c734e5b4101f7b9c0c577a8fc | false | 1 | 42231749283 | 8 | 1 | 0 | 3982342 | 74443123 | 0xcac59f91e4536bc0e79ab816a5cd54e89f10433c | 0x3088887eb4310e5c18ca3416b71d1ecadefbd0e4f422577231742da87bf841c0 | 2022-02-28T12:37:18.000Z | 0 | 0xff404673816fa18a0be173335661f4bab799eaa5b65f5fae279bebea1208341a | 0x009ab97bf519e5a50d87ac2233e731722c69587eed3e0db37bed21e4f40e05ec |
| 0xa81d244a1814468c734e5b4101f7b9c0c577a8fc | false | 2 | 9570084890 | 8 | 1 | 0 | 3982451 | 26016123 | 0x6488b9b595d510b0724e9f552b1cba22d197eb4e | 0x1cf1175502ae9f96b4d9e20904b2a5a9acdd3eacd0ee4a5eb3ae2b1bf4fda37f | 2022-02-28T12:40:21.000Z | 0 | 0xc10723ab009cdfd9584e5671a0a0856e0d96c5db598d85ba6ca4fe5052202539 | 0xf2c2a636f0348ce27e477fd7cd6e7186f4a219e41de76ead4ce9dfe1b81144bd |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.L2Bridge_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeDAI\_TransferSent\_event
DAI bridge transfer events from Hop Protocol's Layer 2 bridge on Optimism, recording cross-chain transfers with bonder fees, destination chain IDs, and transfer amounts. Used for analyzing DAI bridging activity, fee structures, and cross-chain transfer patterns between Optimism and other chains like Ethereum mainnet and Gnosis Chain.
| 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 |
| ------------------------------------------ | ------- | --------- | ----------------------- | ---------- | ----------- | ------------ | ------------- | --------------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x7191061d5d4c60f598214cc6913502184baddf18 | false | 10 | 92321388002355477048355 | 6 | 1 | 0 | 6906898 | 147014500243596154123 | 0x6a9c7836ab5da544981b6993cfbf5414cfe02db1 | 0xe47d4531894d0f208e3b2c3615ae26a01d9552e52825ced2ad8ec99b023f4d06 | 2022-05-02T06:03:56.000Z | 0 | 0xfb06ce90080bc0d3bd8d6f3b7f2c1955d28ce01bc5d5e4e9e0bb0e19d9ac4264 | 0x52019b6ba00541a8f53c8bbc2f547f62a7ad1b580846e31454da5c7629375353 |
| 0x7191061d5d4c60f598214cc6913502184baddf18 | false | 0 | 769068886657443640356 | 6 | 1 | 0 | 6918832 | 29683939468851608123 | 0x632eb766871b02c4e421abdf14aceafa9fbcb84d | 0xf69b286a265f860872af6973ada87c9d9e05f62bca60ad3f75a622d4d1ab88fa | 2022-05-02T10:29:17.000Z | 0 | 0xd88bdc87cd57b8648e158008dc0accca243aeb3a04d98b145dec124777eaf699 | 0x369888959d0da2e07dc7f4803d693ea17800dda8a509d478ca6b667ebb0a95cd |
| 0x7191061d5d4c60f598214cc6913502184baddf18 | false | 1 | 145013944473565910606 | 6 | 1 | 0 | 6931500 | 21871876367430791123 | 0x12f3ab830cdd9db348a06a8eda0619a9c2ec10b8 | 0xde5ebcbd002b1e9f969e3bd9ed6b092bbcca25e0f2db5996ccd600fda2a8e870 | 2022-05-02T14:10:00.000Z | 0 | 0x897175e11d707b2105fe9a53aa1ca97a9bc16bfde96a19848593dec48636febb | 0x7acc8e8ae75a1891936987c98adc3d5d26c7cc103c107113cb8449fe160395ae |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.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 |
| ------------------------------------------ | ------- | --------- | ------------------ | ---------- | ----------- | ------------ | ------------- | ---------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x83f6244bd87662118d96d9a6d44f09dfff14b30e | false | 193 | 609357822128407912 | 6 | 1 | 0 | 14082711 | 1978933371192123 | 0x404ac1bdfe4cf148ab16114b1f2ab0a4fa505038 | 0x98ad418c9be1aba9132ccec85612daa8d44d3874b72ef8b799a76e616d918350 | 2022-07-08T10:08:10.000Z | 0 | 0xe90d0d0093f6bb797dba14c8f4268a441d6b6dc2f04113e0f73befc6f7a2e4cc | 0x7e6edf3bed02d513bf74da9530093275da5b90bb9e740da60da1fb7b81c5adca |
| 0x83f6244bd87662118d96d9a6d44f09dfff14b30e | false | 182 | 319604176565947186 | 6 | 1 | 0 | 14071175 | 2736705426527123 | 0xb4fe4a4925b8cda870ae67e0f885247dfc31f5d4 | 0x4eb8feda065811f9215bb59ac21097940ef2ae38e1a56468c6207213a50573d2 | 2022-07-08T07:12:52.000Z | 0 | 0x3d331990261f515dfbad80b62b7401c72077fca615f00b2191a13149c2f9c01e | 0xa65b493c23396a19dd737f3d1b76926912a38f5348afd9c04fa53b31f7a36f83 |
| 0x83f6244bd87662118d96d9a6d44f09dfff14b30e | false | 184 | 49938402021937950 | 6 | 1 | 0 | 14073534 | 3454706678126123 | 0x320773fe41cf2c8759bc583057bbdbcec6243cb2 | 0x1ea62f131396ef220accb38f0a5006b955de2462f133df16832d5bd14809b5ed | 2022-07-08T07:58:10.000Z | 0 | 0xae46f8b4e1367d11e4bde92b86a09a022327fd67f6e0a2aeafff2482eaccae40 | 0x40a6218bf46c25cdc544be5d8960a05762a414740384807151b3d1bb7f9f2466 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.L2BridgeETH_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeHOP\_TransferSent\_event
TransferSent events from Hop Protocol's Layer 2 (L2) bridge contract on Optimism, capturing outbound cross-chain transfers with amounts, destination chain IDs (chainId), bonder fees, and minimum output amounts. Used for tracking bridge flows and analyzing transfer costs across chains like Ethereum mainnet (chain 1), Polygon (137), Base (8453), and Arbitrum Nova (42170).
| 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 |
| ------------------------------------------ | ------- | --------- | ---------------------- | ---------- | ----------- | ------------ | ------------- | -------------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x03d7f750777ec48d39d080b020d83eb2cb4e3547 | false | 3 | 5524573849429779915891 | 12 | 137 | 1698075145 | 110935787 | 11289624235286386123 | 0x59c910bbb1fdbf56ec580267f579351627b18d2b | 0xe1eb170f6c8de89d252ffffe403f1824c0cd57437a9e5ad9cc777a8e66ab6069 | 2023-10-16T15:32:31.000Z | 5485661355947344630188 | 0xee92688ccf2b25b7f3baf82522a88d8353b0235b68b76b9e51b34cc7c11182bb | 0xd2b4b491af075397b77c1d673b86669dcb7921d28e3128aff640c293e71d26aa |
| 0x03d7f750777ec48d39d080b020d83eb2cb4e3547 | false | 2 | 5493462371305395976308 | 3 | 8453 | 1698063909 | 110930171 | 12748159846399676123 | 0xdd53e1da04f2c3ae45b5d70ff7ea67c489fa8b93 | 0x5d9e69284b1c906ca4a0f8de3930db4d21b27bb77703b9da1e4110412c5db8f0 | 2023-10-16T12:25:19.000Z | 5453246899602469320303 | 0xefd432fdfad7a1cfc31ec46d07656f68cd18c6230086ef0ccee1e195bf385e38 | 0xa7ef295180a3afd25ba72151dbd7f86a17657f3025d9d0560bfb53ff7e517315 |
| 0x03d7f750777ec48d39d080b020d83eb2cb4e3547 | false | 0 | 5600000000000000000 | 29 | 42170 | 1695934237 | 109865333 | 5359292681405495123 | 0xfefec7d3eb14a004029d278393e6ab8b46fb4fca | 0xae85111d9db7a1f277788dab6bc11e035ab3c98a415c855a08a8e5dec2d0ed46 | 2023-09-21T20:50:43.000Z | 212707318594504877 | 0x1f5a9a0c498e67e14d3f829130cf2ae0417febb2ca753d57dd0c677bbfe0e09c | 0x6d20eb80f7a81948481f7b9472ed724667c88b72223ee7efd4d0e0d2ec82104d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.L2BridgeHOP_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeRETH\_TransferSent\_event
Outbound cross-chain transfer events for Rocket Pool ETH (rETH) from Hop Protocol's Optimism bridge to destination chains (Arbitrum, Ethereum mainnet). Contains transfer amounts, bonder fees, recipient addresses, and unique transfer identifiers for tracking bridge transactions.
| 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 |
| ------------------------------------------ | ------- | --------- | ------------------- | ---------- | ----------- | ------------ | ------------- | ---------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0xa0075e8ce43dcb9970cb7709b9526c1232cc39c2 | false | 51 | 922790413759762716 | 8 | 42161 | 1697315229 | 110555831 | 1456036369515123 | 0xdb1032c4c3a3c81cd75a864dd85325cd85743218 | 0xbd6f5c746b499e905626b5b2122874183a29d964e168044fc672428e0ea99248 | 2023-10-07T20:27:19.000Z | 914401649602657811 | 0xbe98094526a5ce76b65d370fdb8d0e4ccb906e33f9251a946cb197cdeb2b96fd | 0x813db6a2cd76aa131fa3ceba76f543e2e85101d1d4bafc87d10d33aa72150070 |
| 0xa0075e8ce43dcb9970cb7709b9526c1232cc39c2 | false | 17 | 929268926824825123 | 61 | 42161 | 1688104339 | 105950384 | 1492608185850123 | 0xc87158be3c28d725043291e42ea960eebae681af | 0xf6070e3b23de8d17a36dd728a548fc5bd0bda09fecc81ffc3c9c7ed1e7f295da | 2023-06-23T05:52:25.000Z | 922686979659734913 | 0x953dcc116c8996b541fe32ab4d29c2817cc219b598c9af523a6e9807c9101639 | 0xa218ad167cc20df037e4077f371c5d7409d8ce4d8c2001d8a8be18c4f41fa736 |
| 0xa0075e8ce43dcb9970cb7709b9526c1232cc39c2 | false | 16 | 1045549848883580064 | 22 | 42161 | 1688094857 | 105945646 | 1671952783520123 | 0x1ae4f1a178abfc6b7c90da19917676b82c698e4b | 0x1982d04b41f6e750b6f65a773b5893b3576aeced4d5b15ecf858505b18f4e9c1 | 2023-06-23T03:14:29.000Z | 1038354706510383282 | 0x5b2ed838956269da4d39cad2a935bc722bfef31fdb8eae5775caf35af8d90023 | 0x4d1c9c4045ed4a9d0570fcb704ed917ed15cc09362e23c4bbe876dcc2827b07a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.L2BridgeRETH_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeSNX\_TransferSent\_event
SNX token transfer events initiated from Hop Protocol's Optimism L2 bridge to Ethereum mainnet (chainId 1). Contains transfer amounts, bonder fees, recipient addresses, and unique transfer identifiers for tracking cross-chain SNX movements and analyzing bridge usage 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_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 |
| ------------------------------------------ | ------- | --------- | ---------------------- | ---------- | ----------- | ------------ | ------------- | -------------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x16284c7323c35f4960540583998c98b1cfc581a7 | false | 17 | 9969490756953578656 | 7 | 1 | 0 | 114583591 | 3866212851630420990 | 0x0455c9f8c74e227d3179464fd4fd9dfed1c2f50e | 0xcf9df9e19185cd83d2bf01e263fc59bdf7b90b7a13921d5c769ef4d96e9c7d02 | 2024-01-09T02:05:59.000Z | 0 | 0xc96f60f547ddba9ea30df01e9748c18c56cb587da7475f90e54f0a55ab49a2d8 | 0xd8ba0c33fd281b5ea3c5d63f6694b7e4aa658694abe52b6d31cbafce82791e6e |
| 0x16284c7323c35f4960540583998c98b1cfc581a7 | false | 2 | 29508647166559563816 | 10 | 1 | 0 | 69247003 | 3075283522745326899 | 0xc782ec33ef8d71434f58485786fc8d0ff6c114b2 | 0x4d27b6169801bba38fc2870cfe8e5da6826dd1b238a64535be355deafc8e8719 | 2023-01-20T06:42:55.000Z | 0 | 0x9b362a14cdab87cdad8c11fc4ed0296fc89286aed4aa7a7021b30883baf6cac1 | 0x4fb4813ee7998838b04e3a7a5a7a3c4b9542da44abeb097c8ce5073a62c70afe |
| 0x16284c7323c35f4960540583998c98b1cfc581a7 | false | 2 | 4975725426663419989332 | 6 | 1 | 0 | 69279010 | 12442776918094576123 | 0x4d0e439ba905eb39aee88097433add619cf5257b | 0xa7fa89d68be97f8f9311d943ac8c6bf14882b486afb07e1b1c298accd2121868 | 2023-01-20T11:10:22.000Z | 0 | 0x8c8324265d710f18f7148d8f3c852f861bacff2e42712fd7fb1a898879215e3d | 0xb0f19257b840f03448a5730c5a62f6f2de9a15ce2d72f0681ad90c6aaf7783c0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.L2BridgeSNX_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeSUSD\_TransferSent\_event
TransferSent events from Hop Protocol's sUSD bridge on Optimism Layer 2, capturing outbound cross-chain transfers to Ethereum mainnet (chain ID 1) with transfer amounts, bonder fees, recipient addresses, and unique transfer identifiers for tracking bridge transactions.
| 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 |
| ------------------------------------------ | ------- | --------- | ------------------------ | ---------- | ----------- | ------------ | ------------- | --------------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x33fe5bb8da466da55a8a32d6ade2bb104e2c5201 | false | 2 | 20094665351186597773580 | 7 | 1 | 0 | 110529674 | 43386869325064970123 | 0x793491fe4a7b25eee0065e484a52c7a0dfd8c0d9 | 0x5649776f26e3909be77860b2044e34aade2f07e0dcadecf8668e41298e56f9c4 | 2023-10-07T05:55:25.000Z | 0 | 0x47afb82af41098ec1881c9f7a500d59a756e21f740ae16c764e765e9aa555400 | 0xe50cb8975c2f7e8f434ae4784993e705cea31992e3a158762fba2eb6c5a0889a |
| 0x33fe5bb8da466da55a8a32d6ade2bb104e2c5201 | false | 3 | 1338143289757332229872 | 6 | 1 | 0 | 95234275 | 23252356450785895123 | 0x50102aee2a69f6c473b4dd49c698db90733965d3 | 0x532c1c1da3d780001d92e8d2096822326a86c165ff44c6b154d00ccdf8ad51e9 | 2023-04-29T11:16:48.000Z | 0 | 0xe094ba7687666fa5c095c50c354cac1bb17dc439c07dabade7f63c5fb0936754 | 0x88d968544410a0759645da187a500514f08b06589e7f3d54827fe49f5e62fbdb |
| 0x33fe5bb8da466da55a8a32d6ade2bb104e2c5201 | false | 1 | 162595504443611956435262 | 37 | 1 | 0 | 106710369 | 350938410996775445123 | 0x73e8c09780e1df14dbd69a3c72127d89d049dc6b | 0x9f579f3ae24e19bf84d65a81d9dc8bf666d36d2179d4feaf2dbda9f6da76bbe7 | 2023-07-10T20:05:15.000Z | 0 | 0x75f9ba4c10de344a1554473681003939a4fb7514c3ee13e7b13ddef05fd1dcc6 | 0xbac905d9ff74f3c9297ac69ebb24a8950ed9c83efe65c95610246f071f1d33ca |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.L2BridgeSUSD_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### L2BridgeUSDT\_TransferSent\_event
Outbound USDT transfer events from Hop Protocol's Layer 2 bridge contract on Optimism, recording cross-chain transfers to Ethereum mainnet, Polygon, and Arbitrum with bonder fees and recipient details. Used for tracking bridge volume, fee analysis, and cross-chain USDT 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_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 |
| ------------------------------------------ | ------- | --------- | ------------ | ---------- | ----------- | ------------ | ------------- | ------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x46ae9bab8cea96610807a275ebd36f8e916b5c61 | false | 3 | 758033109 | 7 | 1 | 0 | 4012358 | 21552123 | 0x217b0731afcf792be787429e7c555851af09be0a | 0x1f2b2e830d75f0559dc0d027f9398b15b589f86d6a37ca2d3b4f2b5af463270c | 2022-03-01T06:21:48.000Z | 0 | 0xb3f29427fc1232a24dc346a3b19f64c8e57e599593e7228372573d4cc13316b5 | 0xf57f1ef8f7c88a7a9b88b02b2d17e242f33f78808c324ba54c703886505fbcdf |
| 0x46ae9bab8cea96610807a275ebd36f8e916b5c61 | false | 4 | 293475337898 | 7 | 1 | 0 | 4035833 | 698842123 | 0x931f69b205b661f73eb441f0717915a94654a294 | 0x0a048c19bccc94e2a0ce071f7c28849608a4b8f1ded16190eded12f61562323b | 2022-03-01T21:40:00.000Z | 0 | 0x6436b02f7a3c03bdea6ab0fa53316a7f9df6165731b31854bd004bc748262cfe | 0xc5e1f1d9ce1567d732540e451f35fd9a21fcce45e1129c4bb97b90d702e661f1 |
| 0x46ae9bab8cea96610807a275ebd36f8e916b5c61 | false | 38 | 160132962 | 7 | 137 | 1646757266 | 4029630 | 387123 | 0x66a29d658a410391a43825df561a264483ce83c5 | 0x80392ac3a7a5b90d91eb1c4d91618368a7fce48e8aafeddfee66b46e16506709 | 2022-03-01T16:34:28.000Z | 159164827 | 0x7e14fe0aec4dbcad191a2ace2b5e5767f311ee303b30fcdb36b5edd580189d6a | 0xff91c7f94936e0cdfbc306df5ad27ae59157d1316bf0f440306a6629fbc48739 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.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_optimism.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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x25a5a48c35e75bd2eff53d94f0bb60d5a00e36ea | 0x10fbf3fdda393713b883cc73a743b2dd943eff2a | false | 378239321335352670292 | 1 | 92092511 | 2023-04-19T04:37:38.000Z | 0x46eb4ba71e99c5b64ae0f7753bd201a1c68fd35d261849db8a235b16d665b725 |
| 0x25a5a48c35e75bd2eff53d94f0bb60d5a00e36ea | 0x7fb5ca677b02467dd9164add75739cd29c28316c | false | 47222225894128464208 | 1 | 92247688 | 2023-04-19T13:28:54.000Z | 0xf2903cfb2d4712d5a7e5ba0a6d5162b5264a28e5f3077d7337814bf5fb62d0eb |
| 0x25a5a48c35e75bd2eff53d94f0bb60d5a00e36ea | 0xd007058e9b58e74c33c6bf6fbcd38baab813cbb6 | false | 1807159456901787200000 | 1 | 92282033 | 2023-04-19T15:43:52.000Z | 0x33416b7814d74401c7db1e658426852a9f9ade6d2b1fb6b584d975ef9ba2d692 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.StakingRewards_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewardsOP\_RewardPaid\_event
Reward distribution events from Hop Protocol's OP token staking contract on Optimism, tracking when users claim earned rewards. Used for analyzing staking incentive payouts and yield farming participant behavior.
| 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 |
| ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x09992dd7b32f7b35d347de9bdaf1919a57d38e82 | 0x285e6e07ce1bcd84cc9b6f2ef661de222899eb23 | false | 20745896695916980187 | 5 | 110021701 | 2023-09-25T11:42:59.000Z | 0x64367219a8c01cf6631e0536d4f23c72f017c5a821ec2ee856bd1a7b338eb409 |
| 0x09992dd7b32f7b35d347de9bdaf1919a57d38e82 | 0x4390b9fdb1099805e36f9d1a6b33b290719cd0c0 | false | 155859333638700583 | 32 | 110008132 | 2023-09-25T04:10:41.000Z | 0x721de6137a78c27fb1ce9a48dbc8d4ff11858dd7db78185d408cbceb948989f8 |
| 0x09992dd7b32f7b35d347de9bdaf1919a57d38e82 | 0x4390b9fdb1099805e36f9d1a6b33b290719cd0c0 | false | 867146906944 | 76 | 110008147 | 2023-09-25T04:11:11.000Z | 0xbfcb98bc354614da2a456735bb63a609a2e864747b1165824a7b1aff488408c7 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.hop_v1_optimism.StakingRewardsOP_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***