zksyncera

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.
`l1_batch_number`	`INT64`	L1 batch number grouping multiple zkSync Era blocks for submission to Ethereum mainnet. Blocks with the same batch number are processed and finalized together on L1.
`l1_batch_timestamp`	`TIMESTAMP`	Timestamp when the L1 batch containing this zkSync Era block was submitted to Ethereum mainnet. Can occur slightly before or after the block timestamp depending on batch processing timing.
`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.
`base_fee_per_gas`	`INT64`	Minimum fee per gas unit required for transaction inclusion in the block. Measured in wei, representing the base cost dynamically adjusted by the network’s fee mechanism.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 66-character hex string including 0x prefix.
`nonce`	`STRING`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`sha3_uncles`	`STRING`	Keccak-256 hash of the RLP-encoded list of uncle block headers. 66-character hex string including 0x prefix.
`logs_bloom`	`STRING`	Bloom filter for efficient event log querying within the block. 512-character hex string (including 0x prefix) representing a probabilistic data structure for testing event presence.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
`receipts_root`	`STRING`	Merkle root hash of all transaction receipts in the block. 66-character hex string including 0x prefix.
`difficulty`	`INT64`	Mining difficulty target for the block. Integer value representing the computational effort required to produce the block, with 0 indicating proof-of-stake consensus and higher values indicating proof-of-work difficulty.
`total_difficulty`	`NUMERIC`	Cumulative sum of block difficulty from genesis to the current block. Numeric value representing the total computational work expended on the chain up to and including this block.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`extra_data`	`STRING`	Arbitrary data field included in the block by the block producer. Hex-encoded string format, typically containing miner software version, pool information, or chain-specific metadata.
`mix_hash`	`STRING`	Hash value used in proof-of-work mining or consensus verification. 66-character hex string including 0x prefix.
`uncles`	`ARRAY<STRING>`	List of uncle block hashes included in the block. Empty array for chains not supporting uncle blocks in their consensus mechanism.
`seal_fields`	`ARRAY<STRING>`	Array of additional consensus seal data used in some blockchain consensus mechanisms. Always empty for zkSync Era as it uses a ZK-rollup architecture without traditional proof-of-work sealing.

Sample Data

miner	nonce	number	uncles	gas_used	mix_hash	gas_limit	timestamp	block_hash	extra_data	logs_bloom	state_root	parent_hash	seal_fields	sha3_uncles	receipts_root	l1_batch_number	base_fee_per_gas	transaction_count	transactions_root	l1_batch_timestamp
0x0000000000000000000000000000000000000000	0x0000000000000000	1760662	[]	17476895	0x0000000000000000000000000000000000000000000000000000000000000000	4294967295	2023-04-18T09:32:02.000Z	0xc7ef4fa1fd8170311db83902e5b772c44e6b86c29d2c5b52efafc416b8b527eb	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x1e0de59a65f85e1dcd4713f2464859b6f360f7363e29692e212d19264fd5f53b	[]	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x0000000000000000000000000000000000000000000000000000000000000000	17664	250000000	11	0x0000000000000000000000000000000000000000000000000000000000000000	2023-04-18T09:30:29.000Z
0x0000000000000000000000000000000000000000	0x0000000000000000	1760711	[]	0	0x0000000000000000000000000000000000000000000000000000000000000000	4294967295	2023-04-18T09:32:50.000Z	0x39b8c7ddeca0bc0fa03714834023f20e5c27b0f2e56d762a9ad710147c162b3b	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x264f2feb849a84d46abea02396c64fbb39cd39ff985fe4bbb13fc7233a190d6a	[]	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x0000000000000000000000000000000000000000000000000000000000000000	17664	250000000	0	0x0000000000000000000000000000000000000000000000000000000000000000	2023-04-18T09:30:29.000Z
0x0000000000000000000000000000000000000000	0x0000000000000000	1760853	[]	0	0x0000000000000000000000000000000000000000000000000000000000000000	4294967295	2023-04-18T09:35:57.000Z	0x52399876d7a7dedb4c7bebf48961e87492482a8265e533c8652f0a12387db7a7	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0xef6a3c238076f5e48b20ad4bacfeb24a762ced834dcf6f42609910c8957e0e57	[]	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x0000000000000000000000000000000000000000000000000000000000000000	17665	250000000	0	0x0000000000000000000000000000000000000000000000000000000000000000	2023-04-18T09:33:32.000Z

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.zksyncera.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.
`l1_batch_number`	`INT64`	Layer 1 batch number on Ethereum where this zkSync Era transaction was finalized. zkSync groups multiple L2 blocks into batches that are committed to Ethereum for security guarantees.
`transaction_log_index`	`INT64`	Position of this log entry within its parent transaction’s emitted events, starting from zero. Used to maintain ordering when multiple events occur in a single transaction.
`log_type`	`STRING`	Event log categorization field indicating the type or source of the log entry. Currently null for all standard zkSync Era transaction logs.

Sample Data

data	topics	address	removed	log_index	block_hash	block_number	block_timestamp	l1_batch_number	transaction_hash	transaction_log_index
0x0000000000000000000000000000000000000000000000000000dbaf5e6d9680	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x0000000000000000000000000000000000000000000000000000000000008001”,“0x000000000000000000000000fc5b07a5dd1b80cf271d35642f75cc0500ff1e2c”]	0x000000000000000000000000000000000000800a	false	3	0x007ecade2b4c66987f1d99a3e199b2f76b0bfb76312aa732a4bc159667d4cce9	7672	2023-03-05T00:06:28.000Z	202	0xd81f2f0446d404e4c9c701b9ccac6fd946ed1fa98524e7c4671d0424de455404	3
0x000000000000000000000000000000000000000000000000000165019839ad00	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x000000000000000000000000fc5b07a5dd1b80cf271d35642f75cc0500ff1e2c”,“0x0000000000000000000000000000000000000000000000000000000000008001”]	0x000000000000000000000000000000000000800a	false	0	0x007ecade2b4c66987f1d99a3e199b2f76b0bfb76312aa732a4bc159667d4cce9	7672	2023-03-05T00:06:28.000Z	202	0xd81f2f0446d404e4c9c701b9ccac6fd946ed1fa98524e7c4671d0424de455404	0
0x00000000000000000000000000000000000000000000000000004766b80b8900	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x0000000000000000000000000000000000000000000000000000000000008001”,“0x000000000000000000000000fc5b07a5dd1b80cf271d35642f75cc0500ff1e2c”]	0x000000000000000000000000000000000000800a	false	1	0x007ecade2b4c66987f1d99a3e199b2f76b0bfb76312aa732a4bc159667d4cce9	7672	2023-03-05T00:06:28.000Z	202	0xd81f2f0446d404e4c9c701b9ccac6fd946ed1fa98524e7c4671d0424de455404	1

Example Query

Query with partition filter

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

traces

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

Columns

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

Sample Data

gas	input	output	status	gas_used	trace_id	to_address	trace_type	block_number	from_address	trace_address	block_timestamp	transaction_hash	transaction_index
252882	0xbf1fe4200000000000000000000000000000000000000000000000000000000005f5e100	0x	true	3807	Call_0x2018e4fe84cd54e9bbb1ba22d7bce8917410dab7c28cacee3d1634ff04a51b1e_0_6	0x000000000000000000000000000000000000800b	Call	24081690	0x0000000000000000000000000000000000008001	0,6	2024-01-15T04:22:37.000Z	0x2018e4fe84cd54e9bbb1ba22d7bce8917410dab7c28cacee3d1634ff04a51b1e	10
419013	0x000000000000000000000000bc7c96d0f927d6e883a069cede9d6a891cc7e3010000000000000000000000000000000000000000000000000000000000000000	0x841eb5cbebdd09c88e067aa9b43112c18bf39e4a8ac4e245090386f73cb1271f	true	303	Call_0x46e004fe519caff0b3ee48038892126db856bb80e8688c1c7e1cf9dcb3b4722a_0_9_0_1	0x0000000000000000000000000000000000008010	Call	24102974	0x0000000000000000000000000000000000008003	0,9,0,1	2024-01-15T10:42:21.000Z	0x46e004fe519caff0b3ee48038892126db856bb80e8688c1c7e1cf9dcb3b4722a	11
4101030360	0x00000000000000000000000000000000000000000000000000003b181fdf9400	0x	true	317	Call_0x0032cf23efa04f05d9de177ba58dc1b8639ed7b778bb9f3c5b02c17dba982206_0_19_3	0x000000000000000000000000000000000000800d	Call	24071114	0x000000000000000000000000000000000000800a	0,19,3	2024-01-15T01:15:21.000Z	0x0032cf23efa04f05d9de177ba58dc1b8639ed7b778bb9f3c5b02c17dba982206	7

Example Query

Query with partition filter

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

transactions

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

Columns

Column	Type	Description
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_price`	`INT64`	Price per unit of gas for the transaction. Integer value denominated in the smallest unit of the blockchain’s native currency (wei for EVM chains).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`input`	`STRING`	Calldata or transaction payload sent with the call or transaction. Hex-encoded string starting with 0x, containing the function signature and encoded parameters for smart contract interactions.
`l1_batch_number`	`INT64`	Batch number on the zkSync Layer 1 settlement layer that contains this transaction. Used to group multiple L2 transactions into a single L1 commitment for cost efficiency.
`l1_batch_tx_index`	`INT64`	Index position of this transaction within its L1 batch on zkSync Era. Transactions are ordered sequentially within each L1 batch, starting from 0.
`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.
`receipt_contract_address`	`STRING`	Contract address created by the transaction when deploying a new smart contract. Hex-encoded, 0x-prefixed, 42-character string. Null for all non-deployment transactions.
`receipt_cumulative_gas_used`	`INT64`	Total gas consumed by all transactions in the block up to and including this transaction. Integer value representing the cumulative sum of gas used, incrementing with each transaction in sequential order.
`receipt_effective_gas_price`	`INT64`	Actual gas price paid per unit for transaction execution. Integer value denominated in wei.
`receipt_gas_used`	`INT64`	Gas units consumed by this specific transaction.
`receipt_logs_bloom`	`STRING`	Bloom filter for efficiently querying event logs emitted by the transaction. 512-character hex string including 0x prefix, representing a 256-byte bit array used for probabilistic matching of log topics and addresses.
`receipt_status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true indicates successful execution and false indicates failure.
`receipt_transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`receipt_l1_batch_number`	`INT64`	Sequential number of the L1 batch that included this transaction’s execution on zkSync Era. Corresponds to the batch committed to Ethereum Layer 1 for finality.
`receipt_l1_batch_tx_index`	`INT64`	Position of the transaction within its L1 batch on zkSync Era. Matches `l1_batch_tx_index` in the sample data, indicating the transaction’s ordering within the rollup batch submitted to Ethereum L1.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`receipt_root`	`STRING`	State root hash of the transaction receipt on zkSync Era. Matches the block hash for this Layer 2 transaction.

Sample Data

gas	input	value	chain_id	gas_price	block_hash	to_address	block_number	from_address	receipt_root	receipt_type	receipt_status	block_timestamp	l1_batch_number	max_fee_per_gas	receipt_gas_used	transaction_hash	transaction_type	l1_batch_tx_index	transaction_index	receipt_logs_bloom	receipt_l1_batch_number	receipt_l1_batch_tx_index	receipt_transaction_index	receipt_effective_gas_price
742563	0x	373400000000000000	324	500000000	0xd16f514484daef5bc1f045f8bb72d8699564e6e79c77e9e76e0ca98a3c025f92	0xfc331f0dccc57b6e42a95e0e9d637cec862330fd	19864276	0xfc331f0dccc57b6e42a95e0e9d637cec862330fd	0xd16f514484daef5bc1f045f8bb72d8699564e6e79c77e9e76e0ca98a3c025f92	255	true	2023-11-25T06:21:18.000Z	320142	500000000	590531	0xfd7a7f81e82853df1d39a9a5ec965e165280e09f1c31fd6aaa7e814be889a3e5	255	27	27	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	320142	27	27	500000000
742563	0x	2478000000000000000	324	516472129	0x6875707cd7e1d85fc75d9660ea9047039913c621f8fdaf4c7cca6956adc92c82	0x74315a8d54cf9b615f6d4ddf132620abf04600c8	19883661	0x74315a8d54cf9b615f6d4ddf132620abf04600c8	0x6875707cd7e1d85fc75d9660ea9047039913c621f8fdaf4c7cca6956adc92c82	255	true	2023-11-25T11:54:07.000Z	320725	516472129	590531	0xffdef830b9409fce280ec136bb21496de4caad89998c229f0ce11f3f48e2fbe6	255	449	15	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	320725	449	15	516472129
783252	0x	5993864627200000000	324	500000000	0x1125bb19ac7137d6a6e656c494fbb2a3cff3f7fcd33a37cff4834ceb15d458f9	0x117f2448c5aa4060875260d8b8359257758e5e99	19850029	0x117f2448c5aa4060875260d8b8359257758e5e99	0x1125bb19ac7137d6a6e656c494fbb2a3cff3f7fcd33a37cff4834ceb15d458f9	255	true	2023-11-25T02:18:02.000Z	319804	500000000	625041	0xa0e1eaf1667df851771c01115942c26e39126fb73644c3758f81d49c8fa65243	255	415	17	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	319804	415	17	500000000

Example Query

Query with partition filter

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