hyperevm

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
`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.
`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.
`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.
`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.
`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.
`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.
`requests_hash`	`STRING`	Hash of the execution layer requests included in the block. 66-character hex string including 0x prefix, or keccak256 hash of an empty byte string when no requests are present.
`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.
`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.
`withdrawals_root`	`STRING`	Merkle root hash of all validator withdrawals in the block. 66-character hex string including 0x prefix.
`withdrawals`	`ARRAY<JSON>`	List of validator withdrawal records included in the block. Each withdrawal contains recipient address, amount withdrawn, withdrawal index, and validator index for proof-of-stake consensus mechanisms.
`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	mix_hash	gas_limit	timestamp	block_hash	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	withdrawals	receipts_root	base_fee_per_gas	withdrawals_root	transactions_root	parent_beacon_block_root
585	0x0000000000000000000000000000000000000000	0x0000000000000000	6525833	[]	0x0000000000000000000000000000000000000000000000000000000000000000	2000000	2025-06-23T07:47:55.000Z	0x8b51c91fdd272f1b325562c8a87e1d91e4a84f1a22211e6c2c8a4cdf901fa69c	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x151b42e82f4f7d39ec3dd8a87f06d5baf9e95d3228134d11d6d6be522fa2bccd	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[]	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	100000000	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	0x0000000000000000000000000000000000000000000000000000000000000000
585	0x0000000000000000000000000000000000000000	0x0000000000000000	6512906	[]	0x0000000000000000000000000000000000000000000000000000000000000000	2000000	2025-06-23T04:16:00.000Z	0xb16b9ef99b3f013348da18ec3e376a72d3f4a5500b07668c7e962f3550dcf3ce	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x00657e24808c5a5d61f3a34d6b1113a095639388b044483c4bee885f40964551	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[]	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	100000000	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	0x0000000000000000000000000000000000000000000000000000000000000000
585	0x0000000000000000000000000000000000000000	0x0000000000000000	6538118	[]	0x0000000000000000000000000000000000000000000000000000000000000000	2000000	2025-06-23T11:09:18.000Z	0x628986490c4b3bb7273195bcbefe7ce44537d7a2dfb32ebdd02a4be0cd577fb9	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x9b6aba615f991a1ed1e8741b39926e2d97c75bc7893f8380a705d50da108c78e	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[]	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	100000000	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	0x0000000000000000000000000000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.hyperevm.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	block_hash	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000000000000000000000000001	[“0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31”,“0x0000000000000000000000006c407a43fc106c976cec70455067b8e10ca9f371”,“0x0000000000000000000000007be8f48894d9ec0528ca70d9151cf2831c377be0”]	0x44b598c9acd2aecc3fc6b285f72e434c93ab4077	false	0x3619ffaabe8b6ef28c8431270f0c5b32dc98915339d14d2984c0e00280b97804	1019872	2025-03-13T00:00:00.000Z	0xe25cb30b6a1d56fea67e9adc67f0de1dccb81300058f03b0888dd45b72fad857
0x	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x0000000000000000000000009645ca7f83323611d0ce6a8e67faf9813e3f9ef3”,“0x0000000000000000000000002921b419f43898b25d32b74a1f49657f0989a56d”,“0x00000000000000000000000000000000000000000000000000000000000009a4”]	0x44b598c9acd2aecc3fc6b285f72e434c93ab4077	false	0x913a72790e89dd12bec6867f59d16720f284802e7c4115f691f2dd973ac40b9c	1019875	2025-03-13T00:00:04.000Z	0xa4322221754a136fb37e37c096b89c866664675e0d23dd6cbe307ef4e9252b59
0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000174876e8000000000000000000000000000000000000000000000000000000000067d2212c0000000000000000000000000000000000000000000000000000000067d33a6c0000000000000000000000000000000000000000000000000000000067d372ac000000000000000000000000ffbe385ca6e7d084e96d64c46979f9acb1ff556c00000000000000000000000000000000000000000000000000000000000000034254430000000000000000000000000000000000000000000000000000000000	[“0xb362a0ab21ba3a158a0c45f03e607cd10cb7731e03aaa535248d1f055dde08d0”,“0x000000000000000000000000000000000000000000000000000000000000009d”]	0x728dd2c9b995b0345a27e21aca35e02c7f642455	false	0x09137a2c3d108a375dd7d1fb186f5e6275494a073ef39a24ed6fe555d6ebf915	1019878	2025-03-13T00:00:10.000Z	0x824ec54511a1fdb0839c26496746ae7a3ee45f1f13743640a062ae80900f095e

Example Query

Query with partition filter

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

receipts

Transaction execution receipts from HyperEVM blockchain containing gas usage, event logs, and status outcomes. Used for analyzing transaction success rates, gas consumption patterns, and detailed event-driven protocol interactions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_date`	`DATE`	Date when the block was produced. Derived from block timestamp, truncated to day precision.
`block_number`	`STRING`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`transaction_index`	`STRING`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`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.
`contract_address`	`STRING`	Contract address created by this transaction if it deployed a new smart contract. Null for regular transfers and contract calls that do not deploy new contracts.
`gas_used`	`STRING`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`cumulative_gas_used`	`STRING`	Total gas consumed by all transactions in the block up to and including this transaction. Hex-encoded value representing the running sum of gas used within the block.
`effective_gas_price`	`STRING`	Gas price paid per unit of gas for this transaction, denominated in wei. This is the actual price paid after EIP-1559 priority and base fee calculation.
`status`	`STRING`	Success indicator for the operation. Boolean value where true indicates successful execution and false indicates failure.
`receipt_type`	`STRING`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`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.
`logs`	`ARRAY<STRUCT<address STRING, blockHash STRING, blockNumber STRING, blockTimestamp STRING, data STRING, logIndex STRING, removed BOOL, topics ARRAY<STRING>, transactionHash STRING, transactionIndex STRING>>`	Structured array of event logs emitted during transaction execution, containing event signatures, indexed topics, and non-indexed data. Empty for simple transfers that don’t trigger contract events.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`number_index`	`INT64`	Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.
`receipt_index`	`INT64`	Position of this transaction receipt within the block, ordered sequentially starting from 0. Useful for ordering transactions when analyzing block-level activity.

Sample Data

logs	number	status	gas_used	block_date	block_hash	logs_bloom	to_address	block_number	from_address	receipt_type	receipt_index	block_timestamp	transaction_hash	transaction_index	cumulative_gas_used	effective_gas_price
[{“data”:“0x000000000000000000000000000008b8724dbcc28649f3fe374222dd9c38cca500000000000000000000000054d53876f81d1148642a58e923e45240294658200000000000000000000000000000000000000000000000000000000000000374000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000068155a43676e00000000000000000000000000000000000000000000000000000000000067ebcfec0000000000000000000000005555555555555555555555555555555555555555”,“topics”:[“0xde1951e410d2f4644b8dd23d6b9e5d2e862b417055f42e3939ab16b4635ec6de”],“address”:“0x7be8f48894d9ec0528ca70d9151cf2831c377be0”,“removed”:false,“logIndex”:“0x1”,“blockHash”:“0x06d0c9593b59e7cf8239eaa525bd6ea00feadee4b7d8bbb069cec5c04c4e39b0”,“blockNumber”:“0x86696”,“blockTimestamp”:“0x67c442f0”,“transactionHash”:“0x042f1ac3b3862c9d294cb0f0c56508903e40703977b475ec899e585e5db6ca14”,“transactionIndex”:“0x1”}]	550550	0x1	0xf842	2025-03-02	0x06d0c9593b59e7cf8239eaa525bd6ea00feadee4b7d8bbb069cec5c04c4e39b0	0x00000000000000000000000000000000000080000400000000000000010000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x7be8f48894d9ec0528ca70d9151cf2831c377be0	0x86696	0x000008b8724dbcc28649f3fe374222dd9c38cca5	0x0	1	2025-03-02T11:37:20.000Z	0x042f1ac3b3862c9d294cb0f0c56508903e40703977b475ec899e585e5db6ca14	0x1	0x1bb39	0x7270e00
[{“data”:“0x000000000000000000000000000000000000000000000002d29459886e401c4d”,“topics”:[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x000000000000000000000000d2735f40db3b1ab7020abfdef224845dfc47e279”,“0x000000000000000000000000000158e60c393b51fdfac71b14ce70b70148c326”],“address”:“0x5555555555555555555555555555555555555555”,“removed”:false,“logIndex”:“0x0”,“blockHash”:“0xf9b16d6ed801e4c138d67b12643f50e6316e2047f3a44022cbd1e47fd6d27e84”,“blockNumber”:“0x895dc”,“blockTimestamp”:“0x67c49e70”,“transactionHash”:“0xa860feaace5f6291896046cafe068c6b83208b4f358b07a74a157a82a5a7bc09”,“transactionIndex”:“0x0”},{“data”:“0x00000000000000000000000000000000000000000000003635c9adc5dea00000”,“topics”:[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x000000000000000000000000000158e60c393b51fdfac71b14ce70b70148c326”,“0x000000000000000000000000d2735f40db3b1ab7020abfdef224845dfc47e279”],“address”:“0xb5fe77d323d69eb352a02006ea8ecc38d882620c”,“removed”:false,“logIndex”:“0x1”,“blockHash”:“0xf9b16d6ed801e4c138d67b12643f50e6316e2047f3a44022cbd1e47fd6d27e84”,“blockNumber”:“0x895dc”,“blockTimestamp”:“0x67c49e70”,“transactionHash”:“0xa860feaace5f6291896046cafe068c6b83208b4f358b07a74a157a82a5a7bc09”,“transactionIndex”:“0x0”},{“data”:“0xfffffffffffffffffffffffffffffffffffffffffffffffd2d6ba67791bfe3b300000000000000000000000000000000000000000000003635c9adc5dea00000000000000000000000000000000000000000000463074605fc5a2010c83f65610000000000000000000000000000000000000000000009aca676d8184a679ed10000000000000000000000000000000000000000000000000000000000007385”,“topics”:[“0xc42079f94a6350d7e6235f29174924f928cc2ac818eb64fed8004e115fbcca67”,“0x0000000000000000000000004e2960a8cd19b467b82d26d83facb0fae26b094d”,“0x000000000000000000000000000158e60c393b51fdfac71b14ce70b70148c326”],“address”:“0xd2735f40db3b1ab7020abfdef224845dfc47e279”,“removed”:false,“logIndex”:“0x2”,“blockHash”:“0xf9b16d6ed801e4c138d67b12643f50e6316e2047f3a44022cbd1e47fd6d27e84”,“blockNumber”:“0x895dc”,“blockTimestamp”:“0x67c49e70”,“transactionHash”:“0xa860feaace5f6291896046cafe068c6b83208b4f358b07a74a157a82a5a7bc09”,“transactionIndex”:“0x0”}]	562652	0x1	0x267b1	2025-03-02	0xf9b16d6ed801e4c138d67b12643f50e6316e2047f3a44022cbd1e47fd6d27e84	0x00000000000000020000000000800000000000000000000000000000000000000000000000000000000000000000000004000000000020002000000000000000000000000000000800001008000000000000002000000000000000000000000000000000000001000000000400000400000000000000000408000010000800000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000002000000000002000000000100000000000000000000000001000000000000000000080000004000000000000000000000000000000000000000000000	0x4e2960a8cd19b467b82d26d83facb0fae26b094d	0x895dc	0x000158e60c393b51fdfac71b14ce70b70148c326	0x0	0	2025-03-02T18:07:44.000Z	0xa860feaace5f6291896046cafe068c6b83208b4f358b07a74a157a82a5a7bc09	0x0	0x267b1	0x7270e00
[]	559143	0x1	0x5208	2025-03-02	0x29188354294429605902efede6fa6f00d19d6f292a26e0acd0c24f01a19a879d	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x2075c3bb28144346ea127aba54df7d2f58656247	0x88827	0x00071360d75385c4c25dd8f217465693ffe91a69	0x0	0	2025-03-02T16:14:32.000Z	0x5918b113a04cf2fdef2e82de11835f88bc8e4c834426f18e004b9693ce209146	0x0	0x5208	0x7270e00

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.hyperevm.receipts`
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).
`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.
`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.
`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, storageKeys 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_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.

Sample Data

r	s	v	gas	input	nonce	value	chain_id	y_parity	gas_price	block_hash	to_address	access_list	block_number	from_address	receipt_type	receipt_status	block_timestamp	max_fee_per_gas	receipt_gas_used	transaction_hash	transaction_type	receipt_logs_bloom	max_priority_fee_per_gas	receipt_cumulative_gas_used	receipt_effective_gas_price
0x74ea27b7837a91b612e9c250cdf25f87b4e1e88f405fe251df56e6c4828e5725	0x41fbeef38882624ab52ec0bf2469a48f51813acdb396638fadbb9091fc97f6e8	0	21000	0x	244	6000000000000000000	999	0	120740321	0x799b92a422845cd3a2657c4f840877b8703552ddc84b24b17ad3100239e7aa8c	0x1be82cf51c5e56dbd0d0f476b44798a081cc965b	[{“address”:null,“storageKeys”:[]}]	16069006	0xbfeb480177971ca34c7088b0479da12ac4c3031c	2	true	2025-10-10T01:06:30.000Z	420740321	21000	0xfa91a180ecf6478959ccf461cb8d3fc4cdcdb1da35fcb7d5aaa2adf76e9855e0	2	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	20740321	21000	120740321
0xc04100ce19b8e1664fd8280255324bc62097ea850e8b389aa2c7a282cde105c8	0x16cebccfe332c64a8217e6faf06bee0a5d1ecc9ee63cdf573ae15c6c16c54139	2033	21000	0x	2382	0	999		32800305706	0xd1b362aca102cb2a89f922f5c78f18b261677ed930209c6c129c8ae2a34e16ba	0xe1a9fc32755bd4ed8955c01a23afc6430a07f575	[{“address”:null,“storageKeys”:[]}]	16128666	0xe1a9fc32755bd4ed8955c01a23afc6430a07f575	0	true	2025-10-10T17:24:32.000Z		21000	0xab504bf81272e03cb399fd2120dc032bade0171fe0e988945aa491179ba2d03e	0	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000		21000	32800305706
0x1	0x1	2034	30000	0x	722343	700000000000000000	999		0	0xf3c10d4d85af6039f78ab65023792ae8972ea4c746dfa1778fa66f41a55616a5	0xf63023c7afde71b113e6c9340a3b1fbd52cfa8b6	[{“address”:null,“storageKeys”:[]}]	16144795	0x2222222222222222222222222222222222222222	0	true	2025-10-10T21:48:57.000Z		0	0xe4416a216b077ff77e2ff5323c40c6233388383c12b07fd372033ab3b1635cdf	0	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000		0	0

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

logs

receipts

transactions

Metrics

Primitives

Contracts

Blockchain

​Tables

​blocks

​logs

​receipts

​transactions

Tables

blocks

logs

receipts

transactions