hop_v1_ethereum

Tables

L1Bridge_TransferSentToL2_event

Cross-chain transfer initiation events from Hop Protocol’s Ethereum L1 bridge, capturing token transfers sent to Layer 2 networks including Polygon, Gnosis Chain, and Base. Records include transfer amounts, destination chain IDs, recipient addresses, slippage parameters (amountOutMin), and optional relayer fees for analyzing bridge activity and cross-chain flow patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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_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.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_chainId	in_relayer	in_deadline	block_number	in_recipient	block_timestamp	in_amountOutMin	transaction_hash
0x3666f603cc164936c1b87e207f36beba4ac5f18a	false	26350869	352	100	0x0000000000000000000000000000000000000000	1693791978193	18009952	0x53108ac329d0559428df6b19b150b185936dbf19	2023-08-28T01:46:35.000Z	26219114	0x7805c6db54105dd2859d32db918b8dc4b0877d92e192ea8aef1d99feb64594d4
0x3666f603cc164936c1b87e207f36beba4ac5f18a	false	1601993471	384	100	0x0000000000000000000000000000000000000000	1693834132386	18013446	0x2e73b131d3308333d8b80929994f795b32022635	2023-08-28T13:29:11.000Z	1593983503	0xfb11c694008ff32a2a71cb3cf99282ba4a600a2bffeae7b52f54525225b220c5
0x3666f603cc164936c1b87e207f36beba4ac5f18a	false	1000000000	190	100	0x0000000000000000000000000000000000000000	1693840446854	18013964	0x163e427123125ca77d194634cf7dd39698225393	2023-08-28T15:14:23.000Z	995000000	0x2f4ca12023f693368e895752b763fb6cd870ef0a8af639e971853e2935588eb0

Example Query

Query with partition filter

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

L1BridgeDAI_TransferSentToL2_event

DAI token bridge transfer events from Ethereum L1 to Layer 2 networks via Hop Protocol, capturing cross-chain transfers to Polygon (chainId 137) and Arbitrum (chainId 42161) with transfer amounts, recipients, slippage protection minimums, and optional relayer configurations.

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_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_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.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_chainId	in_relayer	in_deadline	block_number	in_recipient	block_timestamp	in_amountOutMin	transaction_hash
0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1	false	96276864173750000000	258	137	0x0000000000000000000000000000000000000000	1681548558	17044528	0xeeb8825088f87a3efe1804a5f478410c0d09b162	2023-04-14T09:26:23.000Z	91462808006884713198	0x582a3c4af1c52afd46d2160bac2f3f700855fb1a0c28b8d0a3c84ded295c6d9d
0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1	false	9912500000000000000	419	137	0x0000000000000000000000000000000000000000	1681531189	17042939	0x8978849fc3b2e46b2940f9cbb8f67930db68e704	2023-04-14T04:00:11.000Z	9428180952498706193	0xc56e1d4d7f1bf08bcf70265e2e87abdc5dec3920e8013c2ac6e577fbbc18ff64
0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1	false	1135389072057500000000	154	137	0x0000000000000000000000000000000000000000	1681550100	17044476	0x280f19702a5fe91d1e741d570d5b457cf9b40980	2023-04-14T09:15:23.000Z	1078692336273951844567	0xf9f85b97da793f4673f1ecc528e6ec0eab6c431bd8177793a347e12c796736ba

Example Query

Query with partition filter

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

L1BridgeETH_TransferSentToL2_event

ETH bridge transfer events from Hop Protocol’s Ethereum mainnet (L1) contract sending assets to Layer 2 chains like Optimism (chain ID 10). Used for tracking cross-chain ETH transfers including transfer amounts, recipient addresses, relayer fees, and minimum output requirements.

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_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_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.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_chainId	in_relayer	in_deadline	block_number	in_recipient	block_timestamp	in_amountOutMin	transaction_hash
0xb8901acb165ed027e32754e0ffe830802919727f	false	7000000000000000	281	10	0x0000000000000000000000000000000000000000	1660404831	15289542	0x64ebde2e66d3101e12973f407d97fdacbdb5c313	2022-08-06T15:33:53.000Z	6959136133201953	0x8749ce5a076d2e989261b43b520bea6805c877b9ef0ee25fe929327fc95bf558
0xb8901acb165ed027e32754e0ffe830802919727f	false	4800000000000000	55	10	0x0000000000000000000000000000000000000000	1660384491	15288033	0x7ffb4964631d98c796996022056f28c66d386daf	2022-08-06T09:54:57.000Z	4770580498017894	0x9f7dc26d0973f6d3507ac2d1fadf512105aab91cc83cc9f3f466220b6f5c1b23
0xb8901acb165ed027e32754e0ffe830802919727f	false	1000000000000000000	183	10	0x0000000000000000000000000000000000000000	1660379719	15287693	0x77337dfe579a03a07a475870db443d65127f0769	2022-08-06T08:35:49.000Z	994609396680085636	0x48c3837d004948ac82a4c76d76a2957c7b7fef75b9aa6bb8849b44404de22b0c

Example Query

Query with partition filter

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

L1BridgeHOP_TransferSentToL2_event

Cross-chain bridge transfer events from Hop Protocol’s Ethereum Layer 1 (L1) contract, recording token transfers initiated to Layer 2 networks (Optimism chain ID 10, Arbitrum chain ID 42161). Captures transfer amounts, recipient addresses, minimum output amounts, relayer fees, and deadline timestamps for analyzing bridge flow volumes and user migration patterns between Ethereum and L2s.

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_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_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.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_chainId	in_relayer	in_deadline	block_number	in_recipient	block_timestamp	in_amountOutMin	transaction_hash
0x914f986a44acb623a277d6bd17368171fcbe4273	false	32966967887802886312582	96	10	0x881296edcb252080bd476c464ceb521d08df7631	1695732349	18219147	0x0a6c69327d517568e6308f1e1cd2fd2b2b3cd4bf	2023-09-26T09:45:59.000Z	32802133048363870846976	0xa425bb03c1dfe3bf8dbcde851915647d906102afe8ef882a7ab1f4e64ea9bd4b
0x914f986a44acb623a277d6bd17368171fcbe4273	false	30861373004320085347663	293	10	0x881296edcb252080bd476c464ceb521d08df7631	1691871603	17851116	0x1b56403289ce09ed7afe2e11b220cf373cb043a0	2023-08-05T20:20:11.000Z	30707066139298484920924	0x098d93f182f9cd37f206732ebd957b91553a3be3aedae0c6b4ea1260f229131f
0x914f986a44acb623a277d6bd17368171fcbe4273	false	46745224851920307089767	233	42161	0x881296edcb252080bd476c464ceb521d08df7631	1691858987	17850069	0x6baaf66d5e46bea788a28abe8ebbec54108181b1	2023-08-05T16:49:59.000Z	46511498727660705554318	0x360f2b5f292235cdf55434edf5a0552bc96a264ac6d1d18f5da1ca770f595115

Example Query

Query with partition filter

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

L1BridgeMAGIC_TransferSentToL2_event

TransferSentToL2 events from Hop Protocol’s Ethereum L1 bridge contract for MAGIC token transfers to Layer 2 networks (Arbitrum One chain ID 42161, Arbitrum Nova chain ID 42170). Records bridge deposits with transfer amounts, recipients, slippage protection parameters, optional relayer fees, and destination chain identifiers for tracking cross-chain MAGIC token 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_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_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.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_chainId	in_relayer	in_deadline	block_number	in_recipient	block_timestamp	in_amountOutMin	transaction_hash
0xf074540eb83c86211f305e145eb31743e228e57d	false	1436175589887602468271	281	42161	0xa251e7519cbcf76e33d4672d2218e3cbcceb6d60	1692433367	17897567	0xb8d622a8cccff1f4c8955a23ed0e8434bf334675	2023-08-12T08:22:59.000Z	1430344768923437360967	0x3ab0caf70c94102ec7481486bc1e85af3be7a91d4b718bcc311d075fea1278fe
0xf074540eb83c86211f305e145eb31743e228e57d	false	100000000000000000	58	42170	0x0000000000000000000000000000000000000000	0	17480733	0x924ac9910c09a0215b06458653b30471a152022f	2023-06-14T21:04:47.000Z	0	0x3f69273d8d5d4ec46d02c8a54b08dba8c796e28a317c62e6f545eeba143adcae
0xf074540eb83c86211f305e145eb31743e228e57d	false	1369778742085666232035	179	42161	0xa251e7519cbcf76e33d4672d2218e3cbcceb6d60	1696057781	18196939	0x7737d3742ddc67f1443b40cbe6d401d649d3906a	2023-09-23T07:09:47.000Z	1365146867281860527971	0x3bada052f5ae5e7670fd4284d036d79aa3d2485dea389da618cb689278be2a77

Example Query

Query with partition filter

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

L1BridgeMATIC_TransferSentToL2_event

MATIC token transfers initiated from Ethereum (Layer 1) to Polygon (chain ID 137) via the Hop Protocol bridge. Captures transfer amounts, recipient addresses, slippage parameters (amountOutMin), and optional relayer fees for cross-chain bridging analytics.

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_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_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.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_chainId	in_relayer	in_deadline	block_number	in_recipient	block_timestamp	in_amountOutMin	transaction_hash
0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2	false	530700000000000000000	211	137	0x0000000000000000000000000000000000000000	1631300579	13154534	0x533a8499dcf5ad415b8606b6c34cbac7640e03fc	2021-09-03T19:04:29.000Z	528270942968009511500	0x69eca08e2c6850e7498132bd5c1937d84c1964644487ed552d6fe4fa58751915
0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2	false	145396527990000000000	218	137	0x0000000000000000000000000000000000000000	1631246278	13150465	0xb9e95651a78907fd5bb8bc37fc5138669314ed93	2021-09-03T03:58:36.000Z	144701683528322744523	0xcf6e0a035e29cdf42c09fccb4634890a59e4125f1ea9ec27497514d26dac8fea
0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2	false	59888480662308574000	188	137	0x0000000000000000000000000000000000000000	1683920738070	17246030	0x837e44a6552828e97011f2f9dd29ce435150764c	2023-05-12T19:25:59.000Z	59284190506016637976	0xb5b07cb28c67e0884bafdee7563b48f99be96ee625d05455ad4bef90b39ccda3

Example Query

Query with partition filter

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

L1BridgeRETH_TransferSentToL2_event

Hop Protocol V1 rETH (Rocket Pool ETH) bridge transfer events from Ethereum L1 to Layer 2 destinations including Optimism and Arbitrum. Contains transfer amounts, recipient addresses, relayer fees, and minimum output amounts for analyzing cross-chain rETH bridging 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_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_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.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_chainId	in_relayer	in_deadline	block_number	in_recipient	block_timestamp	in_amountOutMin	transaction_hash
0x87269b23e73305117d0404557badc459ced0dbec	false	460212677362178823	410	10	0xd38b96277df34f1f7ac5965f86016e7d02c4ca94	1692102251	17913171	0xae1c38847fb90a13a2a1d7e5552ccd80c62c6508	2023-08-14T12:45:23.000Z	455772966097918017	0x84bd9a099b3041a7abd2e44812dd7e9d3d76a25f38d934135d1558134be905c9
0x87269b23e73305117d0404557badc459ced0dbec	false	762140197888193410	191	10	0xd38b96277df34f1f7ac5965f86016e7d02c4ca94	1692098080	17912722	0x1941ec212c143b19fa708714eea6d9e05fa4a2a5	2023-08-14T11:15:23.000Z	758598381832492169	0xefc706e5f521cd5da9674a6b28b402360a53bd4b921a4c62fdfd8e6c90c6789e
0x87269b23e73305117d0404557badc459ced0dbec	false	700000000000000000	155	42161	0xd38b96277df34f1f7ac5965f86016e7d02c4ca94	1692098010	17912719	0x1941ec212c143b19fa708714eea6d9e05fa4a2a5	2023-08-14T11:14:47.000Z	696318102526676144	0x612b5132d935de1055195775abd7a6b077d3d9bf46eebdb7b04a705ff5f3c63d

Example Query

Query with partition filter

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

L1BridgeSNX_TransferSentToL2_event

SNX token bridge transfers from Ethereum mainnet to Optimism (chain ID 10) via Hop Protocol, capturing amount, recipient, relayer fees, and minimum output parameters for analyzing cross-chain Synthetix token migration 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_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_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.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_chainId	in_relayer	in_deadline	block_number	in_recipient	block_timestamp	in_amountOutMin	transaction_hash
0x893246facf345c99e4235e5a7bbee7404c988b96	false	5538365411987161454761	313	10	0x547d28cdd6a69e3366d6ae3ec39543f09bd09417	1671250364	16151839	0x72159d5ec288cba0aaf7f5b67b8325f440070fff	2022-12-10T04:13:11.000Z	5497997919080846178247	0xa906c7ff0ba2690993ff3189ccfaf7ec36bd8ce2c3e24ea9f594576ecdd9b4f9
0x893246facf345c99e4235e5a7bbee7404c988b96	false	131095794665136772138	50	10	0x547d28cdd6a69e3366d6ae3ec39543f09bd09417	1671287020	16154880	0xf1696ec04262085c24a9c8b86fc7d9bbd14b9dc3	2022-12-10T14:23:59.000Z	130113541521231070674	0x70d68cbd2232dade1829370e8460c245d66b1842606c21cd33cc8f00eda65fb5
0x893246facf345c99e4235e5a7bbee7404c988b96	false	25000000000000000000000	358	10	0x547d28cdd6a69e3366d6ae3ec39543f09bd09417	1671244806	16151380	0x0b4c8694d1832937328f541854317969b86601fc	2022-12-10T02:40:35.000Z	24829323276156262751171	0x49c3cde52e29e3c8b02bd747a43f71b598ceb059252245595efc018f6014286b

Example Query

Query with partition filter

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

L1BridgeSUSD_TransferSentToL2_event

sUSD token bridge transfer events from Ethereum Layer 1 to Optimism (chain ID 10) via Hop Protocol. Tracks bridge amount, recipient address, slippage parameters, and optional relayer details for analyzing cross-chain sUSD 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_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_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.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_chainId	in_relayer	in_deadline	block_number	in_recipient	block_timestamp	in_amountOutMin	transaction_hash
0x36443fc70e073fe9d50425f82a3ee19fef697d62	false	2036670399640929105727	446	10	0x547d28cdd6a69e3366d6ae3ec39543f09bd09417	1683718340	17179919	0xc789026a0f0b15c532c77405491331997f2b2bbc	2023-05-03T11:32:23.000Z	2030359921960304828885	0x1fad710548c4dcf2517ed59eb789353ad83d997211a49b75489abfa0278bc09c
0x36443fc70e073fe9d50425f82a3ee19fef697d62	false	8036504913093173114757	168	10	0x547d28cdd6a69e3366d6ae3ec39543f09bd09417	1688794735	17597188	0xa4cc5fd6f8d58a1a8f89f654cc5797463b8c6c59	2023-07-01T05:39:11.000Z	7973999474665358529896	0x1177cb12dd7bc78e20e4b4f975411bdf2337e885d42d096a7e990df708941934
0x36443fc70e073fe9d50425f82a3ee19fef697d62	false	188605575452129094646	300	10	0x547d28cdd6a69e3366d6ae3ec39543f09bd09417	1694799029	18093197	0xaa30e3f0da0363397c0bcd62636c9ad2c4690e18	2023-09-08T17:30:35.000Z	187696350227315520903	0x1ba0b6aa90d575f735e5bed97a1e4acc436bfbd810ab43ca94a9c9cbf1090bf2

Example Query

Query with partition filter

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

L1BridgeUSDT_TransferSentToL2_event

USDT bridge transfer events from Hop Protocol’s Ethereum L1 bridge contract to Layer 2 networks (Optimism, Polygon). Records cross-chain USDT transfers including amounts, destination chains, recipients, slippage parameters, and optional relayer details for analyzing bridge flow patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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_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.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_chainId	in_relayer	in_deadline	block_number	in_recipient	block_timestamp	in_amountOutMin	transaction_hash
0x3e4a3a4796d16c0cd582c382691998f7c06420b6	false	140037110	378	10	0x0000000000000000000000000000000000000000	1694126557073	18037605	0x7dd1ff5a759706e8ff5ae0a64986653f6b157dad	2023-08-31T22:42:59.000Z	139215164	0x1083e9f4ae9e2d05319d0ca7a39abf3821e0771fd7d0acd17162d4015bdc565e
0x3e4a3a4796d16c0cd582c382691998f7c06420b6	false	1000000	222	137	0x0000000000000000000000000000000000000000	1694130559757	18037935	0x2ea5c5b4ce93ab06e199449eee48e0561834c327	2023-08-31T23:49:35.000Z	995000	0x8fc95c5d7d4217726542fc66f308e2213fb2a7f7633c94e2a6543217539fd1ed
0x3e4a3a4796d16c0cd582c382691998f7c06420b6	false	1000085007	220	137	0x0000000000000000000000000000000000000000	1694081033463	18033840	0x6f23d9c2417f66de8ba085265d159142cb060af2	2023-08-31T10:04:11.000Z	995957078	0x94928fe9695763cf0e7198b8c539eb800925f85b9d2bccdff63cb699f3553c76

Example Query

Query with partition filter

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

L1BridgeWBTC_TransferSentToL2_event

Ethereum mainnet (L1) events recording WBTC transfers initiated through Hop Protocol bridge to Layer 2 destinations including Arbitrum, Optimism, Polygon, and Gnosis Chain. Contains transfer amounts, recipient addresses, destination chain identifiers, relayer fee parameters, and deadline timestamps for analyzing cross-chain WBTC flow patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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_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.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFee`	`STRING`	Fee paid to the relayer for executing the cross-chain transaction. Numeric string representation of the fee amount in the token’s smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_chainId	in_relayer	in_deadline	block_number	in_recipient	block_timestamp	in_amountOutMin	transaction_hash
0xb98454270065a31d71bf635f6f7ee6a518dfb849	false	1000	466	42161	0x0000000000000000000000000000000000000000	9999999999	14578752	0xfefec7d3eb14a004029d278393e6ab8b46fb4fca	2022-04-13T18:30:21.000Z	1	0x0b6729270e5fe2829f02a61bc8a1a26398819eecbef79887de9d47a193b5e9ab
0xb98454270065a31d71bf635f6f7ee6a518dfb849	false	100	565	137	0x0000000000000000000000000000000000000000	0	14077787	0xfefec7d3eb14a004029d278393e6ab8b46fb4fca	2022-01-25T23:34:45.000Z	0	0x3fa15164b46900c26083a82a53d3a61743f90563b5de8ea6336c853a2caaed8b
0xb98454270065a31d71bf635f6f7ee6a518dfb849	false	1000	68	10	0x0000000000000000000000000000000000000000	0	13477589	0x924ac9910c09a0215b06458653b30471a152022f	2021-10-24T02:42:01.000Z	0	0xa024cb78a701f86183aba4cd8e4163a2bd32ffc5d432195d03b334aeda06382d

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

L1Bridge_TransferSentToL2_event

L1BridgeDAI_TransferSentToL2_event

L1BridgeETH_TransferSentToL2_event

L1BridgeHOP_TransferSentToL2_event

L1BridgeMAGIC_TransferSentToL2_event

L1BridgeMATIC_TransferSentToL2_event

L1BridgeRETH_TransferSentToL2_event

L1BridgeSNX_TransferSentToL2_event

L1BridgeSUSD_TransferSentToL2_event

L1BridgeUSDT_TransferSentToL2_event

L1BridgeWBTC_TransferSentToL2_event

​Tables

​L1Bridge_TransferSentToL2_event

​L1BridgeDAI_TransferSentToL2_event

​L1BridgeETH_TransferSentToL2_event

​L1BridgeHOP_TransferSentToL2_event

​L1BridgeMAGIC_TransferSentToL2_event

​L1BridgeMATIC_TransferSentToL2_event

​L1BridgeRETH_TransferSentToL2_event

​L1BridgeSNX_TransferSentToL2_event

​L1BridgeSUSD_TransferSentToL2_event

​L1BridgeUSDT_TransferSentToL2_event

​L1BridgeWBTC_TransferSentToL2_event

Tables

L1Bridge_TransferSentToL2_event

L1BridgeDAI_TransferSentToL2_event

L1BridgeETH_TransferSentToL2_event

L1BridgeHOP_TransferSentToL2_event

L1BridgeMAGIC_TransferSentToL2_event

L1BridgeMATIC_TransferSentToL2_event

L1BridgeRETH_TransferSentToL2_event

L1BridgeSNX_TransferSentToL2_event

L1BridgeSUSD_TransferSentToL2_event

L1BridgeUSDT_TransferSentToL2_event

L1BridgeWBTC_TransferSentToL2_event