viction

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.
`uncles`	`ARRAY<STRING>`	List of uncle block hashes included in the block. Empty array for chains not supporting uncle blocks in their consensus mechanism.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 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.
`receipts_root`	`STRING`	Merkle root hash of all transaction receipts in the block. 66-character hex string including 0x prefix.
`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.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 66-character hex string including 0x prefix.
`penalties`	`STRING`	Penalties applied to validators for malicious behavior or protocol violations on Viction’s PoSV (Proof of Stake Voting) consensus. Hex-encoded value, typically empty (0x) when no penalties are assessed.
`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.
`block_hash`	`STRING`	Unique identifier for the block. 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.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`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.
`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.
`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.
`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.
`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.
`validator`	`STRING`	BLS signature of the validator who produced this block. Hex-encoded 192-character string used in Viction’s proof-of-stake consensus mechanism.
`validators`	`STRING`	Block validator addresses encoded as a hex string. Typically empty (0x) in samples, may contain validator set information for specific block types or governance events.
`transaction_count`	`INT64`	Number of transactions included in the block.

Sample Data

size	miner	nonce	number	uncles	gas_used	mix_hash	gas_limit	penalties	timestamp	validator	block_hash	difficulty	extra_data	logs_bloom	state_root	validators	parent_hash	sha3_uncles	receipts_root	total_difficulty	transaction_count	transactions_root
1024	0x0000000000000000000000000000000000000000	0x0000000000000000	36166828	[]	55878	0x0000000000000000000000000000000000000000000000000000000000000000	840000000	0x	2021-06-02T12:35:03.000Z	0x8ce0c85aadc9142e5f8d7fe12f2e900d93d76b11264bc7ceb9c3bda4ef8e5f0f3f7fd7e8cda94220646b4db9556f309bd10a3c58f7de1b345717ef0f5d3116df00	0x30a8e25048add29d546a17c189a5d680e468b6a5994182ceb3886e8448375432	140	0xd88302030084746f6d6f88676f312e31352e36856c696e75780000000000000063c20381eefc97b7a9ab2ac299903b02a35b8eb7a1acc7e1a390a425c563936e352e7954d0b82dcf7ed1a49b2b6135da6c499b3f43fca66376cdc0c6c5bb7e2b01	0x01000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000200000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000010000000000004000000000000000000000000000000000000000000000040000000000000020200004000000000000000000000000000000000000000000000000000000000000002000000000000000800000000000000001000000000008000000000004010004800000000000040000000000000000000002000000000000000000000	0x6077dbd129ab2958f68b0447396f6666906db97edaf89f9b7d5081b754c63133	0x	0x2221af890eb38db305359b7252256d9caabeca5ef79d7043370aad4e885fb088	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x011701bd3cc31ccdbb0084a065d08c79bac0d4f452c0dab474e6e2aa1cd22333	5280833563	2	0x02acc5fd4045f8d1d5e36a487b924b823670d6100453730126774eaaccbd2fe6
1024	0x0000000000000000000000000000000000000000	0x0000000000000000	36177785	[]	46716	0x0000000000000000000000000000000000000000000000000000000000000000	840000000	0x	2021-06-02T19:20:35.000Z	0xcde2cb8758176eecf5458c8ccccb354b9126e39c7c43ca98d7da24c2965412a715bbb527e7ff4e9b284e659aa5d505e267bb14e8e5e3b296f199c768b45e5d5601	0x11cecc0dd613e15a6cc1584a6c86e31c4f910a1a95a0b58849f78f3056b84599	140	0xd88302030084746f6d6f88676f312e31352e36856c696e757800000000000000197723466a7327215cb5485cab175619935d39fb24f50daadb6dd430b1b1a04367745a7e711c201312e500c3ca77f28701944cd59d34c8a698a57121bdae60a900	0x01000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000004000000001000000000000000000000000000000004000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000002000000020000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000800000000000000000000000000000000000000004000200800000000000000000000000000000000000000000000000000001000	0x2d34bd278be1c555be2fb1421490bd5938b93fda00cd0cdc65321553e2cb8709	0x	0x587681f9a21f8ef5f2649e5a3454e8860552382f84e72d9802681e28f5373d37	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xa5d2d9a5fe7aae85c0dfb1bce6f79d12aff291bd2c8b2638bb0a0495c9067559	5282367327	2	0xbdfdb2c0f76dcc1099c34fad46e9b112210536bf8c4ef2848734e18f3b041c10
1024	0x0000000000000000000000000000000000000000	0x0000000000000000	36171993	[]	55942	0x0000000000000000000000000000000000000000000000000000000000000000	840000000	0x	2021-06-02T15:47:54.000Z	0x08be6f9a9cba53dff2c26b4d33625c74e86ad1667e31f8cfe991804fce9a30d15ecaab85b9c69c442b691e5b7c2d0fd60c11771c453ab8fd40e6d34baf45556601	0x1c17d4a4fd2c5b4f6927e83ddd6bd64630a8bc4b12a84dcf63b91e7fa0e6c2cd	140	0xd88302030084746f6d6f88676f312e31352e35856c696e7578000000000000005cceb4b7c151f98118efba247b9a080367bbc5d5ac946a8fa38944f8a77cdf531e199516559606923fc22bb6ec4f8a4e4a8d36957fd19b208f548e30a9fb6c0600	0x01000000000000020000000000000000000000000000000000000000000000000000000000000000000000000001000000000008000000000000000000200000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000010000000000000000000000000000000000000000000000000000000000040000000000000020200004000000000000000000000000000000000000000000000000000000000000002000000000000000800000000000000001020000000000000000000004010004800000000000000000000000000000000002000000000000000000000	0xaaaa70edd5a8f265f06e641ada8c8fcad7830662943618e9480dff623a3fef83	0x	0xea5ab92f46296aff6c84e34c9d576039d962caa60709f6ca901ffd89bf61c0f2	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xe1c6a61f9942cf302d812820d21f5511a8603cc90d2f3a21212d8e91dfb60d34	5281556557	2	0x7a83446ddbf93a470d472c23f7bbc8858bee922ca78f5ad13097959986714c3f

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.viction.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
0x	[]	0x0000000000000000000000000000000000000089	false	52	0xc8ed736814cfb4142ea6ef692642fc43d04b325d2361bc1460a1aff4d4f81e18	19791872	2020-04-24T02:28:42.000Z	0xcc83afbaf00c6e233b5ae1a42d748731be649c63e0ad2d919dc5ed3c7d9b8e57	52
0x	[]	0x0000000000000000000000000000000000000089	false	60	0xc8ed736814cfb4142ea6ef692642fc43d04b325d2361bc1460a1aff4d4f81e18	19791872	2020-04-24T02:28:42.000Z	0x9f200fd82203169d298e2a56da09da3cf4c4a603c83107c566dba6ef5a55494c	60
0x	[]	0x0000000000000000000000000000000000000089	false	124	0xc8ed736814cfb4142ea6ef692642fc43d04b325d2361bc1460a1aff4d4f81e18	19791872	2020-04-24T02:28:42.000Z	0x34296b3cfeb81aa5bcb332a504a77e3170d1308f294ca7d123217f1f609d2f98	124

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.viction.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`	`STRING`	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	value	status	trace_id	to_address	trace_type	block_number	from_address	trace_address	block_timestamp	transaction_hash	transaction_index
0x	785000000000000	true	CALL_0xb48122bf57381dab130af12a464f21298ebb433a232032ad08544cfde3d3586b_0_0	0x86e96c357089c2d2317a45b311d03bc9085f8e2e	CALL	72822355	0xa658742d33ebd2ce2f0bdff73515aa797fd161d9	0,0	2023-11-27T16:20:31.000Z	0xb48122bf57381dab130af12a464f21298ebb433a232032ad08544cfde3d3586b	1
0x	161385891285987036	true	CALL_0x3046226267d284f2d7caada7e42343b4f712bc06ae50587f080279eac2a95439_0	0x5595005e589d89692631a1d969831150e56ca588	CALL	72819465	0x37e1d9be75eb569613b27f64f46cb3a208f03cdf	0	2023-11-27T14:40:13.000Z	0x3046226267d284f2d7caada7e42343b4f712bc06ae50587f080279eac2a95439	3
0x	167031477265434809	true	CALL_0x6cb53e4d4dc000755f2164417b3168ca4ea7b7c75e7ead157a4fe2f850b4ee1c_0	0x5595005e589d89692631a1d969831150e56ca588	CALL	72805705	0x827133d5d036ab97b195fc50668d02cac4d7ea58	0	2023-11-27T06:40:06.000Z	0x6cb53e4d4dc000755f2164417b3168ca4ea7b7c75e7ead157a4fe2f850b4ee1c	11

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.viction.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`	`STRING`	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.
`eth_compatible`	`BOOL`	Indicates whether the transaction uses Ethereum-compatible transaction formatting and signature standards. Typically null for standard Viction transactions and true when using EVM-compatible transaction types.
`fee_currency`	`STRING`	Contract address of the token used to pay transaction fees, applicable on chains supporting fee payment in alternative currencies. Null when fees are paid in the native currency (VIC).
`gateway_fee`	`STRING`	Gateway fee paid for the transaction, denominated in the native VIC token or alternative fee currency. Typically null for standard Viction transactions not utilizing gateway services.
`gateway_fee_recipient`	`STRING`	Address designated to receive gateway fees for this transaction on Viction. Null for standard transactions that do not involve gateway fees.
`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.
`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	receipt_transaction_index	receipt_cumulative_gas_used
0x48f37f62cd74988b51e8c9839c1ae05ade9fda0b130de0fa7ed00245dba73003	0x3c40593b855739afe37264e41ae7eb551c7cf4a57d6cdc3a7487475a1aa997b7	211	21000	0x	718	100000000000000000	250000000	0xaae9efdfdda3f788db53a2348c4584eb034b21f227750dade8b8acdef75b7f7f	0x0faa1cd8659d50b9547b3b9428701989e5a87566	[{“address”:null,“storage_keys”:[]}]	74040529	0xed123cf8e3ba51c6c15da1eac74b2b5deea31448	true	2023-12-27T06:39:31.000Z	21000	0x0569ac329c6e740b78cfb76f8deb0a931169ddda8e3edb9362970847be23d60c	4	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	4	780486
0xe4c016607c044115b0a00c45590af0b735643bc111bafbae31511962f0bb397e	0x4188a8bd9246d4ea869d23ddfcf267ad61962821172322b2e6d9a16653f877e3	212	21000	0x	557	100000000000000000	250000000	0xf43050e0bf787164e25aa67452e6865840a2ff81c3512427477530445f005f1e	0xfede0305fa2884f51c3701a1b25b7b06fe4e1447	[{“address”:null,“storage_keys”:[]}]	74029125	0xed123cf8e3ba51c6c15da1eac74b2b5deea31448	true	2023-12-27T00:00:29.000Z	21000	0x5b72b673a28ffbffe4af84399da664c5f91ad161a9e5bc0525bb208fb215cdd5	2	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2	125544
0x8682eaa246652f2f3f467f44cf54819fab163feeb2845b46023a698d3ca40d39	0x1e350bbf663f05a1e06bbc0d64aeac35ad692db7c1b638a734357d9df23af948	212	50000	0x	1	7999986870000000000	262500000	0x1004a12598a6264720afaf1617e2a0305eb54bff9b4311a15380fcd79e465b1c	0x1651d700cd4020334bd185ba4c6e0271ffc0c732	[{“address”:null,“storage_keys”:[]}]	74056245	0x609a903f30164876de0a2571044ac74e3ef7e300	true	2023-12-27T15:52:13.000Z	21000	0x50362832152b326cc9d68e88cf878c3c4ce0759cf5967104b7b7e71b304ebada	2	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2	125480

Example Query

Query with partition filter

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