Skip to main content

Tables

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.
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
30000x8fda5a7a8dca67bbcdd10f02fa0649a9372154220xeecb86c38c4667b46487255f41c6904df3d76f8ffalse0x1d17cbcf0d6d143135ae902365d2e5e2a16538d40x5aea5775959fbc2557cc8789bc1bf90a239d9a9135036489918602024-06-13T16:41:29.000Z0x1d4dae7bca8e67890d7e19d9ef7ded728a4edc7d15e4764d3ed9d6d305e30abd
1000x8fda5a7a8dca67bbcdd10f02fa0649a9372154220x2dee3855d991a07ad3ed1fe3b26343320a122963false0x1d17cbcf0d6d143135ae902365d2e5e2a16538d40x493257fd37edb34451f62edf8d2a0c418852ba4c303484954412024-05-25T02:15:10.000Z0xe6a9c62970b83a09887cedddc72bb03f1abaf08972ee2a236d926550fb1f06a8
1000x8fda5a7a8dca67bbcdd10f02fa0649a9372154220x66e83d7110a8715266f067fe35875f968732e58afalse0x144b83555d8a3119b0a69a7bc2f0a0388308fee30xa995ad25ce5eb76972ab356168f5e1d9257e4d05463656953712024-06-14T15:37:07.000Z0x1ea8e7d65d8b2374279eb2997636b8cc3c7ee6a6e39aa7ca89eef1ccbc77a569
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_zksyncera.Factory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Burn_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL changes.
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_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_tickUpperINT64Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountlog_indexin_amount0in_amount1block_numberin_tickLowerin_tickUpperblock_timestamptransaction_hash
0xff577f0e828a878743ecc5e2632cbf65cecf17cffalse0x0616e5762c1e7dc3723c50663df10a162d690a86123208726311944199240400280287138901958401987202024-03-11T18:55:17.000Z0x75f354d70e56f5ce96650e6bb13719b0aa4786477f41bb874fc947cb7c6b2ea2
0xff577f0e828a878743ecc5e2632cbf65cecf17cffalse0x0616e5762c1e7dc3723c50663df10a162d690a86118614135713056303746064730287052241974001986602024-03-11T16:27:43.000Z0x525e7075aefc5bb2ed24d411b76f9e04b2ed899792e484f191f56952c5687920
0xff577f0e828a878743ecc5e2632cbf65cecf17cffalse0x0616e5762c1e7dc3723c50663df10a162d690a8613120175968644121557558570287122261935601977602024-03-11T18:26:58.000Z0xefdd5c0071439e7c3d6fa32ee89ab3ef45eb50b62cf75420c0969b54c228f655
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_zksyncera.Pool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management activity.
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_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_tickUpperINT64Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerlog_indexin_amount0in_amount1block_numberin_recipientin_tickLowerin_tickUpperblock_timestamptransaction_hash
0xff577f0e828a878743ecc5e2632cbf65cecf17cffalse0x0616e5762c1e7dc3723c50663df10a162d690a8624177226270443426673560311181943160x30aec46ea55f68e60eba5f96b22a375bfe0c68152014802040002023-11-05T10:36:43.000Z0xad69227dc7d15c476016f0169a248ab62b92d4d6e510334ce7e673c88fe1eb14
0xff577f0e828a878743ecc5e2632cbf65cecf17cffalse0x0616e5762c1e7dc3723c50663df10a162d690a8641945231590181721660x19d9c35934e600559a176ba91afaf3ca9177f4662012402037602023-11-05T04:18:33.000Z0xcc0fd514745a3106edf340876d1a253f6cef8c7a194929b989a2a774a3a60f62
0xff577f0e828a878743ecc5e2632cbf65cecf17cffalse0x0616e5762c1e7dc3723c50663df10a162d690a864040566822273688886331977181720810x19d9c35934e600559a176ba91afaf3ca9177f4662012402037602023-11-05T04:17:06.000Z0xd59fc256f1c6ca84c502b24dd6ef08e276db53c73cdfba6397cd2381568fe4ac
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_zksyncera.Pool_Collect_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_CollectProtocol_event

Protocol fee collection events from concentrated liquidity pools, recording fees withdrawn by the protocol from trading activity. Contains token amounts collected (amount0, amount1), sender address initiating the collection, and recipient address receiving the fees.
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_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_zksyncera.Pool_CollectProtocol_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation analysis.
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_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_paid0STRINGAmount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
in_paid1STRINGAmount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
addressremovedin_paid0in_paid1in_senderlog_indexin_amount0in_amount1block_numberin_recipientblock_timestamptransaction_hash
0x1fa900dbb20ed45d18883849c00632bca16f6610false043502072666531270x9667eadb9e22b2ded42ae481099dfedc4144659b91043502072666531266560362752020x9667eadb9e22b2ded42ae481099dfedc4144659b2024-06-11T02:16:08.000Z0xb65686fc2d20d216d5947c6d609c8a0eb6f9c27e438cc38e010858ac74d536a4
0x1fa900dbb20ed45d18883849c00632bca16f6610false010262932083147690x9667eadb9e22b2ded42ae481099dfedc4144659b17010262932083147687936362755830x9667eadb9e22b2ded42ae481099dfedc4144659b2024-06-11T02:22:48.000Z0xbd9948a45f904eec3bd0fd278ff638ec0abb74c43e2ddde7131e08d5bb1b1fe5
0x1fa900dbb20ed45d18883849c00632bca16f6610false011128560696485750x9667eadb9e22b2ded42ae481099dfedc4144659b17011128560696485740544363203180x9667eadb9e22b2ded42ae481099dfedc4144659b2024-06-11T15:47:32.000Z0xdd27d3a8fb8d84401cb5e0ae06a12aa883a2b084394d2ccd90f577f906b3e6f3
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_zksyncera.Pool_Flash_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.
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_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_tickUpperINT64Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountin_senderlog_indexin_amount0in_amount1block_numberin_tickLowerin_tickUpperblock_timestamptransaction_hash
0xff577f0e828a878743ecc5e2632cbf65cecf17cffalse0x0616e5762c1e7dc3723c50663df10a162d690a8613046141273749880x0616e5762c1e7dc3723c50663df10a162d690a86240801642999999999800254108251963201969802024-01-31T07:26:37.000Z0x78cc35b914b3dc359afa81b6faff51dfc7ba075072685f2784fd4791d7153fe1
0xff577f0e828a878743ecc5e2632cbf65cecf17cffalse0x0616e5762c1e7dc3723c50663df10a162d690a861617279356085460x0616e5762c1e7dc3723c50663df10a162d690a86470599899999999998260253881161947601987202024-01-31T00:34:18.000Z0x39366bf980fad87bf34710fe2c288e75402fce5c929082ca3849da5d60877e9f
0xff577f0e828a878743ecc5e2632cbf65cecf17cffalse0x0616e5762c1e7dc3723c50663df10a162d690a86586564040x0616e5762c1e7dc3723c50663df10a162d690a8696103118499752254233731989001990202024-01-31T11:14:15.000Z0x77e446096a2900aeca48176391e1c8ff5c0e65a9d9417c0e692143f86546119b
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_zksyncera.Pool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_SetFeeProtocol_event

Protocol fee configuration change events emitted when liquidity pool fee parameters are updated. Records old and new fee protocol values for both tokens in the pool, tracking governance-initiated fee structure modifications.
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_feeProtocol0OldINT64Previous protocol fee for token0. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
in_feeProtocol1OldINT64Previous protocol fee for token1. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
in_feeProtocol0NewINT64New protocol fee for token0. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.
in_feeProtocol1NewINT64New protocol fee for token1. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_zksyncera.Pool_SetFeeProtocol_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.
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_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_sqrtPriceX96STRINGSquare root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
in_liquiditySTRINGTotal liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
in_tickINT64Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.
addressin_tickremovedin_senderlog_indexin_amount0in_amount1block_numberin_liquidityin_recipientblock_timestampin_sqrtPriceX96transaction_hash
0xff577f0e828a878743ecc5e2632cbf65cecf17cf200216false0x28731bcc616b5f51dd52cf2e4df0e78dd1136c0628-8051698400000000000000019524531372835375467814980x4f583cf8ab2cdc8565e8669e84f6bbcf081bdc7b2023-11-21T05:39:03.000Z17632522222249340738593336182662170x04e390bfe020978f60b2d29b113f12c90de90400339dc2c8fb9905cf0e5b3b33
0xff577f0e828a878743ecc5e2632cbf65cecf17cf200217false0x28731bcc616b5f51dd52cf2e4df0e78dd1136c0656-201281591000000000000000019516533371734553187258980x6c61dbcdb20ecfde781f89eb6def3b5ac01364582023-11-21T03:24:13.000Z17633062704748506675753809497059140x6b18cd49dd1a2d9b58b0efc25022e5469c8aefd275502d0ec1d434868bec5b64
0xff577f0e828a878743ecc5e2632cbf65cecf17cf200217false0x28731bcc616b5f51dd52cf2e4df0e78dd1136c0638-8051035400000000000000019516963371734553187258980x1af6754863d3b8c6362cda3efbbae36f3bff825e2023-11-21T03:31:27.000Z17633248713410606736035998679515230x2f1d92cf0879e2266da89e4acb1d8a2b3ec131457d5c88f9e41144822fefbbab
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_zksyncera.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100