Skip to main content

​
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.
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__startingQueueIndexSTRINGStarting 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__numQueueElementsSTRINGNumber 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__totalElementsSTRINGTotal 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.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin__totalElementsin__numQueueElementsin__startingQueueIndex
0x4bf681894abec828b212c906082b444ceb2f6cf6false352131368452021-09-01T01:33:31.000Z0x33ad2596d30180cd5326866cc01defddf1cc470ad19afb3e378b2c2133c7aa631122045018594
0x4bf681894abec828b212c906082b444ceb2f6cf6false39131382382021-09-01T06:42:14.000Z0x0060db4cbce28644aed9dcc60e8fa71f0737b37fa5ccd21679fb45606322fa5d1128613018633
0x4bf681894abec828b212c906082b444ceb2f6cf6false323131417022021-09-01T19:42:04.000Z0xd7f5d3855b87c78606190dd8893bd45583a2a5e4a9cb52035e2089badb6b41f21145136018787
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.
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__batchIndexSTRINGSequential 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__batchRootSTRINGMerkle 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__batchSizeSTRINGNumber of state root elements included in this Optimism state batch submission. Typically ranges from double to triple digits (100-1000 elements per batch).
in__prevTotalElementsSTRINGCumulative 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__extraDataSTRINGAdditional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.
addressremovedlog_indexblock_numberin__batchRootin__batchSizein__extraDatain__batchIndexblock_timestamptransaction_hashin__prevTotalElements
0xe969c2724d2448f1d1a6189d3e2aa1f37d5998c1false210128488930xc074ac686040e28526ea4d4d502cbda44b85ac56eabc01260915df9f816e92da5060x0000000000000000000000000000000000000000000000000000000060f3c1dc000000000000000000000000473300df21d047806a082244b417f96b32f13a332782021-07-18T05:53:32.000Z0x08455bd9b76e8caeeca2560b75e139aef760c402fbb048afd8093064eed7810a58014
0xe969c2724d2448f1d1a6189d3e2aa1f37d5998c1false158128503880x6fa120225b4dc715a4c26c94a1a10dede7e92e5e6256a9bd9d0ffb654483cf6c8420x0000000000000000000000000000000000000000000000000000000060f412a6000000000000000000000000473300df21d047806a082244b417f96b32f13a332812021-07-18T11:38:14.000Z0xe125cd631891023a4343d4ff0e9dd1202c3dba65fdb18bf8155e30e3bd8c2ea660398
0xe969c2724d2448f1d1a6189d3e2aa1f37d5998c1false311128509050x332b51f6a335e5741d589ec1c2f57baf88217bc43e1494553613c7d0e9e6207f980x0000000000000000000000000000000000000000000000000000000060f42f41000000000000000000000000473300df21d047806a082244b417f96b32f13a332822021-07-18T13:40:17.000Z0x2ce7a55e2ede978893fb84abd5253fa137c642169cfb33c843b8b8f51785941b61240
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