zksyncera_v1_zksyncera

Tables

ContractDeployer_AccountNonceOrderingUpdated_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_accountAddress`	`STRING`	-
`in_nonceOrdering`	`INT64`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zksyncera_v1_zksyncera.ContractDeployer_AccountNonceOrderingUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ContractDeployer_AccountVersionUpdated_event

Account Abstraction (AA) version updates for deployed contracts on zkSync Era, emitted by the ContractDeployer system contract. Tracks which AA version specification each account contract implements for wallet and smart contract account analysis.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_accountAddress`	`STRING`	Account address that had its version updated. Hex-encoded, 0x-prefixed 40-character address string for the zkSync Era account undergoing the version change.
`in_aaVersion`	`INT64`	Account Abstraction (AA) version number for the deployed contract, where 0 indicates a standard account and higher values represent different AA implementation versions. This value defines the account’s interaction model with the zkSync Era protocol.

Sample Data

address	removed	log_index	block_number	in_aaVersion	block_timestamp	transaction_hash	in_accountAddress
0x0000000000000000000000000000000000008006	false	4	51507788	0	2024-12-17T11:21:43.000Z	0x835400177b507bda673c969fcf9c8652b7464a7bfebc0fb13c244124fb9092d5	0x270fe1e8effa2c5a013480b27532c436d650a1d7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zksyncera_v1_zksyncera.ContractDeployer_AccountVersionUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ContractDeployer_ContractDeployed_event

Contract deployment events from zkSync Era’s system ContractDeployer contract, capturing when new smart contracts are deployed to the network with bytecode hash, deployer address, and resulting contract address for tracking contract creation activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_deployerAddress`	`STRING`	Address of the account that initiated the contract deployment on zkSync Era. Hex-encoded, 0x-prefixed 40-character string representing the externally owned account or contract that deployed the new contract.
`in_bytecodeHash`	`STRING`	Keccak-256 hash of the contract’s bytecode as stored on zkSync Era, used to uniquely identify the deployed contract code. Hex-encoded, 0x-prefixed 64-character string following zkSync’s bytecode versioning scheme (indicated by the 0100 prefix).
`in_contractAddress`	`STRING`	Contract address on the destination blockchain that is the target of the cross-chain call or deployment. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_bytecodeHash	transaction_hash	in_contractAddress	in_deployerAddress
0x0000000000000000000000000000000000008006	false	256	20546371	2023-12-03T08:27:46.000Z	0x0100004124426fb9ebb25e27d670c068e52f9ba631bd383279a188be47e3f86d	0x5b3cfc625f4188cbed53d919a6f6b5d01efed9529b465fb0689a468dbbeb6fbf	0xb5a9bc08b4e6b1a0bc503941ff9a736fff1544e4	0xdaec33641865e4651fb43181c6db6f7232ee91c2
0x0000000000000000000000000000000000008006	false	256	20562646	2023-12-03T13:08:44.000Z	0x0100004124426fb9ebb25e27d670c068e52f9ba631bd383279a188be47e3f86d	0xa4f7c78f5be7948c9f3e7495eb6602fbcd1cab7f737d4ac174da2f536bd0ccbd	0x043094782e4d207cf7afb635fe7c206111a90d39	0xdaec33641865e4651fb43181c6db6f7232ee91c2
0x0000000000000000000000000000000000008006	false	1	20560009	2023-12-03T12:23:23.000Z	0x0100001bcf3424d9bc67cdb6eca8cfb731cec86df28064283f3c82fb1bf5c8be	0x2a54b3c99f8f9a2f8b821d4617dc0154d92674d166b1fe470bc70dd081c41af0	0x4a1f6db4324a255fc5158ac0a99b2d5284966177	0x557057b7dc2c156f15b4048f5d16e3b5edc3f5fb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zksyncera_v1_zksyncera.ContractDeployer_ContractDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ERC20_Transfer_event

ERC-20 token transfer events decoded from transaction logs, containing sender address, recipient address, and token amount. Primary source for tracking fungible token flows and wallet holdings across EVM-compatible blockchains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000008001	0x000000000000000000000000000000000000800a	0x774f5c965bbb4136f75ffd74689acf3463f6d065	false	1385295000000000	12	11010048	2023-08-12T02:18:07.000Z	0x20ba0f929591710bad24861183526bb1f5d4b3931b3fd9c5c1fa5899d69cc461
0xe399b954ed6483b734d5d311d7b36c5b5916b9aa	0x000000000000000000000000000000000000800a	0x0000000000000000000000000000000000008001	false	116779750000000	34	11010048	2023-08-12T02:18:07.000Z	0x3b39c07ea3158e52b4d08dd2bef05d52a81c92f6a74d7d2bd2ed19cfb973c7ca
0xb28c5d26e899de9123cc150afcd94edb5d122c86	0x000000000000000000000000000000000000800a	0x0000000000000000000000000000000000008001	false	53292000000000	2	11010048	2023-08-12T02:18:07.000Z	0xb5c769fa235ad571144dbebe8cf4b24f5d82159186e54e31bbf471199f3dfa45

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zksyncera_v1_zksyncera.ERC20_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ContractDeployer_AccountNonceOrderingUpdated_event

ContractDeployer_AccountVersionUpdated_event

ContractDeployer_ContractDeployed_event

ERC20_Transfer_event

​Tables

​ContractDeployer_AccountNonceOrderingUpdated_event

​ContractDeployer_AccountVersionUpdated_event

​ContractDeployer_ContractDeployed_event

​ERC20_Transfer_event

Tables

ContractDeployer_AccountNonceOrderingUpdated_event

ContractDeployer_AccountVersionUpdated_event

ContractDeployer_ContractDeployed_event

ERC20_Transfer_event