metis

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
`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.
`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.
`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.
`block_hash`	`STRING`	Unique identifier for the block. 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.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`mix_hash`	`STRING`	Hash value used in proof-of-work mining or consensus verification. 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.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 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.
`sha3_uncles`	`STRING`	Keccak-256 hash of the RLP-encoded list of uncle block headers. 66-character hex string including 0x prefix.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`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.
`transaction_count`	`INT64`	Number of transactions included in the block.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
`uncles`	`ARRAY<JSON>`	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
933	0x0000000000000000000000000000000000000000	0x0000000000000000	19850801	[]	21000	0x0000000000000000000000000000000000000000000000000000000000000000	1100000000	2025-03-05T18:36:28.000Z	0x6a6d15c62ec1d33397b982a3629d209246d61bdcd7cc1a4e9de706348e789824	2	0xd98301090a846765746889676f312e31352e3133856c696e757800000000000047047245da0fe28d802554a8471e59e299eaf410fcda786172ac71ddfe2cdb904eda092270f26b4499d4975789fd58308c980d0b883a858dc0071980036df2fc00	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0xeca2383bc0b5fd8acee37e3a94b94eb692c15df4756c07d3a5c062ee090f2f40	0x00f05aee610856b1a60dd2344e2cdd448114552c929e741bc89cd2cafc1aa57e	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x056b23fbba480696b65fe5a59b8f2148a1299103c4f57df839233af2cf4ca2d2	39701603	1	0x864616d20001918789c24f9af2cf6cc5bbea3a024d93e9dad6c436e32c9133e1
941	0x0000000000000000000000000000000000000000	0x0000000000000000	19849576	[]	21000	0x0000000000000000000000000000000000000000000000000000000000000000	1100000000	2025-03-05T14:28:09.000Z	0xa204b08f3a8bba51142e67381117c1a6dcde7ab6dd2c44d09f8f4662902734ec	2	0xd98301090a846765746889676f312e31352e3133856c696e75780000000000002d299d68f9968d86807346908cbef588064e7b686d62a4b45f4f230f0373a1a704ec3b292bf76e0bcb84d655b7b167e941c5f96e1d517a0ca06a1714ddcd849a00	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x285ecdd86bebdf64e6529189af08b6309001a16aaef1a4598d041f818baee880	0x32156a7ef5d966bfdfdb9ed9b27641fc76069bf0d542cec1b5d752b97c803f0d	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x056b23fbba480696b65fe5a59b8f2148a1299103c4f57df839233af2cf4ca2d2	39699153	1	0xb2c0b9fcb06fbcb05d9a3c8d574d02619ab86fce9b53d679ec1bf43b173bd757
943	0x0000000000000000000000000000000000000000	0x0000000000000000	19848099	[]	47835	0x0000000000000000000000000000000000000000000000000000000000000000	1100000000	2025-03-05T09:38:00.000Z	0x2820f628794d9f12a9cb86ed82d0fdb2b459c32ee7fba472473ff314907c3e27	2	0xd98301090a846765746889676f312e31352e3133856c696e75780000000000007dadf1fc8493ce7002a8ddebbd590dd2d28e58d07cc54049cb36328acd890dbd20834af96ec2947721a42ebf0858e3e47d09c040e5d8c8a0a7a9d36e68e8b69100	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000480000000000000000002000000000000000000000040000000000000000008000000000000000000000000000000000000000000000080000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000200000000000	0xb82190b29cd795231fdca369edc9710aa8c69a6879672231d1bb7fa10b0369f9	0xc3d769c9e7998ccd604f863b108f28d5b132de634816c1089104f54e926e684a	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xd18960849220314e8ae4f52eace9ba9fe3fe03a0ba598deb84459e82987832d7	39696199	1	0x4eb1b3980f1a9a2e22aa683b5f13b27f6cfbb44a60792dd321a2e8f32dc3db4e

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.metis.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.
`address`	`STRING`	Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.
`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.
`data`	`STRING`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 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.
`block_hash`	`STRING`	Unique identifier for the block. 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.
`removed`	`BOOL`	Indicates whether the log was removed due to a chain reorganization.

Sample Data

data	topics	address	removed	log_index	block_hash	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000294224f000000000000000000000000000000000000000000000000000000003943d0820000000000000000000000000000000000000000000000000000000000000000	[“0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822”,“0x0000000000000000000000002d4f788fdb262a25161aa6d6e8e1f18458da8441”,“0x000000000000000000000000723243e7d7a17877e4b8b359fdcde511266508d9”]	0xa3e8e7eb4649ffc6f3cbe42b4c2ecf6625d3e802	false	11	0x008ee0a8d1035203c7d13c6778f70a9f794abe15dd97a9656fda870c6b2237ae	10371888	2024-01-01T00:00:20.000Z	0x9a0f2e1b60a45eebf73ac51bb1116091e174d158ecbd252e3f6497f1a5672f57
0x000000000000000000000000000000000000000000000000000000003943d082	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x000000000000000000000000a3e8e7eb4649ffc6f3cbe42b4c2ecf6625d3e802”,“0x000000000000000000000000723243e7d7a17877e4b8b359fdcde511266508d9”]	0x72c232d56542ba082592dee7c77b1c6cfa758bcd	false	7	0x008ee0a8d1035203c7d13c6778f70a9f794abe15dd97a9656fda870c6b2237ae	10371888	2024-01-01T00:00:20.000Z	0x9a0f2e1b60a45eebf73ac51bb1116091e174d158ecbd252e3f6497f1a5672f57
0x000000000000000000000000000000000000000000000000000000000294224f	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x0000000000000000000000005ab390084812e145b619ecaa8671d39174a1a6d1”,“0x000000000000000000000000a3e8e7eb4649ffc6f3cbe42b4c2ecf6625d3e802”]	0xea32a96608495e54156ae48931a7c20f0dcc1a21	false	2	0x008ee0a8d1035203c7d13c6778f70a9f794abe15dd97a9656fda870c6b2237ae	10371888	2024-01-01T00:00:20.000Z	0x9a0f2e1b60a45eebf73ac51bb1116091e174d158ecbd252e3f6497f1a5672f57

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.metis.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
`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_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`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.
`value`	`FLOAT64`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`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.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.
`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.
`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.
`error`	`STRING`	Error message returned when transaction execution fails. Empty when execution succeeds.
`revert_reason`	`STRING`	Human-readable explanation for why a transaction or call reverted during execution. Empty when execution succeeds.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`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.
`status`	`BOOL`	Success indicator for the operation. Boolean value where true indicates successful execution and false indicates failure.

Sample Data

gas	input	output	status	gas_used	trace_id	to_address	trace_type	block_number	from_address	trace_address	block_timestamp	transaction_hash	transaction_index
778623	0x0902f1ac	0x000000000000000000000000000000000000000000000000000000006f2de4f0	false	620	STATICCALL_0x75eeeedc3c614a48c8a5d11ade657ca7fc8c39dfbba07a3f77f6a2238627641d_1	0x0a72d3bc826e9c435c6a2e6a59b5a62c372d112a	STATICCALL	19429178	0x0000000000002f2c7bc8de9ad25fcf041b4679c6	1	2025-01-10T22:40:02.000Z	0x75eeeedc3c614a48c8a5d11ade657ca7fc8c39dfbba07a3f77f6a2238627641d	2
781485	0x70a082310000000000000000000000001d347debf7b4c6ef0e7fbefd94d74f75156a16a5	0x00000000000000000000000000000000000000000000009abdbcff40beef9f91	false	2446	STATICCALL_0x75eeeedc3c614a48c8a5d11ade657ca7fc8c39dfbba07a3f77f6a2238627641d_0	0x75cb093e4d61d2a2e65d8e0bbb01de8d89b53481	STATICCALL	19429178	0x0000000000002f2c7bc8de9ad25fcf041b4679c6	0	2025-01-10T22:40:02.000Z	0x75eeeedc3c614a48c8a5d11ade657ca7fc8c39dfbba07a3f77f6a2238627641d	2
633515	0x70a08231000000000000000000000000d0c5ecbb9e363531ea4cbf5807837c656d308eb0	0x0000000000000000000000000000000000000000000000ccb71090781e99adbd	true	2446	STATICCALL_0x28a975170f0c71a9c1f3a12dbeaf1cb1674bc60ea92db87061135e08fce930e7_0	0x75cb093e4d61d2a2e65d8e0bbb01de8d89b53481	STATICCALL	19422662	0x0000000000002f2c7bc8de9ad25fcf041b4679c6	0	2025-01-10T04:44:59.000Z	0x28a975170f0c71a9c1f3a12dbeaf1cb1674bc60ea92db87061135e08fce930e7	0

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.metis.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_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.
`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.
`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.
`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.
`value`	`STRING`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`v`	`INT64`	ECDSA signature component v from the transaction signature. Integer value used for signature verification and public key recovery.
`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.
`queue_origin`	`STRING`	Origin type of the transaction in Metis’s queue system. Typically set to ‘sequencer’ for L2 transactions processed by the Metis sequencer.
`l1_tx_origin`	`STRING`	Ethereum Layer 1 address that originated the transaction when submitted via the L1 bridge to Metis. Defaults to zero address for transactions submitted directly to the Metis sequencer.
`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.
`l1_timestamp`	`TIMESTAMP`	Timestamp when this transaction was anchored to Ethereum Layer 1 for data availability and security. Null for transactions that originated directly on Metis (sequencer origin).
`index`	`INT64`	Position of the transaction within its block on Metis Andromeda. Unique sequential identifier starting from 0 for ordering transactions in a block.
`queue_index`	`INT64`	Position of the transaction within the Metis sequencer queue when submitted via the Layer 2 ordering system. Typically 0 for sequencer-originated transactions as seen in the samples.
`raw_transaction`	`STRING`	RLP (Recursive Length Prefix) encoded signed transaction data as submitted to the Metis network. Hex-encoded string containing all transaction parameters, signature components, and metadata required for broadcast and verification.
`seq_r`	`STRING`	ECDSA signature component (r-value) for sequencer-signed transactions on Metis L2. Null for user-originated transactions, populated only for transactions signed by the sequencer batch processor.
`seq_s`	`STRING`	Signature component ‘s’ for sequencer-signed transactions on Metis L2. Null for standard user transactions; populated only for transactions submitted directly by the sequencer.
`seq_v`	`INT64`	ECDSA signature recovery parameter for sequencer-signed transactions on Metis Layer 2. Null for user-submitted transactions; populated only when queue_origin is ‘sequencer’.
`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.
`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.
`chain_id`	`INT64`	Numeric identifier for the blockchain network. Integer value that uniquely identifies the blockchain according to EIP-155 chain ID standard.
`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.
`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_gas_used`	`INT64`	Gas units consumed by this specific transaction.
`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_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_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_effective_gas_price`	`INT64`	Actual gas price paid per unit for transaction execution. Integer value denominated in wei.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.

Sample Data

r	s	v	gas	index	input	nonce	value	gas_price	block_hash	to_address	access_list	block_number	from_address	l1_tx_origin	queue_origin	receipt_status	block_timestamp	l1_block_number	raw_transaction	receipt_gas_used	transaction_hash	receipt_logs_bloom	receipt_cumulative_gas_used
0xe2a77bf2d760ec6e93d3093ea9d94b4245a990f08554935507e3b5e9ab4f8d0a	0x4d7ff480290df09a1ce407074b8e6cbb998e4557da7beef02aeee6653aae2f5b	2212	21000	1074866	0x	11	2237501894719800318	18000000000	0xc6c7e527297cb7b9b73af8baaa7f52b93ea8779c29896e864117f2b6df440964	0x66392cae8619293fe638378f60818caccee4a67d	[{“address”:null,“storage_keys”:[]}]	1074867	0xe787dcc6147c10e4410e371222189e9e3c9a54ce	0x0000000000000000000000000000000000000000	sequencer	false	2022-03-01T19:11:58.000Z	14302931	0xf86e0b850430e234008252089466392cae8619293fe638378f60818caccee4a67d881f0d341e530983fe808208a4a0e2a77bf2d760ec6e93d3093ea9d94b4245a990f08554935507e3b5e9ab4f8d0aa04d7ff480290df09a1ce407074b8e6cbb998e4557da7beef02aeee6653aae2f5b	21000	0xc46681934b20ea373494af7d5d18b42e05b8d918bc4785cf94074814bbd93d74	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	21000
0x2fafa0d4e47cb84c06d1fcd4f2841056b0b5028ad728a945e2bb33d1a4423c60	0x33710ec33f16f78eb683935da37d7fa73cb5af69dfb5ba81dd0ebf02d9692e6d	2212	200000	1072593	0x44a0d68a000000000000000000000000000000000000000000000000000000003b9aca00	32	0	18000000000	0x9c079540b6eecf9c5af55abe72ae0d02e13f45d7095b16bd0672d6417cb9575c	0x54af20db4a4b65b2b8f0b0cda910925c43a55e3d	[{“address”:null,“storage_keys”:[]}]	1072594	0x42b9cfe0a0a2faa3fdce96057b4540a876a8f967	0x0000000000000000000000000000000000000000	sequencer	false	2022-03-01T15:49:56.000Z	14302045	0xf88b20850430e2340083030d409454af20db4a4b65b2b8f0b0cda910925c43a55e3d80a444a0d68a000000000000000000000000000000000000000000000000000000003b9aca008208a4a02fafa0d4e47cb84c06d1fcd4f2841056b0b5028ad728a945e2bb33d1a4423c60a033710ec33f16f78eb683935da37d7fa73cb5af69dfb5ba81dd0ebf02d9692e6d	21228	0x4a548d4513b3afd39b093b1a07cbebf50c20dd089add8deb56db3688150ec024	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	21228
0x406321e3b67a1c181f56bac71be74c9d71cb921866fb19350351d88309b8329a	0x2804f4aa1f6a31ae5590a028ed201381041fa5c2555c7d47c3f6c64e97ac04ee	2212	500000	1072161	0xe2bbb15800000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000	9	0	18000000000	0xb6527c4b707d710f78208fce8ecc304eafd436b0df72d676c7c6907d5d8f0cde	0x54a8fb8c634ded694d270b78cb931ca6bf241e21	[{“address”:null,“storage_keys”:[]}]	1072162	0xfb69cef879215c81c670983be6d7a4d6472c056f	0x0000000000000000000000000000000000000000	sequencer	false	2022-03-01T15:19:39.000Z	14301904	0xf8ac09850430e234008307a1209454a8fb8c634ded694d270b78cb931ca6bf241e2180b844e2bbb158000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000008208a4a0406321e3b67a1c181f56bac71be74c9d71cb921866fb19350351d88309b8329aa02804f4aa1f6a31ae5590a028ed201381041fa5c2555c7d47c3f6c64e97ac04ee	21332	0x0a87b5bd5f60f4a23940689a8f8eb362890234cd6d0926d9fb3047bc086fb11d	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	21332

Example Query

Query with partition filter

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