kyber_v3_bsc

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	0xe823b53b073b493a2c294a6414584c7a0e98d7d7	false	0x25d887ce7a35172c62febfd67a1856f20faebb00	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	122	28579128	2023-05-27T14:19:47.000Z	100	10	0xddd149ae74264e09c6bdadf9b6725a8ea109c7f97ec907b82dfe8e30e9afb9a3
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0x87ac8d5b34cfd5b28eed251e3a72f923ab9af512	false	0x0aa93a07848fc2e566788a82f9cdcd7e950af4c8	0xe9e7cea3dedca5984780bafc599bd69add087d56	158	29438024	2023-06-26T11:52:04.000Z	1000	200	0xd046b249a63c42cb77c8ffc77cf2ba4c38169d95aed849815eb7d6e06f92cd95
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0x2c1c2486c573c9ed0ea636d0e177d446fbf1e720	false	0x55d398326f99059ff775485246999027b3197955	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	42	32720670	2023-10-18T20:36:45.000Z	8	1	0x1f74acee03b919188cc176b2ed106dac3021b03d8cae6b4fbf2daeeeb09aa257

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_bsc.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
379868449032976418067	0x60f86a67383e6d47822543f95261853603485e03	460331972457324039526	15267195066987893744	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	228	30422173	-30000	-19000	2023-07-30T18:26:22.000Z	0xe9772e889b10d4f20f6e47dad197877edca0e611aed5c501b4bde7a76e3e32a2
70885361511543570054549	0xf5b08cec831c24a66a69a8153cca2470212e08d9	55138391390003995995629369	4826536297573295048	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	307	30424076	-156200	-143900	2023-07-30T20:01:40.000Z	0x6d1fa072255fc1ec5df256057fb8fd8aeccfe611dea172a0df0b560bc465c2ba
38059190838743131952662	0xf5b08cec831c24a66a69a8153cca2470212e08d9	29447321076843537094501661	0	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	157	30424081	-152000	-142200	2023-07-30T20:01:55.000Z	0xdb06f530e89591781ded7421479f2190d77357fbe4d3fc4564c6ae0d156b0569

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_bsc.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
24922616475048646	0x6c85e9e62e6e98c18b08a29367d1fe7383d11cf4	81687086666991556	7604890213611838	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	153	29489322	2023-06-28T06:42:57.000Z	0x5b6abc35c1b82256946407fcf89c1bb60ad7069e280d21ff33fe6f5388ec080c
30168508340608	0x6c85e9e62e6e98c18b08a29367d1fe7383d11cf4	98881173166561	9205622293648	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	378	29488307	2023-06-28T05:52:10.000Z	0x415a6ceb3ee7995cdc3db4a587c1bfbfb1571516d6c90dfe0c96f2a2b5bc1cf6
1726034514136692088	0x4dcea22540f5ccae0331749ff32a0c7ff522b444	84055558804004214	35778530750832114064	false	0x9e0921645512b2da495d19154cb677853ba21fa2	29	31421834	2023-09-03T14:32:08.000Z	0x4be3f1d5a80a3c90f496d61f3ccc975d6cc1a864579e05710cafecb354c6d737

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_bsc.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
67187564380860908684	0xa58d2d744794d02c99db40006531fb7f4fb62ffa	1830678176197771	0	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	81	30822839	58190	58200	2023-08-13T17:26:58.000Z	0xffdecce950cb320fbedc863c2e9a834cce2a835fcf9542f41737da6b1e0355cb
20001981000828227450840	0xbbf9a2ca8020368cd40b1f6d349f3c101f3516f5	94865958838156264448490	905159611094	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	93	30818524	-276325	-276324	2023-08-13T13:51:11.000Z	0xe0cb8cd3e6ae78174b482574a43c99c1aa876af860ccbdbe6e55c823aab6b441
10711301226846313	0xdd25853921f43995725f43268bdd011fa51e4c01	4999999928394401925976	38292021	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	295	28612003	-325000	-323330	2023-05-28T17:47:39.000Z	0x8f741b132b77a7df7843ade2753915a98b7e07a4553be6e33aa286b5aa85e815

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_bsc.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_liquidity	in_recipient	in_currentTick	block_timestamp	transaction_hash
0xbbf9a2ca8020368cd40b1f6d349f3c101f3516f5	false	79228267132258793085835	0xcaa00aaf6fbc769d627d825b4faedc3aad880597	157	29041892	1000000000000000000	-999921	20001073516709664414533	0xcaa00aaf6fbc769d627d825b4faedc3aad880597	-276325	2023-06-12T16:48:20.000Z	0x5bc7a0fc7e5ee031fc85d6b061ee597a6626e8d37d283d49757e56a267dd5873
0xbbf9a2ca8020368cd40b1f6d349f3c101f3516f5	false	79228267136219840604274	0xcaa00aaf6fbc769d627d825b4faedc3aad880597	233	29036379	1000000000000000000	-999921	20001073516709664414533	0xcaa00aaf6fbc769d627d825b4faedc3aad880597	-276325	2023-06-12T12:12:06.000Z	0x399539fe638aa8e960b2ba3ec23789d304333314787873183ab663c5ca2976fa
0xbbf9a2ca8020368cd40b1f6d349f3c101f3516f5	false	79228267128297745567792	0xcaa00aaf6fbc769d627d825b4faedc3aad880597	258	29043388	1000000000000000000	-999921	20001073516709664414533	0xcaa00aaf6fbc769d627d825b4faedc3aad880597	-276325	2023-06-12T18:03:41.000Z	0x2a27e4c788b3ae736671d032dfec5b48bfd6564431eaa9d1205d0186e7b7b3e2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_bsc.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	0xf1914261f3af664dfc22b75d0b5a0fdb0970b393	false	0x55d398326f99059ff775485246999027b3197955	0xfe56d5892bdffc7bf58f2e84be1b2c32d21c308b	317	20326005	2022-08-10T18:24:43.000Z	40	8	0xddacfb71cf9e544b245aa111f4a09468694ac8e7422a52b733da08d7e60a1a44
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x10dc95296004ae7ae08017b12a15cce5eecc1667	false	0xba2ae424d960c26247dd6c32edc70b295c744c43	0xe9e7cea3dedca5984780bafc599bd69add087d56	39	23415351	2022-11-27T11:16:46.000Z	1000	200	0x34a5231a7e78215a528e5b58c2546efb7853bb003855f79afc16ea8f6d768093
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x4d62d08ba7ed95968379bb887d0db193da60a23f	false	0x8929dfe88b3a781e07d8ca08fd0633eb3e79de2c	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	228	24927624	2023-01-19T17:37:45.000Z	1000	200	0xb610e411d6cbc3c7d627064d7d25b13b6ddddb7a54f86a5cfeb066dd6f43967b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_bsc.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
4163254852784176879	0xbaef2c0b1426b7f59709c957b5d25b91cff13cd2	59097579448040567	598447042539976171	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	225	22594588	15456	17408	2022-10-29T12:17:16.000Z	0x740c6a8ca754d0a0373e1b7dbb5c0c208b0e33ed321af926e3a6f0a98ac54c23
65006352799897668462963564	0x9915b4d6f7ab749c473284c752024f1cd3aff6fa	0	3250236386116526687764	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	296	20406056	0	1	2022-08-13T13:08:06.000Z	0x3177192bd44b1e3c8a45ef2faf640709452384819ec5329db49c2e5aba2c4bb1
64944365534945550141185330	0x9915b4d6f7ab749c473284c752024f1cd3aff6fa	0	3246974755669860028230	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	247	20405897	-1	0	2022-08-13T13:00:09.000Z	0x30883b6625ad4c8bea212dbc8d8ba9cb83a02c4da31f8b9708aa4daeff7852e4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_bsc.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
11934158402121	0x9ff16438e937789b95e990d05dc3f05d2d577e26	698229935065	204008304996498	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	325	20801722	2022-08-27T07:19:54.000Z	0x493e21b04a0ba4bc3e44a86483b2ceba3e759f732829a179996382c16644d3b8
12360570963522116	0xf1914261f3af664dfc22b75d0b5a0fdb0970b393	16356970471226321	9347763129992505	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	280	20801703	2022-08-27T07:18:57.000Z	0xd46b938172167d99e87fabdac61c4f7b1a365771cd05fc6162083827f26c5a49
1105048638674566	0xd687c27eb3208902091b977a4e88f5a5aeff3e23	57927500212623	21503752644467532	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	150	25158470	2023-01-27T20:25:42.000Z	0x5c3996d3e1db4f09a9d092eb4d0e3756ba8ea534a1f1c54a827f91b17489eef1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_bsc.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_qty0	removed	in_paid0	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x92b4396c63edb968e2b5d63e69ae39a9bb5bbb94	3257539542190065000000000000000	false	9772618626570195000000000000	0xadc3c2245a3c9448382675f05e9be4efeb5588f2	150	27421602	0xadc3c2245a3c9448382675f05e9be4efeb5588f2	2023-04-17T08:04:45.000Z	0x020c4f86f6a54b214c0bf5b378f62064f6620e511c544f7ee729cd2035b141c6
0x92b4396c63edb968e2b5d63e69ae39a9bb5bbb94	3257539542190065000000000000000	false	9772618626570195000000000000	0xadc3c2245a3c9448382675f05e9be4efeb5588f2	89	27448280	0xadc3c2245a3c9448382675f05e9be4efeb5588f2	2023-04-18T06:22:36.000Z	0x7fddd0b52f36f076e4db676b99bdd362faf01df844c7d2453343986d9d2c77c7
0x92b4396c63edb968e2b5d63e69ae39a9bb5bbb94	3257539542190065000000000000000	false	9772618626570195000000000000	0xadc3c2245a3c9448382675f05e9be4efeb5588f2	122	27443885	0xadc3c2245a3c9448382675f05e9be4efeb5588f2	2023-04-18T02:42:34.000Z	0xc68238f53ccbd1c65eb452a2eac67585390e945559a7c844afbbd4406716065f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_bsc.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
19980917369698064221	0xd687c27eb3208902091b977a4e88f5a5aeff3e23	325361799670284397	103374108930812865755	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	178	21932183	47520	61380	2022-10-05T20:53:19.000Z	0xcf821b9ab27192ac530ec838fab391fe753211b7217362cd1eb31d076bf853f5
15527267849500509751	0xbaef2c0b1426b7f59709c957b5d25b91cff13cd2	311863155418033746	839292825501326374	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	204	21935304	14792	16184	2022-10-05T23:29:54.000Z	0x6d86dcdc6bf379078ce0d4d99d0da30b137455e76ddb7a05ff75bed11490e6fa
272295433870292218768	0x511f2b546d6a08ede8415c4bca123f7628da9e40	999999999999999999807	4986871460931819299	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	109	21923023	-50100	-36900	2022-10-05T13:10:41.000Z	0x11b72c4d82f21f2396fa41c4bf24a9c1cbe3cf88dcb1b1d89c1712290dabccf8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_bsc.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
0x02bc18a11fe40bb06476a362f2959780109b338b	false	5002908865650685122330433570	0x41684b361557e9282e0373ca51260d9331e518c9	170	19737497	264494165676050329	-1061072978971325	2582164183679113993	0x41684b361557e9282e0373ca51260d9331e518c9	-55250	2022-07-21T06:29:25.000Z	0x1ed74b0e03211c23904d02b6c9a468f2c7463b2d009ed819849040148f9d3db6
0x02bc18a11fe40bb06476a362f2959780109b338b	false	5035470456393881381151238790	0x41684b361557e9282e0373ca51260d9331e518c9	241	19736383	-1236593429646757524	4849533338897291	2582164183679113993	0x41684b361557e9282e0373ca51260d9331e518c9	-55120	2022-07-21T05:33:43.000Z	0xec90753e4a308fdb457e9c68397234d699b04c186aaa1f224005939b751d1363
0x02bc18a11fe40bb06476a362f2959780109b338b	false	4889355602034392762836234329	0x41684b361557e9282e0373ca51260d9331e518c9	567	19748974	949949567209848901	-3700324638278935	2582164183679113993	0x41684b361557e9282e0373ca51260d9331e518c9	-55709	2022-07-21T16:04:17.000Z	0x990480ed085fa90d718df3aff24ba9c357d5fa14871e2fd9992f21520c6a3cb4

Example Query

Query with partition filter

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