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.

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_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.

Sample Data

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

Example Query

Query with partition filter

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.

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.
`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.

Sample Data

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

Example Query

Query with partition filter

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.

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.
`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.

Sample Data

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

Example Query

Query with partition filter

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.

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.
`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%.

Sample Data

gas	status	gas_used	in_newFee	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
163548	true	5960	10	0x9cd05bfd	0x3a76e377ed58c8731f9df3a36155942438744ce3	51503478	0x97f03b2f6246da8ff336f37ad3b047f7c3f74e59	0,19,0,0,11,0,7	2024-12-17T10:04:26.000Z	0x219118528a1aba9590f85fab67eee679800c12a976c531ca8dcf917c2f3db182
135135	true	20340	8	0x9cd05bfd	0x3a76e377ed58c8731f9df3a36155942438744ce3	16346659	0x13bd7a61b46950ff0e9b41571dc4c503ee854042	0,15,0	2023-10-14T08:39:13.000Z	0x866a9d169e7f0b8334fad072c5bd20bfbb775859b8abb703400289708aefcfa1
96012	true	5960	20	0x9cd05bfd	0x3a76e377ed58c8731f9df3a36155942438744ce3	60184639	0x97f03b2f6246da8ff336f37ad3b047f7c3f74e59	20,0,0,11,7	2025-05-10T03:41:37.000Z	0x1f445d5fead0edf0f64e250851fa0ecfb90e6da6b155d34f536ca18f6cbad120

Example Query

Query with partition filter

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.

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.
`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).

Sample Data

gas	status	gas_used	in__pair	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash	in__swapFeeOverride
143892	true	11484	0xe585a96e7daa6a8695736c86a963da58f0dbb0f4	0x07cd2757	0x3a76e377ed58c8731f9df3a36155942438744ce3	51503478	0x97f03b2f6246da8ff336f37ad3b047f7c3f74e59	0,19,0,0,11,1,7	2024-12-17T10:04:26.000Z	0x219118528a1aba9590f85fab67eee679800c12a976c531ca8dcf917c2f3db182	30
214704	true	37181	0xd33a17c883d5aa79470cd2522abb213dc4017e01	0x07cd2757	0x3a76e377ed58c8731f9df3a36155942438744ce3	14428994	0x13bd7a61b46950ff0e9b41571dc4c503ee854042	16,0	2023-09-21T13:40:20.000Z	0x7006a3b4e2f1a0e9cad18ed850e179d66c58cbc42a2ce30f93c68cf402dd93f0	6
115920	true	13466	0xde2c0adc2e08ee02344ee6ad29a6c1c32c067333	0x07cd2757	0x3a76e377ed58c8731f9df3a36155942438744ce3	44335895	0x97f03b2f6246da8ff336f37ad3b047f7c3f74e59	0,19,0,0,12,7	2024-09-16T11:55:43.000Z	0x71fb6fd11f2d6e05fd067b33b041be8b6377ce911a1bd5c6ab59f6caff21308e	65535

Example Query

Query with partition filter

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.

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_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.

Sample Data

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

Example Query

Query with partition filter

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.

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_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.

Sample Data

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

Example Query

Query with partition filter

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.

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_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.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount1In	in_amount0Out	block_timestamp	transaction_hash
0x003cc7f2be7524a127e1625b5b2eb6b7bcdb44ef	0x7642e38867860d4512fcce1116e2fb539c5cdd21	false	0x18381c0f738146fb694de18d1106bde2be040fa4	94	9768657	3000000000000000	5593940	2023-07-28T12:46:04.000Z	0x4a10f1722aaecc708cb50c54eb705f925aca309303eef1ae69c4b99130960cdd
0x0111a52c0f1c16dd6af25cda8a55a82bb3e0ce54	0xf100ff84b363af74e3fcdff554e3da3309159458	false	0x18381c0f738146fb694de18d1106bde2be040fa4	371	9759262	6451	6499	2023-07-28T10:07:34.000Z	0x7d915923343f8f406115b39ec477be3a28e06e5f9f2a9e182a5a196a6bd54ff0
0x01a10eb472ddad63b881f3c3b5c6f54a5b874088	0x7642e38867860d4512fcce1116e2fb539c5cdd21	false	0x18381c0f738146fb694de18d1106bde2be040fa4	89	9755358	29375524931544813	54625355	2023-07-28T09:01:37.000Z	0xa7f7f36b2fb189d47683bd9e199d9f23b55bc7769e087f03fa14a4111e864960

Example Query

Query with partition filter

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.

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_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.

Sample Data

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

Example Query

Query with partition filter

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.

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
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

Example Query

Query with partition filter

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.

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_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.

Sample Data

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

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Factory_setFeeTo_function

Factory_setProtocolFeeFactor_function

Factory_setSwapFee_function

Factory_setSwapFeeOverride_function

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Swap2EarnRewarder_Claimed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Factory_setFeeTo_function

​Factory_setProtocolFeeFactor_function

​Factory_setSwapFee_function

​Factory_setSwapFeeOverride_function

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

​Swap2EarnRewarder_Claimed_event

Tables

Factory_PairCreated_event

Factory_setFeeTo_function

Factory_setProtocolFeeFactor_function

Factory_setSwapFee_function

Factory_setSwapFeeOverride_function

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Swap2EarnRewarder_Claimed_event