optimism

Tables

blocks

Block header data containing sequential numbering, cryptographic hashes linking to parent blocks, timestamps, and consensus metadata. Primary source for blockchain state verification and chain navigation.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transaction_count`	`INT64`	Number of transactions included in the block.
`gas_limit`	`INT64`	Maximum gas allowed to be consumed by all transactions in the block. Measured in gas units, representing the computational capacity limit set for block execution.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`excess_blob_gas`	`INT64`	Cumulative blob gas exceeding the target per block, used to adjust future blob gas pricing. Measured in blob gas units as defined by EIP-4844.
`blob_gas_used`	`INT64`	Total gas consumed by blob transactions in the block. Measured in blob gas units, representing the data availability cost for EIP-4844 blob-carrying transactions.
`parent_beacon_block_root`	`STRING`	Root hash of the parent beacon chain block for post-merge consensus verification. 66-character hex string including 0x prefix.
`base_fee_per_gas`	`INT64`	Minimum fee per gas unit required for transaction inclusion in the block. Measured in wei, representing the base cost dynamically adjusted by the network’s fee mechanism.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 66-character hex string including 0x prefix.
`nonce`	`STRING`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`sha3_uncles`	`STRING`	Keccak-256 hash of the RLP-encoded list of uncle block headers. 66-character hex string including 0x prefix.
`logs_bloom`	`STRING`	Bloom filter for efficient event log querying within the block. 512-character hex string (including 0x prefix) representing a probabilistic data structure for testing event presence.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
`receipts_root`	`STRING`	Merkle root hash of all transaction receipts in the block. 66-character hex string including 0x prefix.
`difficulty`	`INT64`	Mining difficulty target for the block. Integer value representing the computational effort required to produce the block, with 0 indicating proof-of-stake consensus and higher values indicating proof-of-work difficulty.
`total_difficulty`	`NUMERIC`	Cumulative sum of block difficulty from genesis to the current block. Numeric value representing the total computational work expended on the chain up to and including this block.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`extra_data`	`STRING`	Arbitrary data field included in the block by the block producer. Hex-encoded string format, typically containing miner software version, pool information, or chain-specific metadata.
`mix_hash`	`STRING`	Hash value used in proof-of-work mining or consensus verification. 66-character hex string including 0x prefix.
`uncles`	`ARRAY<STRING>`	List of uncle block hashes included in the block. Empty array for chains not supporting uncle blocks in their consensus mechanism.

Sample Data

size	miner	nonce	number	uncles	gas_used	mix_hash	gas_limit	timestamp	block_hash	difficulty	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	receipts_root	total_difficulty	transaction_count	transactions_root
780	0x0000000000000000000000000000000000000000	0x0000000000000000	8258804	[]	46573	0x0000000000000000000000000000000000000000000000000000000000000000	15000000	2022-05-14T15:37:50.000Z	0xd454d6c069dfed77b25002612e690bc01e3b89ac21a2de1700d2b2f6eb4034fe	2	0xd98301090a846765746889676f312e31352e3133856c696e75780000000000006ea2f3c55fe49802166ce074b84c9d45228e300fa2ce9358079da64d6491087a364daf63d44efa8facc86dfd7ccca194112083b248f7e9446dd488bcc2dfb8ba01	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000200000000000000000002000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000020000000000000000000000020000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000002200008000000000000	0x7fac3cb89db510935ee8d075546e0c4a43af06819a98903c9f62f45b3ff9e454	0x1f4063b3560ba7e0e0f05212b8fd96b725d16e280967ca4fe7548ebcfff9032e	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x798ec7f5bb5b908e0ea8f5c6a87fe43b415fa4338c200f383c8194957411a4f2	16517609	1	0x4a3f422e90897ac7d4d1a264c495280cf1b9e600794938fa6ed39df0e4a5c366
780	0x0000000000000000000000000000000000000000	0x0000000000000000	8245589	[]	47050	0x0000000000000000000000000000000000000000000000000000000000000000	15000000	2022-05-14T12:03:00.000Z	0x2045c7ac3085fd24213aaf03c283e95bbef835f9b282422f90033dc0eab8d443	2	0xd98301090a846765746889676f312e31352e3133856c696e75780000000000005c612583a2a19502481e398b207ba4718f2cbe825fb02e633c02ac763ce68a9a1420a807f03ead6d5174b777c3ef3b9d7652c2b7273493ff0e3ea455a04a596101	0x00000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000008000000000004000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000080000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000004000000000000000000000000800000000000000000000000000000000000008100000000000000000	0xd3e73e70d87d1ed88794bd01bf2fc0855bbc841242a530d844e486b6a7752c10	0x4ce3cb06206e329b2d0f788242b4678caf2fbb006381b663439a8cec25dcfb4e	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x7ede3776dbb5b60e6e4a3cb65d4897ce5b1046f65723ad7948f453251807f023	16491179	1	0x9876cd595e426ce7af340b54216aa29d132e851d08b140530e9a96b013e02e84
780	0x0000000000000000000000000000000000000000	0x0000000000000000	8238259	[]	46717	0x0000000000000000000000000000000000000000000000000000000000000000	15000000	2022-05-14T10:29:32.000Z	0x7a19887c54609d550ccedb032be3e1e5b2707b44e22b71c7aa4e378a249ecbad	2	0xd98301090a846765746889676f312e31352e3133856c696e7578000000000000de4c55209aaf95de7efce639883dbdb34a6de771fa670ce163c38d02abbbc34955f053e056aa7c260ed3230c1f462b7a9ddc21086974c2dad249de79cbada54800	0x00000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000404000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000800000000000000000000000000000000080008000000001000001000	0x09a610b93d7e5b028b12a06b8982ccbafb6425cb31af60ae93cd3bcf2cb0164e	0xb33366881ed0ae19ec95bd0bf5cf46ea99825e15ce25e2926dd2bbdcdec482c1	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xbc91099f1beb88d34ba03cbb1870398fe6e192cf637b28d98b6e40526e208511	16476519	1	0x975fe2248c2ec0b0c86585b0e197f176f47c3d256d4f7481b44b97a95d98f447

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.optimism.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

logs

Event logs emitted by smart contracts during transaction execution, containing indexed topics for efficient filtering and ABI-encoded data payloads. Primary source for tracking contract interactions, token transfers, and state changes across blockchain networks.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event log within its containing block. Zero-indexed integer indicating the sequential order of logs emitted in the block.
`address`	`STRING`	Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.
`data`	`STRING`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
`topics`	`ARRAY<STRING>`	Indexed event parameters from the emitted log. Array of 66-character hex strings including 0x prefix, where the first element is the event signature hash and subsequent elements are indexed parameters.
`removed`	`BOOL`	Indicates whether the log was removed due to a chain reorganization.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.

Sample Data

data	topics	address	removed	log_index	block_hash	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000000000047cae16749cef758e0000000000000000000000000000000000000000000000047cfb1d4a61b9d800	[“0x54e4482fe1d38392effe5d53f0e9e72f60221a75a10cea7abbb684bfb03519bf”,“0x00000000000000000000000034235c8489b06482a99bb7fcab6d7c467b92d248”]	0xbd7a3b7dbeb096f0b832cf467b94b091f30c34ec	false	0	0x50136c9312cd0cd498190069743cc809bd4a67964886db72e9ca1319fe9f3534	69079021	2023-01-19T06:49:36.000Z	0xb3b6ca88d93a385f17b4dc2ae6ccbedb58feb03b4108b2aa5ebd1269ce55bede
0x00000000000000000000000000000000000000000000000000b76e06fffc7914	[“0x7fcf532c15f0a6db0bd6d0e038bea71d30d808c7d98cb3bf7268a95bf5081b65”,“0x000000000000000000000000ba12222222228d8ba445958a75a0704d566bf2c8”]	0x4200000000000000000000000000000000000006	false	1	0xe617df5a587f79cc5b2bec30c7e71d6ae56b8a25bf39e0054e37319e75fd4a51	69079025	2023-01-19T06:49:36.000Z	0xcec7e492c93e5f20241a7ba979fd40bfc8e72400b02875fd468e0bfbcd8d9e5d
0x00000000000000000000000000000000000000000000000000b50d5160275f4e	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x000000000000000000000000f900e6e123c64559a322e85d3586203659abaa38”,“0x0000000000000000000000000000000000000000000000000000000000000000”]	0x4fd63966879300cafafbb35d157dc5229278ed23	false	0	0xe617df5a587f79cc5b2bec30c7e71d6ae56b8a25bf39e0054e37319e75fd4a51	69079025	2023-01-19T06:49:36.000Z	0xcec7e492c93e5f20241a7ba979fd40bfc8e72400b02875fd468e0bfbcd8d9e5d

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.optimism.logs`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

traces

Individual transaction execution steps recording internal operations, including contract calls, value transfers, and gas consumption. Used for analyzing complex transaction flows and debugging smart contract interactions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_type`	`STRING`	Type of trace operation executed within the transaction. Common values include CALL for contract calls, CREATE for contract deployments, DELEGATECALL for delegate calls, STATICCALL for static calls, and SELFDESTRUCT for contract destruction operations.
`status`	`BOOL`	Success indicator for the operation. Boolean value where true indicates successful execution and false indicates failure.
`error`	`STRING`	Error message returned when transaction execution fails. Empty when execution succeeds.
`trace_address`	`STRING`	Hierarchical position of the trace within the transaction’s execution tree. Comma-separated string of zero-indexed integers representing the depth and order of nested calls.
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`input`	`STRING`	Calldata or transaction payload sent with the call or transaction. Hex-encoded string starting with 0x, containing the function signature and encoded parameters for smart contract interactions.
`output`	`STRING`	Return data from the smart contract execution or call. Hex-encoded string starting with 0x, containing the function’s return value in ABI-encoded format.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`revert_reason`	`STRING`	Human-readable explanation for why a transaction or call reverted during execution. Empty when execution succeeds.
`trace_id`	`STRING`	Unique identifier for the trace operation within a transaction. Composite string combining the trace type and transaction hash, with optional trace address appended to distinguish between multiple operations of the same type.

Sample Data

status	trace_id	block_number	block_timestamp	transaction_hash
true	null_0x7c9c31c11bd7f17b3ddefc00c7359140c0253d6b95b6edb2c63dfc0fc7c02908_	94478934	2023-04-26T15:39:33.000Z	0x7c9c31c11bd7f17b3ddefc00c7359140c0253d6b95b6edb2c63dfc0fc7c02908
true	null_0xb9dd5c2a24d9d6dd5bf052165f9efafae5831cf04451f794bdb596f9be4a357c_	94405764	2023-04-26T11:23:15.000Z	0xb9dd5c2a24d9d6dd5bf052165f9efafae5831cf04451f794bdb596f9be4a357c
true	null_0xe82f0d231fddf38736b3149e739d0be551b4399b7c93e83ebff2ed0252d4936e_	94299332	2023-04-26T04:32:34.000Z	0xe82f0d231fddf38736b3149e739d0be551b4399b7c93e83ebff2ed0252d4936e

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.optimism.traces`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

transactions

Transaction records containing signed operations that modify blockchain state. Primary source for tracking value transfers, contract interactions, and account state changes across the network.

Columns

Column	Type	Description
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`l1_block_number`	`INT64`	Block number on the Layer 1 blockchain corresponding to this Layer 2 block or transaction. Integer value representing the L1 block height at the time of L2 block production or transaction submission.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_price`	`INT64`	Price per unit of gas for the transaction. Integer value denominated in the smallest unit of the blockchain’s native currency (wei for EVM chains).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`input`	`STRING`	Calldata or transaction payload sent with the call or transaction. Hex-encoded string starting with 0x, containing the function signature and encoded parameters for smart contract interactions.
`nonce`	`INT64`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`r`	`STRING`	ECDSA signature component r from the transaction signature. 66-character hex string including 0x prefix.
`s`	`STRING`	ECDSA signature component s from the transaction signature. 66-character hex string including 0x prefix.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`v`	`INT64`	ECDSA signature component v from the transaction signature. Integer value used for signature verification and public key recovery.
`value`	`STRING`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`transaction_type`	`INT64`	EIP-2718 transaction type indicator. Integer value representing the transaction format: 0 for legacy, 1 for EIP-2930 access list, 2 for EIP-1559 fee market, 3 for EIP-4844 blob transactions.
`chain_id`	`INT64`	Numeric identifier for the blockchain network. Integer value that uniquely identifies the blockchain according to EIP-155 chain ID standard.
`max_fee_per_gas`	`NUMERIC`	Maximum gas price per unit willing to be paid for transaction execution. Integer value denominated in wei for EVM chains, specified by the transaction sender as part of EIP-1559 fee market transactions.
`max_priority_fee_per_gas`	`NUMERIC`	Maximum tip per gas unit offered to validators for transaction priority. Integer value denominated in wei for EVM chains, specified by the transaction sender in EIP-1559 transactions to incentivize faster inclusion.
`index`	`INT64`	Position of the transaction within its block before execution ordering. Null for standard transactions that are ordered by transaction_index.
`l1_timestamp`	`TIMESTAMP`	Timestamp when the corresponding Layer 1 (Ethereum) block was produced. Null for transactions that do not have an associated L1 block reference.
`l1_tx_origin`	`STRING`	Address of the transaction originator on Ethereum L1 that triggered this L2 transaction. Populated for deposits and system transactions bridged from L1; null for user-initiated L2 transactions.
`queue_index`	`INT64`	Queue position for transactions originating from the L1 to L2 message queue. Null for standard L2 transactions not deposited from Ethereum.
`queue_origin`	`STRING`	Origin source identifier for transactions submitted through Optimism’s sequencer queue system. Primarily used for pre-Bedrock upgrade system deposits and legacy transaction routing.
`raw_transaction`	`STRING`	RLP-encoded signed transaction data as submitted to the network. Null for most transactions as they are reconstructed from component fields (r, s, v, input, etc.).
`mint`	`NUMERIC`	Amount of native currency minted and credited to the transaction sender. Denominated in the smallest unit of the blockchain’s native currency.
`source_hash`	`STRING`	Unique identifier for Layer 2 deposit transactions originating from Layer 1. 66-character hex string including 0x prefix.
`receipt_contract_address`	`STRING`	Contract address created by the transaction when deploying a new smart contract. Hex-encoded, 0x-prefixed, 42-character string. Null for all non-deployment transactions.
`receipt_cumulative_gas_used`	`INT64`	Total gas consumed by all transactions in the block up to and including this transaction. Integer value representing the cumulative sum of gas used, incrementing with each transaction in sequential order.
`receipt_effective_gas_price`	`INT64`	Actual gas price paid per unit for transaction execution. Integer value denominated in wei.
`receipt_gas_used`	`INT64`	Gas units consumed by this specific transaction.
`receipt_gas_used_for_l1`	`INT64`	Gas units consumed on Layer 1 for publishing this Layer 2 transaction to the Layer 1 blockchain.
`receipt_logs_bloom`	`STRING`	Bloom filter for efficiently querying event logs emitted by the transaction. 512-character hex string including 0x prefix, representing a 256-byte bit array used for probabilistic matching of log topics and addresses.
`receipt_status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true indicates successful execution and false indicates failure.
`receipt_transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`receipt_l1_gas_price`	`INT64`	Price per gas unit paid on Layer 1 for publishing Layer 2 transaction data. Denominated in wei.
`receipt_l1_gas_used`	`INT64`	Gas units consumed on Layer 1 for the transaction on Layer 2 rollup chains.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`receipt_l1_fee`	`INT64`	Fee paid for publishing the transaction data to Layer 1. Denominated in the smallest unit of the blockchain’s native currency.
`receipt_l1_fee_scalar`	`NUMERIC`	Scaling factor applied to Layer 1 fee calculations for Layer 2 transaction data publishing costs.
`receipt_deposit_nonce`	`INT64`	Sequential counter for Layer 2 deposit transactions originating from Layer 1. Increments by 1 for each new deposit to prevent replay attacks and ensure transaction ordering for cross-chain deposits.
`receipt_l1_base_fee_scalar`	`INT64`	Scaling factor applied to the Layer 1 base fee component in Layer 2 transaction fee calculations.
`receipt_l1_blob_base_fee`	`INT64`	Base fee per gas unit for EIP-4844 blob data on Layer 1. Denominated in wei.
`receipt_l1_blob_base_fee_scalar`	`INT64`	Scaling factor applied to the Layer 1 blob base fee component in Layer 2 transaction fee calculations for EIP-4844 blob transactions.
`receipt_da_footprint_gas_scalar`	`INT64`	Scaling factor applied to the data availability footprint gas calculation for Layer 2 transaction data publishing costs.

Sample Data

r	s	v	gas	input	nonce	chain_id	gas_price	block_hash	to_address	block_number	from_address	receipt_type	receipt_l1_fee	receipt_status	block_timestamp	max_fee_per_gas	receipt_gas_used	transaction_hash	transaction_type	transaction_index	receipt_logs_bloom	receipt_l1_gas_used	receipt_l1_gas_price	receipt_l1_fee_scalar	max_priority_fee_per_gas	receipt_transaction_index	receipt_cumulative_gas_used	receipt_effective_gas_price
0xa9406a23020ee9d52ac3b58bd36b25538c2d432e749b6efc26861a9fc0e555ce	0x79427891161e184dfe89481a6346dd6cd7f694117e60d531ebe0f3990a080eb1	1	327936	0x070e246807825168a88d0d7da8091870ce8a22e6ac12650302000000000000000000002cf400000000000000000000001fc869f3227634c2b324abb4b397d14f81067d65507fc568e8b29bcc466f18cc9ff48ae63e8a77edf6f31ec47e2a40af6645449184fec99a0713ac99688024c684c99ca7f3e8e9cc92bb6ece6a944cf3c3be5313620206000000000000000001b86765000000009f6d03f80fa67e8a98f89aea7fce63a80e74f857d1ac834a2c68d99d1110d670b3f88ea622dcd0fd725a1716120b8334eea60704fa1e0c95fdd7ee63e18659fbeabdbaf23f1dbb08	83570	10	10607109	0xff9bc4da367a0a062b68effadcb04a3c8d8ed4a1e95256c23fda06e83b289f11	0x000000561d8419c30093009fe70082e10a00007b	112867893	0x6809501ef4df4a4c78024bd50ba4bef3d5af17a9	2	104740743058212	true	2023-11-30T08:56:03.000Z	19770946	268564	0x1fd674578c6b387799c16bb74603356fcd946367cfbce9cdea2534229f67e728	2	6	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	5076	30167403726	0.684	100000	6	1816944	10607109
0x8b7f5a303f8574db33a5d2d85524ef5d46de87cba0e1827d3e5537c2f977ddf9	0x17e9c86d0d39b67728124b3a1f0b5b5abf4d0efa6de891c9942c6fcf2f6064c6	0	525312	0x6a627842000000000000000000000000bbe730571650670780f0cb0466bf4c2aaef4e4be	71	10	15446896	0x0e2b256dd4362bac5323853c6e8d365ad8e6fd199dac89fa916a1244ba9bbeaf	0x484a335c0833942479ca10f697630f0230d45599	112856325	0xbbe730571650670780f0cb0466bf4c2aaef4e4be	2	54375958978298	true	2023-11-30T02:30:27.000Z	19337569	335404	0x8ddd9affcc3014bc2f7d3506e0fd8aca8daa600a6b173f87433f5ff8ae95bacc	2	3	0x00000200000000000000000000000000000000000000000000000000010000020000000000000400000000000000000000000000100000000000040000000002000000000000200080000008000000000000000000000000000000020000000000000000020000000000000000000800000000000000000080000010000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000080000000000000000000000000000040000000000200000020000000000000000000000000000000200000000000000400000000000000000400	2352	33799751722	0.684	5866583	3	1547865	15446896
0xae3d362bbfcac499a1a047afd2b16337e9a41235aaaf34788eeab8662512b0f3	0x5ac7dfd4bd36f7fb8030e5be959e7e4feed1cdf2d7d222e9f97b3b8a7af75460	56	2099200	0xa80a1edd00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000027000000000000000000000000000000000000000000000000000000000000005c000000000000000000000000000000000000000000000000000000000000271000000000000000000000000027a333a11a8cc8545a76ba1d36a23742c2f4b97c0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006568737a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001600000000000000000000000000000000000000000000000000000000000000000	466	10	10999039	0xd0fe731ef0b34c4eac804056f40ead879438331772f1ba934260900a6ddf8a53	0xf9cfb8a62f50e10adde5aa888b44cf01c5957055	112872402	0x27a333a11a8cc8545a76ba1d36a23742c2f4b97c	0	66476205961114	true	2023-11-30T11:26:21.000Z		1167924	0x584d8cbbcff31ad8fe8494156c46cb77953758740908d5a41c63e2be5f242a02	0	5	0x00001000100000040000008040000c00000004000000000008100000402001200d0a008020000000000040000000200000000050020002000090000040a0008100001000000a2088020000080000000004820000000002000000000800108000020800000204004000020000000008020400080080080010a000001208000c001400100000000000000002000020000008001000008100000400040008000000020010000000001000000000800000008010000000800020008000000000400400000012000000000000000404030000000200040080030800000040000020800010082140000008000000100000010008000000008000000010000000010000	3996	24321180084	0.684		5	1543769	10999039

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.optimism.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

logs

traces

transactions

Metrics

Primitives

Contracts

Blockchain

​Tables

​blocks

​logs

​traces

​transactions

Tables

blocks

logs

traces

transactions