Tables
L2ERC20Bridge_WithdrawalInitiated_event
ERC-20 token withdrawal initiation events from zkSync Era’s Layer 2 bridge to Ethereum Layer 1, capturing token address, amount, sender on L2, and recipient on L1 for tracking cross-chain asset movements.Columns
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_l2Sender | STRING | Contract address of the user initiating the withdrawal on zkSync Era L2. Hex-encoded, 0x-prefixed 40-character Ethereum address that often matches the L1 receiver address. |
in_l1Receiver | STRING | L1 (Ethereum mainnet) address designated to receive the withdrawn tokens after bridge finalization. Typically matches the L2 sender address for same-wallet withdrawals. |
in_l2Token | STRING | Contract address of the token on Layer 2. 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
Sample Data
| address | removed | in_amount | log_index | in_l2Token | in_l2Sender | block_number | in_l1Receiver | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x11f943b2c77b743ab90f4a0ae7d5a4e7fca3e102 | false | 8000000000000000000 | 14 | 0x0e97c7a0f8b2c9885c8ac9fc6136e829cbc21d42 | 0x6c15222d11f91c91975b5cbf32b3b81ad15eddc9 | 10608871 | 0x6c15222d11f91c91975b5cbf32b3b81ad15eddc9 | 2023-08-07T09:21:30.000Z | 0xcc7ac0da1f63be8fd990657dd08a0355cc04fa8c2d1ca8c6ee0b36c23f1e9d78 |
| 0x11f943b2c77b743ab90f4a0ae7d5a4e7fca3e102 | false | 5148273304846905445 | 58 | 0x0e97c7a0f8b2c9885c8ac9fc6136e829cbc21d42 | 0x1a5a5c6a1ddc2481395bdcb715d0851470e311bb | 10607314 | 0x1a5a5c6a1ddc2481395bdcb715d0851470e311bb | 2023-08-07T08:55:09.000Z | 0x91a8e72e419384d443822896a4010630d87948e09158ecef1aaa3f5f3417bb25 |
| 0x11f943b2c77b743ab90f4a0ae7d5a4e7fca3e102 | false | 10514859770 | 4 | 0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4 | 0xb5f96f6286b41d5c444d87cfa7e0fb5877ad8f8e | 10642891 | 0xb5f96f6286b41d5c444d87cfa7e0fb5877ad8f8e | 2023-08-07T18:54:03.000Z | 0x59cf95d2912f38c8e6f43cb8e3cb32f982d3d813ccb5eb279ddf2614b93227c7 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.zksyncerabridge_v1_zksyncera.L2ERC20Bridge_WithdrawalInitiated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100