hop_v1_polygon

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	in_boughtId	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0x5c32143c8b198f392d01f8446b754c181224ac26	false	0x09b17dbcd8ac17ed5d2d6bd22ecb8eb68759cb4b	1	148	0	32322745	543386	2022-08-25T23:06:10.000Z	543140	0x23ecb271efffd313f85b84ae516a9b488accfce340d1a7583731f231ab21e60b
0x5c32143c8b198f392d01f8446b754c181224ac26	false	0x09b17dbcd8ac17ed5d2d6bd22ecb8eb68759cb4b	0	214	1	32322338	1081761	2022-08-25T22:47:54.000Z	1081384	0x375770b0c9042252598fc21c2eb8823c1621d1c83df9d4ee1c07ba698c1126fb
0x5c32143c8b198f392d01f8446b754c181224ac26	false	0x1dab8da475acce5ef82dc6a0ab21cf758f18a8b8	1	129	0	32304115	6298306	2022-08-25T11:22:44.000Z	6295094	0x51d0b94e52c9c08b33e8f1f40575e57b1954c9f66fd777786c654d02a8a190cd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hop_v1_polygon.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 Polygon. Records swaps between hTokens and canonical DAI with buyer addresses, token amounts, and pool token IDs for analyzing liquidity pool activity and cross-chain bridge utilization.

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
0x25fb92e505f752f730cad0bd4fa17ece4a384266	false	0x28529fec439cff6d7d1d5917e956dee62cd3be5c	1	442	64746128	4800000000000000000000	2024-11-26T07:42:17.000Z	4771942851100531000129	0x44c031938f610bfec18cbd28a9c3e793065168226f881dce93c81bb20b00d4ef
0x25fb92e505f752f730cad0bd4fa17ece4a384266	false	0x28529fec439cff6d7d1d5917e956dee62cd3be5c	1	425	64746128	9164129510209373593592	2024-11-26T07:42:17.000Z	9127717472428178918454	0x44c031938f610bfec18cbd28a9c3e793065168226f881dce93c81bb20b00d4ef
0x25fb92e505f752f730cad0bd4fa17ece4a384266	false	0x28529fec439cff6d7d1d5917e956dee62cd3be5c	1	550	64733248	361449209744077645768	2024-11-26T00:01:47.000Z	361464885214737504389	0x59d79283c4bed818f9816ac57f908f1221542b281cfb217e54f85df34f420d65

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hop_v1_polygon.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	in_soldId	log_index	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0x266e2dc3c4c59e42aa07afee5b09e964cffe6778	false	0x0f6b5c480fdc3a1fafb1321b68c759873e677451	1	370	75755084	603211145553542	2025-08-28T10:09:57.000Z	602364845204485	0x8357a1afe2ad56886855427e31b56f2f6b9c8d253dbf17485b7785ed2be2d34c
0x266e2dc3c4c59e42aa07afee5b09e964cffe6778	false	0x2bd79c4b155808ac80623a7bf5d866a02b55a6be	1	466	75750796	324183342446779	2025-08-28T07:38:05.000Z	323728876022214	0x63651cae8912e7f35d23b6ffd7960659f153c2143c6cdda4110908ea382b0a12
0x266e2dc3c4c59e42aa07afee5b09e964cffe6778	false	0x3611b82c7b13e72b26eb0e9be0613bee7a45ac7c	1	315	75755675	99661036345160	2025-08-28T10:30:53.000Z	99521206281445	0x9923630ab5fa02b590fad9e7f0d39d75e9525a350dc6d6f3a882db12d3189553

Example Query

Query with partition filter

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

L2AmmMATIC_TokenSwap_event

Token swap events from Hop Protocol’s MATIC automated market maker (AMM) on Polygon L2. Records swaps between canonical and hToken MATIC with buyer addresses, sold/bought amounts, and token IDs for analyzing bridge 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	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1	false	0x3d9ee32b4d8c5f4232b48a4d05e9325b23fe7a61	1	790	45285086	5618518407252169999	2023-07-20T01:18:04.000Z	5610213951984584941	0xba97a3b739f8a80adb79b4522fed53aecb7d5d5d7cea9528e0110d94a9155e45
0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1	false	0x884d1aa15f9957e1aeaa86a82a72e49bc2bfcbe3	1	506	45307280	257725000000000000000	2023-07-20T14:41:14.000Z	257406807447326643570	0x670c239c5346315a09b6c43de4d8440dcb0e313427aaaa7ec9a9c1b43a36c4a0
0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1	false	0x884d1aa15f9957e1aeaa86a82a72e49bc2bfcbe3	1	797	45285329	2107406085838735024	2023-07-20T01:26:52.000Z	2104289664521227682	0x27984882c3b5b54e67e92134c9f9d005599ed9133c2355f9147e3333f4b900a1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hop_v1_polygon.L2AmmMATIC_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 Polygon Layer 2. Records token exchanges between pool assets with sold/bought amounts and token identifiers 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	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0xb2f7d27b21a69a033f85c42d5eb079043baadc81	false	0x8741ba6225a6bf91f9d73531a98a89807857a2b3	1	151	37088532	81281645	2022-12-21T07:07:48.000Z	81293171	0x6abfbafe1c00d563e0db22c21fcc3d7362233cae09ec6514ee4e66126b23c210
0xb2f7d27b21a69a033f85c42d5eb079043baadc81	false	0x8741ba6225a6bf91f9d73531a98a89807857a2b3	1	16	37114657	5735838	2022-12-21T22:27:53.000Z	5739140	0x4093d0834cb538b75365f6cf6ca16875068caff314f8e560d9c4047cca02c1d5
0xb2f7d27b21a69a033f85c42d5eb079043baadc81	false	0x8741ba6225a6bf91f9d73531a98a89807857a2b3	1	839	37077696	28000000000	2022-12-21T00:51:52.000Z	28008592937	0x38f9ce59923fe0d7c945789b4b30c29cb96b304959ba0c962e47c894bf930af7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hop_v1_polygon.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_polygon.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
0x25d8039bb044dc227f741a9e381ca4ceae2e6ae8	false	3	21657977	163	1	27740710	14732123	0x2722764f04c605e378261ebd577434ebeb4c3746	0xfb5b7c5ff7814cf1f30c51ebb660448aa53e09334cb26a7f5b31af1a95c50a2c	2022-04-30T03:28:27.000Z	0x2e01e4f1e6a83a90a3a79b256dd594ad47db697bc3952c3937b4859a91a7f5ba	0xf1c31e680aba1c3598935a911c510787071a4ea37394e6e5b028787e4f7f99f8
0x25d8039bb044dc227f741a9e381ca4ceae2e6ae8	false	6	74432838	239	1	27748441	13110123	0x6255e5d2b3f82e4025959c1a3e8f19fefe087cc2	0x11653f39a2ee546ffa9477c2451df634ee17b80de40dfd206e6f9142d7bc5271	2022-04-30T08:11:51.000Z	0x668d2935b76f66ce2c0fd7f021da94ab7e0665837ec43333346a73d6f8910289	0x3c5dfc9ede36b8d442221774a0da45834f3fa77418b3733941343330b173fcc5
0x25d8039bb044dc227f741a9e381ca4ceae2e6ae8	false	16	233313821	329	1	27761328	25706123	0xa844e772716caa96faed692b123f65f7d882d0d6	0x7b24a8f76bedf71ac6569edc5cfce6799ede20b2003ae8b60c611edbfb8c16af	2022-04-30T16:12:46.000Z	0x3b9fb15e3b350c195b7d1e4fbf5a4469968617842064decaf87ff38fc195c5da	0x2b6ef36f1ee2b3c4392ab8062fad8b1c6ce251af01d7d5e166a9e5265690c17b

Example Query

Query with partition filter

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

L2BridgeDAI_TransferSent_event

Outbound DAI transfer events from Hop Protocol’s Layer 2 bridge contract on Polygon, capturing cross-chain transfers to Ethereum mainnet and Optimism with transfer amounts, bonder fees, recipient addresses, and unique transfer identifiers.

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
0xecf268be00308980b5b3fcd0975d47c4c8e1382a	false	27	369849536745651943017	225	1	0	29968298	4790152599676184123	0xd9a3ea0acdb41a12e871482a8eef99a017e38bf4	0xa72cd102e361360cbffc2032b674ebe82b96b25b7b7aadff9ac986f8e4c51b12	2022-06-25T03:52:30.000Z	0	0xbce4ea4d5892e88963b913f365dff54adaea57c09614871421deff179b73407f	0x1452904b18222f9ebc1d0530aadb1002f21fb111f96ded7c47af24251251744e
0xecf268be00308980b5b3fcd0975d47c4c8e1382a	false	57	997779696585400976	205	10	1656134146586	29969893	434897800962701577	0x813e16e4cd95c2cc74af6be7e4850937e10705a6	0x025a5a1611c369961082aca03d621720156539265ebe2a30e9f0fa624cd857fd	2022-06-25T04:56:08.000Z	534029656855727313	0xe8cf27607d634c9439de2da46dd9f5c8fecc9ecf154dc2ee52a5909eb8a4f91f	0x44264509012cce2343f468f76dcf38bad7f7270584020d9f194b5678534503cd
0xecf268be00308980b5b3fcd0975d47c4c8e1382a	false	58	9996998067098214546	274	10	1656244217	29980214	387235814670058889	0xd88c972516714c6cb182c08cc4116dd3d5056f86	0x2c277d814c2b9f09b48d9395a9bbc393b5a6d8b6129674de1fe6e320fb4f757c	2022-06-25T12:12:13.000Z	9315237824863147411	0x1446fb2fb6a6daf897876d73057bcabe30f55cb3edc8ae0875eafaf109d7fcd5	0x70d38f04af8ef0546caf4686220d5f410fae54b761efab079f145e57323f622c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hop_v1_polygon.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
0xb98454270065a31d71bf635f6f7ee6a518dfb849	false	530	60219996571624945	169	1	53060430	3367783266144123	0x0353ee54aa1d88f962d5d806d0856fe25dbdc568	0x2212018c9edac78387a11f67377d50c07db56fc9107abf213db6bc3816571a37	2024-02-03T03:11:42.000Z	0x907db9ef6ec9bc0a23f4d6fbe65e98b10ee41ec6c41c8836483480f38591588f	0xca17399dd3b7bb72e4863b9acb5f7829b04747802a701674eb841cd439e6518e
0xb98454270065a31d71bf635f6f7ee6a518dfb849	false	582	21215918838260374	439	1	53070436	2401335055026006	0x0c7d841966696af4d1aff9a56424ab938626a443	0x01e9a0d1abfb3b4860be7917a4e0cb30a1ce91a8b42b42d1eafad90a496470d9	2024-02-03T09:20:36.000Z	0xb401fba47386d36e61a01b1dce3a544ef8d80d8ba5bafec64724a50bb0914e70	0xe5b8b037d210f32d560146480b306d7068440a0a1182b43ab9eeba4953ca3ec0
0xb98454270065a31d71bf635f6f7ee6a518dfb849	false	656	4357043529658591	390	1	53083737	3614135287993205	0xb4881e8f7d139956c732b2cdcd09c4195359f0e8	0xabb2988dd6705636b09ad0af0e1b348818f52bc6377853a00a0885df06af44c0	2024-02-03T17:27:49.000Z	0x3d6dc3767ce63f556269e22ca9cbb95f2ada72beecf46476640072caf59f9007	0x0f555c99fa74639b5922ea80735dc97079fd6a10250046bc4f6a29b5add63120

Example Query

Query with partition filter

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

L2BridgeMATIC_TransferSent_event

MATIC token transfer events sent from Hop Protocol’s Layer 2 bridge on Polygon to Ethereum mainnet (chain ID 1). Records include transfer amounts, bonder fees, recipient addresses, and unique transfer identifiers for tracking cross-chain 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
0x553bc791d746767166fa3888432038193ceed5e2	false	210	1408772500408682792684	282	1	58829184	10098176904433562801	0x062f3d74aa609cb4156acaa00a7b253e262b4a56	0x26342b0ac5c1174bbd68d79d6b1934484bf7baa8b0bd1d11d53e47d50c9af80d	2024-07-01T13:14:07.000Z	0x99bbd316da8836e5bfaea25b93a8a84d003c94152f5f17121bb3661f3b2989f0	0x4a314d5f229cadf473edd1bcf19fc178aba3087f19f450928a9414671b6e781f
0x553bc791d746767166fa3888432038193ceed5e2	false	221	270800647313948479236	397	1	58846137	3860045770368786534	0x206dc6fb3b98b3ba0369650656b454837ba06a2a	0x859366b325eb7d301c9bcdc76d8215988ee1fc3baaefaac45b37eae74b84c7df	2024-07-01T23:21:33.000Z	0x9aeb9fee16724c962e86a772f6c39dc093515a8a6e7a5c3eb66ee27af4b9e890	0x2de48f51c85bab1edf7746402f63a58b6a834c2c560b294bca3bbd1c5fa26877
0x553bc791d746767166fa3888432038193ceed5e2	false	216	115140908564818948046	100	1	58838511	16038629181832956287	0x26eae1288f7f5c77b23ede18d138d097f5ebf1c5	0x89a9b737aae2617d6186d1354e0233501722643635bbfe3b3fa2f0da34f07524	2024-07-01T18:46:39.000Z	0xd64bbe37babab12f345e90c0cd24c4dad027b9c04d789539ca599bef6fd0d170	0x683ff029d9ca01ffc95cd350ec992c9660faba9bf3bbb6ab6b0a53d0f583329c

Example Query

Query with partition filter

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

L2BridgeUSDT_TransferSent_event

USDT bridge transfer events sent from Hop Protocol’s Layer 2 bridge on Polygon to destination chains (primarily Ethereum mainnet and Arbitrum). Records transfer amounts, bonder fees, recipient addresses, and unique transfer identifiers for tracking cross-chain USDT movements.

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
0x6c9a1acf73bd85463a46b0afc076fbdf602b690b	false	15	977399	220	1	69804984	450814	0x6ec6d1da62bf276f0bae82532c33cce02db694a3	0xad2a3b26b7c75727713439b63f35fbf2cc8cba545bd9447defb30af6e2fd5cac	2025-04-02T12:25:39.000Z	0x3495798927e1c165e738fe1d92b465ae21064f3c4b3191dd13bc18ef2f8d3ed6	0x62cee581d9c8aa6747549205312cbdd837f9fa55822ef0682e283236f8c72fb4
0x6c9a1acf73bd85463a46b0afc076fbdf602b690b	false	17	1066726	666	1	69816673	457175	0x6e41ca1c55a7fbd1b5ea5e338e479f15237eff76	0x34da73969f36a037351f0bb530b43d398d2e9fa54753b5cb810dcf424765fc5c	2025-04-02T19:19:40.000Z	0xfa1cb1b3656c9fd2cd71032bdefa017c4b51ebc175e8d114e6a632359aa3460e	0x6baf95156dc10da679a791180ae49bd20d5f65b873bfd43ee6adf87907f60d97
0x6c9a1acf73bd85463a46b0afc076fbdf602b690b	false	18	34518439	233	1	69820221	932465	0x7d6f869601b0c817eb08f991f07a7db3fd55c4be	0x030f7cf117f0b0abeb3fb9701fab76fbde66f0c837d5a534e7bc785de62bafaa	2025-04-02T21:25:22.000Z	0x94a9ce7f14ff40996567d35e61bfaec6124a3905915cff586d04257ba47cd7e5	0xc3b30077f72178129b1f2f64c60a047576d7fde9d30220e0dc5bb1553e143554

Example Query

Query with partition filter

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

L2BridgeWBTC_TransferSent_event

WBTC (Wrapped Bitcoin) transfer events from Hop Protocol’s Layer 2 bridge on Polygon, capturing cross-chain transfers to Ethereum mainnet (chain ID 1) with amounts, bonder fees, and recipient addresses. Used for tracking WBTC bridge flow volume and fee analysis.

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
0x91bd9ccec64fc22475323a0e55d58f7786587905	false	0	100	213	1	0	24164565	25	0xfefec7d3eb14a004029d278393e6ab8b46fb4fca	0x3608640d46fd719cbcdef5c7b3927e4bcec29b486ac648e7d3f21f263b049126	2022-01-25T23:43:38.000Z	0	0xaab5d9a86883b6867359d0de1d5869db334f42655c9e7cf77e9ce144fab5ce91	0xc538dd4431fc3ab0b21a83e3f06b4c0fa0c22e46e4686d482fa200ba42438a7a
0x91bd9ccec64fc22475323a0e55d58f7786587905	false	0	10	136	1	0	30492829	5	0xfefec7d3eb14a004029d278393e6ab8b46fb4fca	0x680084de6c19854cf4ae00024efe2f8f6cdd4c8c377746168d06dd51fdfea086	2022-07-08T18:17:10.000Z	0	0xb6fa47e4d2869c28781c78e96a780d70601eb1ffed2f48130b4d93fba1c1bab9	0x2564e81c2700e70efbe19a29d3ce4228745c4f2cbd4a3dddbd1debec5c9be961

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hop_v1_polygon.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
0x297e5079df8173ae1696899d3eacd708f0af82ce	0xfa043b360ab0c98644c1312594a091a758920b44	false	9240030437424	293	56190233	2024-04-24T06:45:07.000Z	0x0162340bd8955859509022306aa2291cf38577633ecd6dca3d4c25c71756fa7e
0x297e5079df8173ae1696899d3eacd708f0af82ce	0x38b3349d3c1454754f12848621fe590f2163c427	false	153976790967514224	195	56205031	2024-04-24T16:03:48.000Z	0xa73e2af36a4f5c3c0310269cec19989d4e07fa1fc0f53df9d5adfb8d371dae21
0x297e5079df8173ae1696899d3eacd708f0af82ce	0xfa043b360ab0c98644c1312594a091a758920b44	false	1232320749371097712	349	56190178	2024-04-24T06:43:07.000Z	0xeb4aff775c5bfae7159e241f05205b35de77776c553817a93b9008e008234215

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hop_v1_polygon.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

L2AmmMATIC_TokenSwap_event

L2AmmUSDT_TokenSwap_event

L2AmmWBTC_TokenSwap_event

L2Bridge_TransferSent_event

L2BridgeDAI_TransferSent_event

L2BridgeETH_TransferSent_event

L2BridgeMATIC_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

​L2AmmMATIC_TokenSwap_event

​L2AmmUSDT_TokenSwap_event

​L2AmmWBTC_TokenSwap_event

​L2Bridge_TransferSent_event

​L2BridgeDAI_TransferSent_event

​L2BridgeETH_TransferSent_event

​L2BridgeMATIC_TransferSent_event

​L2BridgeUSDT_TransferSent_event

​L2BridgeWBTC_TransferSent_event

​StakingRewards_RewardPaid_event

Tables

L2Amm_TokenSwap_event

L2AmmDAI_TokenSwap_event

L2AmmETH_TokenSwap_event

L2AmmMATIC_TokenSwap_event

L2AmmUSDT_TokenSwap_event

L2AmmWBTC_TokenSwap_event

L2Bridge_TransferSent_event

L2BridgeDAI_TransferSent_event

L2BridgeETH_TransferSent_event

L2BridgeMATIC_TransferSent_event

L2BridgeUSDT_TransferSent_event

L2BridgeWBTC_TransferSent_event

StakingRewards_RewardPaid_event