zksyncerabridge_v1_ethereum

Tables

Diamond_EthWithdrawalFinalized_event

ETH withdrawal completion events from zkSync Era bridge on Ethereum mainnet, recording finalized withdrawals with recipient addresses and amounts in wei. Used for tracking cross-chain ETH transfers from zkSync Era L2 to Ethereum L1.

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_to`	`STRING`	Destination address receiving tokens or assets in the 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.

Sample Data

in_to	address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x02b6b0964fdb4a42ecacfecd69bf4d7f02fd55a1	0x32400084c286cf3e17e7b677ea9583e60a000324	false	1000000000000	128	17028509	2023-04-12T00:54:35.000Z	0x03a3f03f597f8e8f3830f27101408558d4f6f3afb99148063db0224754bd812a
0x7078c60e5a2ce8c300f9d3ba63951757c1661abd	0x32400084c286cf3e17e7b677ea9583e60a000324	false	1000000000000000000	127	17028509	2023-04-12T00:54:35.000Z	0x03a3f03f597f8e8f3830f27101408558d4f6f3afb99148063db0224754bd812a
0x85160a3d89cdd71a8c7eb28f57e0900f8467a5de	0x32400084c286cf3e17e7b677ea9583e60a000324	false	100000000000000	122	17028509	2023-04-12T00:54:35.000Z	0x03a3f03f597f8e8f3830f27101408558d4f6f3afb99148063db0224754bd812a

Example Query

Query with partition filter

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

Diamond_finalizeEthWithdrawal_function

Ethereum Layer 1 (L1) withdrawal finalization transactions for zkSync Era bridge, containing merkle proofs and Layer 2 (L2) message metadata for users claiming ETH from the zkSync rollup. Used for tracking bridge withdrawal completions and analyzing cross-layer fund 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__l2BlockNumber`	`STRING`	Block number on zkSync Era Layer 2 where the withdrawal was initiated. References the L2 block containing the original withdrawal transaction that is being finalized on Ethereum L1.
`in__l2MessageIndex`	`STRING`	Index position of the withdrawal message within the zkSync Era L2 block’s message queue. Used with block number and transaction number to uniquely identify the withdrawal for merkle proof verification.
`in__l2TxNumberInBlock`	`STRING`	Transaction index within the zkSync Era Layer 2 block that initiated this withdrawal. Represented as a string-formatted integer, typically ranging from double to triple digits.
`in__message`	`STRING`	Encoded withdrawal message data from the zkSync Era L2 transaction being finalized on Ethereum L1. Includes the function signature (0x6c0960f9) followed by the recipient address and withdrawal amount in hex format.
`in__merkleProof`	`ARRAY<STRING>`	Array of hex-encoded hash values forming the Merkle proof path to verify the L2 withdrawal message’s inclusion in the zkSync Era state root. Used cryptographically to authenticate the withdrawal request from Layer 2 to Ethereum mainnet.

Sample Data

gas	status	gas_used	signature	to_address	in__message	block_number	from_address	trace_address	block_timestamp	in__merkleProof	transaction_hash	in__l2BlockNumber	in__l2MessageIndex	in__l2TxNumberInBlock
295563	true	64312	0x6c0960f9	0x32400084c286cf3e17e7b677ea9583e60a000324	0x6c0960f9ad9595c8b1dcf4cb5b1ef98d1980783c8f899ace000000000000000000000000000000000000000000000000000ddb07829fc000	18750464	0xf8a16864d8de145a266a534174305f881ee2315e	0	2023-12-09T18:31:11.000Z	[“0x5b2f27568ba9a1bec2f92e1d5e54313986c76b4a94c238fe09903f2fda0b2bd9”,“0xc3d03eebfd83049991ea3d3e358b6712e7aa2e2e63dc2d4b438987cec28ac8d0”,“0xe3697c7f33c31a9b0f0aeb8542287d0d21e8c4cf82163d0c44c7a98aa11aa111”,“0x199cc5812543ddceeddd0fc82807646a4899444240db2c0d2f20c3cceb5f51fa”,“0xe4733f281f18ba3ea8775dd62d2fcd84011c8c938f16ea5790fd29a03bf8db89”,“0x1798a1fd9c8fbb818c98cff190daa7cc10b6e5ac9716b4a2649f7c2ebcef2272”,“0x66d7c5983afe44cf15ea8cf565b34c6c31ff0cb4dd744524f7842b942d08770d”,“0xb04e5ee349086985f74b73971ce9dfe76bbed95c84906c5dffd96504e1e5396c”,“0xac506ecb5465659b3a927143f6d724f91d8d9c4bdb2463aee111d9aa869874db”,“0x124b05ec272cecd7538fdafe53b6628d31188ffb6f345139aac3c3c1fd2e470f”,“0xc3be9cbd19304d84cca3d045e06b8db3acd68c304fc9cd4cbffe6d18036cb13f”]	0xb833b587d0f8ab8b1e8c884dd2aae731b4d939e298491674f6ae4a6fd611c620	336785	0	168
298074	true	70323	0x6c0960f9	0x32400084c286cf3e17e7b677ea9583e60a000324	0x6c0960f96848c057c06809a2a8e38c1e2e839486b510867b00000000000000000000000000000000000000000000000000036ddcfd68e4a1	18746883	0xf8a16864d8de145a266a534174305f881ee2315e	1	2023-12-09T06:27:59.000Z	[“0x4c4924f5cd9c30ac7e0d1e62b20771f4ae4f7c3f39ddf5379eaea7728ccf3cdd”,“0xc3d03eebfd83049991ea3d3e358b6712e7aa2e2e63dc2d4b438987cec28ac8d0”,“0xe3697c7f33c31a9b0f0aeb8542287d0d21e8c4cf82163d0c44c7a98aa11aa111”,“0x199cc5812543ddceeddd0fc82807646a4899444240db2c0d2f20c3cceb5f51fa”,“0xe4733f281f18ba3ea8775dd62d2fcd84011c8c938f16ea5790fd29a03bf8db89”,“0x1798a1fd9c8fbb818c98cff190daa7cc10b6e5ac9716b4a2649f7c2ebcef2272”,“0x66d7c5983afe44cf15ea8cf565b34c6c31ff0cb4dd744524f7842b942d08770d”,“0xb04e5ee349086985f74b73971ce9dfe76bbed95c84906c5dffd96504e1e5396c”,“0xac506ecb5465659b3a927143f6d724f91d8d9c4bdb2463aee111d9aa869874db”,“0x124b05ec272cecd7538fdafe53b6628d31188ffb6f345139aac3c3c1fd2e470f”,“0xc3be9cbd19304d84cca3d045e06b8db3acd68c304fc9cd4cbffe6d18036cb13f”]	0x498aae31848214bf5edf9fa2b1aebe66654545b3708080403fe80603e780f419	336245	1	405
300000	true	89312	0x6c0960f9	0x32400084c286cf3e17e7b677ea9583e60a000324	0x6c0960f9aa5fecfe5b36f5ec20ecf9c2be9dffa94eceeaec0000000000000000000000000000000000000000000000000003451d3e5951b4	18746883	0xf8a16864d8de145a266a534174305f881ee2315e	0	2023-12-09T06:27:59.000Z	[“0x2f7e30d2fe80642466f3019e3f79a11a2625bb9b49fed13b6446f6f9aa764733”,“0xc3d03eebfd83049991ea3d3e358b6712e7aa2e2e63dc2d4b438987cec28ac8d0”,“0xe3697c7f33c31a9b0f0aeb8542287d0d21e8c4cf82163d0c44c7a98aa11aa111”,“0x199cc5812543ddceeddd0fc82807646a4899444240db2c0d2f20c3cceb5f51fa”,“0xe4733f281f18ba3ea8775dd62d2fcd84011c8c938f16ea5790fd29a03bf8db89”,“0x1798a1fd9c8fbb818c98cff190daa7cc10b6e5ac9716b4a2649f7c2ebcef2272”,“0x66d7c5983afe44cf15ea8cf565b34c6c31ff0cb4dd744524f7842b942d08770d”,“0xb04e5ee349086985f74b73971ce9dfe76bbed95c84906c5dffd96504e1e5396c”,“0xac506ecb5465659b3a927143f6d724f91d8d9c4bdb2463aee111d9aa869874db”,“0x124b05ec272cecd7538fdafe53b6628d31188ffb6f345139aac3c3c1fd2e470f”,“0xc3be9cbd19304d84cca3d045e06b8db3acd68c304fc9cd4cbffe6d18036cb13f”]	0x498aae31848214bf5edf9fa2b1aebe66654545b3708080403fe80603e780f419	336245	0	76

Example Query

Query with partition filter

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

Diamond_NewPriorityRequest_event

Priority request events from zkSync Era’s Diamond contract on Ethereum L1, capturing cross-chain transactions queued for execution on zkSync with transaction details, gas parameters, and expiration timestamps.

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_txId`	`STRING`	Transaction identifier for the cross-chain or layer-2 operation. 66-character hex string including 0x prefix.
`in_txHash`	`STRING`	Transaction hash of the priority request on zkSync Era as emitted by the bridge contract. Hex-encoded, 0x-prefixed 64-character string identifier for the L2 transaction.
`in_expirationTimestamp`	`STRING`	Unix timestamp indicating when the priority request expires and can no longer be processed by the zkSync Era bridge. Represents the deadline for L2 transaction inclusion after being submitted on L1 Ethereum.
`in_transaction`	`STRUCT<txType STRING,` from`STRING,`to `STRING, gasLimit STRING, gasPerPubdataByteLimit STRING, maxFeePerGas STRING, maxPriorityFeePerGas STRING, paymaster STRING, nonce STRING, value STRING, reserved ARRAY<STRING>, data STRING, signature STRING, factoryDeps ARRAY<STRING>, paymasterInput STRING, reservedDynamic STRING>`	Structured record containing the zkSync Era L2 transaction details submitted as a priority request from Ethereum L1. Includes transaction parameters like sender, recipient, value, gas settings, nonce, and zkSync-specific fields such as gasPerPubdataByteLimit and factory dependencies.
`in_factoryDeps`	`ARRAY<STRING>`	Array of factory dependency bytecode hashes required to deploy contracts within this zkSync Era priority transaction. Typically empty for simple transfers; populated when deploying smart contracts that depend on other contracts.

Sample Data

address	in_txId	removed	in_txHash	log_index	block_number	in_factoryDeps	in_transaction	block_timestamp	transaction_hash	in_expirationTimestamp
0x32400084c286cf3e17e7b677ea9583e60a000324	616928	false	0x1117c9b9bceff5611a39764e1f2c028e7ad10841d5de1b98a9608e55eb9202b9	256	17218033	[]	28188516871530704	2023-05-08T20:05:47.000Z	0x26cd1f1e94391ea77aa6ceb6f5f2f84c3943bf066a3d1f16008a1bfb32db0acd	1683576347
0x32400084c286cf3e17e7b677ea9583e60a000324	616655	false	0xa602f79d1cdc2e07f70ed1c5624b7b16050d2a6bad5a6a64cf6e3a12de2362f0	256	17215833	[]	350000000000000000	2023-05-08T12:40:11.000Z	0xdcce24d9f26992a5959a61cd6592fefc1d612d8ec727861c749cbcfddb1a4284	1683549611
0x32400084c286cf3e17e7b677ea9583e60a000324	616175	false	0x9b28bfb4eb77bca55547791ec4316b498e90035a2b363b02ed312528ac40b291	257	17213401	[]	92214446903286242	2023-05-08T04:28:59.000Z	0xfd763a361ce3d90bdd1be5624a480db3160501be1e4a6b8b303b9e0c3e5e0f61	1683520139

Example Query

Query with partition filter

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

Diamond_requestL2Transaction_function

Failed L1-to-L2 transaction requests on zkSync Era’s Diamond proxy contract from Ethereum mainnet. Contains bridge deposit attempts with gas parameters and ETH values for analyzing cross-chain transaction failures and user behavior.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__contractL2`	`STRING`	Target contract address on zkSync Era L2 where the bridged transaction will be executed. Null values indicate failed transaction requests that did not complete L2 contract specification.
`in__l2Value`	`STRING`	ETH value to be sent to the target contract on the zkSync Era L2 chain, denominated in wei. Null in sample data suggests optional parameter for cross-chain transaction requests.
`in__calldata`	`STRING`	Calldata payload to be executed on the L2 contract after the transaction is bridged to zkSync Era. Null in sample rows indicates transactions without additional execution instructions beyond the value transfer.
`in__l2GasLimit`	`STRING`	Gas limit allocated for executing the transaction on the zkSync Era L2 network, specified by the user initiating the bridge transaction. Null in the provided samples, indicating optional or default gas limit behavior.
`in__l2GasPerPubdataByteLimit`	`STRING`	Gas price limit per byte of public data published to L1 for this zkSync Era L2 transaction request. Null values indicate the parameter was not specified in failed transaction requests.
`in__factoryDeps`	`ARRAY<STRING>`	Array of bytecode hashes for smart contracts that need to be deployed on zkSync Era L2 before executing the transaction. Typically empty for simple transfers; populated when deploying contracts or interacting with factory patterns.
`in__refundRecipient`	`STRING`	Ethereum address designated to receive refunds for unused gas from the zkSync Era L2 transaction. Null in sample data suggests this parameter is optional or typically not set for standard bridge transactions.
`out_canonicalTxHash`	`STRING`	Transaction hash of the resulting L2 transaction created on zkSync Era after the bridge request is processed. Null when the L1 transaction failed (status false) before successfully initiating the L2 transaction.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	in__factoryDeps	transaction_hash
577148	5000000000000000	false	24028	0xeb672419	0x32400084c286cf3e17e7b677ea9583e60a000324	16644828	0x250302de8c3a0443dffc8e25f5d5d276ff5cde7f	2023-02-17T00:19:23.000Z	[]	0x22fae68750bd0346e8b240198fe2611fb46122497f9996c4c39c44dbf843bf10
577136	5753798010464430	false	24028	0xeb672419	0x32400084c286cf3e17e7b677ea9583e60a000324	16646319	0x3d651e2d837c81ca0ca68f7d39237e6e7354c80f	2023-02-17T05:19:59.000Z	[]	0x1350e16cfb101bee20892d22d8cac08ef7dbf7001a15003d6a397bb3540a5e73
577136	1729659579246863	false	24028	0xeb672419	0x32400084c286cf3e17e7b677ea9583e60a000324	16646014	0x614ee92f226701dcf79eab668ab76a5bcd82aaec	2023-02-17T04:18:47.000Z	[]	0x4a21b340607a8445d5bd7eaf5bf43b3bc34309bb05afc48b789051821fe2ef15

Example Query

Query with partition filter

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

L1ERC20Bridge_DepositInitiated_event

ERC-20 token deposit events initiated on Ethereum Layer 1 (L1) for bridging to zkSync Era Layer 2 (L2), capturing token address, amount, sender, recipient, and corresponding L2 transaction hash. Used for tracking cross-layer token transfers and reconciling bridge activity between Ethereum mainnet and zkSync Era.

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_l2DepositTxHash`	`STRING`	Transaction hash of the corresponding deposit transaction created on zkSync Era L2. Hex-encoded, 0x-prefixed 64-character string that uniquely identifies the L2 side of this bridge deposit.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. 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.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	in_l1Token	block_number	block_timestamp	transaction_hash	in_l2DepositTxHash
0x438e1879c38b92e235e9791e13972d6c742c7038	0x57891966931eb4bb6fb81430e6ce0a03aabde063	0x438e1879c38b92e235e9791e13972d6c742c7038	false	3389540178170308346187	125	0x111111111117dc0aa78b770fa6a738034120c302	18030411	2023-08-30T22:32:47.000Z	0xbfc1a87c48de592b13b50caf8d91c6c524d1d539492c8b90c733ed3d10198522	0x08d76d9dd6f4e2c04f65a11cb5fc80b90877f5d54520ea9a627369a44ae1b6aa
0x109b458547bea6339cd9aa7e3ea190653685e829	0x57891966931eb4bb6fb81430e6ce0a03aabde063	0x109b458547bea6339cd9aa7e3ea190653685e829	false	3280000	307	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18026039	2023-08-30T07:50:11.000Z	0x267fb99e6ccfa8a811c88bedabc77dfd370a7dd5a5dfb8a778264d1535eb8614	0xd5eb131196b8c3fbcc094ad432c0a8c715184ef20a0847645e2468438906cdc9
0x3441c373486a1d7e81c73f40cb010767e945c200	0x57891966931eb4bb6fb81430e6ce0a03aabde063	0x3441c373486a1d7e81c73f40cb010767e945c200	false	3480000	94	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18025521	2023-08-30T06:05:35.000Z	0xa25fbf2cb2c235b43fcd49459db32e6f2a4349714a70b75d8a5a723c9311b630	0xffb2d71cf7a0e7bb1dda669c170af12c5064b8a9eda6b9cdd52880e521692865

Example Query

Query with partition filter

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

L1ERC20Bridge_WithdrawalFinalized_event

Completed ERC-20 token withdrawals from zkSync Era back to Ethereum mainnet (Layer 1), recording the recipient address, token contract, and withdrawal amount. Useful for tracking cross-chain asset flows and bridge liquidity 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. 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.

Sample Data

in_to	address	removed	in_amount	log_index	in_l1Token	block_number	block_timestamp	transaction_hash
0x90c5f7408360fe2734af14689b4ba6a973285568	0x57891966931eb4bb6fb81430e6ce0a03aabde063	false	600000	71	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	18567937	2023-11-14T05:04:59.000Z	0xb15db42ad8a4131eed12d7d1f5d0abcff77625c240f639d8a770b0c487e8dc95
0x3dc40d707e22be5c670f6c7a5a7878aedda7ca17	0x57891966931eb4bb6fb81430e6ce0a03aabde063	false	5500000000	10	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	18567938	2023-11-14T05:05:11.000Z	0xf6abcefe8faa974c4fcc33955d3bdf24722b5c506dad088fea88a1e412842ad2
0xcb178d2e50478ba2a1921fc60d3913bd170d8b9d	0x57891966931eb4bb6fb81430e6ce0a03aabde063	false	1000000	30	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	18567938	2023-11-14T05:05:11.000Z	0xf6abcefe8faa974c4fcc33955d3bdf24722b5c506dad088fea88a1e412842ad2

Example Query

Query with partition filter

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

L1SharedBridge_BridgehubDepositBaseTokenInitiated_event

Base token deposit events initiated from Ethereum L1 to zkSync Era (chain ID 324) through the L1SharedBridge contract. Tracks native ETH and token transfers with depositor addresses, amounts, and destination chain information for analyzing cross-chain 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. 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.

Sample Data

address	in_from	removed	in_amount	log_index	in_chainId	in_l1Token	block_number	block_timestamp	transaction_hash
0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	0x0fc9a195a2139b7ac97f8a5264c42d5446beba0b	false	34247589611403661	302	324	0x0000000000000000000000000000000000000001	20213670	2024-07-01T19:10:35.000Z	0xf1f15e891f51db971f3cad86e5847b258382851492936b94c72b5316cf5e1b69
0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	0x142e721dde3b8db2b8f1eaa8bd633858e74c8319	false	33921339117242720	239	324	0x0000000000000000000000000000000000000001	20213911	2024-07-01T19:58:59.000Z	0xc47ff2ad3c029a639d81466d99dfe6ce4cbf38a7e9a1cd0646f4aeadeef21ab2
0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	0x196e7bcc060303cf386e40095a111277f6c91f3b	false	2626607196651845	96	324	0x0000000000000000000000000000000000000001	20215096	2024-07-01T23:56:47.000Z	0x910c683acb224c4944fd083280801da9f4b81cb28d88489010521b958d57dbf9

Example Query

Query with partition filter

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

L1SharedBridge_BridgehubDepositFinalized_event

Ethereum Layer 1 (L1) events emitted when deposits to zkSync Era chains are finalized through the shared bridge contract, linking L1 transaction hashes to their corresponding L2 deposit transaction hashes. Used for tracking cross-chain deposit completion and reconciling bridge operations across zkSync Era (chain 324) and Cronos zkEVM (chain 388).

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_txDataHash`	`STRING`	Transaction data hash for the deposit operation on Layer 1. This hash identifies the specific deposit transaction details processed by the zkSync Era bridge.
`in_l2DepositTxHash`	`STRING`	Transaction hash of the corresponding deposit transaction on the L2 chain (zkSync Era). Hex-encoded, 0x-prefixed 64-character string representing the Layer 2 transaction that processes this finalized bridge deposit.

Sample Data

address	removed	log_index	in_chainId	block_number	in_txDataHash	block_timestamp	transaction_hash	in_l2DepositTxHash
0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	false	289	324	21256795	0x325a77f1eac39cc3eb2cc9a47722a987d09b6267277d7c1070e48a291b58d4ab	2024-11-24T09:45:23.000Z	0xbc244de4fac72946e1314588a93b7c65ce5b68e59df7cea69c5cd397d6eae222	0x6a4adf0e6628f7f881ccded6bb0a56e3caa684a48240c824278ae840dfeaebcc
0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	false	52	388	21259184	0x6e39cb9abad141200d45840cc426a17dfe6ef2a29246439e1cf59b3cdb90a427	2024-11-24T17:46:11.000Z	0xdef3809ee85931509ec3daf219d090db7f0fa46088ad65f7c347af01efe69616	0xf407933a570a8d03dffe04a2779521bb4429937817ff4a158b95d80f18e48a1f
0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	false	80	388	21257083	0x58df94125977d530ba7968051aac4bc1bf5e047c68a1401533d3f3d824490bcf	2024-11-24T10:42:59.000Z	0x386dcf2d2bb3c01f963c58b73a415db76b6d93c6a9c6bfed7ad88785876fb9e5	0xaeed0441e0da86869fea4e61179d20ddc0bc5c75f691993b00e2a9d66e64e550

Example Query

Query with partition filter

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

L1SharedBridge_BridgehubDepositInitiated_event

Deposit initiation events from zkSync Era’s L1 shared bridge contract on Ethereum, capturing token transfers bridged to zkSync chains. Records sender/recipient addresses, token amounts, L1 token contracts (USDC, USDT), and destination chain identifiers for tracking cross-chain deposit 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_txDataHash`	`STRING`	Hash of the transaction data being bridged from L1 to the destination zkSync Era chain. Used to track and verify the deposit transaction across the bridging process.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. 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.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	in_chainId	in_l1Token	block_number	in_txDataHash	block_timestamp	transaction_hash
0x01018fe8bb93ea88bb499f55c3273859a98e9edc	0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	0x01018fe8bb93ea88bb499f55c3273859a98e9edc	false	10000000	534	543210	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	21044984	0xdbf74ebb54686f18c8896322a6b284a0b3cb232628e074e8b475f38dda50b1e6	2024-10-25T20:20:59.000Z	0x8f5ebcc0084dea931c929b56d354845cc1ae79be918764fd8cb4be9282c4d734
0x1a9b315367fc746b479dbb6a143a10cd4642aad8	0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	0x1a9b315367fc746b479dbb6a143a10cd4642aad8	false	10000000000	308	324	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	21041441	0xea4181af305e3745b18dfd051a84a62c6158d15d4bd4950027f178a4c4bb5aae	2024-10-25T08:29:47.000Z	0x9618acfdb81bdeef72edfc19936c0c1950245b8ee5be1284fff03ad595eef9dd
0x93fe98a915580dfa9ad763804e6b0d7940409be9	0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	0x93fe98a915580dfa9ad763804e6b0d7940409be9	false	100205000000	502	324	0xdac17f958d2ee523a2206206994597c13d831ec7	21045277	0x3765ad91e61a4425d3384d3ba4d49dd064a4e3bd4cbe6b514771d69821ee622d	2024-10-25T21:19:35.000Z	0xc2e04fc6ea01e2de3168a4e271b0f8398393cadb8b7a582eea8be51efc33345d

Example Query

Query with partition filter

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

L1SharedBridge_WithdrawalFinalizedSharedBridge_event

Completed withdrawal events from zkSync Era bridge on Ethereum L1, recording token transfers finalized from zkSync Era (chain ID 324) to recipient addresses. Used for tracking bridge withdrawal completions and analyzing cross-chain asset 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. 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.

Sample Data

in_to	address	removed	in_amount	log_index	in_chainId	in_l1Token	block_number	block_timestamp	transaction_hash
0xa345ff272e1d1e401c6fea6a8e739affff2f905a	0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	false	2818142256235950	700	324	0x0000000000000000000000000000000000000001	21350435	2024-12-07T11:52:11.000Z	0x90589af69d6b3770abc9975bf1727ac59bde4b84a07db9adc68159f11e5a1b9a
0xa66d96992f116f28821a3a306bf64f08fec5ceca	0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	false	6800000000000000	747	324	0x0000000000000000000000000000000000000001	21353375	2024-12-07T21:44:47.000Z	0xb13a58dcf4117f8e52fb2563445a438c1ee5553f476b0ae8fd643ec3043730c6
0xe006ec1522ffd27ad866e934e8c16b3b116cdc0f	0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	false	6800000000000000	213	324	0x0000000000000000000000000000000000000001	21353386	2024-12-07T21:46:59.000Z	0x3f9d865483ad55dee4d8dbe3509abdc1bfe1ec5ca7cc1c6e3da23b8f7865cf53

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Diamond_EthWithdrawalFinalized_event

Diamond_finalizeEthWithdrawal_function

Diamond_NewPriorityRequest_event

Diamond_requestL2Transaction_function

L1ERC20Bridge_DepositInitiated_event

L1ERC20Bridge_WithdrawalFinalized_event

L1SharedBridge_BridgehubDepositBaseTokenInitiated_event

L1SharedBridge_BridgehubDepositFinalized_event

L1SharedBridge_BridgehubDepositInitiated_event

L1SharedBridge_WithdrawalFinalizedSharedBridge_event

​Tables

​Diamond_EthWithdrawalFinalized_event

​Diamond_finalizeEthWithdrawal_function

​Diamond_NewPriorityRequest_event

​Diamond_requestL2Transaction_function

​L1ERC20Bridge_DepositInitiated_event

​L1ERC20Bridge_WithdrawalFinalized_event

​L1SharedBridge_BridgehubDepositBaseTokenInitiated_event

​L1SharedBridge_BridgehubDepositFinalized_event

​L1SharedBridge_BridgehubDepositInitiated_event

​L1SharedBridge_WithdrawalFinalizedSharedBridge_event

Tables

Diamond_EthWithdrawalFinalized_event

Diamond_finalizeEthWithdrawal_function

Diamond_NewPriorityRequest_event

Diamond_requestL2Transaction_function

L1ERC20Bridge_DepositInitiated_event

L1ERC20Bridge_WithdrawalFinalized_event

L1SharedBridge_BridgehubDepositBaseTokenInitiated_event

L1SharedBridge_BridgehubDepositFinalized_event

L1SharedBridge_BridgehubDepositInitiated_event

L1SharedBridge_WithdrawalFinalizedSharedBridge_event