Skip to main content

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.
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 initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
in__toSTRINGDestination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
in__sequenceNumberSTRINGMonotonically increasing counter assigned to each deposit transaction by the Arbitrum bridge contract on Layer 1. Used to track and order bridge events chronologically.
in__amountSTRINGAmount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
in__toaddressremovedin__fromlog_indexin__amountin_l1Tokenblock_numberblock_timestamptransaction_hashin__sequenceNumber
0x780f3308b5eeef72135f2843a90fe64cc0698fbb0x6142f1c8bbf02e6a6bd074e8d564c9a5420a0676false0x780f3308b5eeef72135f2843a90fe64cc0698fbb3303000000110922792115810x58b6a8a3302369daec383334672404ee733ab239148674082022-05-29T16:07:57.000Z0x8724054e5b15d234b51fc36f92b2aff014d75ecd8779cd55ae588dfd7d729776492185
0xeb66b5f264138839d7ad2421d2a40f5dd79df4730x6142f1c8bbf02e6a6bd074e8d564c9a5420a0676false0xeb66b5f264138839d7ad2421d2a40f5dd79df4731779744505000000000000x58b6a8a3302369daec383334672404ee733ab239148681592022-05-29T19:01:39.000Z0xf66f5cb20437ba2759a772f9e0cd592340799e394b271cd3df1410149c2cbd7c492338
0x5bd99e37d6585513c60172a50cc02626313abeb00x6142f1c8bbf02e6a6bd074e8d564c9a5420a0676false0x5bd99e37d6585513c60172a50cc02626313abeb0213237000000000000000000x58b6a8a3302369daec383334672404ee733ab239148656742022-05-29T09:21:44.000Z0x8c5ce1aa030127295102c746a8805364205efa560570e5e9d63a0dd6910cc8d9491145
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.
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__userFromSTRINGEthereum 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__userToSTRINGEthereum 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_gatewaySTRINGContract address of the specific gateway contract handling this token transfer on Ethereum L1. Routes to token-specific gateway implementations within the Arbitrum bridge architecture.
addressremovedin_tokenlog_indexin__userToin_gatewayblock_numberin__userFromblock_timestamptransaction_hash
0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031effalse0xc944e90c64b2c07662a292be6244bdf05cda44a73190x6eeeafa18f7e764234affbe2a29c24be76184f460x01cdc91b0a9ba741903aa3699bf4ce31d6c5cc06166156140x6eeeafa18f7e764234affbe2a29c24be76184f462023-02-12T22:19:11.000Z0xf11a185936a7bfb6c2ba1bf078c81db54fae5c778049756edef55a7dfa5672b3
0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031effalse0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca02430xf222edc392be0e580c7ed4de4520499402ae8eb10x0f25c1dc2a9922304f2eac71dca9b07e310e8e5a166099790xf222edc392be0e580c7ed4de4520499402ae8eb12023-02-12T03:25:47.000Z0xb2feffe3509a926b443213c297386573a4106e756d0f03409e6f230ed1196118
0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031effalse0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca01400xd2b954a0635096ddaadd7ff1d5a182198f02fcae0x0f25c1dc2a9922304f2eac71dca9b07e310e8e5a166115630xd2b954a0635096ddaadd7ff1d5a182198f02fcae2023-02-12T08:44:11.000Z0xf6f74dca6e04cf7823a122899e5d1323c8a916e8eef7e1d3d46dac989c2f79c1
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