kinto

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.
`l1_block_number`	`INT64`	Block number on the Layer 1 blockchain corresponding to this Layer 2 block or transaction. Integer value representing the L1 block height at the time of L2 block production or transaction submission.
`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.
`send_count`	`INT64`	Number of outbound messages or cross-chain communications sent from the Layer 2 to Layer 1 in the block. Integer value representing the count of L2-to-L1 message transactions included in the block for Arbitrum-based rollup chains.
`send_root`	`STRING`	Merkle root hash of all outbound Layer 2 to Layer 1 messages 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.
`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.
`withdrawals_root`	`STRING`	Merkle root hash of all validator withdrawals in the block. 66-character hex string including 0x prefix.

Sample Data

size	miner	nonce	number	uncles	gas_used	mix_hash	gas_limit	send_root	timestamp	block_hash	difficulty	extra_data	logs_bloom	send_count	state_root	parent_hash	sha3_uncles	receipts_root	l1_block_number	base_fee_per_gas	total_difficulty	transaction_count	transactions_root
855	0xa4b000000000000000000073657175656e636572	0x0000000000000d86	205559	[]	174447	0x00000000000000060000000001357197000000000000000a0000000000000000	1125899906842624	0x94b55ede5165829a224376766b44991f5f70d8986858916ecfec5668fba847df	2024-07-11T00:33:18.000Z	0x08335de4b2e7482c4f1c37d587f5965231c3728b055975aca3f6ded01c7a1053	1	0x94b55ede5165829a224376766b44991f5f70d8986858916ecfec5668fba847df	0x40000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200800000000000000000000000000000000002000000000000000000000000200000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000	6	0xcbcc35918457b8999025972a093ad86a71e461b85eeebe791603cb31939d8e28	0x6b2197248e32d5b8bf935ff146d6596dc51b3ff43f949e550d894db631e5ca90	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xbffa22383795f8d2dc01fc42c89fa17ed2c1bc3c0a6e8d6f1898128451c73e70	20279703	100000000	205560	2	0x4011dcbee150203f44409e19d9278cb6b7a3c83872d41ffe995674dd4fb7faef
855	0xa4b000000000000000000073657175656e636572	0x0000000000000d86	205564	[]	174447	0x0000000000000006000000000135724d000000000000000a0000000000000000	1125899906842624	0x94b55ede5165829a224376766b44991f5f70d8986858916ecfec5668fba847df	2024-07-11T01:09:30.000Z	0x2b97fe52e86013aee432891f784cdf0805d66c55fd1ae72dbb3026197da86fb3	1	0x94b55ede5165829a224376766b44991f5f70d8986858916ecfec5668fba847df	0x40000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200800000000000000000000000000000000002000000000000000000000000200000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000	6	0xf45418790d4537452fc2f394f5eeead278a2638947ef6f4e486970379ff17a30	0x8e209ff7d7f5994f853f4b2a18d179833aacb2c8366d281276a272dcf45172d5	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x464e34245e6de4f72aed41d4a6817650aaba295700aee6a78d7a20ec992db289	20279885	100000000	205565	2	0xb85fe168761e82407416140a7365f044896e91ccd00dad3ab645cc0f87c79de6
1175	0xa4b000000000000000000073657175656e636572	0x0000000000000d86	205574	[]	311462	0x00000000000000060000000001357387000000000000000a0000000000000000	1125899906842624	0x94b55ede5165829a224376766b44991f5f70d8986858916ecfec5668fba847df	2024-07-11T02:12:45.000Z	0x6240271bf5f0bd6f54930912a2f1cb166c0373a5f0bd249a23cff8d28d773476	1	0x94b55ede5165829a224376766b44991f5f70d8986858916ecfec5668fba847df	0x00000000000000200000000000000000000000000000000000000000000200000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000001000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011000000000000000000400000000000000800000000000	6	0xf4f9ee454487481b151b2cf8fdcfc93f23383978200b45ccffa1ce7f591c636f	0xaac8f51007e13c4d2ebe9caf3429ee4c3e1fca4fa453668fa1e082c8480fae1e	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xf1e5ffd47319792b362c5ac6f904120d744bff870da52b3a146fc5b1c93cc3ae	20280199	100000000	205575	2	0x74252925631b6747c12f77deaf04e365de4117e43836d02287bad8af606b9d9c

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.kinto.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	transaction_index
0x0000000000000000000000000000000000000000000000000000000066350bc7	[“0x47cee97cb7acd717b3c0aa1435d004cd5b3c8c57d70dbceb4e4458bbd60e39d4”,“0x000000000000000000000000caf611c46ec93403cc77420a5ae4e5053bfcb9ae”]	0x0719d47a213149e2ef8d3f5afdada8a8e22dfc03	false	0xfd715d974ee31e8ffe4488bf47cb1917ee3c65d908e16204fbf4a5bacce9e10f	129138	2024-05-03T16:07:35.000Z	0x20205c16c29991cb264e0f417aa1b11292b7921fd4c95dd4c851981a01b551c1	1
0x000000000000000000000000000000000000000000000000000000006634699a	[“0x47cee97cb7acd717b3c0aa1435d004cd5b3c8c57d70dbceb4e4458bbd60e39d4”,“0x0000000000000000000000002907518801e962f0c06c697b3c8406a8dd7c1d8a”]	0x0719d47a213149e2ef8d3f5afdada8a8e22dfc03	false	0xb490896a44807a448df2fece6c86d80351648928863c6419d8d9ba9ec001b88d	129102	2024-05-03T04:35:38.000Z	0x29ccc3dd7ad1a9fd366b8a0d26752ea135bd59ad491169c65e237b2231380b37	1
0x000000000000000000000000000000000000000000000000000000006634cb45	[“0x47cee97cb7acd717b3c0aa1435d004cd5b3c8c57d70dbceb4e4458bbd60e39d4”,“0x000000000000000000000000353d8df0b9e08173bbc2410bb6152c9a8b7c69f7”]	0x0719d47a213149e2ef8d3f5afdada8a8e22dfc03	false	0x2dc5224a2b5f60d7c597febcc2a40915e410d8ae16dd09a564e5047295f130ec	129128	2024-05-03T11:32:21.000Z	0x3184666645e5c8e0f59b61e4e3b9c949daaddad99503f5f0bee822e1bb552cb9	1

Example Query

Query with partition filter

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

input	status	trace_id	to_address	trace_type	block_number	from_address	block_timestamp	transaction_hash
0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012320770000000000000000000000000000000000000000000000000000000000004e580000000000000000000000000000000000000000000000000000000000000009	true	CALL_0x3e8e2194f40d9de0942f6da4e9754d872106c46237cb5e11a7711b0fd225e406_	0x00000000000000000000000000000000000a4b05	CALL	20056	0x00000000000000000000000000000000000a4b05	2024-01-24T21:51:19.000Z	0x3e8e2194f40d9de0942f6da4e9754d872106c46237cb5e11a7711b0fd225e406
0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012320470000000000000000000000000000000000000000000000000000000000004e0b000000000000000000000000000000000000000000000000000000000000000b	true	CALL_0x4757e594894f9ca2a78439c23a788a94ceef961701516f28592b1cc2da44ef41_	0x00000000000000000000000000000000000a4b05	CALL	19979	0x00000000000000000000000000000000000a4b05	2024-01-24T21:41:34.000Z	0x4757e594894f9ca2a78439c23a788a94ceef961701516f28592b1cc2da44ef41
0x6bf6a42d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000123217b0000000000000000000000000000000000000000000000000000000000004f600000000000000000000000000000000000000000000000000000000000000001	true	CALL_0xf929a3a35a02042fd139d2584c5ad8b5507623ca2d7d5d6dd561459b99ec7899_	0x00000000000000000000000000000000000a4b05	CALL	20320	0x00000000000000000000000000000000000a4b05	2024-01-24T22:43:27.000Z	0xf929a3a35a02042fd139d2584c5ad8b5507623ca2d7d5d6dd561459b99ec7899

Example Query

Query with partition filter

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

transactions

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_price`	`INT64`	Price per unit of gas for the transaction. Integer value denominated in the smallest unit of the blockchain’s native currency (wei for EVM chains).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`input`	`STRING`	Calldata or transaction payload sent with the call or transaction. Hex-encoded string starting with 0x, containing the function signature and encoded parameters for smart contract interactions.
`nonce`	`INT64`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`value`	`STRING`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`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.
`mint`	`NUMERIC`	Amount of native currency minted and credited to the transaction sender. Denominated in the smallest unit of the blockchain’s native currency.
`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.
`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.
`request_id`	`STRING`	Unique identifier for retryable transaction requests on Arbitrum-based Layer 2 chains.
`source_hash`	`STRING`	Unique identifier for Layer 2 deposit transactions originating from Layer 1. 66-character hex string including 0x prefix.
`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_gas_used_for_l1`	`INT64`	Gas units consumed on Layer 1 for publishing this Layer 2 transaction to the Layer 1 blockchain.
`receipt_l1_block_number`	`INT64`	Ethereum Layer 1 block number at which this Kinto (Layer 2) transaction was anchored or settled. Used to track the L1 commitment point for this L2 transaction.
`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_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	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_l1_block_number	receipt_effective_gas_price
0x0	0x0	0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012534bd0000000000000000000000000000000000000000000000000000000000018a0c000000000000000000000000000000000000000000000000000000000000003b	7887	0xc5415e5446a1f6027ab829e77457c84b16437d7a8f060a351f1a27046be414d4	0x00000000000000000000000000000000000a4b05	[{“address”:null,“storage_keys”:[]},{“address”:null,“storage_keys”:[]}]	100876	0x00000000000000000000000000000000000a4b05	106	true	2024-02-13T00:35:06.000Z	0x061ce664893accc1403370beda4c64fee9e9da4185b1ecb959514a2559cd0123	106	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	19215549	100000000
0x0	0x0	0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012541d50000000000000000000000000000000000000000000000000000000000018f4c0000000000000000000000000000000000000000000000000000000000000037	7887	0x2bb453a693544f8c9b98eb1fea021501a166c9a4b1406df59a6628054cbf5beb	0x00000000000000000000000000000000000a4b05	[{“address”:null,“storage_keys”:[]},{“address”:null,“storage_keys”:[]}]	102220	0x00000000000000000000000000000000000a4b05	106	true	2024-02-13T11:50:26.000Z	0x141443bd536270acdf73f0a8a70b4033b31677c93f7d4188f2a9c78907a87ece	106	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	19218901	100000000
0x0	0x0	0x6bf6a42d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000125390d0000000000000000000000000000000000000000000000000000000000018b06000000000000000000000000000000000000000000000000000000000000008f	7887	0x5f428ad6e7d0562f85375b3b7f87d5004518cd7226bea4871d6ebebf57c55747	0x00000000000000000000000000000000000a4b05	[{“address”:null,“storage_keys”:[]},{“address”:null,“storage_keys”:[]}]	101126	0x00000000000000000000000000000000000a4b05	106	true	2024-02-13T04:17:27.000Z	0x142dc2ec4e3104dc92ad6a7e567ad22c3f4e69677c8223b5de0a09869ff4d4fa	106	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	19216653	100000000

Example Query

Query with partition filter

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