iotex

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
`author`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`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.
`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.
`difficulty`	`FLOAT64`	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.
`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.
`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_beacon_block_root`	`STRING`	Root hash of the parent beacon chain block for post-merge consensus verification. 66-character hex string including 0x prefix.
`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.
`step`	`INT64`	Consensus step number in IoTeX’s Roll-DPoS protocol at which this block was produced. This value remains constant across sample blocks, indicating consensus epoch alignment.
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`total_difficulty`	`FLOAT64`	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<STRING>`	List of uncle block hashes included in the block. Empty array for chains not supporting uncle blocks in their consensus mechanism.
`withdrawals_root`	`STRING`	Merkle root hash of all validator withdrawals in the block. 66-character hex string including 0x prefix.

Sample Data

size	step	miner	author	number	uncles	timestamp	block_hash	difficulty	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	receipts_root	total_difficulty	transaction_count	transactions_root
1	373422302	0x006df2afaafd3df1e601c9561e5a3f6ba333fd8d	0x006df2afaafd3df1e601c9561e5a3f6ba333fd8d	22549390	[]	2023-03-10T08:58:55.000Z	0x74e8f7ce0845464170db748fbcac56ccd61ffcdcf6fc9b1ab64b66902d9a24bb	3.402823669209385e+38	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0xf33b7e185ea0a7c5e5608beae5af2e56b396a4dbb8262ec9d05a107a861670f1	0x3a867fea437affb2797f62bb7f3d192baf8544b1566888980c09e2968654ae5b	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x4ff0ec97c1ff914e74e8cf5798f4fe877f1e40c8b84b5ce3c415c00bf7d6d0a6	3.5552939893556495e+44	1	0x98ebabffc99612a589e5dd21e2a316cb2743889ab2b87624c71796dfbda2b770
1	373422302	0x006df2afaafd3df1e601c9561e5a3f6ba333fd8d	0x006df2afaafd3df1e601c9561e5a3f6ba333fd8d	22548639	[]	2023-03-10T07:56:20.000Z	0x7469980227bd5dedc737da0b377154410a6cf2a3d58fd92a006dbf13a225aab3	3.402823669209385e+38	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0xe5bebc1e9b171e4cf9ce463f242e92471b4fd6c41ccc14db221e7775802f7cc6	0x34e2716b71547c858bbbfce02333cb8942ade339f96f1b87b30c45441a5c3b3f	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x3b427c5a95ebf039ab3eb7febb1b83f93030aac07173ea272473ff201fc7dd00	3.5552939893556495e+44	1	0x6537d359be0abeaa474566f51635630ef2e4352d7b30da2b75effa22d90dfb7f
1	373422302	0x006df2afaafd3df1e601c9561e5a3f6ba333fd8d	0x006df2afaafd3df1e601c9561e5a3f6ba333fd8d	22549726	[]	2023-03-10T09:26:55.000Z	0x00b9fc7f942f2ea54057572deb2a4f1a94fb3cdb8f15820731c8707e57afc24d	3.402823669209385e+38	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x75e51a5be057f21d190ccac8686a421807c57408c093d8be916d442264f18c5e	0xc299454b341681b54add1d25f8291b4ee50f2955c5f49947844e9fe796d10966	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xe5efc73dd7bfb2831cfc0fe17311070f46062500e28f5420f26a881c61b56149	3.5552939893556495e+44	1	0x89637626e52323aafdca2563135c574266bfcdb06947dfbb4c586b6a574651d8

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.iotex.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
0x00000000000000000000000000000000000000000000000001aa535d3d0c0000	[“0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925”,“0x000000000000000000000000b2f6e0f3d6d7659e850c39e0b2ba61ebbd094992”,“0x0000000000000000000000005f8366b3ad32b639a796132f01bcd7c2a7097005”]	0x17df9fbfc1cdab0f90eddc318c4f6fcada730cf2	false	0	0x322d3148cfc3a6c4e6d0bfcf60d14953d41d2a6aaf1ea4c51d78af2d173632d5	24666206	2023-07-11T00:00:05.000Z	0xe38462dd261a267ea20515e14936642a20069f3df155bfc2dbdc6cb22fb673b0
0x00000000000000000000000000000000000000000000000001aa535d3d0c0000	[“0xdcd726e11f8b5e160f00290f0fe3a1abb547474e53a8e7a8f49a85e7b1ca3199”,“0x000000000000000000000000000000000000000000000000000000000023d0c0”,“0x000000000000000000000000b2f6e0f3d6d7659e850c39e0b2ba61ebbd094992”]	0x5f8366b3ad32b639a796132f01bcd7c2a7097005	false	2	0x322d3148cfc3a6c4e6d0bfcf60d14953d41d2a6aaf1ea4c51d78af2d173632d5	24666206	2023-07-11T00:00:05.000Z	0xe38462dd261a267ea20515e14936642a20069f3df155bfc2dbdc6cb22fb673b0
0x00000000000000000000000000000000000000000000000001aa535d3d0c0000	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x000000000000000000000000b2f6e0f3d6d7659e850c39e0b2ba61ebbd094992”,“0x0000000000000000000000005f8366b3ad32b639a796132f01bcd7c2a7097005”]	0x17df9fbfc1cdab0f90eddc318c4f6fcada730cf2	false	1	0x322d3148cfc3a6c4e6d0bfcf60d14953d41d2a6aaf1ea4c51d78af2d173632d5	24666206	2023-07-11T00:00:05.000Z	0xe38462dd261a267ea20515e14936642a20069f3df155bfc2dbdc6cb22fb673b0

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.iotex.logs`
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.
`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.
`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.
`expired_time`	`INT64`	Unix timestamp indicating when this transaction expires on the IoTeX network. Null for most transactions as expiration is an optional IoTeX-specific feature.
`payer`	`STRING`	IoTeX-specific address that pays transaction fees when differs from transaction sender. Null in standard transactions where the sender pays their own fees.
`payer_v`	`INT64`	ECDSA signature recovery identifier (v-value) for the payer component of IoTeX transactions. Null for standard transactions; present when a third-party payer covers gas fees.
`payer_r`	`STRING`	ECDSA signature component r from the transaction payer on IoTeX for sponsored transactions. Null for non-sponsored transactions where the sender pays their own gas.
`payer_s`	`STRING`	ECDSA signature component ‘s’ value from the payer’s signature in IoTeX fee-delegated transactions. Null for standard transactions where sender pays their own gas fees.
`blob_versioned_hashes`	`ARRAY<STRING>`	Array of commitment hashes for EIP-4844 blob data attached to the transaction. Each hash is a 66-character hex string including 0x prefix that references blob data stored separately from the transaction.
`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.
`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_fee_per_blob_gas`	`NUMERIC`	Maximum gas price per unit willing to be paid for blob data in EIP-4844 transactions. Integer value denominated in wei, specified by the transaction sender to limit the cost of posting blob data separately from transaction execution.
`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.
`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_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_payer`	`STRING`	Address of the account that paid gas fees for this transaction on IoTeX. Null in most cases; populated only for transactions using IoTeX-specific gas delegation features.
`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_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`receipt_blob_gas_price`	`NUMERIC`	Actual price per unit of blob gas paid for EIP-4844 blob transactions. Integer value denominated in wei.
`receipt_blob_gas_used`	`INT64`	Gas units consumed for blob data storage in EIP-4844 transactions. Integer value representing the amount of gas specifically used for posting blob data, separate from execution gas.

Sample Data

r	s	v	input	block_hash	to_address	access_list	block_number	from_address	receipt_status	block_timestamp	transaction_hash	receipt_logs_bloom	blob_versioned_hashes
0xede9b7f524c5c23c7d3aec5cdd94e0811a3e818936e68423994fb70a35f26161	0x7441d1083d786af3299a2210a5057d15ed84814212eae8230750d3a993954516	27	0xd72778dc0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000055ffca	0xcd3c3d9d0125c3a626e4afbcd1297ac17669ddd37bcdd8b0e32ffd66ebcd4c2f	0xa576c141e5659137ddda4223d209d4744b2106be	[{“address”:null,“storage_keys”:[]},{“address”:null,“storage_keys”:[]}]	5636042	0x003b072f9e1e32cedf980a4d8788c679ce127dcb	true	2020-06-29T06:09:40.000Z	0xf439a31036346846822aa70d8056535d9fbc5b54ebac4bad966bd9229065e825	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]
0x54fd0a48ff430950deafd9cd8b8e00af238359fc85b99a543686bd12b190f32	0x5eae4520fa5c73dd01e7dbfb6c8aab6bfdbbc7f83e2217b723f653991a2a8dba	27	0xd72778dc0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000055f665	0xb97732ec9359790b8449dbfb07c499506025d966ff831aa48822757c6210745b	0xa576c141e5659137ddda4223d209d4744b2106be	[{“address”:null,“storage_keys”:[]},{“address”:null,“storage_keys”:[]}]	5633637	0x003b072f9e1e32cedf980a4d8788c679ce127dcb	true	2020-06-29T02:49:15.000Z	0x9f7405a26a9e4025a2c1bda2248a25e270a001dbe4cea80226044b7f08767b57	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]
0xf03e763af8c1350455cc028cbfe27e8486240fcbb8fb7d29eb3390be8aaec4aa	0x30a56345fa9c81b6453afc6199303ee35d904e39ca432978ffe06f3ffaf25b91	27	0xd72778dc0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000056017a	0xe70835bda9bcbd1b557dd723639f62bf4589252671d87141d24c83fc08fc0882	0xa576c141e5659137ddda4223d209d4744b2106be	[{“address”:null,“storage_keys”:[]},{“address”:null,“storage_keys”:[]}]	5636474	0x003b072f9e1e32cedf980a4d8788c679ce127dcb	true	2020-06-29T06:45:40.000Z	0xb49bb53f0eb93f6f8b2a6e53c04d8c4bd372ff41f824d02e1110a8227c94f664	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

logs

transactions

Metrics

Primitives

Contracts

Blockchain

​Tables

​blocks

​logs

​transactions

Tables

blocks

logs

transactions