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
30000xcb2436774c3e191c85056d248ef4260ce5f27a9d0x21d5a075073e631a85ab9c02e4b703460c572b4bfalse0x1b64b9025eebb9a6239575df9ea4b9ac46d4d1930xb8ce59fc3717ada4c02eadf9682a9e934f625ebb01353096602025-09-19T11:39:16.000Z0xaf995146c5a791daa4934f8c397103e147eba26ef6b25cd8a67dfcecac21de23
30000xcb2436774c3e191c85056d248ef4260ce5f27a9d0x2eabb32f34b7a25c34bc9cea142ce0e060ee0682false0xa3d68b74bf0528fdd07263c60d6488749044914b0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb01352783602025-09-19T11:34:03.000Z0xcc94a51d2a38221d1cec6718a9d4976ad016144a3617db8d2741c4f19636fd88
30000xcb2436774c3e191c85056d248ef4260ce5f27a9d0xce4ac514ca6a9db357cccc105b7848d7fd37445dfalse0x9895d81bb462a195b4922ed7de0e3acd007c32cb0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb01352291602025-09-19T11:25:51.000Z0x3a4d576a35041bfb458486f2f79b82d4910a161ecfcabf36d1767964a3a0aa75
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_plasma.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
0x8603c67b7cc056ef6981a9c709854c53b699fa66false0x743e03cceb4af2efa3cc76838f6e8b50b63f184c463837573446079226941250016289026180440348772258254-274800-2747402025-09-29T23:10:36.000Z0x69cdd4e57c0d00972f52de3c02ee81254fd7d19aa2d69eb3d47ed36e753c539c
0x8603c67b7cc056ef6981a9c709854c53b699fa66false0x743e03cceb4af2efa3cc76838f6e8b50b63f184c048002259160-275040-2745602025-09-29T23:25:42.000Z0x297c875ccadec7ffd1f4ae14be900e5ca034e6bcade8fe455788ec4fb3db91c9
0x8603c67b7cc056ef6981a9c709854c53b699fa66false0x743e03cceb4af2efa3cc76838f6e8b50b63f184c24079665963367782936572264728024789374836892254822-274500-2744402025-09-29T22:13:24.000Z0x3699e7c2bd98a6594983f1e1b63dc2088bd8e28355bd84f0d1347ac234167da3
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_plasma.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
0x5526b8baabb4f47d4e7ed738bb8f9989eeb11afefalse0x743e03cceb4af2efa3cc76838f6e8b50b63f184c327867531658375353003421786678327165520x02adc450569ba14b4478774d544c1b904782f871-278200-2746002025-10-05T06:28:54.000Z0x09963d311146264ff679a740f29e011786f92c4044b21806f02b0c88097f119e
0x5526b8baabb4f47d4e7ed738bb8f9989eeb11afefalse0x743e03cceb4af2efa3cc76838f6e8b50b63f184c1712220367022428470120388258314481827165520x02adc450569ba14b4478774d544c1b904782f871-278200-2746002025-10-05T06:28:54.000Z0x09963d311146264ff679a740f29e011786f92c4044b21806f02b0c88097f119e
0x8603c67b7cc056ef6981a9c709854c53b699fa66false0x743e03cceb4af2efa3cc76838f6e8b50b63f184c37667729676513937734859027700810x02cfdac6e736c7adf63196230c1ecce04f2e5acc-275640-2731202025-10-05T21:21:03.000Z0xefdffe3c884893c242d84ea00adf8cb62625bfeea29724c9ee49a81475e90c70
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_plasma.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_plasma.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
0x8603c67b7cc056ef6981a9c709854c53b699fa66false32486911891200x3c699b2e1ee8c12275c17b301ac3c8781510900031108289706303733033031420x3c699b2e1ee8c12275c17b301ac3c878151090002025-10-12T01:29:08.000Z0xe2c4e1e86aec4becd01863a533892eb92df51e3549c4bc859bac421cb4900f62
0x8603c67b7cc056ef6981a9c709854c53b699fa66false96186122635700x3c699b2e1ee8c12275c17b301ac3c8781510900047320620408785609033031420x3c699b2e1ee8c12275c17b301ac3c878151090002025-10-12T01:29:08.000Z0xf10892d968de827291cb781ffdb3e793474f9f9a62fe02770bec706d61660de9
0x8603c67b7cc056ef6981a9c709854c53b699fa66false27839323981000x3c699b2e1ee8c12275c17b301ac3c878151090002092797746603117033031430x3c699b2e1ee8c12275c17b301ac3c878151090002025-10-12T01:29:09.000Z0x771dc12eea9b7943d90529cd411beca8e23faf994686cf88c1871be088c7d2c3
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_plasma.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
0x8603c67b7cc056ef6981a9c709854c53b699fa66false0x743e03cceb4af2efa3cc76838f6e8b50b63f184c249778028208997830x743e03cceb4af2efa3cc76838f6e8b50b63f184c412392539429793892387579241000000002521885-887220-2751002025-10-03T00:24:27.000Z0x9fd6a6280105187bdaddb2210268eede31d6e336c6de6b00857599e41739cf10
0x345187069f97ba23ae6c402d3aacd67b4b4df555false0x743e03cceb4af2efa3cc76838f6e8b50b63f184c22435518528567702661822340x743e03cceb4af2efa3cc76838f6e8b50b63f184c909999999999999999999999997172579130-8872001220002025-10-03T16:18:32.000Z0xb6992f43b1d9e7f7c884b047822a5f4ebc3b61f36f6d5f3e865dbe6225eb66bf
0x38984a03d6e559b62632094cc526feeb5d29e8dbfalse0x743e03cceb4af2efa3cc76838f6e8b50b63f184c20098613875672112425318610x743e03cceb4af2efa3cc76838f6e8b50b63f184c809999999999999999999999997582569137-8872001242002025-10-03T13:31:59.000Z0xe106cf193049e49f2366fbaf743e7d1c4dcf49759f81b212c9c9c87898e5ed79
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_plasma.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_plasma.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
0x8603c67b7cc056ef6981a9c709854c53b699fa66-281497false0x1b35fba9357fd9bda7ed0429c8bbabe1e8cc88fc4-167246224103603951000012192591090868390201320xe4306ad21a29f9edcfa9fa584e379a8d0d1463bb2025-09-17T22:18:51.000Z611751026195383833340450x24fac8943d94d0c04a402067d9c298b4f472bbb7f4621fda2f15e6ad3dc28e2e
0x8603c67b7cc056ef6981a9c709854c53b699fa66-281499false0x807f4e281b7a3b324825c64ca53c69f0b418de404400000000000000000-23838011732691090868390201320x2102ab11a3c74b1d543891020969dc3d46c132ab2025-09-17T09:32:21.000Z611678615555625407638350xc07e55e5bdb64ecc1c1601db830ada9bba729e4a7e39fa5495d1aead7b7fc7a6
0x8603c67b7cc056ef6981a9c709854c53b699fa66-281499false0x807f4e281b7a3b324825c64ca53c69f0b418de404400000000000000000-23838411728141090868390201320x2102ab11a3c74b1d543891020969dc3d46c132ab2025-09-17T09:24:46.000Z611684644801244090133970x9e75f5222a42df7c3b2aeca2b0efcb43a4a12a64083650c91ce72ddf2fed88bd
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_plasma.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100