Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_stableBOOLBoolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values.
in_pairSTRINGContract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
in_anon4STRINGSequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value.
in_feeSTRINGFee 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_feeaddressin_pairremovedin_anon4in_stablein_token0in_token1log_indexblock_numberblock_timestamptransaction_hash
2500x40be1cba6c5b47cdf9da7f963b6f761f4c60627d0x4e3a9ba2a852162020d74bbd9be118a4c026fcb7false2417false0x32fd44bb869620c0ef993754c8a00be67c4648060x5aea5775959fbc2557cc8789bc1bf90a239d9a9175331065632024-05-04T05:23:25.000Z0x7fdcb3c6de5876fc99dd32bbd30fcadccfc5b1f2b2532b32419d3b0aba56098e
300x40be1cba6c5b47cdf9da7f963b6f761f4c60627d0x0b062ebe191dccf6c20e96626c35a38035541e5cfalse2419false0x026712a486b7bd7c621d34f8dd1ea898a140542e0x5aea5775959fbc2557cc8789bc1bf90a239d9a9128331278212024-05-04T11:37:36.000Z0x6fa65222581d27e3afca98d4fec4bff6168ae0e049132d6558a120dca470fe34
300x40be1cba6c5b47cdf9da7f963b6f761f4c60627d0x42bde38a7579ccdfd3767764e89e59c96ada5774false2418false0xa995ad25ce5eb76972ab356168f5e1d9257e4d050xbfb4b5616044eded03e5b1ad75141f0d9cb1499b89331205052024-05-04T09:28:51.000Z0x7ee278ba1601a29aa07811e3c9945ec6700a097975a763937b5d8838d14446a0
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_feeSTRINGFee 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_tickSpacingINT64Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_feeaddressin_poolremovedin_token0in_token1log_indexblock_numberin_tickSpacingblock_timestamptransaction_hash
30000x488a92576da475f7429bc9dec9247045156144d30x0b67ca4f5dd025f15544653c929ceb4a428588a5false0x1d17cbcf0d6d143135ae902365d2e5e2a16538d40x5a7d6b2f92c77fad6ccabd7ee0624e64907eaf3e338832058602024-07-11T16:02:37.000Z0xc515ec504f0a9bda3b48d9e3219ab201e225c08444995aa254c757240518a3b8
100000x488a92576da475f7429bc9dec9247045156144d30xd8ad6a9643233b6a04ebea47d06258d3d823dc38false0x3355df6d4c9c3035724fd0e3914de96a5a83aaf40xa995ad25ce5eb76972ab356168f5e1d9257e4d0529348713392002024-05-25T08:31:02.000Z0x10b6be963fa32fca94d78d612cf79c18268ba4eeaeffa9df39e29600d541abed
50000x488a92576da475f7429bc9dec9247045156144d30x051350faaf904c892e9cef133cc4e52609f676fdfalse0x493257fd37edb34451f62edf8d2a0c418852ba4c0x4b9eb6c0b6ea15176bbf62841c6b2a8a398cb65615355720901002024-06-02T17:34:14.000Z0x7dd6ee81ab4139fa76f5a778ea25c3107576c27a14fd075409f05d4bbcd99ec3
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