arbitrum_v1_arbitrum

Tables

ArbSys_L2ToL1Transaction_event

L2-to-L1 (Layer 2 to Layer 1) transaction events from Arbitrum’s ArbSys precompile contract, tracking withdrawal and cross-chain message operations from Arbitrum to Ethereum mainnet. Contains caller addresses, destination addresses, ETH transfer values, batch numbers, and transaction data for analyzing bridge activity and fund movements between layers.

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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_uniqueId`	`STRING`	Unique identifier for this L2-to-L1 transaction within Arbitrum’s withdrawal system. Each withdrawal is assigned a sequential numeric identifier to track the message across layers.
`in_batchNumber`	`STRING`	Batch number on L1 Ethereum containing this L2-to-L1 transaction. Increments sequentially as Arbitrum submits batches of L2 transactions to Ethereum mainnet.
`in_indexInBatch`	`STRING`	Position of this L2-to-L1 transaction within its sequencer batch. String-encoded integer starting at 0, indicating ordering when multiple outbox messages are included in the same batch.
`in_arbBlockNum`	`STRING`	Arbitrum L2 block number at which the L2-to-L1 transaction was initiated. Matches the block_number value for this event record.
`in_ethBlockNum`	`STRING`	Ethereum L1 block number where this L2-to-L1 transaction was included or referenced. Corresponds to the mainnet block that processed or finalized this Arbitrum withdrawal event.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_callvalue`	`STRING`	ETH value sent with the L2-to-L1 transaction, denominated in wei. Typically zero for token transfers, non-zero for native ETH withdrawals.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

address	in_data	removed	in_caller	log_index	in_uniqueId	block_number	in_callvalue	in_timestamp	in_arbBlockNum	in_batchNumber	in_destination	in_ethBlockNum	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000064	0x	false	0x07a9b800db5b84385e1fc8d8cc48c3f4a103af85	0	81254	19914099	130375034587208000	1660139342	19914099	15490	0x07a9b800db5b84385e1fc8d8cc48c3f4a103af85	15314703	2022-08-10T13:49:02.000Z	0x8174ce1abbb1f3421e4f0719d7dae65831b5f3548f6d3c1459e6a85dec2f6f36
0x0000000000000000000000000000000000000064	0x2e567b36000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000833a11b69873151fba6d14f455db5392542825ca000000000000000000000000833a11b69873151fba6d14f455db5392542825ca000000000000000000000000000000000000000000000000000000003b9aca0000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000166700000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000000	false	0x096760f208390250649e3e8763348e783aef5562	2	81264	19926958	0	1660148391	19926958	15494	0xcee284f754e854890e311e3280b767f80797180d	15315358	2022-08-10T16:19:51.000Z	0xc69b9e16fd9107abc974b7ea162ad83bb4098bac61220e330bf17799e10efcc7
0x0000000000000000000000000000000000000064	0x2e567b360000000000000000000000000ff5a8451a839f5f0bb3562689d9a44089738d110000000000000000000000005fb8b9512684d451d4e585a1a0aabfb48a253c670000000000000000000000005fb8b9512684d451d4e585a1a0aabfb48a253c6700000000000000000000000000000000000000000000000ad78ebc5ac620000000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000166900000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000000	false	0x096760f208390250649e3e8763348e783aef5562	2	81269	19928817	0	1660150218	19928817	15496	0xcee284f754e854890e311e3280b767f80797180d	15315505	2022-08-10T16:50:18.000Z	0x47184fb17a94442bdfbe1cafd9af1905dfde23fc04262c7d2bb2045746648dbe

Example Query

Query with partition filter

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

ArbSys_L2ToL1Tx_event

Layer 2 to Layer 1 withdrawal transaction events from Arbitrum’s ArbSys precompile contract (0x0000000000000000000000000000000000000064). Tracks cross-chain messages including ETH withdrawals and arbitrary data transfers with both Arbitrum and Ethereum block references for reconciling L2-to-L1 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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_hash`	`STRING`	Unique identifier hash for the Layer 2 to Layer 1 transaction within Arbitrum’s withdrawal system. Stored as a large integer representation of the transaction’s hash used to track cross-layer message passing.
`in_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_arbBlockNum`	`STRING`	Arbitrum Layer 2 block number when the L2-to-L1 transaction was initiated. Matches the block_number field as this event occurs on the Arbitrum chain.
`in_ethBlockNum`	`STRING`	Ethereum Layer 1 block number where this L2-to-L1 message was initiated on Arbitrum. Corresponds to the mainnet block height at the time of the cross-chain transaction.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_callvalue`	`STRING`	ETH value in wei sent from Layer 2 to Layer 1 with the withdrawal transaction. Always zero for pure message passing without value transfer.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

address	in_data	in_hash	removed	in_caller	log_index	in_position	block_number	in_callvalue	in_timestamp	in_arbBlockNum	in_destination	in_ethBlockNum	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000064	0x	50130473958012442939212375380951803846992232676825794912994583595580882326513	false	0x31c103e18781d159ae195e3873818a973d051607	19	42055	58444156	55579262985540270	1675670638	58444156	0x31c103e18781d159ae195e3873818a973d051607	16568428	2023-02-06T08:03:58.000Z	0x1a80374cae43651384806d2bc49fa9278486892cbb3b963abc5d4749be60e8ad
0x0000000000000000000000000000000000000064	0x	13133881450020284642003199991582884021203196233119420237162611307130029840051	false	0x32532edf1d8a44a5f7d14d277d85156b118b6d1d	38	42407	58572253	5000000000000000	1675705401	58572253	0x32532edf1d8a44a5f7d14d277d85156b118b6d1d	16571314	2023-02-06T17:43:21.000Z	0x9a1b82e9800dbf4efab1b7e67a4a4309ddff8cfbcee593943e1d6be1d6552577
0x0000000000000000000000000000000000000064	0x	40654430782144595744905409753703266841380765218354648661540491203835374820252	false	0x9f6b08a69155e81d8191b7e74b15f333cdea1996	41	42155	58473896	10900000000000	1675678675	58473896	0x9f6b08a69155e81d8191b7e74b15f333cdea1996	16569095	2023-02-06T10:17:55.000Z	0xb01f99523b8c6a79dd3b1d424799f6189f1f407faddfa3f8d8b771b3bfc95565

Example Query

Query with partition filter

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

ExpressLaneAuction_AuctionResolved_event

Resolved auction results from Arbitrum’s Express Lane priority transaction mechanism, recording winning bidders, bid amounts, and round timing for each ~60-second auction period. Used for analyzing MEV (Maximal Extractable Value) pricing dynamics and sequencer priority access costs on Arbitrum.

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_isMultiBidAuction`	`BOOL`	Flag indicating whether multiple bids were submitted for this auction round. Always false in sample data, suggesting single-bid auctions are the norm for Express Lane controller rights.
`in_round`	`STRING`	Sequential identifier for vault or auction rounds. Numeric string representing the round number in the protocol’s lifecycle.
`in_firstPriceBidder`	`STRING`	Ethereum address of the highest bidder in the Express Lane auction round. Hex-encoded, 0x-prefixed 40-character string identifying the participant who submitted the winning bid.
`in_firstPriceExpressLaneController`	`STRING`	Address of the express lane controller designated by the winning first-price bidder for this auction round. Hex-encoded, 0x-prefixed 40-character string identifying the controller account.
`in_firstPriceAmount`	`STRING`	Winning bid amount in wei for the express lane auction round. Typically ranges from 1-3 ETH (1e15-3e15 wei) based on sample values showing amounts like 2659138526983043 wei.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_roundStartTimestamp`	`STRING`	Unix timestamp marking the start of the auction round for Arbitrum Express Lane priority transaction rights. Represents the beginning of the ~60-second bidding window for sequencer priority access.
`in_roundEndTimestamp`	`STRING`	Unix timestamp marking the end of the auction round for this Express Lane auction. Represents the second boundary when the winning bidder’s priority transaction rights expire, typically 59 seconds after the round start.

Sample Data

address	removed	in_price	in_round	log_index	block_number	block_timestamp	transaction_hash	in_firstPriceAmount	in_firstPriceBidder	in_isMultiBidAuction	in_roundEndTimestamp	in_roundStartTimestamp	in_firstPriceExpressLaneController
0x5fcb496a31b7ae91e7c9078ec662bd7a55cd3079	false	1000000000000000	53678	1	327370303	2025-04-17T16:35:38.000Z	0x9dd1de6ec0e72361a6843a2502a6952c21e8541f50447d66142fc57e000215ae	2659138526983043	0x2b38a73dd32a2eafe849825a4b515ae5187eda42	false	1744907810	1744907751	0x2b38a73dd32a2eafe849825a4b515ae5187eda42
0x5fcb496a31b7ae91e7c9078ec662bd7a55cd3079	false	1000000000000000	53919	1	327428134	2025-04-17T20:36:38.000Z	0x31b355861bdef99fed33c27e8a31866b5d07216c1765acc496e65a3e9816f434	1818958214789845	0x2b38a73dd32a2eafe849825a4b515ae5187eda42	false	1744922270	1744922211	0x2b38a73dd32a2eafe849825a4b515ae5187eda42
0x5fcb496a31b7ae91e7c9078ec662bd7a55cd3079	false	1000000000000000	53647	1	327362791	2025-04-17T16:04:38.000Z	0x8c0b80b41eec4b8232907b8c1adb66fe4fc4f1ac93fc3d789403fb749110ce05	2119602072886141	0x2b38a73dd32a2eafe849825a4b515ae5187eda42	false	1744905950	1744905891	0x2b38a73dd32a2eafe849825a4b515ae5187eda42

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ArbSys_L2ToL1Transaction_event

ArbSys_L2ToL1Tx_event

ExpressLaneAuction_AuctionResolved_event

​Tables

​ArbSys_L2ToL1Transaction_event

​ArbSys_L2ToL1Tx_event

​ExpressLaneAuction_AuctionResolved_event

Tables

ArbSys_L2ToL1Transaction_event

ArbSys_L2ToL1Tx_event

ExpressLaneAuction_AuctionResolved_event