kyber_v2_zksyncera

Tables

KSFactory_PoolCreated_event

Liquidity pool creation events emitted by the KyberSwap factory contract. Records token pair addresses, amplification parameters, fee configuration, and cumulative pool count for tracking DEX deployment 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_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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_ampBps`	`STRING`	Amplification factor of the liquidity pool expressed in basis points (BPS). Numeric string value that defines the pool’s price curve characteristics in the Kyber protocol.
`in_feeUnits`	`STRING`	Fee charged by the liquidity pool for trades. Numeric string value representing the fee in basis points or fee units defined by the Kyber protocol.
`in_totalPool`	`STRING`	Total number of liquidity pools created by the factory contract at the time of this pool creation event. Numeric string value that increments sequentially with each new pool.

Sample Data

address	in_pool	removed	in_ampBps	in_token0	in_token1	log_index	in_feeUnits	block_number	in_totalPool	block_timestamp	transaction_hash
0x9017f5a42fbe5bca3853400d2660a2ee771b241e	0x13e38ab4cdaf258362cbd0145f78d537719b5ff5	false	10024	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	56	300	13880386	76	2023-09-15T01:50:46.000Z	0x97738a428857541f10116e75ceff53096498164066bcfc5a1441727c2d6272d9
0x9017f5a42fbe5bca3853400d2660a2ee771b241e	0x2c45cc84e0458f98eb53d18a527dcf1b56d72518	false	10233	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	108	300	13889035	78	2023-09-15T04:18:43.000Z	0x1a045ffb88fd90d35f21ccb28936fabcdf9e71a4567928c9a56aca1ba98c98de
0x9017f5a42fbe5bca3853400d2660a2ee771b241e	0xa340d74d33de20fed6678da5e43b54ae3e3ffee4	false	11200	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	59	50	13918941	81	2023-09-15T12:54:28.000Z	0xba9195dcea43c48ab9a53d50fd944c971128281b063e9a48afceb88ef0b17ec1

Example Query

Query with partition filter

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

KSPool_Swap_event

KyberSwap pool swap events recording token exchanges within liquidity pools. Contains input and output amounts for both token0 and token1, swap fees, initiating sender, and recipient address for tracking DEX trading activity and volume 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_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_feeInPrecision`	`STRING`	Swap fee amount expressed in high-precision fixed-point format. Stored as decimal string representing the fee scaled by a precision factor.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash	in_feeInPrecision
0x0c83d9a7353f533d762bc9ecd8bca48b0add6a33	0x40e76c271e501803ae7f6854ae06c68231c6ec91	false	0x0c83d9a7353f533d762bc9ecd8bca48b0add6a33	56	6420222	0	100000000000000	176194	0	2023-06-19T02:29:11.000Z	0xcec44f69c71d1e5bd8767b24725ae188319d68b2c338d8b75a5731aecb68654e	3000000000000000
0x849c6514e07fe2249d380044a03947da40c7fa1a	0x17086a037d0104a7f6878eaaeb7319be40d037f5	false	0x849c6514e07fe2249d380044a03947da40c7fa1a	33	10660859	36597	0	0	20149821836824	2023-08-07T23:55:56.000Z	0xf7668fa3b7d2da2c4e97736626ec4c8138c1af2f046526c6b0b72f9c717914b4	100000000000000
0x849c6514e07fe2249d380044a03947da40c7fa1a	0x17086a037d0104a7f6878eaaeb7319be40d037f5	false	0x849c6514e07fe2249d380044a03947da40c7fa1a	103	10614859	1000	0	0	546619507766	2023-08-07T11:02:27.000Z	0x86fe04b87ae5cc3a1a01501e98053079da235bf0071ab9e524a3223bd7bca6b4	100000000000000

Example Query

Query with partition filter

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

KSPool_Sync_event

KyberSwap pool synchronization events emitted when liquidity pool reserves are updated. Contains actual reserve balances (reserve0, reserve1) and virtual reserves (vReserve0, vReserve1) used in Kyber’s dynamic market maker pricing mechanism.

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_vReserve0`	`STRING`	Virtual reserve amount of the first token in a Kyber liquidity pool. Stored as decimal string representing the smallest unit of the token.
`in_vReserve1`	`STRING`	Virtual reserve amount of the second token in a Kyber liquidity pool. Stored as decimal string representing the smallest unit of the token.
`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	in_vReserve0	in_vReserve1	block_timestamp	transaction_hash
0x29809988573341d0b275a54745bdb4a84fe06858	false	88	8731174911467003913	5318320738024150	14406666	0	0	2023-09-21T07:12:09.000Z	0x9b93b32fe7c6ca559f45a35480e33770124d6b4421c585a4874917e9117b00ed
0x1fdf0b149566e2c5032828ae73d3e4494efdcaa2	false	136	5227705	8520227193505967158	14388520	6303530	10175985767658036258	2023-09-21T01:59:45.000Z	0xefa5b9a676ec2ef20261a54d0680c7ede681c15d63fb8bf9b89e98d164cc71c5
0xa985408b850a444d11db6e4b3afc585942f661fb	false	179	51632950	33488090792697050	14429455	78663305	49490545139929669	2023-09-21T13:48:16.000Z	0x817fdd83cbf1f9642f77a3863cbbdeb988d0994d34fc562473b912b9964936cb

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

KSFactory_PoolCreated_event

KSPool_Swap_event

KSPool_Sync_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​KSFactory_PoolCreated_event

​KSPool_Swap_event

​KSPool_Sync_event

Tables

KSFactory_PoolCreated_event

KSPool_Swap_event

KSPool_Sync_event