Skip to main content

​
Tables

​
L2Gateway_WithdrawalInitiated_event

Token withdrawal events initiated on Arbitrum L2 for bridging assets back to Ethereum L1, capturing sender/recipient addresses, token amounts, L1 token addresses, and unique exit identifiers. Used for tracking cross-chain withdrawal flows and analyzing bridge activity patterns.
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_l1TokenSTRINGContract address of the token on Ethereum Layer 1. Hex-encoded, 0x-prefixed, 42-character string.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_l2ToL1IdSTRINGUnique identifier for this Layer 2 to Layer 1 withdrawal message in the Arbitrum bridge system. Increments sequentially for each withdrawal initiated from Arbitrum to Ethereum mainnet.
in_exitNumSTRINGUnique sequential identifier for this withdrawal within the Arbitrum bridge exit queue. Numeric value that increments with each new withdrawal event, used to track L2-to-L1 message ordering.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_toaddressin_fromremovedin_amountlog_indexin_exitNumin_l1Tokenin_l2ToL1Idblock_numberblock_timestamptransaction_hash
0xc255e0a1be0a4b7b8bf5ebe8d0aba162cf75bae20x07d4692291b9e30e326fd31706f686f83f331b820xc255e0a1be0a4b7b8bf5ebe8d0aba162cf75bae2false58630471177677810499400x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca010308338691912022-10-30T11:14:41.000Z0xa0fc650c0c796fe5bac45fa43b39d2bf091774f156bbbc4e4a24d0c87243bc4d
0x5fb8b9512684d451d4e585a1a0aabfb48a253c670x096760f208390250649e3e8763348e783aef55620x5fb8b9512684d451d4e585a1a0aabfb48a253c67false600000000000000000000469180x0ff5a8451a839f5f0bb3562689d9a44089738d1110094337439882022-10-30T00:49:52.000Z0x88d16554764f9d8c2d5ec8fc939c991cbd867889e8a07a44e697f6a376e2007c
0x2b49ce21ad2004cfb3d0b51b2e8ec0406d6325130x096760f208390250649e3e8763348e783aef55620x2b49ce21ad2004cfb3d0b51b2e8ec0406d632513false34000000000000000000000469260x57b946008913b82e4df85f501cbaed910e58d26c10136337852412022-10-30T04:41:45.000Z0x71c0ba2de432bc1624efa17437b4f2e034f1ee8922a94712edc210aa563278a6
Query with partition filter
SELECT *
FROM `tt-contracts.arbitrumbridge_v1_arbitrum.L2Gateway_WithdrawalInitiated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
L2GatewayRouter_TransferRouted_event

Token bridge routing events from Arbitrum’s L2GatewayRouter contract tracking ERC-20 transfers between Ethereum and Arbitrum. Records which gateway contract handled each token transfer with sender, recipient, and token addresses for analyzing cross-chain asset flows.
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_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in__userFromSTRINGAddress of the user initiating the token transfer through the Arbitrum bridge router. Typically matches in__userTo in sample data, indicating self-transfers or single-party bridge operations.
in__userToSTRINGDestination address receiving tokens on the Arbitrum L2 after the bridge transfer. Hex-encoded, 0x-prefixed 40-character Ethereum address that receives the routed tokens.
in_gatewaySTRINGContract address of the gateway handling this token transfer route on the Arbitrum bridge. Hex-encoded, 0x-prefixed 40-character string representing the specific gateway contract responsible for processing this bridging event.
addressremovedin_tokenlog_indexin__userToin_gatewayblock_numberin__userFromblock_timestamptransaction_hash
0x5288c571fd7ad117bea99bf60fe0846c4e84f933false0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800xd2a02d8e60de0776206ef4c5395ae8f695d78a800x096760f208390250649e3e8763348e783aef5562125599810xd2a02d8e60de0776206ef4c5395ae8f695d78a802022-05-20T13:04:35.000Z0xd01e0e5d79a3d7a6f8a077fe54924f210035ad140dbd42d3482db86bdfb23823
0x5288c571fd7ad117bea99bf60fe0846c4e84f933false0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800x27bedf4431d6127e62986380f37be5f8a963212c0x096760f208390250649e3e8763348e783aef5562125664340x27bedf4431d6127e62986380f37be5f8a963212c2022-05-20T14:35:28.000Z0xec3fa28ab7e4fd515c1921710e376ab4bb17da30221e98b4616f9f551c4f21e0
0x5288c571fd7ad117bea99bf60fe0846c4e84f933false0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800x756497be59e32264539fcb412d3e5848a4bf9ef90x096760f208390250649e3e8763348e783aef5562125510810x756497be59e32264539fcb412d3e5848a4bf9ef92022-05-20T10:39:53.000Z0x94ca925bd501f67b2857b270c390b9988f9cc276a8c7928b3d72674ac67b733c
Query with partition filter
SELECT *
FROM `tt-contracts.arbitrumbridge_v1_arbitrum.L2GatewayRouter_TransferRouted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100