optimism_v1_ethereum

Tables

CanonicalTransactionChain_SequencerBatchAppended_event

Optimism sequencer batch submission events logged on Ethereum L1, tracking when transaction batches are appended to the Canonical Transaction Chain contract. Used for monitoring L2 sequencer activity, batch sizes, and cross-chain settlement 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__startingQueueIndex`	`STRING`	Starting index position in the queue where this sequencer batch begins processing transactions. This numeric identifier tracks the batch’s position within Optimism’s transaction queue on Ethereum L1.
`in__numQueueElements`	`STRING`	Number of transactions included from the L1 queue in this sequencer batch. Typically zero, indicating the batch contains only sequencer-submitted transactions rather than force-included L1 transactions.
`in__totalElements`	`STRING`	Total number of transaction elements included in the sequencer batch up to this point. Cumulative count representing Optimism L2 transactions batched and submitted to Ethereum L1.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in__totalElements	in__startingQueueIndex
0x4bf681894abec828b212c906082b444ceb2f6cf6	false	352	13136845	2021-09-01T01:33:31.000Z	0x33ad2596d30180cd5326866cc01defddf1cc470ad19afb3e378b2c2133c7aa63	1122045	18594
0x4bf681894abec828b212c906082b444ceb2f6cf6	false	39	13138238	2021-09-01T06:42:14.000Z	0x0060db4cbce28644aed9dcc60e8fa71f0737b37fa5ccd21679fb45606322fa5d	1128613	18633
0x4bf681894abec828b212c906082b444ceb2f6cf6	false	323	13141702	2021-09-01T19:42:04.000Z	0xd7f5d3855b87c78606190dd8893bd45583a2a5e4a9cb52035e2089badb6b41f2	1145136	18787

Example Query

Query with partition filter

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

StateCommitmentChain_StateBatchAppended_event

Optimism Layer 2 state batch commitment events logged on Ethereum mainnet when the StateCommitmentChain contract appends state root batches. Used for tracking Optimism’s rollup settlement activity including batch sizes, Merkle roots, and sequencer submissions.

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__batchIndex`	`STRING`	Sequential identifier for the state root batch submitted to Ethereum mainnet from Optimism’s legacy state commitment chain. Increments by one for each new batch appended.
`in__batchRoot`	`STRING`	Merkle root hash of the state batch being appended to Optimism’s State Commitment Chain. Hex-encoded, 0x-prefixed 64-character hash representing the cryptographic commitment to all state transitions in this batch.
`in__batchSize`	`STRING`	Number of state root elements included in this Optimism state batch submission. Typically ranges from double to triple digits (100-1000 elements per batch).
`in__prevTotalElements`	`STRING`	Cumulative count of state elements previously committed before this batch was appended to the StateCommitmentChain. Increments sequentially with each batch, tracking the running total of L2 state elements published to Ethereum L1.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

address	removed	log_index	block_number	in__batchRoot	in__batchSize	in__extraData	in__batchIndex	block_timestamp	transaction_hash	in__prevTotalElements
0xe969c2724d2448f1d1a6189d3e2aa1f37d5998c1	false	210	12848893	0xc074ac686040e28526ea4d4d502cbda44b85ac56eabc01260915df9f816e92da	506	0x0000000000000000000000000000000000000000000000000000000060f3c1dc000000000000000000000000473300df21d047806a082244b417f96b32f13a33	278	2021-07-18T05:53:32.000Z	0x08455bd9b76e8caeeca2560b75e139aef760c402fbb048afd8093064eed7810a	58014
0xe969c2724d2448f1d1a6189d3e2aa1f37d5998c1	false	158	12850388	0x6fa120225b4dc715a4c26c94a1a10dede7e92e5e6256a9bd9d0ffb654483cf6c	842	0x0000000000000000000000000000000000000000000000000000000060f412a6000000000000000000000000473300df21d047806a082244b417f96b32f13a33	281	2021-07-18T11:38:14.000Z	0xe125cd631891023a4343d4ff0e9dd1202c3dba65fdb18bf8155e30e3bd8c2ea6	60398
0xe969c2724d2448f1d1a6189d3e2aa1f37d5998c1	false	311	12850905	0x332b51f6a335e5741d589ec1c2f57baf88217bc43e1494553613c7d0e9e6207f	98	0x0000000000000000000000000000000000000000000000000000000060f42f41000000000000000000000000473300df21d047806a082244b417f96b32f13a33	282	2021-07-18T13:40:17.000Z	0x2ce7a55e2ede978893fb84abd5253fa137c642169cfb33c843b8b8f51785941b	61240

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CanonicalTransactionChain_SequencerBatchAppended_event

StateCommitmentChain_StateBatchAppended_event

​Tables

​CanonicalTransactionChain_SequencerBatchAppended_event

​StateCommitmentChain_StateBatchAppended_event

Tables

CanonicalTransactionChain_SequencerBatchAppended_event

StateCommitmentChain_StateBatchAppended_event