arbitrumbridge_v1_ethereum

Tables

L1Gateway_DepositInitiated_event

Token deposit events from Ethereum L1 to Arbitrum L2 via the bridge gateway contract. Tracks cross-chain transfers with sender, recipient, token address, amount, and sequence numbers for analyzing bridging activity and fund 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_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. Hex-encoded, 0x-prefixed, 42-character string.
`in__from`	`STRING`	Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__sequenceNumber`	`STRING`	Monotonically increasing counter assigned to each deposit transaction by the Arbitrum bridge contract on Layer 1. Used to track and order bridge events chronologically.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

in__to	address	removed	in__from	log_index	in__amount	in_l1Token	block_number	block_timestamp	transaction_hash	in__sequenceNumber
0x780f3308b5eeef72135f2843a90fe64cc0698fbb	0x6142f1c8bbf02e6a6bd074e8d564c9a5420a0676	false	0x780f3308b5eeef72135f2843a90fe64cc0698fbb	330	300000011092279211581	0x58b6a8a3302369daec383334672404ee733ab239	14867408	2022-05-29T16:07:57.000Z	0x8724054e5b15d234b51fc36f92b2aff014d75ecd8779cd55ae588dfd7d729776	492185
0xeb66b5f264138839d7ad2421d2a40f5dd79df473	0x6142f1c8bbf02e6a6bd074e8d564c9a5420a0676	false	0xeb66b5f264138839d7ad2421d2a40f5dd79df473	177	974450500000000000	0x58b6a8a3302369daec383334672404ee733ab239	14868159	2022-05-29T19:01:39.000Z	0xf66f5cb20437ba2759a772f9e0cd592340799e394b271cd3df1410149c2cbd7c	492338
0x5bd99e37d6585513c60172a50cc02626313abeb0	0x6142f1c8bbf02e6a6bd074e8d564c9a5420a0676	false	0x5bd99e37d6585513c60172a50cc02626313abeb0	213	23700000000000000000	0x58b6a8a3302369daec383334672404ee733ab239	14865674	2022-05-29T09:21:44.000Z	0x8c5ce1aa030127295102c746a8805364205efa560570e5e9d63a0dd6910cc8d9	491145

Example Query

Query with partition filter

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

L1GatewayRouter_TransferRouted_event

Token transfer routing events from Arbitrum’s L1 Gateway Router on Ethereum, capturing cross-chain bridge transactions with sender, recipient, token, and gateway addresses. Used for tracking Ethereum-to-Arbitrum token deposits and analyzing bridge usage 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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__userFrom`	`STRING`	Ethereum address of the user initiating the token transfer from L1 to Arbitrum. Always matches `in__userTo` in samples, indicating self-transfers through the gateway router.
`in__userTo`	`STRING`	Ethereum address of the recipient who will receive the tokens on Arbitrum Layer 2. This is the destination address specified by the sender during the bridge transfer.
`in_gateway`	`STRING`	Contract address of the specific gateway contract handling this token transfer on Ethereum L1. Routes to token-specific gateway implementations within the Arbitrum bridge architecture.

Sample Data

address	removed	in_token	log_index	in__userTo	in_gateway	block_number	in__userFrom	block_timestamp	transaction_hash
0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031ef	false	0xc944e90c64b2c07662a292be6244bdf05cda44a7	319	0x6eeeafa18f7e764234affbe2a29c24be76184f46	0x01cdc91b0a9ba741903aa3699bf4ce31d6c5cc06	16615614	0x6eeeafa18f7e764234affbe2a29c24be76184f46	2023-02-12T22:19:11.000Z	0xf11a185936a7bfb6c2ba1bf078c81db54fae5c778049756edef55a7dfa5672b3
0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031ef	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	243	0xf222edc392be0e580c7ed4de4520499402ae8eb1	0x0f25c1dc2a9922304f2eac71dca9b07e310e8e5a	16609979	0xf222edc392be0e580c7ed4de4520499402ae8eb1	2023-02-12T03:25:47.000Z	0xb2feffe3509a926b443213c297386573a4106e756d0f03409e6f230ed1196118
0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031ef	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	140	0xd2b954a0635096ddaadd7ff1d5a182198f02fcae	0x0f25c1dc2a9922304f2eac71dca9b07e310e8e5a	16611563	0xd2b954a0635096ddaadd7ff1d5a182198f02fcae	2023-02-12T08:44:11.000Z	0xf6f74dca6e04cf7823a122899e5d1323c8a916e8eef7e1d3d46dac989c2f79c1

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

L1Gateway_DepositInitiated_event

L1GatewayRouter_TransferRouted_event

​Tables

​L1Gateway_DepositInitiated_event

​L1GatewayRouter_TransferRouted_event

Tables

L1Gateway_DepositInitiated_event

L1GatewayRouter_TransferRouted_event