gnosis

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.
`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.
`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`	`STRING`	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`	`STRING`	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.
`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.
`mix_hash`	`STRING`	Hash value used in proof-of-work mining or consensus verification. 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.
`author`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`withdrawals`	`ARRAY<STRUCT<address STRING, amount NUMERIC, index INT64, validator_index INT64>>`	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.
`withdrawals_root`	`STRING`	Merkle root hash of all validator withdrawals in the block. 66-character hex string including 0x prefix.

Sample Data

size	miner	author	number	uncles	gas_limit	timestamp	block_hash	difficulty	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	withdrawals	receipts_root	base_fee_per_gas	total_difficulty	transactions_root
588	0x010101685223dd44a6ea8545209bcdaab157b540	0x010101685223dd44a6ea8545209bcdaab157b540	19651014	[]	30000000	2021-12-18T22:40:05.000Z	0x15a1bca24edea55882adf7f0bf790f241224fe1454eb55e098dfe2ac50d4fd4f	340282366920938463463374607431768211454	0xdb830303028c4f70656e457468657265756d86312e34372e30826c69	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x2cff42a52342d7cd099acefae16b3b380e74fad0b9c8f73dbdc3c6ab78a87e17	0x499a16b5fcaa5a35d006fd3094205123aae9e2ece9f76ca0c8f3c7594246ac88	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[{“index”:null,“amount”:null,“address”:null,“validator_index”:null}]	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	7	6686893556316498638657262897886181167729323001	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421
588	0x010101685223dd44a6ea8545209bcdaab157b540	0x010101685223dd44a6ea8545209bcdaab157b540	19638391	[]	30000000	2021-12-18T05:07:10.000Z	0x00165c69656963a0b4f5578de68e5bc0f031e7afad92d32639da0f0b8fc3edbb	340282366920938463463374607431768211454	0xdb830303028c4f70656e457468657265756d86312e34372e30826c69	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x4d12b5302de0e52d2f44320df72e87fd7003fc289f736484a39224e2b8e074f7	0x06cf6ac936e8838d98976bebacada1dd709908c1d9821ed27688c0f3cade013f	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[{“index”:null,“amount”:null,“address”:null,“validator_index”:null}]	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	7	6682598171998855632432964720216569957596139171	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421
588	0x010101685223dd44a6ea8545209bcdaab157b540	0x010101685223dd44a6ea8545209bcdaab157b540	19635207	[]	30000000	2021-12-18T00:41:10.000Z	0x1f63e08abe9838b93db6e916e86168ca4fa229c6f2a4eab61bfd8ac22a91a028	340282366920938463463374607431768211454	0xdb830303028c4f70656e457468657265756d86312e34372e30826c69	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0xa5c99b1f61b61665e81f430ceeda5aeb3fcf788ccbb79fbd7b135597ddb67cb6	0x637d63744246da3b87dfeb0ab62f37ebfbdf3343e091a39bd58a6eba7354860a	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[{“index”:null,“amount”:null,“address”:null,“validator_index”:null}]	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	8	6681514712942579364365297335466507207610869643	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.gnosis.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
0x000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000d085e61d29ce7c06d00000000000000000000000000000000000000000000000529b1af06a77cf6e00000000000000000000000000000000000000000000000000000000000000000	[“0x7caea4a19892ce49b4daa2014d5599eed561dcd16ffabfac851a9737217ae410”,“0x000000000000000000000000f035839daaf652f03156b297a27eda25a35e6316”]	0xdb7e6d2ee1463711adb3bfff199666b665e5d24d	false	7	0xdb37859dcf6b5d4cc2998df0cf5321689e5f226f40c13c69e4620aa1282136cd	6930433	2019-11-21T00:13:50.000Z	0x96378545c58dee6e817186c61a12d466b9a7691519cad2b717131c95f3dbe1cd
0x00000000000000000000000000000000000000000000000529b1af06a77cf6e0	[“0x9cb9c14f7bc76e3a89b796b091850526236115352a198b1e472f00e91376bbcb”,“0x000000000000000000000000db7e6d2ee1463711adb3bfff199666b665e5d24d”]	0x4a5811e49277e5e22c2da3ed29c7b711f2cef4f3	false	3	0xdb37859dcf6b5d4cc2998df0cf5321689e5f226f40c13c69e4620aa1282136cd	6930433	2019-11-21T00:13:50.000Z	0x96378545c58dee6e817186c61a12d466b9a7691519cad2b717131c95f3dbe1cd
0x00000000000000000000000000000000000000000000000529b1af06a77cf6e0	[“0x9cb9c14f7bc76e3a89b796b091850526236115352a198b1e472f00e91376bbcb”,“0x000000000000000000000000db7e6d2ee1463711adb3bfff199666b665e5d24d”]	0xd7f7606f6caf8d07fbe93b600682fce45976ff9b	false	4	0xdb37859dcf6b5d4cc2998df0cf5321689e5f226f40c13c69e4620aa1282136cd	6930433	2019-11-21T00:13:50.000Z	0x96378545c58dee6e817186c61a12d466b9a7691519cad2b717131c95f3dbe1cd

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.gnosis.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	status	gas_used	trace_id	to_address	trace_type	block_number	from_address	block_timestamp	transaction_hash
30000	0x	5000000000000000000	true	21000	CALL_0x1e251eb8fdb3a0d4e21a04f418af8e3308556a6779e6157d6381763a849f642d_	0xcc73e91114e0ef6b4f586cdff1ed3a2a7c18295b	CALL	903015	0xc8736855c2d81f6f7849de22ad3889a8283b2e9a	2018-11-30T23:45:45.000Z	0x1e251eb8fdb3a0d4e21a04f418af8e3308556a6779e6157d6381763a849f642d
30000	0x	200000000000000000	true	21000	CALL_0xb3a18c4cf1d2eed230f8672021bb61817031c6f2183a6085216c52dafb5576f6_	0xbbabb9b1303e4306393e7b5275a97fa2ae353d21	CALL	902980	0xc8736855c2d81f6f7849de22ad3889a8283b2e9a	2018-11-30T23:42:50.000Z	0xb3a18c4cf1d2eed230f8672021bb61817031c6f2183a6085216c52dafb5576f6
44699	0x1425388700000000000000000000000077d57ddaded3f0861429bebd537fe9d81ad2aada	0	true	44699	CALL_0xf884121d72f9386b74e45acb0a41d93787d8376564fc7b7539c2ff88c81a4abe_	0x61f399be19c115d5ae400b1943d0df8c952ff9d6	CALL	897346	0xcace5b3c29211740e595850e80478416ee77ca21	2018-11-30T15:53:20.000Z	0xf884121d72f9386b74e45acb0a41d93787d8376564fc7b7539c2ff88c81a4abe

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.gnosis.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_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.
`transaction_index`	`INT64`	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.
`value`	`NUMERIC`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`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).
`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.
`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.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`max_fee_per_gas`	`INT64`	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`	`INT64`	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_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.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`receipt_effective_gas_price`	`INT64`	Actual gas price paid per unit for transaction execution. Integer value denominated in wei.
`receipt_blob_gas_price`	`INT64`	Actual price per unit of blob gas paid for EIP-4844 blob transactions. Integer value denominated in wei.
`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_gas_used`	`INT64`	Gas units consumed by this specific transaction.
`receipt_blob_gas_used`	`INT64`	Gas units consumed for blob data storage in EIP-4844 transactions. Integer value representing the amount of gas specifically used for posting blob data, separate from execution gas.
`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_status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true indicates successful execution and false indicates failure.
`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_transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`error`	`STRING`	Error message returned when transaction execution fails. Empty when execution succeeds.
`v`	`STRING`	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.
`chain_id`	`INT64`	Numeric identifier for the blockchain network. Integer value that uniquely identifies the blockchain according to EIP-155 chain ID standard.
`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.
`data`	`STRING`	ABI-encoded event or transaction data. Hex-encoded 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.
`blob_versioned_hashes`	`STRING`	Array of commitment hashes for EIP-4844 blob data attached to the transaction. Each hash is a 66-character hex string including 0x prefix that references blob data stored separately from the transaction.
`max_fee_per_blob_gas`	`INT64`	Maximum gas price per unit willing to be paid for blob data in EIP-4844 transactions. Integer value denominated in wei, specified by the transaction sender to limit the cost of posting blob data separately from transaction execution.

Sample Data

r	s	v	gas	data	input	nonce	value	gas_price	block_hash	to_address	access_list	block_number	from_address	receipt_status	block_timestamp	receipt_gas_used	transaction_hash	transaction_index	receipt_logs_bloom	blob_versioned_hashes	receipt_transaction_index	receipt_cumulative_gas_used	receipt_effective_gas_price
0xa61e8059b59d88b8ce8b8e5bb9f8d8af93ea32bec8f2b948948bc5ce9b906ba9	0x1b43119b79f8cf7411c725943c4a3e800f90b6f5bb7d2e86fc6e78a66d0c1007	0xeb	21000	0x	0x	197	381187471300000000	3000000000	0x1ae4512be6502d76bab197fdbcdd2bd282af643f24de5e90f6cbacaa6c8fb881	0x72d9e579f691d62aa7e0703840db6dd2fa9fae21	[{“address”:null,“storage_keys”:[]}]	26001598	0xe8753384273059cdb7ed1828534d889fdec856d4	true	2023-01-17T00:24:25.000Z	21000	0x0827c704185a2d5c689c1def14f564232f9edd19de1a153cda2ffcbdbd63b83a	3	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]	3	460983	3000000000
0xae07663f1cda870bd26eeeaccba175684e1fbf16c513c91eff1958a2c6198e5c	0x2bc2f46088e978d942e22ae621d3bb1c8b536120dec5d02b4e35d2a41f45ac9d	0xec	21000	0x	0x	2055663	393651404570000000	3000000000	0xe19c8b34bced1939844bcc00624bd62a4d9343f9ef2ad9b8f8dd55339d0e77d4	0xff57152767838e25fc8ac915f5fa03c94b6773e6	[{“address”:null,“storage_keys”:[]}]	26001891	0x72d9e579f691d62aa7e0703840db6dd2fa9fae21	true	2023-01-17T00:50:00.000Z	21000	0x2563035ba326b4080eeee31b899bb52c677719b73465b5bad87e287096d9a07e	1	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]	1	133321	3000000000
0xfbd846be6d24c77eba7e0a78831ed7699e88c4dbd1dee3a73ef40f613c858443	0x2a78faf1b46e3343446732b0582eb8e15a34504e36ec8c21b068c824f7647d97	0xec	21000	0x	0x	2056658	380137853379500000	3000000000	0xab1d39e67632b7efaf67fe4a978b349bd7bdb19b4bdc9dbd178f3db04bb6cbe8	0xee8bba37508cd6f9db7c8ad0ae2b3de0168c1b36	[{“address”:null,“storage_keys”:[]}]	26007073	0x72d9e579f691d62aa7e0703840db6dd2fa9fae21	true	2023-01-17T08:21:55.000Z	21000	0x6bfcc629acff308a3c7350eacb6e04a107b5a858d48d8dd4e1def6dbc2b9147e	0	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]	0	21000	3000000000

Example Query

Query with partition filter

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