hop_v1_base

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	log_index	in_boughtId	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0x022c5ce6f1add7423268d41e08df521d5527c2a0	false	0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f	12	1	10209425	29088247	2024-02-06T08:29:57.000Z	29125130	0x9c065cbe04bdecdf1863c7fae3d156c2c8975ec6d0ebb7aad4de69a01c94e92f
0x022c5ce6f1add7423268d41e08df521d5527c2a0	false	0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f	30	1	10213886	111947247	2024-02-06T10:58:39.000Z	112083795	0x909af4db90f95734806341cc5df38ddce774c8a4f5a7ea2c8ac71e606471bf33
0x022c5ce6f1add7423268d41e08df521d5527c2a0	false	0x7d269d3e0d61a05a0ba976b7dbf8805bf844af3f	17	1	10213668	121425000	2024-02-06T10:51:23.000Z	121575369	0xf90cd234b9e60df750cdff4f589d2920bae717d033ddca7105c51ab50de3c3ef

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hop_v1_base.L2Amm_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
0x0ce6c85cf43553de10fc56ceca0aef6ff0dd444d	false	0x10541b07d8ad2647dc6cd67abd4c03575dade261	66	1	10255580	5000000000000000	2024-02-07T10:08:27.000Z	4994568625310303	0x38e0309756aca276ed101e04ec2c6c04d908099ffa38b23c6f982b7415def512
0x0ce6c85cf43553de10fc56ceca0aef6ff0dd444d	false	0x10541b07d8ad2647dc6cd67abd4c03575dade261	74	1	10275105	993000000000000	2024-02-07T20:59:17.000Z	991480673487586	0x1a48627d8d91568f3c3d1d5ff121e3b3c56254a5fc143662e932ae3006c5674d
0x0ce6c85cf43553de10fc56ceca0aef6ff0dd444d	false	0x10541b07d8ad2647dc6cd67abd4c03575dade261	63	1	10269617	24000000000000000	2024-02-07T17:56:21.000Z	23963559979093570	0x7a2bdf9cce156cbf73b2a98680ec38d509240f8a854563548472b84d6f2bd48b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hop_v1_base.L2AmmETH_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	in_deadline	block_number	in_bonderFee	in_recipient	in_transferId	block_timestamp	in_amountOutMin	in_transferNonce	transaction_hash
0x46ae9bab8cea96610807a275ebd36f8e916b5c61	false	13	104194129	40	10	1702043678408	7324777	441444	0x5278973d51d3bc8e59a9a0d9e95218bfe4cc4ee4	0xb2fce32805e9304d8d2a3838d186de0e1ab5b376c1557e9063cb3f2d0761dc61	2023-12-01T13:55:01.000Z	103179258	0x409baf958e945490e5faefa6b5d4634c7b5671a7f39f5a9b16b28e82fc4d2568	0xb9509696664fdc5e9501aa11fc474d61296305cfc5e64051527b6b6d3c5b0cb6
0x46ae9bab8cea96610807a275ebd36f8e916b5c61	false	14	34277363	13	10	1701525874	7325070	490641	0x1de21737f386aa8740a8d7aef022abd6588f5f99	0xac8319e7f9302c8e779c4658e9712608c4bfda84407ab2517cfba4300db89584	2023-12-01T14:04:47.000Z	33595028	0xda9e5a0737f827084eb7b1383e03e9f02ac2af1af3bf506c7de1b5293369dbbf	0x2244163a0806a68234d12d1fe01cc21e4ceb7a0e1077c6ef487542b80e1b42fa
0x46ae9bab8cea96610807a275ebd36f8e916b5c61	false	15	100092516	11	10	1701529587	7326930	544604	0x00409fc839a2ec2e6d12305423d37cd011279c09	0x906ff32711949fdb2c8ff5ae34de98bd652a526d8cecf46ae2eb993462a1e00e	2023-12-01T15:06:47.000Z	98983797	0x3a569ffeba513f1e3c0739005649a1fb34f2e975f66a7806bf7d19d191d7ade0	0x4d8ef309130ac03ad2693048c13c98b72ec188ba4ef4032570a898b99a44f6fa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hop_v1_base.L2Bridge_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
0x3666f603cc164936c1b87e207f36beba4ac5f18a	false	693	22614978210847770	6	1	6449054	3308554477969348	0xd8cc1b1555276310842f4a68ae16e673854d911c	0x58ae07bd7509593a598397502f4f215bb7cd63f41a8c6f2ff923791635b37a63	2023-11-11T07:24:15.000Z	0xa010d2b988dab1597a455962a0ef337c2637d2341483900a703aa07428c606ec	0x2c26a277652023ee8a41dcc1cd6918d37289875c169d2a5acd5bc92cbed9aa35
0x3666f603cc164936c1b87e207f36beba4ac5f18a	false	721	12231537131067331	6	1	6464657	6357160199633843	0xd79f8b51a1ed5c6a8150a37c5409421052e8894c	0x3c065a7f8dc2661a7ecdb1efb6d800f44b8824855e5f6a3e61cf959c6007d2ed	2023-11-11T16:04:21.000Z	0x41be615fb8f32c23315c75b1af0083d90de1a4fc64203a96876f23e1ed8d4952	0xd038881f659a5b49da94440cc36ec933f00f806e5edc48a88b0ea088d8065a4c
0x3666f603cc164936c1b87e207f36beba4ac5f18a	false	662	58415776221125859	6	1	6439179	4308852529690146	0xc81541301c331a314eba06530ca28dd727707170	0x571916cf5e0c3db9205911562dbdb31b770cdbd8622a54f9ee48c90b46ccbf37	2023-11-11T01:55:05.000Z	0xfafe3a3a95f24f1846a74df2748a23cee94b323fe4316fc81b070257edd80e47	0x8538a405ed1c452314d2083ce6ad77173b97cea06943857e02c4d675bc552895

Example Query

Query with partition filter

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

L2BridgeHOP_TransferSent_event

Cross-chain transfer events from Hop Protocol’s Layer 2 bridge on Base, tracking outbound transfers with amounts, fees, recipient addresses, and destination chain identifiers. Used for analyzing bridge volume, bonder fee economics, and cross-chain asset flows between Base and other networks like Optimism (chain ID 10), Arbitrum (42161), and Polygon (137).

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
0xe22d2bedb3eca35e6397e0c6d62857094aa26f52	false	6	177196438887613891383	18	10	1704904653	8755255	8444801771209099123	0xc960338b529e0353f570f62093fd362b8fb55f0b	0xc323a4d8777d12391c4fe90bedf3a83c15a48ae987588c1535abe1fe4393f7bb	2024-01-03T16:37:37.000Z	167865654921966722803	0xeec4b868f3048a0f33291639d2e2af7c7c29afaa5fc7b4bb47b534c98ea54b3e	0x45134aeff797e40eda3e8e9be0f775f0d593208745b0b6e8abefdbae85b230ae
0xe22d2bedb3eca35e6397e0c6d62857094aa26f52	false	5	8318501625621866610688	16	10	1704297494	8748674	29556411954797957519	0x0a6c69327d517568e6308f1e1cd2fd2b2b3cd4bf	0x476c61ad911d4459891cf2203d2266c07f88b2fc63ae4f119f5a8871d887a150	2024-01-03T12:58:15.000Z	8276909117493757345792	0xe1b19d75ed8fc5813bfe027dc103ef5029fecaf959c2039a48837590bc17808e	0x712228548b2ea07c430b7e2109ca0ca0cb134e6279119fdfbca88b0142683775
0xe22d2bedb3eca35e6397e0c6d62857094aa26f52	false	2	10293912487405914423296	23	42161	1704280472	8740163	23840265150556050995	0x0a6c69327d517568e6308f1e1cd2fd2b2b3cd4bf	0x5d35cf39916bf536860db4bd5bd5606c2bd53d12305c29716617c1b7922bfb83	2024-01-03T08:14:33.000Z	10242442924968883781632	0xae9eb5963235d0fefef06193c4c7e04d4e8a95fa3414775ce47cb7998f62658c	0x64a75619299f884fe11220810e3e7dda752a5b6cf9b40cd9c503b75219dc862b

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

L2Amm_TokenSwap_event

L2AmmETH_TokenSwap_event

L2Bridge_TransferSent_event

L2BridgeETH_TransferSent_event

L2BridgeHOP_TransferSent_event

​Tables

​L2Amm_TokenSwap_event

​L2AmmETH_TokenSwap_event

​L2Bridge_TransferSent_event

​L2BridgeETH_TransferSent_event

​L2BridgeHOP_TransferSent_event

Tables

L2Amm_TokenSwap_event

L2AmmETH_TokenSwap_event

L2Bridge_TransferSent_event

L2BridgeETH_TransferSent_event

L2BridgeHOP_TransferSent_event