Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_l2SenderSTRINGContract 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_l1ReceiverSTRINGL1 (Ethereum mainnet) address designated to receive the withdrawn tokens after bridge finalization. Typically matches the L2 sender address for same-wallet withdrawals.
in_l2TokenSTRINGContract address of the token on Layer 2. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_amountlog_indexin_l2Tokenin_l2Senderblock_numberin_l1Receiverblock_timestamptransaction_hash
0x11f943b2c77b743ab90f4a0ae7d5a4e7fca3e102false8000000000000000000140x0e97c7a0f8b2c9885c8ac9fc6136e829cbc21d420x6c15222d11f91c91975b5cbf32b3b81ad15eddc9106088710x6c15222d11f91c91975b5cbf32b3b81ad15eddc92023-08-07T09:21:30.000Z0xcc7ac0da1f63be8fd990657dd08a0355cc04fa8c2d1ca8c6ee0b36c23f1e9d78
0x11f943b2c77b743ab90f4a0ae7d5a4e7fca3e102false5148273304846905445580x0e97c7a0f8b2c9885c8ac9fc6136e829cbc21d420x1a5a5c6a1ddc2481395bdcb715d0851470e311bb106073140x1a5a5c6a1ddc2481395bdcb715d0851470e311bb2023-08-07T08:55:09.000Z0x91a8e72e419384d443822896a4010630d87948e09158ecef1aaa3f5f3417bb25
0x11f943b2c77b743ab90f4a0ae7d5a4e7fca3e102false1051485977040x3355df6d4c9c3035724fd0e3914de96a5a83aaf40xb5f96f6286b41d5c444d87cfa7e0fb5877ad8f8e106428910xb5f96f6286b41d5c444d87cfa7e0fb5877ad8f8e2023-08-07T18:54:03.000Z0x59cf95d2912f38c8e6f43cb8e3cb32f982d3d813ccb5eb279ddf2614b93227c7
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