kyber_v3_polygon

Tables

ElasticFactory_PoolCreated_event

Pool creation events emitted by KyberSwap Elastic (concentrated liquidity) factory contracts. Records new liquidity pool deployments with token pair addresses, fee tier configuration in basis points, and tick spacing parameters that define price granularity for liquidity positions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_swapFeeUnits`	`STRING`	Swap fee for the pool expressed in basis points. Numeric string value where 100 represents 0.01% and 10000 represents 1%.
`in_tickDistance`	`INT64`	Minimum spacing between initialized price ticks in the liquidity pool. Integer value determining the granularity of price points where liquidity can be added.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_token0	in_token1	log_index	block_number	block_timestamp	in_swapFeeUnits	in_tickDistance	transaction_hash
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0xee25a1c02c679f2d96b79a0c7e713f27dbfb0abe	false	0x0be71955731d1b2ae7b7ed1f83b02fbc3a0f0587	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	377	47103795	2023-09-03T18:04:00.000Z	5000	100	0x7fa8ec0fff3c4e7064499ed7d2db385510ccb66e21bacfd4f0ca47558143849e
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0xba59e9089ddd51e6050261e815c5347f46d4c605	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x6442e09576c87ac68e249a0c56f718088a0e7d2d	139	48844027	2023-10-18T00:06:36.000Z	100	10	0x8856668e8efa561580e9dcd3a237f7a178fe58ed1a678b4b3a2a8c326eacca50
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0x105a3761f4f8061b76138623c32e1dad109a9f71	false	0x5202cfd2ec670e5e133cd272011f1e0e6fa8a459	0x7bfce73b37ea2151843be4bdf72f37e094a4676c	868	48850528	2023-10-18T04:13:20.000Z	5000	100	0x586eefd9c2ba93464c449aba3252bf2cbc114f029bb84a783364e53b03d31693

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_polygon.ElasticFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ElasticPool_Burn_event

Liquidity removal events from KyberSwap Elastic concentrated liquidity pools. Records position burns with owner address, liquidity quantity, token amounts withdrawn, and tick range boundaries for tracking DEX liquidity changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower 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_tickUpper`	`INT64`	Upper 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_qty`	`STRING`	Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.
`in_qty0`	`STRING`	Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.
`in_qty1`	`STRING`	Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.

Sample Data

in_qty	address	in_qty0	in_qty1	removed	in_owner	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
57813578506134221404	0x02a3e4184b145ee64a6df3c561a3c0c6e2f23dfa	14055608674	14846045138397394587771	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	365	47086103	276317	276327	2023-09-03T07:13:27.000Z	0x2ad866f20a746041dd9a74794d0eabf1b77e6f78a672b059406bbf43b8dfb203
108116500349309457866	0x02a3e4184b145ee64a6df3c561a3c0c6e2f23dfa	31689846254	22359625070620148568199	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	628	47086096	276318	276328	2023-09-03T07:13:13.000Z	0x6af19903c3764fe4c16085801dfe1d7be82f91e0b9072ab45576544c88c88674
381336860708153029	0x02a3e4184b145ee64a6df3c561a3c0c6e2f23dfa	77080229	75431805561159252973	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	1157	47111156	276318	276326	2023-09-03T22:25:51.000Z	0x3c5d6deab0660828e7737fda45a9d16a193e8625f138e05c0416e9cb841ffafb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_polygon.ElasticPool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ElasticPool_BurnRTokens_event

KyberSwap Elastic liquidity removal events emitted when reinvestment tokens (rTokens) are burned and underlying token pairs are withdrawn from the pool. Records position owner, liquidity quantity burned, and token0/token1 amounts returned.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_qty`	`STRING`	Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.
`in_qty0`	`STRING`	Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.
`in_qty1`	`STRING`	Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.

Sample Data

in_qty	address	in_qty0	in_qty1	removed	in_owner	log_index	block_number	block_timestamp	transaction_hash
4205378978242	0x02a3e4184b145ee64a6df3c561a3c0c6e2f23dfa	4221097	4221288225163600924	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	241	47779649	2023-09-20T18:22:43.000Z	0xbf968df4c1314c6978c789b0743dc9c8831c2f78da10eb47e47701dc88c59c99
957907024229	0x02a3e4184b145ee64a6df3c561a3c0c6e2f23dfa	961487	961530854435985151	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	105	47779643	2023-09-20T18:22:29.000Z	0x74dc3f6331a97f613e7cabf1509c4ed0eae81c0fd382ee685f690f01a6d5c3c7
100880471279	0x02a3e4184b145ee64a6df3c561a3c0c6e2f23dfa	101256	101263085601387127	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	117	47786253	2023-09-20T22:22:26.000Z	0xbab83c9ef63241d2d44f5e0207ebbae06130d6c4aae8f1c70fa00156eb008110

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_polygon.ElasticPool_BurnRTokens_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ElasticPool_Flash_event

Flash loan events from KyberSwap Elastic liquidity pools recording borrowed amounts, repayment fees, and transaction participants. Used for tracking flash loan arbitrage activity and protocol fee generation.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_qty0`	`STRING`	Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.
`in_qty1`	`STRING`	Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.
`in_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_qty0	removed	in_paid0	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x0cfb295296c7869e5df0e8a4187b554167287cc2	42532123093239800000	false	3402569847459184	0xf96c4d04400e1a9c7fdc9f3ab60d7b24f64787e8	85	48399066	0xf96c4d04400e1a9c7fdc9f3ab60d7b24f64787e8	2023-10-06T14:36:44.000Z	0x6103d976a90ec9566c86641e6d359649bf2e527b18bbe79dd6994801d270b176
0xe7129c006353ceda8f229240282c48a54402af45	1023555861	false	81884	0x067436222b183d27acd05c08e51d77c2fb312e64	85	48409249	0x067436222b183d27acd05c08e51d77c2fb312e64	2023-10-06T20:49:44.000Z	0x25cd3c9d89ea5e00b1db6b1efc6ad2aeb537a9f74492cd63f8e01eee04613c13
0x4ebc4d2763e951197f07b6b8b3c2bdfbff7d6b5f	20061385	false	8025	0x067436222b183d27acd05c08e51d77c2fb312e64	86	48396403	0x067436222b183d27acd05c08e51d77c2fb312e64	2023-10-06T12:59:19.000Z	0xf1e5396e7d17dfa9ddee5963bbc1697353907f6cae2ff719c01961f0ffcb7f3f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_polygon.ElasticPool_Flash_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ElasticPool_Mint_event

Liquidity provision events emitted when tokens are deposited into concentrated liquidity positions within KyberSwap Elastic pools. Contains sender, owner, tick boundaries, liquidity quantity minted, and token amounts for tracking position creation and modification across DEX (Decentralized Exchange) pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower 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_tickUpper`	`INT64`	Upper 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_qty`	`STRING`	Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.
`in_qty0`	`STRING`	Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.
`in_qty1`	`STRING`	Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.

Sample Data

in_qty	address	in_qty0	in_qty1	removed	in_owner	in_sender	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
819274646401767	0x4b440a7de0ab7041934d0c171849a76cc33234fa	0	200000000	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	168	45518580	-304400	-290600	2023-07-25T23:32:08.000Z	0x4a5bf806a9df2fb83e851076e366cbb73ce0e5a37bff02431f3960c039fa10d1
66931771576	0x46d90a00dbad3961657c0328a9d1a7850523be7c	19999260691960995	26978	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	85	45498281	-292440	-273720	2023-07-25T10:40:30.000Z	0xc78aa44d21e744ece20710f5a0c936b96cf49ebb57acddf095d599c4942e19e7
2309972284411	0x46d90a00dbad3961657c0328a9d1a7850523be7c	690221352570706009	931074	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	145	45495497	-292440	-273720	2023-07-25T09:00:05.000Z	0x5dc19e45ad618f491652b403f170bf2fb8f304e73f76d1c36281a945e8d78fcb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_polygon.ElasticPool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ElasticPool_Swap_event

Token swap events from KyberSwap Elastic (concentrated liquidity) pools containing sender, recipient, token quantity deltas, and post-swap pool state. Used for tracking DEX trading activity and liquidity pool dynamics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_deltaQty0`	`STRING`	Change in token0 balance resulting from the swap. Numeric string representation in smallest denomination, where positive values indicate token0 added to the pool and negative values indicate token0 removed from the pool.
`in_deltaQty1`	`STRING`	Change in token1 balance resulting from the swap. Numeric string representation in smallest denomination, where positive values indicate token1 added to the pool and negative values indicate token1 removed from the pool.
`in_sqrtP`	`STRING`	Square root of the current price ratio between token0 and token1 in the liquidity pool after the swap execution. Numeric string representation using Q64.96 fixed-point encoding.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_currentTick`	`INT64`	Current tick index of the liquidity pool after the swap execution. Signed integer representing the price tick position in the concentrated liquidity model.

Sample Data

address	removed	in_sqrtP	in_sender	log_index	block_number	in_deltaQty0	in_deltaQty1	in_recipient	in_currentTick	block_timestamp	transaction_hash
0x1317fe389b7992571bc84ff4d9d248225e96d199	false	59212611659678436355854079615	0x1927ad61de34b963d1cef5617467f04d0b42f073	5	69874165	-5081904607118398405	2845180029021461655	0x1927ad61de34b963d1cef5617467f04d0b42f073	-5825	2025-04-04T05:18:55.000Z	0xc0980bb09a7520d840d39e5abf80b742043a8e265c759115c312144cfb217263
0xe88efdf1a6cbd3d6c78a11741a618a116816ba42	false	63892914258950196933670	0x4770663fd162a9ff10219dd9f569b8af5a0e0ae8	351	69865424	37699135031255656	-25249	0xaac941e1f87dc38b8714c6dc2f6c6b271eda3782	-280627	2025-04-04T00:09:15.000Z	0x1baba3f1d8bf92434ed7eaa37ce0af556d8be548312af17a731471416a9683f7
0x61c93621cc0bc8e038d4c8f49e987981cc9ad58d	false	3647440965987542453735457864	0x4770663fd162a9ff10219dd9f569b8af5a0e0ae8	270	69874100	-386416045878907646	827097022779588	0x4770663fd162a9ff10219dd9f569b8af5a0e0ae8	-61570	2025-04-04T05:16:37.000Z	0x81d689e48758e77209ae741dca5045ba1dae3ae743df3d19c6ef52d32f03d30e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_polygon.ElasticPool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_swapFeeUnits`	`STRING`	Swap fee for the pool expressed in basis points. Numeric string value where 100 represents 0.01% and 10000 represents 1%.
`in_tickDistance`	`INT64`	Minimum spacing between initialized price ticks in the liquidity pool. Integer value determining the granularity of price points where liquidity can be added.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_token0	in_token1	log_index	block_number	block_timestamp	in_swapFeeUnits	in_tickDistance	transaction_hash
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x7a8e4b3f66698a4cb9d0d874d0f1ce4e1070421d	false	0x1c954e8fe737f99f68fa1ccda3e51ebdb291948c	0x580a84c73811e1839f75d86d75d88cca0c241ff4	141	33527893	2022-09-25T00:27:00.000Z	1000	200	0x2d6e67c365bdb88c0f187a77fa30965fef198992e629a99d2ee0f1bcfb9e4968
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x2093cdcb5290126700141293a36b03eac69532aa	false	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	0xe0339c80ffde91f3e20494df88d4206d86024cdf	151	33529375	2022-09-25T01:17:58.000Z	1000	200	0x5de5a36bbc9bce308fc008fba9ad976f239741b46c5f4d4d50784e1d8fb08e5a
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x869872c800c5f822a623a45ae1a37b77a472ca6b	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x35ac92580eb672d9c76fee4228165f6ef224c334	146	33528485	2022-09-25T00:47:22.000Z	1000	200	0x77adc727160ab24c0ae6cabf1894178eb0d650e9bbfb11062800be9b6a26920e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower 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_tickUpper`	`INT64`	Upper 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_qty`	`STRING`	Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.
`in_qty0`	`STRING`	Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.
`in_qty1`	`STRING`	Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.

Sample Data

in_qty	address	in_qty0	in_qty1	removed	in_owner	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
1	0x0387dbd5e8504938edf4b38eacbf77a1d0394a1b	0	10596	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	198	39663078	191552	212344	2023-02-24T16:47:04.000Z	0x026d55ce5cdbab6386ea04c839cf2c3937f3d467fe731f2d099e4a2071112962
1764971618118751	0x0387dbd5e8504938edf4b38eacbf77a1d0394a1b	2418297492	1930678712116940432	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	136	39667468	201648	203240	2023-02-24T19:49:27.000Z	0x004d368434ca9899432331052e0ab70454cebb5356bf0f40b5591c597d3f6b24
1	0x0387dbd5e8504938edf4b38eacbf77a1d0394a1b	0	1092	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	199	39667429	201648	203240	2023-02-24T19:48:05.000Z	0xd4044a70f5853cd59823b3a0033110366c091e28a05fe28415926f07f881c8be

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_polygon.Pool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_BurnRTokens_event

Reinvestment token (RToken) burn events from KyberSwap V3 liquidity pools recording position withdrawals. Contains owner address, liquidity quantity burned, and token0/token1 amounts returned to position holders.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_qty`	`STRING`	Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.
`in_qty0`	`STRING`	Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.
`in_qty1`	`STRING`	Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.

Sample Data

in_qty	address	in_qty0	in_qty1	removed	in_owner	log_index	block_number	block_timestamp	transaction_hash
23502649794	0x7b5ed43413f0c47d91ed7824778ff53e9efea6c3	286823142737	2103310983	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	307	50602045	2023-12-01T06:07:24.000Z	0xe19f7b55ca7afea3fbd8b1739fcaa2a949700042034d60b97745b08d1ca6de0a
88686655206370	0x7b5ed43413f0c47d91ed7824778ff53e9efea6c3	1082319882594745	7936790854700	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	179	50602052	2023-12-01T06:07:40.000Z	0xfb206791f41a77d02f1f6112986b413e88e1a818d8d6f8f90ba401ef39f1a9ec
6015683424787	0xfc02d7b9df69e8eb0dc016f24e34038b80f64678	82287	497818643483781637953	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	3163	50607923	2023-12-01T09:37:50.000Z	0xa560eff33b055c42d14e1e438176ac488c481181a6e875361a6f56b1ba0deec3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_polygon.Pool_BurnRTokens_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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_qty0`	`STRING`	Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.
`in_qty1`	`STRING`	Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.
`in_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_qty1	removed	in_paid1	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x5e3e395d9eea311b7039053c2fab47d950429271	3584340000000000000	false	716868000000000	0x067436222b183d27acd05c08e51d77c2fb312e64	29	41391970	0x067436222b183d27acd05c08e51d77c2fb312e64	2023-04-11T03:36:17.000Z	0xc682a6473da5786ec7560b5c6826c030bc860bdec9d01376e1e2c09bbdc74d0e
0x5e3e395d9eea311b7039053c2fab47d950429271	2615926392488748	false	523185278497	0xd8b87923c02ac39abf593258d153fabb80d3b67b	36	41413500	0xd8b87923c02ac39abf593258d153fabb80d3b67b	2023-04-11T17:02:40.000Z	0xaf338397ea3dd99dafcbac804020eaef72f6a5a5afa6a50468fac049e0df6234
0xcacba79427a10008804add4f642275ae76419d6a	1287445358720553800000	false	102995628697644304	0xd8b87923c02ac39abf593258d153fabb80d3b67b	32	40722807	0xd8b87923c02ac39abf593258d153fabb80d3b67b	2023-03-24T18:52:53.000Z	0x1b9e1122bed2325f4df012d12db41ae09d0247ebdcadc449ea0cebab29ffe803

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower 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_tickUpper`	`INT64`	Upper 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_qty`	`STRING`	Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.
`in_qty0`	`STRING`	Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.
`in_qty1`	`STRING`	Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.

Sample Data

in_qty	address	in_qty0	in_qty1	removed	in_owner	in_sender	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
1222133304485	0x0387dbd5e8504938edf4b38eacbf77a1d0394a1b	995344	1099999909958387	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	139	34478492	203656	204776	2022-10-18T01:13:36.000Z	0xfe28c4bc1765a098ff58481014c7fdef36639e19a5b16cd90e1bf703da05e410
248075233613860	0x0387dbd5e8504938edf4b38eacbf77a1d0394a1b	199743573	224999999050735147	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	193	34478416	203656	204776	2022-10-18T01:11:00.000Z	0x19985d95f9256eb5a6cde10a497c2bc4e0fe114e38f53fbcfa72975b18a01916
75003520586125	0x0387dbd5e8504938edf4b38eacbf77a1d0394a1b	35673797	20520539311917145	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	144	34508238	204456	204920	2022-10-18T19:32:53.000Z	0x321ee1c9b9345ca8dfede513740507cc66635d48561a5ed1c658eabf4f763279

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_polygon.Pool_Mint_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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_deltaQty0`	`STRING`	Change in token0 balance resulting from the swap. Numeric string representation in smallest denomination, where positive values indicate token0 added to the pool and negative values indicate token0 removed from the pool.
`in_deltaQty1`	`STRING`	Change in token1 balance resulting from the swap. Numeric string representation in smallest denomination, where positive values indicate token1 added to the pool and negative values indicate token1 removed from the pool.
`in_sqrtP`	`STRING`	Square root of the current price ratio between token0 and token1 in the liquidity pool after the swap execution. Numeric string representation using Q64.96 fixed-point encoding.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_currentTick`	`INT64`	Current tick index of the liquidity pool after the swap execution. Signed integer representing the price tick position in the concentrated liquidity model.

Sample Data

address	removed	in_sqrtP	in_sender	log_index	block_number	in_deltaQty0	in_deltaQty1	in_liquidity	in_recipient	in_currentTick	block_timestamp	transaction_hash
0x7369ad0fad7e20dd126aa8630513b61e1070a5ee	false	56320944654632751148117999419655496	0x1ff01b83bf703bc48c9bb59d7bd1f9e3e0217296	224	32345992	-32033027	16206213959109180251	12293940981508252	0x0aaa9bc932ad57c8c8ca9a7ff0b56336a0786e8c	269498	2022-08-26T14:54:11.000Z	0x1b080561a17e940503f675ae6607a4b0739eea18c68d143ef553ca912d640043
0x0387dbd5e8504938edf4b38eacbf77a1d0394a1b	false	1998094076319151377277457584594648	0x1ff01b83bf703bc48c9bb59d7bd1f9e3e0217296	166	32350503	-2007937	1274987214169791	24649280570536	0x0aaa9bc932ad57c8c8ca9a7ff0b56336a0786e8c	202717	2022-08-26T17:54:52.000Z	0x2b3e1515f22f41bcbde5608ab3542a880da2d0430da7239cb4dd2c6e55981795
0x0387dbd5e8504938edf4b38eacbf77a1d0394a1b	false	2014633483497675958351761562469284	0x1ff01b83bf703bc48c9bb59d7bd1f9e3e0217296	441	32351301	-4014687	2586214557079116	24649280570536	0x0aaa9bc932ad57c8c8ca9a7ff0b56336a0786e8c	202882	2022-08-26T18:26:42.000Z	0x13da7c058fd7f0f05ddbe98d6ad20390fa23342e8a1a00c99e672d6a415b58c4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_polygon.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

ElasticFactory_PoolCreated_event

ElasticPool_Burn_event

ElasticPool_BurnRTokens_event

ElasticPool_Flash_event

ElasticPool_Mint_event

ElasticPool_Swap_event

Factory_PoolCreated_event

Pool_Burn_event

Pool_BurnRTokens_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ElasticFactory_PoolCreated_event

​ElasticPool_Burn_event

​ElasticPool_BurnRTokens_event

​ElasticPool_Flash_event

​ElasticPool_Mint_event

​ElasticPool_Swap_event

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_BurnRTokens_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

Tables

ElasticFactory_PoolCreated_event

ElasticPool_Burn_event

ElasticPool_BurnRTokens_event

ElasticPool_Flash_event

ElasticPool_Mint_event

ElasticPool_Swap_event

Factory_PoolCreated_event

Pool_Burn_event

Pool_BurnRTokens_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event