xai

Tables

blocks

Block header data containing sequential numbering, cryptographic hashes linking to parent blocks, timestamps, and consensus metadata. Primary source for blockchain state verification and chain navigation.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transaction_count`	`INT64`	Number of transactions included in the block.
`gas_limit`	`INT64`	Maximum gas allowed to be consumed by all transactions in the block. Measured in gas units, representing the computational capacity limit set for block execution.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`excess_blob_gas`	`INT64`	Cumulative blob gas exceeding the target per block, used to adjust future blob gas pricing. Measured in blob gas units as defined by EIP-4844.
`blob_gas_used`	`INT64`	Total gas consumed by blob transactions in the block. Measured in blob gas units, representing the data availability cost for EIP-4844 blob-carrying transactions.
`parent_beacon_block_root`	`STRING`	Root hash of the parent beacon chain block for post-merge consensus verification. 66-character hex string including 0x prefix.
`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.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 66-character hex string including 0x prefix.
`nonce`	`STRING`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`sha3_uncles`	`STRING`	Keccak-256 hash of the RLP-encoded list of uncle block headers. 66-character hex string including 0x prefix.
`logs_bloom`	`STRING`	Bloom filter for efficient event log querying within the block. 512-character hex string (including 0x prefix) representing a probabilistic data structure for testing event presence.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
`receipts_root`	`STRING`	Merkle root hash of all transaction receipts in the block. 66-character hex string including 0x prefix.
`difficulty`	`INT64`	Mining difficulty target for the block. Integer value representing the computational effort required to produce the block, with 0 indicating proof-of-stake consensus and higher values indicating proof-of-work difficulty.
`total_difficulty`	`NUMERIC`	Cumulative sum of block difficulty from genesis to the current block. Numeric value representing the total computational work expended on the chain up to and including this block.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`extra_data`	`STRING`	Arbitrary data field included in the block by the block producer. Hex-encoded string format, typically containing miner software version, pool information, or chain-specific metadata.
`mix_hash`	`STRING`	Hash value used in proof-of-work mining or consensus verification. 66-character hex string including 0x prefix.
`uncles`	`ARRAY<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	mix_hash	gas_limit	timestamp	block_hash	difficulty	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	receipts_root	base_fee_per_gas	total_difficulty	transaction_count	transactions_root
872	0x7f68dba68e72a250004812fe04f1123fca89aba9	0x0000000000000b79	101563	[]	0x00000000000001310000000001232315000000000000000b0000000000000000	1125899906842624	2024-01-25T00:06:26.000Z	0x459c994e573b29d999f8f171278b5814e4e3f8c8eeb0fa2c6cc82fb39ddb225f	1	0x1ae3cd1af616bc5712fd939878d81b29915906cfe07fe8242708740fc6dc7012	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x4ab962a1223ff5bb4bb9d0c9868d5e0826b9cfb626c753e4866e88ab930108a8	0xcda973e55b33ae7ffd1382435b5756428d8354ba59dcf2ae8e4791cedb5252e2	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xf08cf5553e1dae52e3df19b356b8320e17c39fb055f635739c31052db5c3e45e	100000000	101564	2	0xe98c4f59ebf00457e710a8ff5cbe272b4abade4a922526d35dc44c2cb2a4c821
872	0x7f68dba68e72a250004812fe04f1123fca89aba9	0x0000000000000b7a	101748	[]	0x0000000000000131000000000123235c000000000000000b0000000000000000	1125899906842624	2024-01-25T00:21:36.000Z	0x2243785d00ccc4171789ac1ae09fc55dd3df51a69d4ce44d191e60db52a1b5b1	1	0x1ae3cd1af616bc5712fd939878d81b29915906cfe07fe8242708740fc6dc7012	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x32ba54148529610f195f56561431d9ad90f5cc606e621994020ae72a12583ef2	0x09492669330b882beb32ff0f9295d0a24094b182608710960eb5e622c797debd	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xf08cf5553e1dae52e3df19b356b8320e17c39fb055f635739c31052db5c3e45e	100000000	101749	2	0xec7003e45196449e4568dd264fb2f4288667f5e59ff1235431368945f08d2487
872	0x7f68dba68e72a250004812fe04f1123fca89aba9	0x0000000000000b7b	101975	[]	0x000000000000013100000000012323a6000000000000000b0000000000000000	1125899906842624	2024-01-25T00:36:38.000Z	0x2e8cabe845889e680cbe867bdfa848835b7d31e772ebbaba13a555fb81e1eba5	1	0x1ae3cd1af616bc5712fd939878d81b29915906cfe07fe8242708740fc6dc7012	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0xad5b7024f0ff24162e033b48289311f0b986ef95181ba967a432a1dac0fdc732	0x0297991b5139bbfb16b032f86b4401b2bf31c36bee48aadd370e71f6f696ed79	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xf08cf5553e1dae52e3df19b356b8320e17c39fb055f635739c31052db5c3e45e	100000000	101976	2	0x1f18cd7203a9575cfef4cbf852dcb615089581076dbfc58919d78ed6ce7fb9d2

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.xai.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

logs

Event logs emitted by smart contracts during transaction execution, containing indexed topics for efficient filtering and ABI-encoded data payloads. Primary source for tracking contract interactions, token transfers, and state changes across blockchain networks.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event log within its containing block. Zero-indexed integer indicating the sequential order of logs emitted in the block.
`address`	`STRING`	Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.
`data`	`STRING`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
`topics`	`ARRAY<STRING>`	Indexed event parameters from the emitted log. Array of 66-character hex strings including 0x prefix, where the first element is the event signature hash and subsequent elements are indexed parameters.
`removed`	`BOOL`	Indicates whether the log was removed due to a chain reorganization.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.

Sample Data

data	topics	address	removed	log_index	block_hash	block_number	block_timestamp	transaction_hash	transaction_index
0x00000000000000000000000016b05b494e7811336b0d0ffc3985ee48ba67018c000000000000000000000000000000000000000000000000000000000050175100000000000000000000000000000000000000000000000000000000012d225c00000000000000000000000000000000000000000000000000000000662ace1400000000000000000000000000000000000000000000013a0766677ee4b8178000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000000	[“0x3e7aafa77dbf186b7fd488006beff893744caa3c4f6f299e8a709fa2087374fc”,“0x00000000000000000000000016b05b494e7811336b0d0ffc3985ee48ba67018c”,“0x74dadddf5a84e9bec340669bb3fc46941dae013f547e816b1d9b65ed7730a18e”,“0x00000000000000000000000000000000000000000000000000000000000003f9”]	0x0000000000000000000000000000000000000064	false	1	0x6b6e14a170d1f5b4d39603f9aa6b14f48a3c2c1b617aaf307f35ceb7ab265ec3	5248849	2024-04-25T21:41:40.000Z	0xc7ac3d60ea8ed92ec9b5cbdbab7a6793bfdeb893a215484a45d39e5b2a7d47eb	1
0x0000000000000000000000002dbda0d5232bd022bf29a9c48d5ac7681a2f896e00000000000000000000000000000000000000000000000000000000004f887500000000000000000000000000000000000000000000000000000000012d11cf00000000000000000000000000000000000000000000000000000000662a0650000000000000000000000000000000000000000000000000dec4e97df374eb0000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000000	[“0x3e7aafa77dbf186b7fd488006beff893744caa3c4f6f299e8a709fa2087374fc”,“0x0000000000000000000000002dbda0d5232bd022bf29a9c48d5ac7681a2f896e”,“0xd5c3591dbb2152406c251a22deac59e83f7de3cee83c4e3bf123ca235ee5d6e6”,“0x00000000000000000000000000000000000000000000000000000000000003e6”]	0x0000000000000000000000000000000000000064	false	0	0x9dd3473b3673e2357826f9c8a47861a59e6d78cfaa94e98e1998655e1e00c52a	5212277	2024-04-25T07:29:20.000Z	0x8759197e92de0cf79b359ca385321fe086bb442b45dbf705493d5783c69bcdc4	1
0x0000000000000000000000002ef3c59c4665e08e16327e7a28c014405b751b3100000000000000000000000000000000000000000000000000000000004fd7ee00000000000000000000000000000000000000000000000000000000012d1b0400000000000000000000000000000000000000000000000000000000662a758a000000000000000000000000000000000000000000000047d1333d055d8d02c000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000000	[“0x3e7aafa77dbf186b7fd488006beff893744caa3c4f6f299e8a709fa2087374fc”,“0x0000000000000000000000002ef3c59c4665e08e16327e7a28c014405b751b31”,“0xfa4f80a0947ea452c1cf859b8f6798a84a6e0d9170cd08f67b276108b624b458”,“0x00000000000000000000000000000000000000000000000000000000000003f3”]	0x0000000000000000000000000000000000000064	false	2	0x02ec6b9a48871c7e9f636983a3cb51e61e7594661469f8adedcde8a00a474f1a	5232622	2024-04-25T15:23:54.000Z	0x28b10c8c788a14fd89e30ade4424c9ce899f19cc337751e3aea1fe765b055c7d	1

Example Query

Query with partition filter

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

traces

Individual transaction execution steps recording internal operations, including contract calls, value transfers, and gas consumption. Used for analyzing complex transaction flows and debugging smart contract interactions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_type`	`STRING`	Type of trace operation executed within the transaction. Common values include CALL for contract calls, CREATE for contract deployments, DELEGATECALL for delegate calls, STATICCALL for static calls, and SELFDESTRUCT for contract destruction operations.
`status`	`BOOL`	Success indicator for the operation. Boolean value where true indicates successful execution and false indicates failure.
`error`	`STRING`	Error message returned when transaction execution fails. Empty when execution succeeds.
`trace_address`	`STRING`	Hierarchical position of the trace within the transaction’s execution tree. Comma-separated string of zero-indexed integers representing the depth and order of nested calls.
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`BIGNUMERIC`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`input`	`STRING`	Calldata or transaction payload sent with the call or transaction. Hex-encoded string starting with 0x, containing the function signature and encoded parameters for smart contract interactions.
`output`	`STRING`	Return data from the smart contract execution or call. Hex-encoded string starting with 0x, containing the function’s return value in ABI-encoded format.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`revert_reason`	`STRING`	Human-readable explanation for why a transaction or call reverted during execution. Empty when execution succeeds.
`trace_id`	`STRING`	Unique identifier for the trace operation within a transaction. Composite string combining the trace type and transaction hash, with optional trace address appended to distinguish between multiple operations of the same type.

Sample Data

input	status	trace_id	to_address	trace_type	block_number	from_address	block_timestamp	transaction_hash
0x6bf6a42d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001253ff700000000000000000000000000000000000000000000000000000000000a47ac0000000000000000000000000000000000000000000000000000000000000002	true	CALL_0x0485784685d3e82aaef13516de8b284d61dcc715d7d655ca0c9cb288a16c410b_0	0x00000000000000000000000000000000000a4b05	CALL	673708	0x00000000000000000000000000000000000a4b05	2024-02-13T10:13:38.000Z	0x0485784685d3e82aaef13516de8b284d61dcc715d7d655ca0c9cb288a16c410b
0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012544f500000000000000000000000000000000000000000000000000000000000a67960000000000000000000000000000000000000000000000000000000000000002	true	CALL_0x251b7b3c70ff8a240c8073d5546dde2bd93c5d4d4f8462f99ff617f4eed0e74a_0	0x00000000000000000000000000000000000a4b05	CALL	681878	0x00000000000000000000000000000000000a4b05	2024-02-13T14:33:38.000Z	0x251b7b3c70ff8a240c8073d5546dde2bd93c5d4d4f8462f99ff617f4eed0e74a
0x6bf6a42d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001254d8d00000000000000000000000000000000000000000000000000000000000aa8d40000000000000000000000000000000000000000000000000000000000000002	true	CALL_0x409a8499dbfaff4f98f27738bf731df943fa5f65568ee924d2930f60690f22ed_0	0x00000000000000000000000000000000000a4b05	CALL	698580	0x00000000000000000000000000000000000a4b05	2024-02-13T21:58:03.000Z	0x409a8499dbfaff4f98f27738bf731df943fa5f65568ee924d2930f60690f22ed

Example Query

Query with partition filter

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

transactions

Transaction records containing signed operations that modify blockchain state. Primary source for tracking value transfers, contract interactions, and account state changes across the network.

Columns

Column	Type	Description
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_price`	`INT64`	Price per unit of gas for the transaction. Integer value denominated in the smallest unit of the blockchain’s native currency (wei for EVM chains).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`input`	`STRING`	Calldata or transaction payload sent with the call or transaction. Hex-encoded string starting with 0x, containing the function signature and encoded parameters for smart contract interactions.
`nonce`	`INT64`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`r`	`STRING`	ECDSA signature component r from the transaction signature. 66-character hex string including 0x prefix.
`s`	`STRING`	ECDSA signature component s from the transaction signature. 66-character hex string including 0x prefix.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`transaction_type`	`INT64`	EIP-2718 transaction type indicator. Integer value representing the transaction format: 0 for legacy, 1 for EIP-2930 access list, 2 for EIP-1559 fee market, 3 for EIP-4844 blob transactions.
`v`	`INT64`	ECDSA signature component v from the transaction signature. Integer value used for signature verification and public key recovery.
`value`	`STRING`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`chain_id`	`INT64`	Numeric identifier for the blockchain network. Integer value that uniquely identifies the blockchain according to EIP-155 chain ID standard.
`max_fee_per_gas`	`NUMERIC`	Maximum gas price per unit willing to be paid for transaction execution. Integer value denominated in wei for EVM chains, specified by the transaction sender as part of EIP-1559 fee market transactions.
`max_priority_fee_per_gas`	`NUMERIC`	Maximum tip per gas unit offered to validators for transaction priority. Integer value denominated in wei for EVM chains, specified by the transaction sender in EIP-1559 transactions to incentivize faster inclusion.
`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_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_l1_gas_used`	`INT64`	Gas units consumed on Layer 1 for the transaction on Layer 2 rollup chains.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.

Sample Data

r	s	input	chain_id	block_hash	to_address	access_list	block_number	from_address	receipt_type	receipt_status	block_timestamp	transaction_hash	transaction_type	receipt_logs_bloom	receipt_effective_gas_price
0x0	0x0	0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013331850000000000000000000000000000000000000000000000000000000000a275f90000000000000000000000000000000000000000000000000000000000000000	660279	0xb9c75b230f126931d85059044dcfed918c133f3e607373cc83d19d29d619fdc2	0x00000000000000000000000000000000000a4b05	[{“address”:null,“storage_keys”:[]}]	10647033	0x00000000000000000000000000000000000a4b05	106	true	2024-06-20T10:05:52.000Z	0xaad1b84e25bbc7de6c107cca65bd261457e4204e9bf4fddb7ded5fa890ff59a5	106	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	736560000
0x0	0x0	0x6bf6a42d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001333bd00000000000000000000000000000000000000000000000000000000000a412800000000000000000000000000000000000000000000000000000000000000000	660279	0xa4cd2ce0660ba77aba604dec1111c3ad130613c6a1e82a3ef29347570bc5a062	0x00000000000000000000000000000000000a4b05	[{“address”:null,“storage_keys”:[]}]	10752640	0x00000000000000000000000000000000000a4b05	106	true	2024-06-20T18:56:39.000Z	0xca3748aef2e18d1fa9a45460bd1cc06c710d2f097fbedc1f7385ead0fe45b610	106	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	740670000
0x0	0x0	0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013327860000000000000000000000000000000000000000000000000000000000a0e47d0000000000000000000000000000000000000000000000000000000000000000	660279	0x8ff0535bb77106d7435ff7ac85cc05cd68226402216c843daa338a6eb8ed5f84	0x00000000000000000000000000000000000a4b05	[{“address”:null,“storage_keys”:[]}]	10544253	0x00000000000000000000000000000000000a4b05	106	true	2024-06-20T01:29:36.000Z	0xde50de953d6e85d760ba3a287f91c9a977a75420e7faf37d178787b2c7e7c7bd	106	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	100000000

Example Query

Query with partition filter

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