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
100000x7a5028bda40e7b173c278c5342087826455ea25a0xbc2f704b2d11c64a3ce8b3d950c4f4c4a9bcaa1efalse0x1449f562fd186fc2ea1014055ebc1f17da22a1980x2cfc85d8e48f8eab294be644d9e25c30308630030114170742002025-03-17T00:03:07.000Z0xf175e234176a3ebc373d3833f76e9e768146a808d7e971845c139e15c6b1f509
100000x7a5028bda40e7b173c278c5342087826455ea25a0x36a7e58a475ea10921c71a89e360f746f7e27b36false0x2cfc85d8e48f8eab294be644d9e25c30308630030x859dbe24b90c9f2f7742083d3cf59ca41f55be5d0114564202002025-03-17T21:54:39.000Z0x47118fe3fec2570f1460c9b7de89eb82c43a792e246170e64603eba165afdc19
100000x7a5028bda40e7b173c278c5342087826455ea25a0xf13aa25554ce5ae3a817bdac7db6654d5d31160cfalse0x79a02482a880bce3f13e09da970dc34db4cd24d10xe894775a317e231cd4e52df54a7d190f06b11f6c0114428002002025-03-17T14:20:39.000Z0x85d93e6c22005207d6e2e609be2aca988c901c28af5b475bb25a60d19b5505a4
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_worldchain.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
0x610e319b3a3ab56a0ed5562927d37c233774ba39false0xe330cc9e896cc7e21facb49e6de89cd327076fbb2983789273977214578522907946220498224032622444380404412011645-279000-2788002025-03-30T18:22:09.000Z0x89272c1c9050dfcaa185ae92e6286a07b0c219cd478a6b8080a98f8b83127412
0x610e319b3a3ab56a0ed5562927d37c233774ba39false0x93a37d4970ab29dca5766734b3886a0a96e2d3f460341331668006410001300279509722768403305429152668612018814-279000-2788002025-03-30T22:21:07.000Z0xb27c1c6d6abc98c0f53844e0415a4499c3bd1befd8e76b8161cfa1c00770f495
0x610e319b3a3ab56a0ed5562927d37c233774ba39false0xe330cc9e896cc7e21facb49e6de89cd327076fbb2864977655581221376416275030750107378483362391655781912010545-279000-2788002025-03-30T17:45:29.000Z0x5a5578ed3878c5886bfe107142e71916a931512320cd9bc1f5c36ef59bcef9f9
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_worldchain.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
0x610e319b3a3ab56a0ed5562927d37c233774ba39false0xec12a9f9a09f50550686363766cc153d03c27b5e757329787312802038345976890147653220x00000a96386d6ddea78a246abd914e59386aa688-275600-2734002025-06-02T12:11:23.000Z0xa07afef6b0d5d12095a89d0a0fba64dde0ef25313d154367e44138f596217a7d
0x5f835420502a7702de50cd0e78d8aa3608b2137efalse0xec12a9f9a09f50550686363766cc153d03c27b5e42529162150137461343422762147767570x00000a96386d6ddea78a246abd914e59386aa688-198170-1979102025-06-02T18:32:33.000Z0xbbb23d151d8a44578ddc754bb994775252c6d376dc26b4580124721469814a53
0x5f835420502a7702de50cd0e78d8aa3608b2137efalse0xec12a9f9a09f50550686363766cc153d03c27b5e758487712087653555912721147647370x00000a96386d6ddea78a246abd914e59386aa688-198140-1979002025-06-02T11:51:53.000Z0x69f824de6eb4ab0cecba7b5ac7a8ef80a0b00d2ec8f484a4ff68b9e51f62fe1d
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_worldchain.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_worldchain.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
0x43a1ba7cf7692c0509c8489351ebfb4123e726bbfalse598000x2b6621224d0b1adab00e1bc4f38787706435041b1219931320116566540x36e14f4b395c76fd72a86513fd7aa620c9d8123a2025-03-22T13:09:07.000Z0xea14e038fa58a371599e2221171e82d34f0b8fab3867ae81090754c882ec108b
0x5f835420502a7702de50cd0e78d8aa3608b2137efalse32000000000000x0921e8c348b912ca3fdf9dcbb600996e7b26f966476400000000000000111552520x0921e8c348b912ca3fdf9dcbb600996e7b26f9662025-03-10T22:35:43.000Z0x68dbe7718f5df1606980e19942ad7eb017c4b04274d16b92cdd3181907efff7b
0x5f835420502a7702de50cd0e78d8aa3608b2137efalse8000000000000x0921e8c348b912ca3fdf9dcbb600996e7b26f966631600000000000000111299330x0921e8c348b912ca3fdf9dcbb600996e7b26f9662025-03-10T08:31:45.000Z0x9e86d7878449cb6909d10142acaa423e0a1f95acad8c3eba84cb8e492d6ebe9a
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_worldchain.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
0x610e319b3a3ab56a0ed5562927d37c233774ba39false0xe330cc9e896cc7e21facb49e6de89cd327076fbb8898535471056590580xe330cc9e896cc7e21facb49e6de89cd327076fbb2433873274252311148482325610892586787111-265800-2656002024-11-29T19:51:01.000Z0x26253debbc37bc3ad9c5d224427789d1b98c5a37135a421d21f6ac2f91f43066
0x610e319b3a3ab56a0ed5562927d37c233774ba39false0xe330cc9e896cc7e21facb49e6de89cd327076fbb8471929626668801920xe330cc9e896cc7e21facb49e6de89cd327076fbb8247032915813303917088572264134396781945-265800-2656002024-11-29T16:58:49.000Z0x31521948277592262bb0798f81e3493ca501fe409affe6addc0fb2f6d5cad4ad
0x610e319b3a3ab56a0ed5562927d37c233774ba39false0xe330cc9e896cc7e21facb49e6de89cd327076fbb8913226895622797300xe330cc9e896cc7e21facb49e6de89cd327076fbb5418985333608934976108130139367506786267-265800-2656002024-11-29T19:22:53.000Z0xc849ac82197890328bed0a66194682c95a11f9e885634c0e7f6539dcb83ee82f
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_worldchain.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_worldchain.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
0x610e319b3a3ab56a0ed5562927d37c233774ba39-271876false0x091ad9e2e6e5ed44c1c66db50e49a601f9f36cf62647007629853125037-1000000284630612780563367864480xce8af9c5ba88baae79a7c32e594fc7b002b916bf2024-08-30T14:30:51.000Z989626474180261887522550x05e13ed9a7c47313750966c799bb9784e4fec83a8066285566881ed71bbf9f8d
0x610e319b3a3ab56a0ed5562927d37c233774ba39-271901false0x091ad9e2e6e5ed44c1c66db50e49a601f9f36cf62648631338841357392-1000000284655312780563367864480xce8af9c5ba88baae79a7c32e594fc7b002b916bf2024-08-30T14:39:05.000Z988386651486475538910450x1704628415693b0c0f36bba399f4efaebb75ff00f9e5af4395370b9640f0dcf4
0x610e319b3a3ab56a0ed5562927d37c233774ba39-271839false0x091ad9e2e6e5ed44c1c66db50e49a601f9f36cf62644583474273075671-1000000284627312780563367864480xce8af9c5ba88baae79a7c32e594fc7b002b916bf2024-08-30T14:29:45.000Z991486208220941410440700x5d394f8928dddfee5abf0fcab88a6524cc75dfecfb52cbe3ef6bae945e1e6a79
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_worldchain.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100