sonic

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
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 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.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 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.
`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.
`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.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`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.
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`timestamp_nano`	`INT64`	High-precision block timestamp in Unix nanoseconds, providing sub-second granularity beyond the standard timestamp field. Useful for precise sequencing and latency analysis between blocks.
`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.
`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.
`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.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`epoch`	`INT64`	Sequential identifier for consensus periods in the blockchain. Integer value representing distinct phases of validator set rotation or network governance cycles.
`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.
`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.
`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.
`transaction_count`	`INT64`	Number of transactions included in the block.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`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	epoch	miner	nonce	number	uncles	mix_hash	gas_limit	timestamp	block_hash	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	receipts_root	timestamp_nano	base_fee_per_gas	withdrawals_root	transactions_root
532	23394	0x0000000000000000000000000000000000000000	0x0000000000000000	25009898	[]	0x0ce6670d9c17e5dc5b086020d672d7a7b37e13eb6422081c902b7e45fbb3da37	5000000000	2025-05-07T13:04:51.000Z	0x3dbbeb25e8e4b6150d54842acf55b5e022f72caa0fd772fa95879457e1d5c505	0x30d2b1c00000000010c850e7	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x7e2759da315da4acf0eff9349e8e1377d379fdbf80327da34ccaea69a669027f	0x25be8c43330dc542339ee975bb2015659a1e64603d330c762a7d75af2d385432	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	1746623091819114500	50000000000	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421
532	23355	0x0000000000000000000000000000000000000000	0x0000000000000000	24942691	[]	0xe0e3d852345e51afd93f11c09b4deb01a8e7cc0917bc353c6a0b6b683a956d13	5000000000	2025-05-07T06:40:30.000Z	0x18551b8383b0dd5b6d70300af98a88c05cb1e4a57455bc3e78d646a9c631e65e	0x2cf7515e000000001271a48d	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0xe130ab50141e61b9c06b3f8497b414e2f6fd6ae2efe1223968fb5ab724ed04a4	0x319370ed5f8a797d7c8461672b869d7e3da6169ac5d3a6ee02e387d4639710a5	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	1746600030754405600	50000000000	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421
532	23384	0x0000000000000000000000000000000000000000	0x0000000000000000	24993187	[]	0xad8696586f4e74b8bf5423b08465c4d834946033881ac9b184873c671db17545	5000000000	2025-05-07T11:28:39.000Z	0x2e28d9edb34f9d976addabac94829529385c3dafe436eb973a01dfcc85bb0c86	0x23b90f0d0000000013046c7c	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x3838113e5fafc6fd1569576d9ace877414726bf76062edbcff278a0df9d92855	0x489f53bbb22bc49aee2224737394d4cbae3efc7123209232e96d6204e4a33070	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	1746617319599330600	50000000000	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.sonic.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	log_index	block_hash	block_number	block_timestamp	transaction_hash	transaction_index
0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000092000000000000000000000000a60205802e1b5c6ec1cafa3cacd49dfeece05ac900000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000b4c86433627cbff76b421bfa605e5f2bfee8f1b200000000000000000000000000000000000000000000000000000000000043bd0000000000000000000000000000000000000000000000000000000067ad36ed000000000000000000000000000000000000000000000000000000000000008438430cce000000000000000000000000000000000000000000000000000000000000bb8000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000	[“0x8a35d03c38d83318b06a44c1b0010ba96f7ba3a2295032f534593ed4fd7618f9”]	0x102f1f556cd9c3d5f820e6920a8931657c5da21b	false	74	0x1edf4e5461b6edaae93f0b95853f2bb9feae1d1dfeac430992b1b8ed725c3da9	7614106	2025-02-13T00:01:00.000Z	0xd055ad28d242e80848d93820bad41de46ff88b0773e2e8f519dba2daee1841da	15
0x00000000000000000000000000000000000000000000000000d8f8a0588fb959	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x0000000000000000000000002f500d4178d36ae358898b6ca398f2cfca0daff6”,“0x000000000000000000000000e45a270b10cfed62ba586d3f1b72b36989a623ba”]	0x50c42deacd8fc9773493ed674b675be577f2634b	false	42	0xe1b2df305d94fc0df1fdf2ea5bcddb2b52816963cf6dcf8ade7dd90a18897831	7614285	2025-02-13T00:02:00.000Z	0x0f87584d782d68ac7c2115a5efb70c425f2312c2d48bc0cc509974636a017b17	14
0xffffffffffffffffffffffffffffffffffffffffffffffefbca9e577d6d000000000000000000000000000000000000000000000000000000000000009f8b0b7000000000000000000000000000000000000000000000c8289f1bb870c480b6c0000000000000000000000000000000000000000000000004eb2bc6f6e201613fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffbb1ad	[“0xc42079f94a6350d7e6235f29174924f928cc2ac818eb64fed8004e115fbcca67”,“0x0000000000000000000000001ac569879ef7eacb17cc373ef801cdce4accded5”,“0x0000000000000000000000002f500d4178d36ae358898b6ca398f2cfca0daff6”]	0xe72b6dd415cdaceac76616df2c9278b33079e0d3	false	32	0xe1b2df305d94fc0df1fdf2ea5bcddb2b52816963cf6dcf8ade7dd90a18897831	7614285	2025-02-13T00:02:00.000Z	0x7f2600bf127d6e78d331689e2a8b1df4c1478a10cb06af6862cb08f08819cef0	10

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.sonic.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`	`FLOAT64`	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	trace_id	to_address	trace_type	block_number	from_address	block_timestamp	transaction_hash
2300	0x	5000000000000000000	true	CALL_0xc3df6401043bc0163ed5aeb92622656f969eed08f9714da6252dfd1c65ee32b3_0_0	0x2d407ddb06311396fe14d4b49da5f0471447d45c	CALL	370	0x2a9e7bded28c5445ca74e53b39a873c3d4b635bc	2024-12-01T17:22:32.000Z	0xc3df6401043bc0163ed5aeb92622656f969eed08f9714da6252dfd1c65ee32b3
2300	0x	100000000000000000000	true	CALL_0xf6d9645f1e745046df19b24b032777f11256a88d97d85410c17c78a2e8bf8f40_0_0	0x9066874c8f0308c25d832ad5d6da797bc44edf10	CALL	2288	0x2a9e7bded28c5445ca74e53b39a873c3d4b635bc	2024-12-01T19:03:04.000Z	0xf6d9645f1e745046df19b24b032777f11256a88d97d85410c17c78a2e8bf8f40
2300	0x	5000000000000000000	true	CALL_0x09cc8f1778afdb7de2dce798b0be059493b18ccf54a989d949b302f25de808c1_0_0	0x6e9f215876d210e5c8a197df598db2d8fe09f6c5	CALL	328	0x2a9e7bded28c5445ca74e53b39a873c3d4b635bc	2024-12-01T17:20:23.000Z	0x09cc8f1778afdb7de2dce798b0be059493b18ccf54a989d949b302f25de808c1

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.sonic.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.
`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.
`max_fee_per_blob_gas`	`NUMERIC`	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.
`blob_versioned_hashes`	`ARRAY<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_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.
`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.
`receipt_contract_address`	`STRING`	Contract address created by the transaction when deploying a new smart contract. Hex-encoded, 0x-prefixed, 42-character string. Null for all non-deployment transactions.
`receipt_cumulative_gas_used`	`INT64`	Total gas consumed by all transactions in the block up to and including this transaction. Integer value representing the cumulative sum of gas used, incrementing with each transaction in sequential order.
`receipt_effective_gas_price`	`INT64`	Actual gas price paid per unit for transaction execution. Integer value denominated in wei.
`receipt_gas_used`	`INT64`	Gas units consumed by this specific transaction.
`receipt_logs_bloom`	`STRING`	Bloom filter for efficiently querying event logs emitted by the transaction. 512-character hex string including 0x prefix, representing a 256-byte bit array used for probabilistic matching of log topics and addresses.
`receipt_status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true indicates successful execution and false indicates failure.
`receipt_transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.

Sample Data

r	s	v	gas	input	nonce	value	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
0x5259158ab53fb89554414618468057a4def28f708649498147f862a70d5ffeb9	0x5c6342777f8bf15e9c62be59057c65ede7d755859019dd6bcb69fd6ab07c9e97	328	30000	0x	35	192741799999878918	55000000000	0x20d1ffd37571a4c3b3ecd63d09d94e04f3071619bff3d9af26d11a5bd54ac149	0xc3e8dc8e75aca23c60f82b3439768a27bd4e5a21	[{“address”:null,“storage_keys”:[]}]	34033532	0xcfc40e18b8916222c26741c207bb26e985c01fb9	true	2025-06-14T16:43:28.000Z	21900	0x270db569a1978343e3ee4e2b508f006f7bcc3d3d10b8c9adb472d460201fc770	1	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]	1	43800	55000000000
0x308ecd1c76329a8042467742ea5d6bc5b41fd39cb5a67932f8d81251df3dd7a2	0x49a53672de00415b20a03c8c7b18485701b125e96b086bd151441457fc592510	328	21000	0x	63099	199743533119129984	55020000000	0xf8b28990e60c228988fc752e44bca522c57155234e81be8a5b2ac87ef46c81ee	0xd68904df4155982cf975d06ea6c69f23bd77bcb6	[{“address”:null,“storage_keys”:[]}]	33942965	0x91604f590d66ace8975eed6bd16cf55647d1c499	true	2025-06-14T05:03:25.000Z	21000	0x73460498dfc22268c1a3953855a2d890e4f860510e68a5788cdb5dd849db8f52	0	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]	0	21000	55020000000
0x5f48d1efb71d0080e168dc1cf73832a395096f793ca639521db68ccceec56622	0x69eccae4cf654f1b82cbd3164b7b23c664df2002e881334586a63b6e17812ac5	328	21000	0x	2	104131685477608315632	55000000000	0x2bb016960f9ebb9733b1ea8a6c8272bdd6aad61b65a1bf4fd82e5f86e6a84e1b	0x4f52a367b1c032322b4cd202af23ad6426740e9d	[{“address”:null,“storage_keys”:[]}]	34048890	0xcd941cdfb913e4a588ddd4c26ed19bab34820536	true	2025-06-14T19:01:15.000Z	21000	0xd4e3dbbd1f8536af11e69a542a745ec2d3ec652a47b233b38e22f180954a14b1	0	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]	0	21000	55000000000

Example Query

Query with partition filter

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