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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

address	removed	in_buyer	in_soldId	log_index	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0x3c0ffaca566fccfd9cc95139fef6cba143795963	false	0xb57e7e8840a97db1e022655ee766fd9c36f6b70d	1	8	111262679	4550974797	2023-10-24T05:08:55.000Z	4549920236	0xc01f143e18f5ee781ef005004e19edad64c6aa7fa3539a44b24ff0aec6ded18b
0x3c0ffaca566fccfd9cc95139fef6cba143795963	false	0x2a10666194f6795642eef32f759b1040693c5bba	1	15	111286895	2700271	2023-10-24T18:36:07.000Z	2697486	0x9c4e1249e26025e3f9f98101ed5efe2971b0088f8774927f35d8936972f03084
0x3c0ffaca566fccfd9cc95139fef6cba143795963	false	0x2ad09850b0ca4c7c1b33f5acd6cbabcab5d6e796	1	14	111280151	128544953	2023-10-24T14:51:19.000Z	128392242	0xa165dcd2f19317b9b31e6a7c196d82214504e4efa78a554a01a3d79a3e463494

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

address	removed	in_buyer	in_soldId	log_index	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0xf181ed90d6cfac84b8073fdea6d34aa744b41810	false	0x2ef2284a784c1fa06f95919fab978e87da18bc66	1	3	14979806	195103693527197357641	2022-07-19T08:59:48.000Z	194745846169469905274	0x729376fdc51f9915b497b1d4bac50c4fa20c633343b8fe3d196fc347cd3efe9f
0xf181ed90d6cfac84b8073fdea6d34aa744b41810	false	0xecf4e16e2903c21e95dafe74e31682d1b8ffe111	1	3	15035907	57350836290314909244	2022-07-19T19:14:55.000Z	57249786000526611772	0xf87b57cf3289af40af5808e289684af595084be6d90318cf7a11ba0f9127f748
0xf181ed90d6cfac84b8073fdea6d34aa744b41810	false	0xb3c68a491608952cb1257fc9909a537a0173b63b	1	8	14950007	20000000000000000000	2022-07-19T03:22:55.000Z	19963091743964820400	0xa1df5ef59cccfc1d631d81eefb28ae21b113f8e146aba00aa7dddafee6aaf6f4

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

address	removed	in_buyer	log_index	in_boughtId	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0xaa30d6bba6285d0585722e2440ff89e23ef68864	false	0x86ca30bef97fb651b8d866d45503684b90cb3312	32	1	68811078	1942397562408720	2023-01-18T01:45:52.000Z	1943541995616917	0x6a1ee18fbd82e427fd0155d0180e684234792ce3fe0d7879b6c4ceee2af65580
0xaa30d6bba6285d0585722e2440ff89e23ef68864	false	0x86ca30bef97fb651b8d866d45503684b90cb3312	53	1	68860672	31588052781439860	2023-01-18T08:01:46.000Z	31602180220351967	0x12197379579964a3a4ac976bbe0d7077817deb6aace7a4b8874fde79269046a9
0xaa30d6bba6285d0585722e2440ff89e23ef68864	false	0x86ca30bef97fb651b8d866d45503684b90cb3312	30	1	68869087	4314016220058119	2023-01-18T08:45:06.000Z	4315241405326984	0xe664448adc921cf42bb3be17003fb9b7869cfcb61197a5313bf710f667527a34

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

address	removed	in_buyer	log_index	in_boughtId	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0xec4b41af04cf917b54aeb6df58c0f8d78895b5ef	false	0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f	38	1	112393770	1945393	2023-11-19T09:31:57.000Z	1944840	0xb8e0e6e363c8391d0a19083d62701cb4b9871a9e7334ebd7dd6f92d11b2717df
0xec4b41af04cf917b54aeb6df58c0f8d78895b5ef	false	0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f	7	1	112403110	13411857	2023-11-19T14:43:17.000Z	13409194	0x1565763e902571add114aeaecbedf64e65c9a1b44318c516d46770302b23fc4c
0xec4b41af04cf917b54aeb6df58c0f8d78895b5ef	false	0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f	27	1	112412676	700139666	2023-11-19T20:02:09.000Z	700077112	0x2e0ab7df3a0af4ffc719cc6e083dac94b225a5dc8852ed1028131ee166a7b283

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_transferNonce`	`STRING`	Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_bonderFee`	`STRING`	Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

address	removed	in_index	in_amount	log_index	in_chainId	block_number	in_bonderFee	in_recipient	in_transferId	block_timestamp	in_transferNonce	transaction_hash
0xa81d244a1814468c734e5b4101f7b9c0c577a8fc	false	0	19365499000	8	1	3980233	45854123	0x8d9f950c23b73edf79ce52f74c6fb589cd2cbd90	0xe8dabe714c34c59bc7780838191cb81e59356dc918d6f4285dd9ba68e49ea55e	2022-02-28T11:35:26.000Z	0xaaa326d54d6d7b3ac9beb22679823eea4e9cf8771c3dfed2da598c7a4b948d83	0xa52c15fac0ca723444a987f3e2e59f6fa66e82cde3a36c0a6ba410e9d8506992
0xa81d244a1814468c734e5b4101f7b9c0c577a8fc	false	1	42231749283	8	1	3982342	74443123	0xcac59f91e4536bc0e79ab816a5cd54e89f10433c	0x3088887eb4310e5c18ca3416b71d1ecadefbd0e4f422577231742da87bf841c0	2022-02-28T12:37:18.000Z	0xff404673816fa18a0be173335661f4bab799eaa5b65f5fae279bebea1208341a	0x009ab97bf519e5a50d87ac2233e731722c69587eed3e0db37bed21e4f40e05ec
0xa81d244a1814468c734e5b4101f7b9c0c577a8fc	false	2	9570084890	8	1	3982451	26016123	0x6488b9b595d510b0724e9f552b1cba22d197eb4e	0x1cf1175502ae9f96b4d9e20904b2a5a9acdd3eacd0ee4a5eb3ae2b1bf4fda37f	2022-02-28T12:40:21.000Z	0xc10723ab009cdfd9584e5671a0a0856e0d96c5db598d85ba6ca4fe5052202539	0xf2c2a636f0348ce27e477fd7cd6e7186f4a219e41de76ead4ce9dfe1b81144bd

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_transferNonce`	`STRING`	Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_bonderFee`	`STRING`	Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

address	removed	in_index	in_amount	log_index	in_chainId	block_number	in_bonderFee	in_recipient	in_transferId	block_timestamp	in_transferNonce	transaction_hash
0x7191061d5d4c60f598214cc6913502184baddf18	false	10	92321388002355477048355	6	1	6906898	147014500243596154123	0x6a9c7836ab5da544981b6993cfbf5414cfe02db1	0xe47d4531894d0f208e3b2c3615ae26a01d9552e52825ced2ad8ec99b023f4d06	2022-05-02T06:03:56.000Z	0xfb06ce90080bc0d3bd8d6f3b7f2c1955d28ce01bc5d5e4e9e0bb0e19d9ac4264	0x52019b6ba00541a8f53c8bbc2f547f62a7ad1b580846e31454da5c7629375353
0x7191061d5d4c60f598214cc6913502184baddf18	false	0	769068886657443640356	6	1	6918832	29683939468851608123	0x632eb766871b02c4e421abdf14aceafa9fbcb84d	0xf69b286a265f860872af6973ada87c9d9e05f62bca60ad3f75a622d4d1ab88fa	2022-05-02T10:29:17.000Z	0xd88bdc87cd57b8648e158008dc0accca243aeb3a04d98b145dec124777eaf699	0x369888959d0da2e07dc7f4803d693ea17800dda8a509d478ca6b667ebb0a95cd
0x7191061d5d4c60f598214cc6913502184baddf18	false	1	145013944473565910606	6	1	6931500	21871876367430791123	0x12f3ab830cdd9db348a06a8eda0619a9c2ec10b8	0xde5ebcbd002b1e9f969e3bd9ed6b092bbcca25e0f2db5996ccd600fda2a8e870	2022-05-02T14:10:00.000Z	0x897175e11d707b2105fe9a53aa1ca97a9bc16bfde96a19848593dec48636febb	0x7acc8e8ae75a1891936987c98adc3d5d26c7cc103c107113cb8449fe160395ae

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_transferNonce`	`STRING`	Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_bonderFee`	`STRING`	Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

address	removed	in_index	in_amount	log_index	in_chainId	block_number	in_bonderFee	in_recipient	in_transferId	block_timestamp	in_transferNonce	transaction_hash
0x83f6244bd87662118d96d9a6d44f09dfff14b30e	false	193	609357822128407912	6	1	14082711	1978933371192123	0x404ac1bdfe4cf148ab16114b1f2ab0a4fa505038	0x98ad418c9be1aba9132ccec85612daa8d44d3874b72ef8b799a76e616d918350	2022-07-08T10:08:10.000Z	0xe90d0d0093f6bb797dba14c8f4268a441d6b6dc2f04113e0f73befc6f7a2e4cc	0x7e6edf3bed02d513bf74da9530093275da5b90bb9e740da60da1fb7b81c5adca
0x83f6244bd87662118d96d9a6d44f09dfff14b30e	false	182	319604176565947186	6	1	14071175	2736705426527123	0xb4fe4a4925b8cda870ae67e0f885247dfc31f5d4	0x4eb8feda065811f9215bb59ac21097940ef2ae38e1a56468c6207213a50573d2	2022-07-08T07:12:52.000Z	0x3d331990261f515dfbad80b62b7401c72077fca615f00b2191a13149c2f9c01e	0xa65b493c23396a19dd737f3d1b76926912a38f5348afd9c04fa53b31f7a36f83
0x83f6244bd87662118d96d9a6d44f09dfff14b30e	false	184	49938402021937950	6	1	14073534	3454706678126123	0x320773fe41cf2c8759bc583057bbdbcec6243cb2	0x1ea62f131396ef220accb38f0a5006b955de2462f133df16832d5bd14809b5ed	2022-07-08T07:58:10.000Z	0xae46f8b4e1367d11e4bde92b86a09a022327fd67f6e0a2aeafff2482eaccae40	0x40a6218bf46c25cdc544be5d8960a05762a414740384807151b3d1bb7f9f2466

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_transferNonce`	`STRING`	Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_bonderFee`	`STRING`	Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

address	removed	in_index	in_amount	log_index	in_chainId	in_deadline	block_number	in_bonderFee	in_recipient	in_transferId	block_timestamp	in_amountOutMin	in_transferNonce	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_transferNonce`	`STRING`	Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_bonderFee`	`STRING`	Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

address	removed	in_index	in_amount	log_index	in_chainId	in_deadline	block_number	in_bonderFee	in_recipient	in_transferId	block_timestamp	in_amountOutMin	in_transferNonce	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_transferNonce`	`STRING`	Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_bonderFee`	`STRING`	Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

address	removed	in_index	in_amount	log_index	in_chainId	block_number	in_bonderFee	in_recipient	in_transferId	block_timestamp	in_transferNonce	transaction_hash
0x16284c7323c35f4960540583998c98b1cfc581a7	false	17	9969490756953578656	7	1	114583591	3866212851630420990	0x0455c9f8c74e227d3179464fd4fd9dfed1c2f50e	0xcf9df9e19185cd83d2bf01e263fc59bdf7b90b7a13921d5c769ef4d96e9c7d02	2024-01-09T02:05:59.000Z	0xc96f60f547ddba9ea30df01e9748c18c56cb587da7475f90e54f0a55ab49a2d8	0xd8ba0c33fd281b5ea3c5d63f6694b7e4aa658694abe52b6d31cbafce82791e6e
0x16284c7323c35f4960540583998c98b1cfc581a7	false	2	29508647166559563816	10	1	69247003	3075283522745326899	0xc782ec33ef8d71434f58485786fc8d0ff6c114b2	0x4d27b6169801bba38fc2870cfe8e5da6826dd1b238a64535be355deafc8e8719	2023-01-20T06:42:55.000Z	0x9b362a14cdab87cdad8c11fc4ed0296fc89286aed4aa7a7021b30883baf6cac1	0x4fb4813ee7998838b04e3a7a5a7a3c4b9542da44abeb097c8ce5073a62c70afe
0x16284c7323c35f4960540583998c98b1cfc581a7	false	2	4975725426663419989332	6	1	69279010	12442776918094576123	0x4d0e439ba905eb39aee88097433add619cf5257b	0xa7fa89d68be97f8f9311d943ac8c6bf14882b486afb07e1b1c298accd2121868	2023-01-20T11:10:22.000Z	0x8c8324265d710f18f7148d8f3c852f861bacff2e42712fd7fb1a898879215e3d	0xb0f19257b840f03448a5730c5a62f6f2de9a15ce2d72f0681ad90c6aaf7783c0

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_transferNonce`	`STRING`	Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_bonderFee`	`STRING`	Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

address	removed	in_index	in_amount	log_index	in_chainId	block_number	in_bonderFee	in_recipient	in_transferId	block_timestamp	in_transferNonce	transaction_hash
0x33fe5bb8da466da55a8a32d6ade2bb104e2c5201	false	2	20094665351186597773580	7	1	110529674	43386869325064970123	0x793491fe4a7b25eee0065e484a52c7a0dfd8c0d9	0x5649776f26e3909be77860b2044e34aade2f07e0dcadecf8668e41298e56f9c4	2023-10-07T05:55:25.000Z	0x47afb82af41098ec1881c9f7a500d59a756e21f740ae16c764e765e9aa555400	0xe50cb8975c2f7e8f434ae4784993e705cea31992e3a158762fba2eb6c5a0889a
0x33fe5bb8da466da55a8a32d6ade2bb104e2c5201	false	3	1338143289757332229872	6	1	95234275	23252356450785895123	0x50102aee2a69f6c473b4dd49c698db90733965d3	0x532c1c1da3d780001d92e8d2096822326a86c165ff44c6b154d00ccdf8ad51e9	2023-04-29T11:16:48.000Z	0xe094ba7687666fa5c095c50c354cac1bb17dc439c07dabade7f63c5fb0936754	0x88d968544410a0759645da187a500514f08b06589e7f3d54827fe49f5e62fbdb
0x33fe5bb8da466da55a8a32d6ade2bb104e2c5201	false	1	162595504443611956435262	37	1	106710369	350938410996775445123	0x73e8c09780e1df14dbd69a3c72127d89d049dc6b	0x9f579f3ae24e19bf84d65a81d9dc8bf666d36d2179d4feaf2dbda9f6da76bbe7	2023-07-10T20:05:15.000Z	0x75f9ba4c10de344a1554473681003939a4fb7514c3ee13e7b13ddef05fd1dcc6	0xbac905d9ff74f3c9297ac69ebb24a8950ed9c83efe65c95610246f071f1d33ca

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_transferNonce`	`STRING`	Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_bonderFee`	`STRING`	Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

address	removed	in_index	in_amount	log_index	in_chainId	in_deadline	block_number	in_bonderFee	in_recipient	in_transferId	block_timestamp	in_amountOutMin	in_transferNonce	transaction_hash
0x46ae9bab8cea96610807a275ebd36f8e916b5c61	false	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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transferId`	`STRING`	Unique identifier for the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_transferNonce`	`STRING`	Nonce value ensuring uniqueness and preventing replay of the cross-chain transfer operation. 66-character hex string including 0x prefix.
`in_bonderFee`	`STRING`	Fee paid to the bonder for facilitating the cross-chain transfer. Numeric string representation of the fee amount in the token’s smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hop_v1_optimism.StakingRewardsOP_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

L2Amm_TokenSwap_event

L2AmmDAI_TokenSwap_event

L2AmmETH_TokenSwap_event

L2AmmRETH_TokenSwap_event

L2AmmSNX_TokenSwap_event

L2AmmSUSD_TokenSwap_event

L2AmmUSDT_TokenSwap_event

L2AmmWBTC_TokenSwap_event

L2Bridge_TransferSent_event

L2BridgeDAI_TransferSent_event

L2BridgeETH_TransferSent_event

L2BridgeHOP_TransferSent_event

L2BridgeRETH_TransferSent_event

L2BridgeSNX_TransferSent_event

L2BridgeSUSD_TransferSent_event

L2BridgeUSDT_TransferSent_event

L2BridgeWBTC_TransferSent_event

StakingRewards_RewardPaid_event

StakingRewardsOP_RewardPaid_event

​Tables

​L2Amm_TokenSwap_event

​L2AmmDAI_TokenSwap_event

​L2AmmETH_TokenSwap_event

​L2AmmRETH_TokenSwap_event

​L2AmmSNX_TokenSwap_event

​L2AmmSUSD_TokenSwap_event

​L2AmmUSDT_TokenSwap_event

​L2AmmWBTC_TokenSwap_event

​L2Bridge_TransferSent_event

​L2BridgeDAI_TransferSent_event

​L2BridgeETH_TransferSent_event

​L2BridgeHOP_TransferSent_event

​L2BridgeRETH_TransferSent_event

​L2BridgeSNX_TransferSent_event

​L2BridgeSUSD_TransferSent_event

​L2BridgeUSDT_TransferSent_event

​L2BridgeWBTC_TransferSent_event

​StakingRewards_RewardPaid_event

​StakingRewardsOP_RewardPaid_event

Tables

L2Amm_TokenSwap_event

L2AmmDAI_TokenSwap_event

L2AmmETH_TokenSwap_event

L2AmmRETH_TokenSwap_event

L2AmmSNX_TokenSwap_event

L2AmmSUSD_TokenSwap_event

L2AmmUSDT_TokenSwap_event

L2AmmWBTC_TokenSwap_event

L2Bridge_TransferSent_event

L2BridgeDAI_TransferSent_event

L2BridgeETH_TransferSent_event

L2BridgeHOP_TransferSent_event

L2BridgeRETH_TransferSent_event

L2BridgeSNX_TransferSent_event

L2BridgeSUSD_TransferSent_event

L2BridgeUSDT_TransferSent_event

L2BridgeWBTC_TransferSent_event

StakingRewards_RewardPaid_event

StakingRewardsOP_RewardPaid_event