> ## 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.
# zkswap_v1_zksyncera
> Tables in tt-contracts.zkswap_v1_zksyncera
## Tables
### Factory\_PairCreated\_event
Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.
| 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_token0` | `STRING` | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token1` | `STRING` | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pair` | `STRING` | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_anon3` | `STRING` | Sequential counter tracking the total number of pairs created by the factory contract. |
| address | in\_pair | removed | in\_anon3 | in\_token0 | in\_token1 | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | --------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 0xb91bb9dc5f343df776f8ed74adff4be2c14e966c | false | 25 | 0x31c2c031fdc9d33e974f327ab0d9883eae06ca4a | 0x493257fd37edb34451f62edf8d2a0c418852ba4c | 164 | 12906059 | 2023-09-03T13:29:19.000Z | 0x82ce5ad732489473d654c16784e6af377bc924456a025df588878648726f08e4 |
| 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 0xee6e1b222648a28b3b39b079b92ce463199232ca | false | 22 | 0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4 | 0x6a5279e99ca7786fb13f827fc1fb4f61684933d6 | 34 | 12222433 | 2023-08-26T11:31:01.000Z | 0xc65d9d0f47590826fd7e28a29c5fda71df263f173c19c6afd06bf7cfe9da64be |
| 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 0xc5e0da4b3bade8b4b32d9fa80718ac7932a260ef | false | 102 | 0x47260090ce5e83454d5f05a0abbb2c953835f777 | 0x787c09494ec8bcb24dcaf8659e7d5d69979ee508 | 21 | 19486774 | 2023-11-20T18:54:31.000Z | 0x3bc0df27440485db4af11614cf112b69d355b726e1ef8a0e9b77d0f7cbf80152 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zkswap_v1_zksyncera.Factory_PairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory\_setFeeTo\_function
Uniswap V2 Factory setFeeTo function call records for updating the protocol fee recipient address. Captures administrative transactions that configure the address receiving protocol trading fees.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `NUMERIC` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__feeTo` | `STRING` | Address designated to receive protocol fees from Uniswap V2 factory operations. Hex-encoded, 0x-prefixed, 42-character string. |
| gas | value | status | gas\_used | in\_\_feeTo | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 359415 | 0 | true | 87340 | 0xdf2f4f154ccd8a96675c9946180cef7c4a267d3a | 0xf46901ed | 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 7372690 | 0x13bd7a61b46950ff0e9b41571dc4c503ee854042 | 14,0 | 2023-06-30T07:13:01.000Z | 0xa0546dbd397e3035adb3cb64e9e9a4740fb869aac600b4b54ce9fad857465c25 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zkswap_v1_zksyncera.Factory_setFeeTo_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory\_setProtocolFeeFactor\_function
Protocol fee factor adjustment events from zkSwap V1 Factory contract on zkSync Era, capturing administrative changes to fee parameters. Useful for tracking fee policy updates and protocol governance actions.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `NUMERIC` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_newFactor` | `INT64` | New protocol fee factor value being set by the factory contract owner. Integer parameter that defines the protocol's fee multiplier, with sample values ranging from 3 to 255. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | in\_newFactor | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 165249 | 0 | true | 50918 | 0xd4038474 | 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 12995807 | 0x13bd7a61b46950ff0e9b41571dc4c503ee854042 | 3 | 14,0 | 2023-09-04T14:47:29.000Z | 0xae8c03c978bbbe1a893bc652ff6dee70adcf9ab0ba1304fc13834d01ddb56a8a |
| 268758 | 0 | true | 49878 | 0xd4038474 | 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 11347579 | 0x13bd7a61b46950ff0e9b41571dc4c503ee854042 | 255 | 14,0 | 2023-08-16T02:08:25.000Z | 0x946a17c1cb3eb08b833e1e57d546a2e74a98771f5d071b9d2d4f18b13336dac5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zkswap_v1_zksyncera.Factory_setProtocolFeeFactor_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory\_setSwapFee\_function
Factory contract administrative calls that update swap fee parameters on zkSwap V1 (zkSync Era). Tracks governance changes to trading fee rates (in basis points) for analyzing protocol fee structure evolution.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `NUMERIC` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_newFee` | `STRING` | Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%. |
| gas | value | status | gas\_used | in\_newFee | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 163548 | 0 | true | 5960 | 10 | 0x9cd05bfd | 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 51503478 | 0x97f03b2f6246da8ff336f37ad3b047f7c3f74e59 | 0,19,0,0,11,0,7 | 2024-12-17T10:04:26.000Z | 0x219118528a1aba9590f85fab67eee679800c12a976c531ca8dcf917c2f3db182 |
| 135135 | 0 | true | 20340 | 8 | 0x9cd05bfd | 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 16346659 | 0x13bd7a61b46950ff0e9b41571dc4c503ee854042 | 0,15,0 | 2023-10-14T08:39:13.000Z | 0x866a9d169e7f0b8334fad072c5bd20bfbb775859b8abb703400289708aefcfa1 |
| 96012 | 0 | true | 5960 | 20 | 0x9cd05bfd | 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 60184639 | 0x97f03b2f6246da8ff336f37ad3b047f7c3f74e59 | 20,0,0,11,7 | 2025-05-10T03:41:37.000Z | 0x1f445d5fead0edf0f64e250851fa0ecfb90e6da6b155d34f536ca18f6cbad120 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zkswap_v1_zksyncera.Factory_setSwapFee_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory\_setSwapFeeOverride\_function
Factory contract admin operations setting custom swap fee overrides for specific trading pairs on zkSwap V1 (zkSync Era). Tracks fee parameter adjustments with override values ranging from 0 to 65535 basis points for liquidity pool customization.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `NUMERIC` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__pair` | `STRING` | Contract address of the trading pair on zkSync Era for which the swap fee override is being set. Hex-encoded, 0x-prefixed 40-character string identifying the liquidity pool contract. |
| `in__swapFeeOverride` | `STRING` | Custom swap fee value being set for the specified trading pair, measured in basis points. Overrides the default factory fee setting, with values ranging from 0 (no fee) to 65535 (maximum override). |
| gas | value | status | gas\_used | in\_\_pair | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash | in\_\_swapFeeOverride |
| ------ | ----- | ------ | --------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | --------------- | ------------------------ | ------------------------------------------------------------------ | --------------------- |
| 143892 | 0 | true | 11484 | 0xe585a96e7daa6a8695736c86a963da58f0dbb0f4 | 0x07cd2757 | 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 51503478 | 0x97f03b2f6246da8ff336f37ad3b047f7c3f74e59 | 0,19,0,0,11,1,7 | 2024-12-17T10:04:26.000Z | 0x219118528a1aba9590f85fab67eee679800c12a976c531ca8dcf917c2f3db182 | 30 |
| 214704 | 0 | true | 37181 | 0xd33a17c883d5aa79470cd2522abb213dc4017e01 | 0x07cd2757 | 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 14428994 | 0x13bd7a61b46950ff0e9b41571dc4c503ee854042 | 16,0 | 2023-09-21T13:40:20.000Z | 0x7006a3b4e2f1a0e9cad18ed850e179d66c58cbc42a2ce30f93c68cf402dd93f0 | 6 |
| 115920 | 0 | true | 13466 | 0xde2c0adc2e08ee02344ee6ad29a6c1c32c067333 | 0x07cd2757 | 0x3a76e377ed58c8731f9df3a36155942438744ce3 | 44335895 | 0x97f03b2f6246da8ff336f37ad3b047f7c3f74e59 | 0,19,0,0,12,7 | 2024-09-16T11:55:43.000Z | 0x71fb6fd11f2d6e05fd067b33b041be8b6377ce911a1bd5c6ab59f6caff21308e | 65535 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zkswap_v1_zksyncera.Factory_setSwapFeeOverride_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair\_Burn\_event
Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) pools.
| 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount0` | `STRING` | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amount1` | `STRING` | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| in\_to | address | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------- | ----------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x18381c0f738146fb694de18d1106bde2be040fa4 | 0x7642e38867860d4512fcce1116e2fb539c5cdd21 | false | 0x18381c0f738146fb694de18d1106bde2be040fa4 | 8 | 1964037 | 1077173486406267 | 10419125 | 2023-08-05T04:09:41.000Z | 0x4595961a5e400a0546b538c65f59b2d4e04419dd3701d1df5b14837dc19d9599 |
| 0x18381c0f738146fb694de18d1106bde2be040fa4 | 0x7642e38867860d4512fcce1116e2fb539c5cdd21 | false | 0x18381c0f738146fb694de18d1106bde2be040fa4 | 9 | 1448201 | 790920402153041 | 10455593 | 2023-08-05T14:23:10.000Z | 0x7fce9545f2bc5b09a8a88a5d45c0a78b66ad9e96963050ace1092118f6c194fa |
| 0x18381c0f738146fb694de18d1106bde2be040fa4 | 0x7642e38867860d4512fcce1116e2fb539c5cdd21 | false | 0x18381c0f738146fb694de18d1106bde2be040fa4 | 9 | 41970984 | 22994899725464975 | 10422758 | 2023-08-05T05:10:48.000Z | 0x53059fc07e46ea0fb908f872066c2112c545937e4f02ff7bab7045edc186c681 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zkswap_v1_zksyncera.Pair_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair\_Mint\_event
Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.
| 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount0` | `STRING` | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amount1` | `STRING` | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1c6abeed33360697958bd9a37b1c3fe3671ed51a | false | 0x18381c0f738146fb694de18d1106bde2be040fa4 | 79 | 1000000000000 | 1000000000000000000000000 | 9744083 | 2023-07-28T05:50:47.000Z | 0x16b4edc9512e43869709bf8485dd14a4720054fba4f48e68cf7d4f5ca6a8cef3 |
| 0x2aeb671087044ef308603e271702134e1eab5505 | false | 0x18381c0f738146fb694de18d1106bde2be040fa4 | 36 | 10000000000000000000 | 5355990702099247 | 9731725 | 2023-07-28T02:22:55.000Z | 0xf59a174b9eb517d7d898c6e64c141741601f86b5f18b3c1aa8bb047ba5a71d97 |
| 0x4b2e75f8a594de349d3e374d94bf88551c46c761 | false | 0x18381c0f738146fb694de18d1106bde2be040fa4 | 38 | 764598000000000000 | 737604 | 9740366 | 2023-07-28T04:48:18.000Z | 0xf8f1bcc37c8fa1668ad3d072b46a1edaad1154a3748c7ac819b38a89d857ff54 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zkswap_v1_zksyncera.Pair_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair\_Swap\_event
Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.
| 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount0In` | `STRING` | Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
| `in_amount1In` | `STRING` | Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
| `in_amount0Out` | `STRING` | Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
| `in_amount1Out` | `STRING` | Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| in\_to | address | removed | in\_sender | log\_index | block\_number | in\_amount0In | in\_amount1In | in\_amount0Out | in\_amount1Out | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | ----------------- | -------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x003cc7f2be7524a127e1625b5b2eb6b7bcdb44ef | 0x7642e38867860d4512fcce1116e2fb539c5cdd21 | false | 0x18381c0f738146fb694de18d1106bde2be040fa4 | 94 | 9768657 | 0 | 3000000000000000 | 5593940 | 0 | 2023-07-28T12:46:04.000Z | 0x4a10f1722aaecc708cb50c54eb705f925aca309303eef1ae69c4b99130960cdd |
| 0x0111a52c0f1c16dd6af25cda8a55a82bb3e0ce54 | 0xf100ff84b363af74e3fcdff554e3da3309159458 | false | 0x18381c0f738146fb694de18d1106bde2be040fa4 | 371 | 9759262 | 0 | 6451 | 6499 | 0 | 2023-07-28T10:07:34.000Z | 0x7d915923343f8f406115b39ec477be3a28e06e5f9f2a9e182a5a196a6bd54ff0 |
| 0x01a10eb472ddad63b881f3c3b5c6f54a5b874088 | 0x7642e38867860d4512fcce1116e2fb539c5cdd21 | false | 0x18381c0f738146fb694de18d1106bde2be040fa4 | 89 | 9755358 | 0 | 29375524931544813 | 54625355 | 0 | 2023-07-28T09:01:37.000Z | 0xa7f7f36b2fb189d47683bd9e199d9f23b55bc7769e087f03fa14a4111e864960 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zkswap_v1_zksyncera.Pair_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair\_Sync\_event
Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.
| 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_reserve0` | `STRING` | Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token. |
| `in_reserve1` | `STRING` | Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token. |
| address | removed | log\_index | in\_reserve0 | in\_reserve1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------ | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x01dc3fc0e7825411c7f6647d6391f5786964d28a | false | 111 | 27934856 | 106592 | 13829503 | 2023-09-14T11:29:07.000Z | 0xa39f882bf1dfa568f2fd322f55aeeecdb10793f0d00981b00cb03bde7a5849f3 |
| 0x01dc3fc0e7825411c7f6647d6391f5786964d28a | false | 116 | 27932648 | 106599 | 13829420 | 2023-09-14T11:27:41.000Z | 0xb2d9df1ab10f1c1d450a4c085f348da1793f3898f3131e0ef0d52e69fedbf8f5 |
| 0x01dc3fc0e7825411c7f6647d6391f5786964d28a | false | 119 | 27930048 | 106607 | 13800870 | 2023-09-14T03:25:16.000Z | 0x4bf25a8cccb78f4183f91ae52c027774d997d8bd055800928744168f7f3ffa19 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zkswap_v1_zksyncera.Pair_Sync_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair\_Transfer\_event
ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.
| 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 |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ---------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xa3f7b7b0a211489f86b358762857449efeadd991 | 0x01dc3fc0e7825411c7f6647d6391f5786964d28a | 0x0000000000000000000000000000000000000000 | false | 4474 | 10 | 13578902 | 2023-09-11T12:27:33.000Z | 0x48f9f79a8b4fddad28d0a606becd70b318a84e7262af55132b58693390bc6867 |
| 0xdf2f4f154ccd8a96675c9946180cef7c4a267d3a | 0x2aeb671087044ef308603e271702134e1eab5505 | 0x0000000000000000000000000000000000000000 | false | 321756451444090 | 40 | 13615129 | 2023-09-11T22:47:16.000Z | 0xd6f8c7d8e88b0b8fa69fc33efa217347219beed49e4df51c4754992fe769e238 |
| 0x61091068e2bfeab449aad4b26770e1c10caabd06 | 0x2aeb671087044ef308603e271702134e1eab5505 | 0x0000000000000000000000000000000000000000 | false | 1246144363220270 | 41 | 13615129 | 2023-09-11T22:47:16.000Z | 0xd6f8c7d8e88b0b8fa69fc33efa217347219beed49e4df51c4754992fe769e238 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zkswap_v1_zksyncera.Pair_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Swap2EarnRewarder\_Claimed\_event
Reward claim events from zkSwap V1's Swap2Earn incentive program on zkSync Era, tracking token amounts distributed to users per reward cycle. Used for analyzing user participation in trading rewards and protocol incentive distribution patterns.
| 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_cycle` | `STRING` | Identifier of the reward distribution cycle during which the swap-to-earn rewards were claimed. Observed values like '3' indicate discrete program periods or epochs for reward calculations. |
| `in_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_cycle | in\_amount | log\_index | in\_account | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------- | ---------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xf4dac6647f4c56de2a8be120e5a830b5bd5aae91 | false | 3 | 1838803444195701786157 | 3 | 0xa1baabc6cb06abe026cf1cd519b35e7b24107bf0 | 18926758 | 2023-11-14T03:22:35.000Z | 0x92f5ea3ad9706e9356799bff265b45253cdc1c4c9d57a94b413fded013d139dc |
| 0xf4dac6647f4c56de2a8be120e5a830b5bd5aae91 | false | 3 | 2540319278580019713 | 3 | 0x0d0d34dcd3242ae5cc6542b058a4be3ec33d5c46 | 18969080 | 2023-11-14T15:20:14.000Z | 0x48abaded867e0e8a47920ca29f9baff78949211e8cb89b2e77692bfe6bb87a2b |
| 0xf4dac6647f4c56de2a8be120e5a830b5bd5aae91 | false | 3 | 8745020848293597382 | 5 | 0xff10684fde3a2446ae6d7667c4f7b242602c3b2e | 18979088 | 2023-11-14T18:14:08.000Z | 0x7fcfa06214cdcac8814c4b786bd31cba16e88eb67705d4693cbe83b9ba475d6d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zkswap_v1_zksyncera.Swap2EarnRewarder_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***