hop_v1_arbitrum

Tables

L2Amm_TokenSwap_event

Token swap events from Hop Protocol Layer 2 Automated Market Maker (AMM) contracts. Records buyer address, sold and bought token identifiers with pool positions, and raw token amounts exchanged between pool assets.

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
0x10541b07d8ad2647dc6cd67abd4c03575dade261	false	0x6dd3c3a01c0c28fe2a19fcb9c16609c048a6bd94	1	3	17465492	509720689	2022-07-12T07:29:37.000Z	509466785	0x6c56ef4ba3af824b205a3422fb44b47a1aa3a5601227308f883cf17df920a183
0x10541b07d8ad2647dc6cd67abd4c03575dade261	false	0xad7d89528e399d232b58636d3bc64432007c7938	1	3	17465968	509780490	2022-07-12T07:40:13.000Z	509525785	0x3ef1cd23357d76308ca857401b21503b6876b322f22eadc22e9f7f3e3ae829de
0x10541b07d8ad2647dc6cd67abd4c03575dade261	false	0x31b48d410003ab480bd66398f6e0712c55e11587	1	3	17484624	5456535	2022-07-12T14:12:20.000Z	5454978	0x91205c05bf2b6b130df8a95269e741c92c24ed019a48acb0824651e381b679c8

Example Query

Query with partition filter

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

L2AmmDAI_TokenSwap_event

Token swap events from Hop Protocol’s DAI Automated Market Maker (AMM) pool on Arbitrum L2. Captures trades between pool token IDs with amounts sold and bought, used for analyzing liquidity pool trading activity and price impact.

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
0xa5a33ab9063395a90ccbea2d86a62eccf27b5742	false	0xe7f40bf16ab09f4a6906ac2caa4094ad2da48cc2	175	1	84590924	40001634665072433728	2023-04-26T19:47:39.000Z	39986959719085903295	0x737b6b270cfef3d80fbebcbadcf0c42ade9634f543ed3885364b943b43433a61
0xa5a33ab9063395a90ccbea2d86a62eccf27b5742	false	0xe7f40bf16ab09f4a6906ac2caa4094ad2da48cc2	8	1	84518063	195879496003750000000	2023-04-26T14:44:08.000Z	195811841198043317858	0xc67bfc1e1e76e81d9347e148d53ab6889cecb341adc03ff72dc35cccbe90a027
0xa5a33ab9063395a90ccbea2d86a62eccf27b5742	false	0xe7f40bf16ab09f4a6906ac2caa4094ad2da48cc2	5	1	84458937	46521343700442941148	2023-04-26T10:38:56.000Z	46504832429514683045	0x3446f3e3e5097d192969097614421a9dc5af511a95b57a402de281a2216de193

Example Query

Query with partition filter

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

L2AmmETH_TokenSwap_event

Token swap events from Hop Protocol’s Layer 2 automated market maker (AMM) pools for ETH pairs. Records buyer address, token indices, and raw quantities exchanged between pool tokens.

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
0x652d27c0f72771ce5c76fd400edd61b406ac6d97	false	0xba9e95050bfbf8c9aedb9ff583958e376f101e4b	3	1	141448645	600000000000000	2023-10-17T16:20:01.000Z	599499524448910	0xfbfd1238b79bbe7939edfd9507b1acbfce88552afa5242d97fe370f56a5bc45f
0x652d27c0f72771ce5c76fd400edd61b406ac6d97	false	0x281a12a299026557ece523f2bf6dbcaea9cdc4ac	3	1	141473174	6250000000000000000	2023-10-17T18:18:32.000Z	6243466736491417904	0x787b169e147fee8e3676e85f1d13faddd44ed90abf9a95a66197c97b6106d2f7
0x652d27c0f72771ce5c76fd400edd61b406ac6d97	false	0xba9e95050bfbf8c9aedb9ff583958e376f101e4b	4	1	141448484	600000000000000	2023-10-17T16:19:15.000Z	599499539868387	0x010aeb0edad27a6302ee3a29474976bef13b492014508e14455eac3a7feb2e45

Example Query

Query with partition filter

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

L2AmmMAGIC_TokenSwap_event

Token swap events from Hop Protocol’s MAGIC token automated market maker (AMM) pool on Arbitrum. Records swaps between pool tokens (soldId/boughtId) with amounts, buyer addresses, and execution prices for analyzing liquidity provision and trading patterns.

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
0xffe42d3ba79ee5ee74a999cad0c60ef1153f0b82	false	0xa0de2f67bafcc8f82895a9d18e909944e2f7d73b	3	1	117831642	66000000000000000000	2023-08-03T19:05:22.000Z	65785680639726008296	0xdab8af675b77a513d55e6fc73a55dc485fc6315fa1669556e1aa1ae337bfc452
0xffe42d3ba79ee5ee74a999cad0c60ef1153f0b82	false	0x50a3a623d00fd8b8a4f3cbc5aa53d0bc6fa912dd	6	1	117619770	81813759451866123763	2023-08-03T04:08:41.000Z	81619354555849841742	0x67a4096ae98b522708d8f5dea01033d06daa6936746d09e00669b6ecfb6ffc11
0xffe42d3ba79ee5ee74a999cad0c60ef1153f0b82	false	0x50a3a623d00fd8b8a4f3cbc5aa53d0bc6fa912dd	6	1	117819010	1000000000000000000000	2023-08-03T18:11:07.000Z	996613038632243076747	0x4a60a0bd47e5a7ba8f1421abd6beec8523422daf8e84cb4923b401a40958c5c6

Example Query

Query with partition filter

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

L2AmmRETH_TokenSwap_event

Token swap events from Hop Protocol’s rETH (Rocket Pool ETH) automated market maker pool on Arbitrum. Records swaps between pool tokens (soldId/boughtId 0 and 1) with amounts, buyer addresses, and exchange rates for analyzing liquidity provider performance and trading volumes.

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
0x0ded0d521ac7b0d312871d18ea4fde79f03ee7ca	false	0x16e08c02e4b78b0a5b3a917ff5feaedd349a5a95	8	1	262394898	9956288183905813	2024-10-10T15:39:53.000Z	9958269863979290	0x6fb4c7177d22afddf853fa89db9b99d7b2a339dd12f4ba9cea220ffb5ad2373c
0x0ded0d521ac7b0d312871d18ea4fde79f03ee7ca	false	0x16e08c02e4b78b0a5b3a917ff5feaedd349a5a95	6	1	124011429	400000000000000000	2023-08-23T00:11:09.000Z	399781750979617324	0xc20f730376742097fec5a7db6c31ec70615d79c6a3539569dc606e9a7bee393c
0x0ded0d521ac7b0d312871d18ea4fde79f03ee7ca	false	0x16e08c02e4b78b0a5b3a917ff5feaedd349a5a95	7	1	124024610	9185146587565487079	2023-08-23T01:16:37.000Z	9177813658442400290	0x9886ca687507601041b16676a637259dcbd9a077c1a25d1efb6657649f55eca4

Example Query

Query with partition filter

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

L2AmmUSDT_TokenSwap_event

Token swap events from Hop Protocol’s USDT Automated Market Maker (AMM) on Arbitrum Layer 2. Captures trade execution details including buyer addresses, token amounts exchanged, and pool token IDs for analyzing liquidity pool trading activity and price slippage.

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
0x18f7402b673ba6fb5ea4b95768aabb8aad7ef18a	false	0x549bcac7403dac509158e59dd6d247420b904c09	1	39	282885531	1098669	2024-12-09T06:23:47.000Z	1094965	0xf387276d867d112b5becae295d60654538494c0e0d38943e0b8e6fbd169d5f37
0x18f7402b673ba6fb5ea4b95768aabb8aad7ef18a	false	0xcb0a4177e0a60247c0ad18be87f8edff6dd30283	1	9	282966792	5000000000	2024-12-09T12:03:41.000Z	4982940877	0xeffdd30599829a7c070a6b81929fc28cd9d947301a738cfb106765288e114c5e
0x18f7402b673ba6fb5ea4b95768aabb8aad7ef18a	false	0xcb0a4177e0a60247c0ad18be87f8edff6dd30283	1	17	282922705	15767969	2024-12-09T08:59:13.000Z	15718510	0x00940c2d591b0ca429292219d356635da3e0318cb6ec1a40cf38653f2ae5897d

Example Query

Query with partition filter

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

L2AmmWBTC_TokenSwap_event

No description available.

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_arbitrum.L2AmmWBTC_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

L2Bridge_TransferSent_event

Cross-chain transfer initiation events from Hop Protocol L2 bridges recording amount, recipient, destination chain, bonder fee, and transfer identifiers. Used for tracking bridge transactions and calculating cross-chain transfer costs.

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
0x0e0e3d2c5c292161999474247956ef542cabf8dd	false	57	499492583	8	1	77110420	9990123	0x4275e0a2d6974b54a2d2f1c7cbf7291c2777527b	0x4fb270d937f7e11ab4345bc45b31b7cbfb2984fcaa7bfc024c6083675af691b2	2023-04-04T23:49:30.000Z	0x179ecca96a42c70a8e6f5aebe68a205020eb5ab61673d0ae9048870cf6e8d295	0x0f3231497da8945899382d1fddb42afa850a13f9709326b747251a70787d8fc3
0x0e0e3d2c5c292161999474247956ef542cabf8dd	false	24	1019164604	8	1	76997434	12494123	0x6f70f8eab808f5ef9eb4794119f542adf514a476	0x657597d609e6301482d65c4631fac43d26e8db57348f1eeac7b8308f11b86cfc	2023-04-04T15:47:43.000Z	0x0a01fee60f60d1de0b52d4b4c3f20341868de8c9e1a2c3dea2d529e89da085b1	0xa41e8d8373d06b2429bbb3d7772944103d635290e51bf197101276762b95177f
0x0e0e3d2c5c292161999474247956ef542cabf8dd	false	31	2995789585	8	1	77031023	14583123	0xe4aaa62deca5b96bc3f056ffb6c40d209c6015ff	0x60d1c5bdde912c6c4624b01249ce1e5ecdfb12a6e424324c0c0336b6d5908b35	2023-04-04T18:07:40.000Z	0xe713f2211605616e76e11347b6997a0f3a36a0d2696f2372f07144ff0bfe2da9	0xaa18126e5b4cb8511d564edab7aa0e27d3f3ca556db86d3208a1e3f8f3b1fcd4

Example Query

Query with partition filter

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

L2BridgeDAI_TransferSent_event

DAI token transfer events sent from Hop Protocol’s Arbitrum L2 bridge to destination chains (Ethereum mainnet, Optimism, Gnosis). Records cross-chain bridge transfers with amounts, bonder fees, recipients, and unique transfer identifiers for tracking DAI movements across Layer 2 networks.

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
0x7ac115536fe3a185100b2c4de4cb328bf3a58ba6	false	18	4503061113407992364143	14	1	34624104	14786393161961152123	0x56b421c0aaca80be6447b7c330222c5a1ce27d4f	0xa46fd6d577d838956cde9cc6d7259a5df63f28b55c673b303c244820bc5c2b4f	2022-11-02T05:12:33.000Z	0x9ee4a3af823ddce5659a5fa4a96fc6fc40d8da35f66b9eb0779f1e02be98771f	0x5cb39e2de3b90c29d037f801f8ed9c976a4586a4d5a33705c14eeab91f51531b
0x7ac115536fe3a185100b2c4de4cb328bf3a58ba6	false	21	7007255559042538258861	6	1	34734989	21696642380983192123	0x12e838f846ffdade34b2e006f84117a370d71687	0x3ef1c51e820a6c0370edb2b7c25c61e7fb97583a105b882a37d9f3a9cdc926c9	2022-11-02T15:44:24.000Z	0x7c0b25671af00e31d3595cfebcadb7be9bc9d755a6db2d57324dfdc0b92e7800	0x4f45701eef300a4693d0b1db2bfdad686453f9f624f876d38a4727f27d39938f
0x7ac115536fe3a185100b2c4de4cb328bf3a58ba6	false	19	6005448869518412952	22	1	34678946	2699230669737739970	0x83db022d29fe7ce7fa977e5721cd4c6a315b6d8d	0x1c494c278e641f6b2ce3cb7456c8322077fbac469930f1c22ec9b68462540983	2022-11-02T10:38:12.000Z	0xa0845f8d660bb8b5baf00d51b07d618e9821f96c0956cf2f103919599e4dc7d3	0xabab51bb9dbd754064ef07dcb4edb7e7557432015e4bd7a7fff4f0d7d3cf3522

Example Query

Query with partition filter

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

L2BridgeETH_TransferSent_event

ETH transfer events emitted by Hop Protocol Layer 2 bridge contracts when cross-chain transfers are initiated. Contains transfer amount, bonder fee, destination chain ID, recipient address, and unique transfer identifiers for tracking asset flows between networks.

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
0x3749c4f034022c39ecaffaba182555d4508caccc	false	118	119884390066621325	7	1	12452979	1823809199284123	0xa01d644810a7149df86dd9265c7c0f94fb75c718	0x2cb3e0aa42bd0ba98eebef89bad1c0b6c7ba868a9bfd1ccd5c75fea2ee4b7cc3	2022-05-19T05:53:10.000Z	0xbfb3e10ff12f7371409e633db3703524810b8d7077a0f66ee2e779c0b20f2bc7	0x025a2484043c57d16a26fefa4c97609516a8eb4b6da4935081f56fc2c3307346
0x3749c4f034022c39ecaffaba182555d4508caccc	false	223	99912314006304045	7	1	12489586	4731057653705123	0xf503c4cac2b5a27f68eee197efb94e6fdeaa48d1	0x24def3503adbb8bedb60347442498f5c378b1e7133b9219c1056cc11bace0af0	2022-05-19T14:30:12.000Z	0x1a6c3e07577540ed01b2129c2c1aea1d6dc456d30684b346b685adc9efb8d86a	0x916900828d2ef65a214d16f0d1e73f1fe6489e9723400d368cfb2fe634d406d5
0x3749c4f034022c39ecaffaba182555d4508caccc	false	261	999387959065837464	7	1	12512064	5196065756337123	0xececafb3fea380ed39264a7ac86a3af846375aff	0xa68c3805a77d7ac5792edba61f53f0c61c0b2d3e50645152429fdf790577166a	2022-05-19T21:34:42.000Z	0x9749bd17d770a5551326e9d8c44731414cf13192a0a48af4d810ee56f291f299	0x0d9bb7456942f07f835c3f207ee755aa4ed81b1ba8df8e24aba329b4602282b6

Example Query

Query with partition filter

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

L2BridgeHOP_TransferSent_event

TransferSent events from Hop Protocol bridge on Arbitrum, recording cross-chain token transfers with destination chain ID, transfer amounts, bonder fees, and recipient addresses. Used for tracking bridge volume, fee analysis, and cross-chain transfer flow between Arbitrum and other chains (Ethereum mainnet, Optimism, Base).

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
0x25fb92e505f752f730cad0bd4fa17ece4a384266	false	0	10523921118246795462259	18	8453	1729072041	261966690	21207045013982241123	0x34327028c727613872cd80122b9a489a4b9c0bfa	0x54b1bf2a7118c20645e6eb804478e464321d36c8097e101cbc625d2a82c8ce73	2024-10-09T09:47:30.000Z	10450094467641579243824	0x1c4128ccfb9216e50d4471b60406813eb2e6cc3e621a211fadedfeb40564e3ad	0xeda64d83f33702a3ab0f9a0fd34d80a4b33eb5b79703d1c86dece59abf1e9e8a
0x25fb92e505f752f730cad0bd4fa17ece4a384266	false	7	18826142120305078326867	1	10	1729098881	262073643	17780593471640220123	0xb9096d6db733d5971ebd4b901398e6e33bd7cc70	0x6cd28c263e1050ec8894bf3f54a32d58e32287a87b7394357b885765c4813133	2024-10-09T17:14:53.000Z	18714230816231912715109	0x6894534eb3a4179b931a24498cccbdc0f06aaa7547fb570dd515f2db719632b3	0xa06dfaaf0b1dad5b8b2895ab80a2c0bf59ca10e91f17d79f6fb121ad2f48d7be
0x25fb92e505f752f730cad0bd4fa17ece4a384266	false	36	1710844515915420356530	37	10	1682958719	81455428	3756733410498980252	0x4cb6f0ef0eeb503f8065af1a6e6d5dd46197d3d9	0x4abd7d9f003d755d13e8fab7f261c59ee069468f71c0ce1c323cb441ad9ed140	2023-04-17T16:31:59.000Z	0	0x61642ce43de78ef572d06eccf8956098ab45a5d63d680110be745381e5c59e09	0x5db353632fa2855d964be189b9c01240d22fd9424a223bf915a017a2fcdd6c5f

Example Query

Query with partition filter

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

L2BridgeMAGIC_TransferSent_event

TransferSent events from Hop Protocol’s MAGIC token bridge on Arbitrum Layer 2, recording cross-chain transfers with bonder fees, transfer amounts, destination chain identifiers, and recipient addresses. Used for tracking MAGIC token bridge flows between Arbitrum and other chains (Ethereum mainnet, Arbitrum Nova) in the Hop liquidity network.

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
0xea5abf2c909169823d939de377ef2bf897a6ce98	false	4	939555423141328096333	18	1	0	228590910	6771175638101079126	0x0a6c69327d517568e6308f1e1cd2fd2b2b3cd4bf	0x59386c3584706c592ee4e1394bbfed10742833c078431fb7254833f0b8808b52	2024-07-04T06:55:24.000Z	0	0xf2a83a3cb6d49d474adf7a37a67677378c3c43c6b0ceb71676e503ea6b451ae5	0x47ed29793d778fcd63144443966cc213bbba4d4ff41cb88c76868d94899cd359
0xea5abf2c909169823d939de377ef2bf897a6ce98	false	41	1004336303738989177085	8	1	0	138558885	4764427862354884123	0x7737d3742ddc67f1443b40cbe6d401d649d3906a	0xde0e5ee8e69739480c86dc04e04fd7478cd80ff198d687f84f792ecc657139f9	2023-10-07T23:26:34.000Z	0	0xf5eb958eed17d2e76407520d554599aa4b9c07c30137905cefebb829f0b1464a	0x44cf47b6bbacedf62c6d04a55295934b2ab6cd9d269f2b04ed137cd6b6926588
0xea5abf2c909169823d939de377ef2bf897a6ce98	false	3	1000277861977195401	9	42170	1713231673	199063354	345725744652730123	0x9c2694293154f17b37b0715f2e4068298cd2eb2c	0x1b2f6281f8c52485dd16052c0fb503d7a91e2971dc48389e61e8298db5ca0246	2024-04-09T01:41:18.000Z	650942501259542376	0xf1545dd8ec02f13cc133e7518007b625ec9131ff404e799580487d8e44e2b564	0xf7b8a0a245dcc08be572c7f0968a3207c481b3369a11b681dee521f513af59ea

Example Query

Query with partition filter

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

L2BridgeRETH_TransferSent_event

Outbound bridge transfer events for rETH (Rocket Pool ETH) from Arbitrum to other chains via Hop Protocol. Used to track cross-chain transfers including amounts, bonder fees, destination chain IDs, and recipient addresses for analyzing rETH bridge activity and liquidity flows.

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
0xc315239cfb05f1e130e7e28e603cea4c014c57f0	false	7	23218025716570137	8	1	142067561	1565528897916123	0xa034ef98a17e753a31cf864c1f8a09c8563835ea	0xd1fa18e87453e811913b569a50e248a33614ba291d3026bec0cb9cf12615edef	2023-10-19T17:28:50.000Z	0x80cf584a81a63016c6ef96c671879eaca33918536f849f7763b3c680a3f24d00	0xce1aea08f5e530fd8cecd7b1fd01a6316018f819489317cb994680b80fb0f015
0xc315239cfb05f1e130e7e28e603cea4c014c57f0	false	8	928926400731391139	8	1	101263714	3912024360765123	0x21c4943a6060eb4c33f8b270562b535c7261015e	0x08867664cda975086a3d3e769a9e073d5604099f980a34329b74cbf8d8d25a58	2023-06-15T01:45:28.000Z	0x124bdbe90ad6b2ef9678ffa8fb350c4545b9f21914c93fda4a197c18fbc56ff2	0x296a495985a3c22ed6136a107140eb6ebc837382f2dce490445c06d1ac305ee6
0xc315239cfb05f1e130e7e28e603cea4c014c57f0	false	10	157629117309774640	8	1	183999687	5230463231185123	0x835762e2ea797b067417292953c82897e853d561	0x0253a6ad9ae23c99a92819e410877b9b0f90b41bcc7fa0e878dd8cbf48c738ed	2024-02-24T13:02:26.000Z	0xa24c1881fa59d4225eafeb5d48978448b3d70816834098fb2d0b2d8a0e98ad57	0xc1c7de716aaee45d95e62ef0370cfdd4a1bc7cb51762ad5d4f7fe5c915fcd9bb

Example Query

Query with partition filter

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

L2BridgeUSDT_TransferSent_event

Transfer initiation events from Hop Protocol’s USDT bridge on Arbitrum Layer 2. Records outbound cross-chain transfers with destination chain IDs (Ethereum mainnet, Optimism, Polygon), amounts, bonder fees, and recipient addresses for analyzing bridge volume and fee economics.

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
0x72209fe68386b37a40d6bca04f78356fd342491f	false	1	947473793	8	1	3531514	56094123	0x50cf9e9854da4302babee8f8134736e85cb5d696	0x3bdab64a69391ca87197480c8371c69aad98eb0662f825654f1733cc7166b9cd	2021-12-03T10:30:40.000Z	0xa9d9fd8aea4af1f4abbb12ce863abebdc5dedfe0510060eb0076add6ff31a478	0x64db8bfbd07c5df79759f2f2a156b4836a3c0d142382990b0a3e7240a866d5f7
0x72209fe68386b37a40d6bca04f78356fd342491f	false	3	4216000515	8	1	3546115	65542123	0x20366b9e058663260d7bda2ee42cec6adc4f643c	0x5e00d40a3bcf426b9ae0593ec2b45b2337b229d9814d21cbbb3352c839b282aa	2021-12-03T23:23:21.000Z	0x7a50ca4adefc4948126f30a7e0483604bd7737a840a2672dcfcb41d9d73f466b	0x6a918d044fb5527005db611caa6fa148a6656fdf5b1296e7cce76eab88ba071d
0x72209fe68386b37a40d6bca04f78356fd342491f	false	2	58196990432	8	1	3543774	235176123	0x575e3fa1608ec75e20d91b383f15186d1228fe98	0xc301d8a34fcfbc9d7006967cfe98fa35b6d8a4d4a9a68167131423d8e3b88b2f	2021-12-03T20:47:19.000Z	0xde3cedf342687c41192f800ff1bb5a9fc8385bb0a218a3a8bebf6b413846726a	0xd07c572366a86aec04b06fe8382d9fd0e83b3332eae29a8e9d3ee2a4a48b463e

Example Query

Query with partition filter

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

L2BridgeWBTC_TransferSent_event

No description available.

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_arbitrum.L2BridgeWBTC_TransferSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StakingRewards_RewardPaid_event

Reward distribution events from StakingRewards contracts recording when staked positions earn incentives. Contains recipient address, reward amount, and optional token or position identifiers for tracking yield distribution across protocols.

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
0x755569159598f3702bdd7dff6233a317c156d3dd	0xa7b11111e9720f4cb50f7cf1b9fd9bd8cea88740	false	125118484463758478	1	119179515	2023-08-07T22:18:47.000Z	0x72e9e3115349d345dbb2643b8f4b0f6fa4f9059f2a34072ac10ea39a4ed0d955
0x755569159598f3702bdd7dff6233a317c156d3dd	0x797e5a59fddd4b0f818833d78d0ce6224bd37121	false	8275209990536879433	1	119071537	2023-08-07T14:25:02.000Z	0x7cdf55cdadbff7534ea5551db51f021f148fa78ba195afeae41ad3d97b31c963
0x755569159598f3702bdd7dff6233a317c156d3dd	0x708c8673f83e87c1ff398f0a474f2167797f8258	false	20765102973731801	1	118960685	2023-08-07T06:38:05.000Z	0x486578da2a44322f3f31a4d856a9b32d044b94510ddb4a87de510485436d8625

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

L2Amm_TokenSwap_event

L2AmmDAI_TokenSwap_event

L2AmmETH_TokenSwap_event

L2AmmMAGIC_TokenSwap_event

L2AmmRETH_TokenSwap_event

L2AmmUSDT_TokenSwap_event

L2AmmWBTC_TokenSwap_event

L2Bridge_TransferSent_event

L2BridgeDAI_TransferSent_event

L2BridgeETH_TransferSent_event

L2BridgeHOP_TransferSent_event

L2BridgeMAGIC_TransferSent_event

L2BridgeRETH_TransferSent_event

L2BridgeUSDT_TransferSent_event

L2BridgeWBTC_TransferSent_event

StakingRewards_RewardPaid_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​L2Amm_TokenSwap_event

​L2AmmDAI_TokenSwap_event

​L2AmmETH_TokenSwap_event

​L2AmmMAGIC_TokenSwap_event

​L2AmmRETH_TokenSwap_event

​L2AmmUSDT_TokenSwap_event

​L2AmmWBTC_TokenSwap_event

​L2Bridge_TransferSent_event

​L2BridgeDAI_TransferSent_event

​L2BridgeETH_TransferSent_event

​L2BridgeHOP_TransferSent_event

​L2BridgeMAGIC_TransferSent_event

​L2BridgeRETH_TransferSent_event

​L2BridgeUSDT_TransferSent_event

​L2BridgeWBTC_TransferSent_event

​StakingRewards_RewardPaid_event

Tables

L2Amm_TokenSwap_event

L2AmmDAI_TokenSwap_event

L2AmmETH_TokenSwap_event

L2AmmMAGIC_TokenSwap_event

L2AmmRETH_TokenSwap_event

L2AmmUSDT_TokenSwap_event

L2AmmWBTC_TokenSwap_event

L2Bridge_TransferSent_event

L2BridgeDAI_TransferSent_event

L2BridgeETH_TransferSent_event

L2BridgeHOP_TransferSent_event

L2BridgeMAGIC_TransferSent_event

L2BridgeRETH_TransferSent_event

L2BridgeUSDT_TransferSent_event

L2BridgeWBTC_TransferSent_event

StakingRewards_RewardPaid_event