arbitrumbridge_v1_arbitrum

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.

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_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. Hex-encoded, 0x-prefixed, 42-character string.
`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_l2ToL1Id`	`STRING`	Unique 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_exitNum`	`STRING`	Unique 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_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_exitNum	in_l1Token	in_l2ToL1Id	block_number	block_timestamp	transaction_hash
0xc255e0a1be0a4b7b8bf5ebe8d0aba162cf75bae2	0x07d4692291b9e30e326fd31706f686f83f331b82	0xc255e0a1be0a4b7b8bf5ebe8d0aba162cf75bae2	false	58630471177677810499	4	0	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	10308	33869191	2022-10-30T11:14:41.000Z	0xa0fc650c0c796fe5bac45fa43b39d2bf091774f156bbbc4e4a24d0c87243bc4d
0x5fb8b9512684d451d4e585a1a0aabfb48a253c67	0x096760f208390250649e3e8763348e783aef5562	0x5fb8b9512684d451d4e585a1a0aabfb48a253c67	false	600000000000000000000	4	6918	0x0ff5a8451a839f5f0bb3562689d9a44089738d11	10094	33743988	2022-10-30T00:49:52.000Z	0x88d16554764f9d8c2d5ec8fc939c991cbd867889e8a07a44e697f6a376e2007c
0x2b49ce21ad2004cfb3d0b51b2e8ec0406d632513	0x096760f208390250649e3e8763348e783aef5562	0x2b49ce21ad2004cfb3d0b51b2e8ec0406d632513	false	34000000000000000000000	4	6926	0x57b946008913b82e4df85f501cbaed910e58d26c	10136	33785241	2022-10-30T04:41:45.000Z	0x71c0ba2de432bc1624efa17437b4f2e034f1ee8922a94712edc210aa563278a6

Example Query

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.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__userFrom`	`STRING`	Address 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__userTo`	`STRING`	Destination 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_gateway`	`STRING`	Contract 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.

Sample Data

address	removed	in_token	in__userTo	in_gateway	block_number	in__userFrom	block_timestamp	transaction_hash
0x5288c571fd7ad117bea99bf60fe0846c4e84f933	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xd2a02d8e60de0776206ef4c5395ae8f695d78a80	0x096760f208390250649e3e8763348e783aef5562	12559981	0xd2a02d8e60de0776206ef4c5395ae8f695d78a80	2022-05-20T13:04:35.000Z	0xd01e0e5d79a3d7a6f8a077fe54924f210035ad140dbd42d3482db86bdfb23823
0x5288c571fd7ad117bea99bf60fe0846c4e84f933	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x27bedf4431d6127e62986380f37be5f8a963212c	0x096760f208390250649e3e8763348e783aef5562	12566434	0x27bedf4431d6127e62986380f37be5f8a963212c	2022-05-20T14:35:28.000Z	0xec3fa28ab7e4fd515c1921710e376ab4bb17da30221e98b4616f9f551c4f21e0
0x5288c571fd7ad117bea99bf60fe0846c4e84f933	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x756497be59e32264539fcb412d3e5848a4bf9ef9	0x096760f208390250649e3e8763348e783aef5562	12551081	0x756497be59e32264539fcb412d3e5848a4bf9ef9	2022-05-20T10:39:53.000Z	0x94ca925bd501f67b2857b270c390b9988f9cc276a8c7928b3d72674ac67b733c

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

L2Gateway_WithdrawalInitiated_event

L2GatewayRouter_TransferRouted_event

​Tables

​L2Gateway_WithdrawalInitiated_event

​L2GatewayRouter_TransferRouted_event

Tables

L2Gateway_WithdrawalInitiated_event

L2GatewayRouter_TransferRouted_event