manta

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.
`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.
`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.
`withdrawals_root`	`STRING`	Merkle root hash of all validator withdrawals in the block. 66-character hex string including 0x prefix.
`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	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	receipts_root	base_fee_per_gas	transaction_count	transactions_root
1082	0x4200000000000000000000000000000000000011	0x0000000000000000	3146403	[]	92617	0x511fee6554bb2853846d0b8f6fd7180fe8f20c26de0049dc7a5bcae379fc2f0b	50000000	2024-09-07T05:46:29.000Z	0x80d122e1c78c9d922e74ff806c87e5e20083baef8666d71d78461a5c9b1943a6	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0xd417899f6d357bd62a945623d8553b5bc294d98a366eb6c5724a30e5cfa5bcbc	0x345b099059668e422ebff4f59878e9202f09f3398d3d91f86991997ea0f9bb6b	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xeddf5fdfbf95c0c38c81782fcc5f658885dc0da53e892f570d9febc423489e17	91	3	0x49bbd9eb58cc471117813b9e2fd83b740130440fc752078dfee89b2c34d28b26
1203	0x4200000000000000000000000000000000000011	0x0000000000000000	3151399	[]	645375	0xa7fd97c7e2ed97a3213e2aecd31053759310d2068cc4efb459382ce0c227b7ea	50000000	2024-09-07T19:39:09.000Z	0xb3bf6651b9330fed8c441ef3122c7ff540f326dbf9d177b1a30d3f49e9a9f0d5	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x2376026b06502a32b7fa8d3a0f1dcc57a35a3005cd09a2d4de0ab54392d1c82b	0xc25d4be859cee9609c7822052c393583569bf6ac9fbb6c950c38013d409aed21	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xf020f831460f2d9da819412b90e0dd20ff225afffaebbc3d79f8d45a48048901	57	4	0x3401bd3f695c305a15ad5186d186086a89172dad776d23b6c411f5a10bca9052
3334	0x4200000000000000000000000000000000000011	0x0000000000000000	3148530	[]	927228	0x03aea5feb9699ad643eb6ff801ad298d9b4e147eb2bb169a0d73e5972bce4d24	50000000	2024-09-07T11:40:59.000Z	0x12918ddee8d8aef6b8afbfad00d3ad1b1e1d436ee2799c5d17c3083f715b7c89	0x	0x402001000000000000000000800000000000100000400020100000100000040400400041000000003000004000008002000000000008011000000400020010000000000000040004000000080000002000000000000000002a0000000000000000000000020000000024000020400800010000000000000300100011000000000000000000000000000000000000000000000001000004080000004000000000100000000100000401014000000000000000004000010000000000000000001000000402000004000000200000000000000100008000001004000000000030000000000000000000000000000000000000000000000000000000000040000000	0xd0d7c75c3ce42b91ffdb839d12bc2542ad0ed26e4b6a54f228d0c6b334f51710	0x7de7c2140f42ec91997bd9f8cff1d72313e30eb631a3edcd363dcc88e238edcf	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x03ca61e220ae040609fcbf4ea117a896e4e140ae3e87a2a6153ff0b5aa2098a3	57	6	0x07edae467b0ab2f990b3e44833711e7b5672f027158bef836543fa30fa7bafc7

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.manta.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	transaction_index
0x0000000000000000000000000000000000000000000000000001bda5165091bb	[“0x7fcf532c15f0a6db0bd6d0e038bea71d30d808c7d98cb3bf7268a95bf5081b65”,“0x000000000000000000000000fde3eac61c5ad5ed617eb1451cc7c3a0ac197564”]	0x0dc808adce2099a9f62aa87d9670745aba741746	false	4	0xe59a6c04b1d5e84c0327d53e23a8b1fd00d4bb7cff4fabeddb39f196faedc9ca	561152	2023-11-13T00:31:19.000Z	0x0887d7046553adb5c616729b6199944cb296a3d68f8edd69abc3e5115926487d	1
0x00000000000000000000000000000000000000000000000000000000000f4240	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x000000000000000000000000546493137cfd7ce09b5b461a669b6de3e66861c3”,“0x00000000000000000000000066c0232d3c5f0c25914785606e73bd41b788b9ac”]	0xf417f5a458ec102b90352f697d6e2ac3a3d2851f	false	2	0xe59a6c04b1d5e84c0327d53e23a8b1fd00d4bb7cff4fabeddb39f196faedc9ca	561152	2023-11-13T00:31:19.000Z	0x0887d7046553adb5c616729b6199944cb296a3d68f8edd69abc3e5115926487d	1
0x000000000000000000000000000000000000000000000000000000000001dc40	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x0000000000000000000000001ebed4024308afcb05e6938ef8ebd1ec5d6e8c46”,“0x000000000000000000000000a2e2f3726df754c1848c8fd1cbea6aaff84fc5b2”]	0xf417f5a458ec102b90352f697d6e2ac3a3d2851f	false	5	0xe59a6c04b1d5e84c0327d53e23a8b1fd00d4bb7cff4fabeddb39f196faedc9ca	561152	2023-11-13T00:31:19.000Z	0x38e3edbd9dda4b09040b9079ff781298ee1b8af2d6085fa39a9b7ead3807a765	2

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.manta.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`	`NUMERIC`	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

gas	input	output	status	gas_used	trace_id	to_address	trace_type	block_number	from_address	block_timestamp	transaction_hash	transaction_index
196746	0x5ae401dc00000000000000000000000000000000000000000000000000000000657a52d1000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000000e404e45aaf000000000000000000000000b73603c5d87fa094b7314c74ace2e64d165016fb0000000000000000000000000dc808adce2099a9f62aa87d9670745aba74174600000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000b71aff0000000000000000000000000000000000000000000000000012cfe07e8e700d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004449404b7c0000000000000000000000000000000000000000000000000012cfe07e8e700d0000000000000000000000000a9c647144f471bf16636b4e55558492d2cbe12300000000000000000000000000000000000000000000000000000000	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000012e7f4d11bf32c0000000000000000000000000000000000000000000000000000000000000000	true	142336	CALL_0x114eeff3dbc89726774944cd2b9ac4eefd3dbea4afb2a44336d6040717c6426e_	0x632c8519d9cdd3b36cf7cf391cd9c437564bae6a	CALL	829028	0x0a9c647144f471bf16636b4e55558492d2cbe123	2023-12-14T00:37:19.000Z	0x114eeff3dbc89726774944cd2b9ac4eefd3dbea4afb2a44336d6040717c6426e	3
225512	0x5ae401dc00000000000000000000000000000000000000000000000000000000657a6bf000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000e404e45aaf0000000000000000000000006fae4d9935e2fcb11fc79a64e917fb2bf14dafaa000000000000000000000000b73603c5d87fa094b7314c74ace2e64d165016fb0000000000000000000000000000000000000000000000000000000000000bb800000000000000000000000098f0f120de21a90f220b0027a9c70029df9bbde40000000000000000000000000000000000000000000000000000000001b9ad5c00000000000000000000000000000000000000000000000000000000157b96a1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000157bfa91	true	109312	CALL_0x8f3a328e836e47aa592faa3fc94f93507ead3d245e824ff7ecc84fcb1a731d74_	0x3488d5a2d0281f546e43435715c436b46ec1c678	CALL	829759	0x98f0f120de21a90f220b0027a9c70029df9bbde4	2023-12-14T02:39:09.000Z	0x8f3a328e836e47aa592faa3fc94f93507ead3d245e824ff7ecc84fcb1a731d74	1
12000000	0xb42390d800000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000001200000000000000000000000000000000000000000000000000000000000000160000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000c6685a2fa18f3bccb22533f2631049aa47a4eb8b00000000000000000000000000000000000000000000000000000000000000010000000000000000000000009ef1b8c0e4f7dc8bf5719ea496883dc6401d5b2e00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000003555564b110000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000003a1711bce829e721c83a20dd05dee70b8a4bb64400000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001		true	438272	CALL_0xcdd93f70569376cd457f3431a0f7b2c8a27435a8681f9390f963b236b350770b_	0xa02d433868c7ad58c8a2a820d6c3ff8a15536acc	CALL	832979	0xc6685a2fa18f3bccb22533f2631049aa47a4eb8b	2023-12-14T11:35:49.000Z	0xcdd93f70569376cd457f3431a0f7b2c8a27435a8681f9390f963b236b350770b	9

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.manta.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.
`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.
`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.
`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.
`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.
`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.
`y_parity`	`INT64`	ECDSA signature parity indicator for EIP-2718 typed transactions. Binary value (0 or 1) representing the y-coordinate parity of the public key recovery point.
`access_list`	`ARRAY<STRUCT<address STRING, storage_keys ARRAY<STRING>>>`	List of addresses and storage keys accessed during EIP-2930 access list transactions. Array of structs containing contract addresses and their associated storage slot keys that the transaction declares it will access.
`deposit_receipt_version`	`STRING`	Version identifier for Layer 2 deposit transaction receipts. Integer value used to track the schema or protocol version of deposit receipts.
`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_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_l1_blob_base_fee`	`BIGNUMERIC`	Base fee per gas unit for EIP-4844 blob data on Layer 1. Denominated in wei.
`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	gas	input	nonce	block_hash	to_address	access_list	source_hash	block_number	from_address	receipt_type	receipt_status	block_timestamp	receipt_gas_used	transaction_hash	transaction_type	receipt_logs_bloom	receipt_deposit_nonce	deposit_receipt_version	receipt_cumulative_gas_used
0x0	0x0	1000000	0x440a5e20000027100000000000000000000000000000000068fb169f000000000168cce50000000000000000000000000000000000000000000000000000000006ab11ef00000000000000000000000000000000000000000000000000000000000000017cf5402643d3572060b0d58f618a6b1f4860aaf2d3b0ea8c814e722209ed523b000000000000000000000000a76e31d8471d569efdd3d95d1b11ce6710f4533f	6706197	0x355db70b7f8301653f46357912f70fd7884d61b92648468f40cd2ddd67232c1f	0x4200000000000000000000000000000000000015	[{“address”:null,“storage_keys”:[]}]	0x7a8924267dae8f624ed3d8019ef69b221c548ff5ece19425814769c1ab7ff073	6706197	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	126	true	2025-10-24T06:05:29.000Z	49391	0x8fa740d107e2a0d66d23e34fd0e76556c3c9e88cdd5a719ab42fd71f0af164f9	126	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	6706197	0x1	49391
0x0	0x0	1000000	0x440a5e20000027100000000000000000000000000000000068fae4a7000000000168c8c700000000000000000000000000000000000000000000000000000000065db1b50000000000000000000000000000000000000000000000000000000000000001cec70f6069b9f721a6e01e4bd252cc48401300ed704b492cb19d95f0a2940152000000000000000000000000a76e31d8471d569efdd3d95d1b11ce6710f4533f	6704918	0x128d11a1306a8af3a7666919bd9c185a8ba007bb61689d83a5496fef98f1a5f1	0x4200000000000000000000000000000000000015	[{“address”:null,“storage_keys”:[]}]	0xe636dc5cfd5fb70ef8525a0d022e1c615a5a054d13b5df07e5070e38756f22b9	6704918	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	126	true	2025-10-24T02:32:19.000Z	49379	0x620addc04630246705f58d6bdda2afd666530b6ca25b77e1a5459e25ea18445b	126	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	6704918	0x1	49379
0x0	0x0	1000000	0x440a5e20000027100000000000000000000000000000000068fafa1f000000000168ca8d0000000000000000000000000000000000000000000000000000000005da0dee00000000000000000000000000000000000000000000000000000000000000010789473cf3dfd0b0bb9a2e62b00a8615ce4c122677bd0d1f3fec99bd93460a41000000000000000000000000a76e31d8471d569efdd3d95d1b11ce6710f4533f	6705468	0x4ae7c6d5b47a21ac61942ba7b247489a8c61b6b1b5360869baaf20a63aebd121	0x4200000000000000000000000000000000000015	[{“address”:null,“storage_keys”:[]}]	0x264a0a994ef82c940b33e67992d846d9fc0d00c6a3428e01fda68e8756074871	6705468	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	126	true	2025-10-24T04:03:59.000Z	49391	0x222a1b03ee511624545549768258481c1ebcc0cf0e656e7ab00482328229abce	126	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	6705468	0x1	49391

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.manta.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