koifinance_v1_zksyncera

Tables

PairFactory_PairCreated_event

Event logs emitted when a new liquidity pool pair is created by a DEX (Decentralized Exchange) factory contract. Records the deployed pair contract address, constituent token addresses, and creation metadata for tracking protocol liquidity expansion.

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_stable`	`BOOL`	Boolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon4`	`STRING`	Sequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	in_pair	removed	in_anon4	in_stable	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
250	0x40be1cba6c5b47cdf9da7f963b6f761f4c60627d	0x4e3a9ba2a852162020d74bbd9be118a4c026fcb7	false	2417	false	0x32fd44bb869620c0ef993754c8a00be67c464806	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	75	33106563	2024-05-04T05:23:25.000Z	0x7fdcb3c6de5876fc99dd32bbd30fcadccfc5b1f2b2532b32419d3b0aba56098e
30	0x40be1cba6c5b47cdf9da7f963b6f761f4c60627d	0x0b062ebe191dccf6c20e96626c35a38035541e5c	false	2419	false	0x026712a486b7bd7c621d34f8dd1ea898a140542e	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	28	33127821	2024-05-04T11:37:36.000Z	0x6fa65222581d27e3afca98d4fec4bff6168ae0e049132d6558a120dca470fe34
30	0x40be1cba6c5b47cdf9da7f963b6f761f4c60627d	0x42bde38a7579ccdfd3767764e89e59c96ada5774	false	2418	false	0xa995ad25ce5eb76972ab356168f5e1d9257e4d05	0xbfb4b5616044eded03e5b1ad75141f0d9cb1499b	89	33120505	2024-05-04T09:28:51.000Z	0x7ee278ba1601a29aa07811e3c9945ec6700a097975a763937b5d8838d14446a0

Example Query

Query with partition filter

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

PoolFactory_PoolCreated_event

Pool creation events emitted by factory contracts when new liquidity pools are deployed. Records the pool address, token pair or configuration parameters, and fee structure for tracking pool deployments across decentralized exchange 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_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
3000	0x488a92576da475f7429bc9dec9247045156144d3	0x0b67ca4f5dd025f15544653c929ceb4a428588a5	false	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	0x5a7d6b2f92c77fad6ccabd7ee0624e64907eaf3e	3	38832058	60	2024-07-11T16:02:37.000Z	0xc515ec504f0a9bda3b48d9e3219ab201e225c08444995aa254c757240518a3b8
10000	0x488a92576da475f7429bc9dec9247045156144d3	0xd8ad6a9643233b6a04ebea47d06258d3d823dc38	false	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	0xa995ad25ce5eb76972ab356168f5e1d9257e4d05	29	34871339	200	2024-05-25T08:31:02.000Z	0x10b6be963fa32fca94d78d612cf79c18268ba4eeaeffa9df39e29600d541abed
5000	0x488a92576da475f7429bc9dec9247045156144d3	0x051350faaf904c892e9cef133cc4e52609f676fd	false	0x493257fd37edb34451f62edf8d2a0c418852ba4c	0x4b9eb6c0b6ea15176bbf62841c6b2a8a398cb656	15	35572090	100	2024-06-02T17:34:14.000Z	0x7dd6ee81ab4139fa76f5a778ea25c3107576c27a14fd075409f05d4bbcd99ec3

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

PairFactory_PairCreated_event

PoolFactory_PoolCreated_event

​Tables

​PairFactory_PairCreated_event

​PoolFactory_PoolCreated_event

Tables

PairFactory_PairCreated_event

PoolFactory_PoolCreated_event