> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# zksyncera_v1_zksyncera
> Tables in tt-contracts.zksyncera_v1_zksyncera
## Tables
### ContractDeployer\_AccountNonceOrderingUpdated\_event
*No description available.*
| 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zksyncera_v1_zksyncera.ERC20_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***