mode

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.
`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<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.
`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.
`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.

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	withdrawals_root	transaction_count	transactions_root	parent_beacon_block_root
1976	0x4200000000000000000000000000000000000011	0x0000000000000000	12266169	[]	1707825	0x1d44c2bac93bea9a3d9ccefc9e21c4736184b0cae860485b75b0f8be5e919bdd	30000000	2024-08-26T19:18:41.000Z	0xde555db43aa05d63e8e3e2f4241a6029dbdb593eb02936e5e8127936da4157f3	0x	0x00000100000000400000000000040008000020000400000400040000000000000200008000004000000000100000000008000000000000040020004000200000000000000000000100000008000000000000000000080000200000000040000000080000020000000000000002000800000010000000000000000010080000004000000000000000000000000800000000000000002040000000000000000000020000000002000000000000000014000000000000000000000000000200002000000002000004000000000020000000000000000003004000000000080020000010001000000204001000000000002010000020400000020000000000400020	0x189e7684266835c9e39da105778698df9c021abf8a5b21546357fea840dcfad4	0xe74c001c142fa49932bfbd2f26f2029317bce4bc1aa69d5befc8157bbd3b5390	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xb9e0e76d08914c06e454c5a6c9ddcba89644d976a27217ae218c122ea1f8edb2	313	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	5	0x429ae875da49b6925efa96d812d6f3bdcfb8795f01ffcc520fdfe9acc2ebe76d	0x0005290e4ef870e4c91a3fa3bc47fe70abe2f30e04cf75112c94cba76eb0dd1b
1141	0x4200000000000000000000000000000000000011	0x0000000000000000	12266164	[]	1065957	0x1d44c2bac93bea9a3d9ccefc9e21c4736184b0cae860485b75b0f8be5e919bdd	30000000	2024-08-26T19:18:31.000Z	0x35cacc56932747d645dac38e11f5110acc3920054f64a24da8c4bf25345699bf	0x	0x00000000000000000000000000000000000000000000000100040000000000000000000000000000000000100000000000000000000000000000000000200000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000002000000000000000000008020000020000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000	0x251f70a1b1f8c1aca4b078e35fb4e2df2127cb927b1809f8908a725376cfd33e	0x4eb6fd8437727f6d64eab40dc1684432ea4412ad535687f3f0517f6e776d7af2	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xa006cee3da603fc2866c248dd558393a1a6e08446a22db2c6ee0e6b3e848849b	313	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	3	0x4fede17a51a07962db7154c4a038b2685cbd06a926e99ca71fd9eb1c95c95ed9	0x0005290e4ef870e4c91a3fa3bc47fe70abe2f30e04cf75112c94cba76eb0dd1b
1303	0x4200000000000000000000000000000000000011	0x0000000000000000	12266167	[]	1799749	0x1d44c2bac93bea9a3d9ccefc9e21c4736184b0cae860485b75b0f8be5e919bdd	30000000	2024-08-26T19:18:37.000Z	0x96e99812d9f50fac442271a757516c45d25ef3e24d14c49490e8f4d323ebc002	0x	0x00000000000000000000000000000000000000004000000000040000000000040000000000000080000000100002000000000000000000000000000000000000040000000440000000000008000000000000000000000000000000000012000000000000000000000000800000000000000000000000000000000010000000000020000000020000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000800000000000000004200000000000000000000008000000000002020000000000000000	0x45ae07d5ab04fb26f047ce4f3bd89666a943402c2d37da258c9d667fdc624493	0x341830fd86c9bf34a113f11fe53b0239490f073abc3eb9f8d55b1aeed86d431b	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x859b9fa39d086ea9d2db399b96277073c5b7b8ffb2e29ab625a021c6b9429bde	313	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	3	0x94088a81f866779ebfe930b0ed6463072cdee72262f6b71538b4645f937607fd	0x0005290e4ef870e4c91a3fa3bc47fe70abe2f30e04cf75112c94cba76eb0dd1b

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.mode.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.
`signature`	`STRING`	# Canonical Column Description: signature

Cryptographic signature authorizing the operation. Hex-encoded string format, typically 130-132 characters including 0x prefix for signed transactions and operations. | | 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. | | 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. | | 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. | | address | STRING | Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string. | | 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	transaction_index
0x000000000000000000000000ffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000066a94e2f0000000000000000000000000000000000000000000000000000000000000000	[“0xc6a377bfc4eb120024a8ac08eef205be16b817020812c73223e81d1bdb9708ec”,“0x000000000000000000000000d5e957e0d9531f374f522a3dcfb5f77de9ee9634”,“0x00000000000000000000000080137510979822322193fc997d400d5a6c747bf7”,“0x000000000000000000000000fe96910cf84318d1b8a5e2a6962774711467c0be”]	0x000000000022d473030f116ddee9f6b43ac78ba3	false	0	0x2ca34fca341d620c13f31f659e68b4f57ce72e23e78ef5ba513ad36d1de25f5c	9806034	2024-06-30T20:34:11.000Z	0x13812ae0de2d709196c55dbd2a6587dcad5daef125defbb865deb6b17b4bab55	2
0x000000000000000000000000000000000000000000000000000a2b083ee222c0fffffffffffffffffffffffffffffffffffffffffffffffffff5bd52e64995970000000000000000000000000000000000000001011f716bdcb843a96a505d0c00000000000000000000000000000000000000000000000066783fb523c240a0000000000000000000000000000000000000000000000000000000000000005700000000000000000000000000000000000000000000000000000015fd8be8f10000000000000000000000000000000000000000000000000000000000000000	[“0x19b47279256b2a23a1665c810c8d55a1758940ee09377d4f8d26497a3577dc83”,“0x000000000000000000000000ea49166a27c1796cd2b226d211d70edeed0ae397”,“0x0000000000000000000000007e15eb462cdc67cf92af1f7102465a8f8c784874”]	0x00551f0ee010f73c4760de6558019f15c2b222e5	false	6	0x2ffeeafb40f0f257d96ebebd2e3a958503e05f2ee108bdb5378339c921926497	9790494	2024-06-30T11:56:11.000Z	0x6d780637c93a9daa89ff69ca7b42769b4845500f383be76f19d7baf0c8204eda	2
0x0000000000000000000000000000000000000000000000000004cf0d21bfdcf3fffffffffffffffffffffffffffffffffffffffffffffffffffb25c2a0c873e0000000000000000000000000000000000000000101265eaac9a8f6c27a8358c200000000000000000000000000000000000000000000000066783fb523c240a000000000000000000000000000000000000000000000000000000000000000590000000000000000000000000000000000000000000000000000000a66613ee10000000000000000000000000000000000000000000000000000000000000000	[“0x19b47279256b2a23a1665c810c8d55a1758940ee09377d4f8d26497a3577dc83”,“0x000000000000000000000000ea49166a27c1796cd2b226d211d70edeed0ae397”,“0x000000000000000000000000ea49166a27c1796cd2b226d211d70edeed0ae397”]	0x00551f0ee010f73c4760de6558019f15c2b222e5	false	8	0x96c5a0532e7490b859a249e6a5b55a549ffd98118f6c950d4aa10e30078cd6c8	9789608	2024-06-30T11:26:39.000Z	0xfce613e93301aabf439253fd12186ca250514ecb6236e5eedb3108c12cc8732e	1

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.mode.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`	`NUMERIC`	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	value	output	status	gas_used	trace_id	to_address	trace_type	block_number	from_address	trace_address	block_timestamp	transaction_hash	transaction_index
345569	0x	200000000000000000		true	0	CALL_0x1581dcecbbc78e83df6915e9470ea76eaef6ba7449574739b39adbb581e399e3_0_0_0_1	0x62c4f0b1be07af5ef9cce365ac16d01c24cf05ef	CALL	1716	0x4200000000000000000000000000000000000010	0,0,0,1	2023-11-16T21:43:35.000Z	0x1581dcecbbc78e83df6915e9470ea76eaef6ba7449574739b39adbb581e399e3	1
380265	0x6e296e45	0	0x000000000000000000000000735adbbe72226bd52e818e7181953f42e3b0ff21	true	548	DELEGATECALL_0x1581dcecbbc78e83df6915e9470ea76eaef6ba7449574739b39adbb581e399e3_0_0_0_0_0	0xc0d3c0d3c0d3c0d3c0d3c0d3c0d3c0d3c0d30007	DELEGATECALL	1716	0x4200000000000000000000000000000000000007	0,0,0,0,0	2023-11-16T21:43:35.000Z	0x1581dcecbbc78e83df6915e9470ea76eaef6ba7449574739b39adbb581e399e3	1
386745	0x6e296e45		0x000000000000000000000000735adbbe72226bd52e818e7181953f42e3b0ff21	true	1031	STATICCALL_0x1581dcecbbc78e83df6915e9470ea76eaef6ba7449574739b39adbb581e399e3_0_0_0_0	0x4200000000000000000000000000000000000007	STATICCALL	1716	0x4200000000000000000000000000000000000010	0,0,0,0	2023-11-16T21:43:35.000Z	0x1581dcecbbc78e83df6915e9470ea76eaef6ba7449574739b39adbb581e399e3	1

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.mode.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.
`deposit_receipt_version`	`INT64`	Version identifier for Layer 2 deposit transaction receipts. Integer value used to track the schema or protocol version of deposit receipts.
`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.
`mint`	`NUMERIC`	Amount of native currency minted and credited to the transaction sender. Denominated in the smallest unit of the blockchain’s native currency.
`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.
`source_hash`	`STRING`	Unique identifier for Layer 2 deposit transactions originating from Layer 1. 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.
`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.
`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_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_deposit_receipt_version`	`INT64`	Version identifier for deposit transaction receipts on Layer 2 blockchains.
`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.
`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_base_fee_scalar`	`NUMERIC`	Scaling factor applied to the Layer 1 base fee component in Layer 2 transaction fee calculations.
`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_l1_blob_base_fee`	`INT64`	Base fee per gas unit for EIP-4844 blob data on Layer 1. Denominated in wei.
`receipt_l1_blob_base_fee_scalar`	`NUMERIC`	Scaling factor applied to the Layer 1 blob base fee component in Layer 2 transaction fee calculations for EIP-4844 blob transactions.
`receipt_da_footprint_gas_scalar`	`INT64`	Scaling factor applied to the data availability footprint gas calculation for Layer 2 transaction data publishing costs.

Sample Data

r	s	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	receipt_deposit_receipt_version
0x0	0x0	1000000	0x015d8eb900000000000000000000000000000000000000000000000000000000012834360000000000000000000000000000000000000000000000000000000065ef00af00000000000000000000000000000000000000000000000000000010fcc6cf70a8e7e3e29b5b261e3742411800a50062cc8b86fc4612990ab36a855f7ac6de21000000000000000000000000000000000000000000000000000000000000000500000000000000000000000099199a22125034c808ff20f377d91187e8050f2e00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0	4997293	0x0e02be3bc64f2c033139aa542f2277265ad072ede0d024c7e99ff04832125338	0x4200000000000000000000000000000000000015	[{“address”:null,“storage_keys”:[]}]	0x2faa54221662cf5e1a7f25537788c21e38f894a7784c195fd585d5cad4120e3b	4997294	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	126	true	2024-03-11T13:02:51.000Z	46877	0x6c623dd8c8432ffaf74991d76a9aa62b7db11b7e4144165be7683db0aae9fcc1	126	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	4997293	1	46877	1
0x0	0x0	1000000	0x015d8eb9000000000000000000000000000000000000000000000000000000000128370f0000000000000000000000000000000000000000000000000000000065ef233b00000000000000000000000000000000000000000000000000000017bf93a4e27100f4ca54caec9f6ce4d784b35400f73a17ab00412cab6c7643b7e4476d91ac000000000000000000000000000000000000000000000000000000000000000400000000000000000000000099199a22125034c808ff20f377d91187e8050f2e00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0	5001714	0x0e0708651a8f6b4ff1842ead3c173461302c5f444ee554af6707593a04536787	0x4200000000000000000000000000000000000015	[{“address”:null,“storage_keys”:[]}]	0xff9628141e324fc5b116425cccf432e57414508b01265b54d53e13def4c03304	5001715	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	126	true	2024-03-11T15:30:13.000Z	46877	0x0252d4fd52ac1881b052387a44d8ace927a30d24a83311f43ea2e92200f7095a	126	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	5001714	1	46877	1
0x0	0x0	1000000	0x015d8eb900000000000000000000000000000000000000000000000000000000012834360000000000000000000000000000000000000000000000000000000065ef00af00000000000000000000000000000000000000000000000000000010fcc6cf70a8e7e3e29b5b261e3742411800a50062cc8b86fc4612990ab36a855f7ac6de21000000000000000000000000000000000000000000000000000000000000000200000000000000000000000099199a22125034c808ff20f377d91187e8050f2e00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0	4997290	0x394d278ae0b87a62b2cb87e6e9678093b8d8b5f8c531e28b9019f810b2f548e1	0x4200000000000000000000000000000000000015	[{“address”:null,“storage_keys”:[]}]	0x205583ec29bbf7d3e9fe61c6260434e30d37f56f9d5faa9243b8d57595a0b5fe	4997291	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	126	true	2024-03-11T13:02:45.000Z	46877	0xce43c4b09cf4f63005853890f606840e7795b26030c93d705f84e65d98f46910	126	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	4997290	1	46877	1

Example Query

Query with partition filter

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