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
1000x1f98431c8ad98523631ae4a59f267346ea31f9840x50e4c3e8d6389edacc626d7e7ab5fc3c33572adefalse0x0d500b1d8e8ef31e21c99d1db9a6444d3adf12700x6db5f930d032bd8593e1913ef17d11b7ecbb75a32814444965712023-06-28T19:51:03.000Z0x2acd06315b53bfc1dbac9e0c32736ddd1c489f1b2e6e79aa868759213d50a30f
1000x1f98431c8ad98523631ae4a59f267346ea31f9840x81151abfb631647f99382393c01dbe515b6744a7false0x940f054be20acff9cc096d5487a2dac2572492840xd5b74c0ffb1a7e92041d1d3f3cb70d4dac15761a2684444905612023-06-28T19:28:38.000Z0xe82ccba06e4a5fdde4b699018419f10ed21329ba088d4e6f7ddec45cba058ffb
5000x1f98431c8ad98523631ae4a59f267346ea31f9840xb38d0d2cb0a26942c0e29bc5c8896157c639e5f4false0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd60x236aa50979d5f3de3bd1eeb40e81137f22ab794b19044433542102023-06-28T10:05:50.000Z0x3999a2bfdb987a5fa2c6d7ddfcd1acd086fa142030b9a3569f8c8e45e35bc90f
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_polygon.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
0x0260c206d80381445b38321361fe9ca0cf13190ffalse0xc36442b4a4522e871399cd717abdd847ab11fe88548990880645443740299019999999999999999939477437240080002023-02-19T17:06:44.000Z0x83e763e8a4fca04fb8947aa225bcb372bca476ee6b690527114efc4de4eeb451
0x0260c206d80381445b38321361fe9ca0cf13190ffalse0xc36442b4a4522e871399cd717abdd847ab11fe88022500394875006600102002023-02-19T23:09:26.000Z0xf2dcb6b712d88d69848e8ed8d7ca6891171e6d095e8cbbb4be83310622080ad9
0x0312692e9cadd3ddaace2e112a4e36397bd2f18afalse0xc36442b4a4522e871399cd717abdd847ab11fe8810309569733394937617467540164757220266515766839451594-72060-709202023-02-19T01:38:57.000Z0x0453e6fdc0e141ec4e468de053b9431167b15cb0d59cc2eb1dac0220283cad9a
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_polygon.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
0xb6e57ed85c4c9dbfef2a68711e9d6f36c56e0fcbfalse0xc36442b4a4522e871399cd717abdd847ab11fe889763416958973265919967231603671773326080x0000000002f4dd78ba85fe4b662983816c9ae95f-292490-2904802025-10-06T13:51:29.000Z0x3d161793f0ec900b42a8c6d2081231d0cc46c8959eb0f3cd3d0333aae9b1aafd
0x781067ef296e5c4a4203f81c593274824b7c185dfalse0xc36442b4a4522e871399cd717abdd847ab11fe8856849833043678115353514440301930773330600x0000000002f4dd78ba85fe4b662983816c9ae95f-291420-2902802025-10-06T14:07:29.000Z0x8fa08a0649081c8f7043f349803fba4aa290cf7b73aa192d059e039944df5ecf
0xb6e57ed85c4c9dbfef2a68711e9d6f36c56e0fcbfalse0xc36442b4a4522e871399cd717abdd847ab11fe885656811446459878593832534583773331820x0000000002f4dd78ba85fe4b662983816c9ae95f-291250-2902502025-10-06T14:11:47.000Z0x8684ba635551b322f210479cc654437e2d84dcf609fa20afea647ab553aa4d7f
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_polygon.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_polygon.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
0xdac8a8e6dbf8c690ec6815e0ff03491b2770255dfalse29900xd396e3b790f0fa79c80c69bd48127db988a56beb13029899460587564640x27bb3fdfac9109d0b541a401717bf45ed6f56de82024-06-29T17:10:47.000Z0xcefc9c445d42fb816eb63e9488fa0251c54dff6b82617a96ebdf851fc2e2246f
0xdac8a8e6dbf8c690ec6815e0ff03491b2770255dfalse35900xd396e3b790f0fa79c80c69bd48127db988a56beb34935885170587407100x12a2abcfcadc04681929f0c199bdf812967207e42024-06-29T07:38:49.000Z0x8ff24cbcbf9df4140d9f16b1669453cf7c1a6e6ddf75522adad772306635def2
0xdac8a8e6dbf8c690ec6815e0ff03491b2770255dfalse8000xd396e3b790f0fa79c80c69bd48127db988a56beb2237975870587341500xd59898d9c951e36f7ee8782f137db919a80434292024-06-29T03:45:14.000Z0x458339b2f16572c6e70a5a37d028658d3c0c54d206412857c2fd56bd7bf57b79
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_polygon.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
0xa4d8c89f0c20efbe54cba9e7e7a7e509056228d9false0x03a8e72f5ee2cf92ca3fc6edf77ad65aea5cc9ef34862623826784630x03a8e72f5ee2cf92ca3fc6edf77ad65aea5cc9ef49105795027550851214997733792341962901980302025-06-29T20:41:01.000Z0x147b8e38e4db4147a229170807591e678067d163ded2632b6ca7fc9a0cb46942
0xa4d8c89f0c20efbe54cba9e7e7a7e509056228d9false0x03a8e72f5ee2cf92ca3fc6edf77ad65aea5cc9ef19533052315187210x03a8e72f5ee2cf92ca3fc6edf77ad65aea5cc9ef48967325004863859264974103725473733792341962901997902025-06-29T20:41:01.000Z0x147b8e38e4db4147a229170807591e678067d163ded2632b6ca7fc9a0cb46942
0x781067ef296e5c4a4203f81c593274824b7c185dfalse0x044e0a4842c47ce125fd3b16e3fcbbcd3f667b172641164641754577430x044e0a4842c47ce125fd3b16e3fcbbcd3f667b1754307972173304093007795878437973373372683-293760-2935202025-06-29T16:48:56.000Z0x2cbb1d3bf11a6ac8f9f39ce50cf82198e722ec59ce7d5d41d6ce6295f8170547
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_polygon.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_polygon.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
0x389080bde84049eafc7e8e3bb670d4aa6dca90bd374462false0x00000000000ba9cd9f5175108141a82b6c24d7279171784-31082522664519150973306592438310308922748347980500x00000000000ba9cd9f5175108141a82b6c24d7272024-12-25T22:35:32.000Z107108545498213510524703674467491209290xbd365f92502d07e91696a8201477d2dd8c72114f20d762b0626c885abb247df2
0x549bb7e94da23bc31e5fc4685548587f4f7c9b16-338493false0x00000000000ba9cd9f5175108141a82b6c24d7271113392086519182657303214-675087265926255148066774553034453490x00000000000ba9cd9f5175108141a82b6c24d7272024-12-25T23:46:32.000Z35397802077707698625670xf65fb12fe343215d9a96d28f3bf9f3532d481185fe1b1ad6b5f0a7064753ab7f
0xead1cd21ddf8793debc9484a0b8d286230c9b5a391713false0x00000000000ba9cd9f5175108141a82b6c24d7271069904253979096981-66546453520564226409765924385260601285204761815731970x00000000000ba9cd9f5175108141a82b6c24d7272024-12-25T22:35:38.000Z77681230175208050622940513584170xd4aa58d78b3583a1a17d2d12fe3027af9267882b6e5c1119828ae98d54092463
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_polygon.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100