kyber_v3_ethereum

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	0x7777d532b8bc52cf4471345cb772d079d2b7bd0f	false	0xaaee1a9723aadb7afa2810263653a34ba2c21c7a	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	245	17773011	2023-07-25T22:14:11.000Z	5000	100	0x4eebb20fb0583b092159527fe7841beb59f8d0604bd4867856836ea0d9642907
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0x9a0b9d568501bbf86e7eb0e1ed02ff0d3ec080a4	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0xf819d9cb1c2a819fd991781a822de3ca8607c3c9	319	17771718	2023-07-25T17:52:23.000Z	2000	100	0x301ebec3f87d43cd62fbe1aadef019e81dfec97578bd72c43964e26bf5fba757
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0xb9f01a0069ddd159e116ec2ada1daaaba34809f3	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xf819d9cb1c2a819fd991781a822de3ca8607c3c9	391	17770779	2023-07-25T14:42:47.000Z	1000	200	0xd72a979401ddeb4a7bfc22989d3009a1987e6bac62c44608a34ca266f6c5b340

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_ethereum.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
18857516225413588	0x4db4ee18960c5cef92c2fc874daaa8e83f1608aa	5051564174732146933	10945001998	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	197	18185894	-201586	-201082	2023-09-21T18:00:11.000Z	0xd22aa7ac2bfadf1cfd7164eeb7c7fc0564461cb4d135aad64daa232d0e6980a1
35713771084361616	0x4db4ee18960c5cef92c2fc874daaa8e83f1608aa	38962701170408472252	95118217405	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	187	18181943	-202384	-200144	2023-09-21T04:41:23.000Z	0xf79c3a8fb78a3d0e7e165f6c4bc9f62fd1aa7ec43e734716c3e170054d421ba5
1143340685981391	0x4db4ee18960c5cef92c2fc874daaa8e83f1608aa	26712729624625012206	48936516132	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	198	18183720	-887272	887272	2023-09-21T10:41:11.000Z	0xab771fced90460b763dd4a2d6b86699d758b829672d419ae5c4810aedf9d1e2f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_ethereum.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
102558956	0x1e32b56f3f21fc12d4de0b59ba5436a27ec26b2a	40300683616	268527	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	326	17503431	2023-06-18T01:34:47.000Z	0x2562ecdf1d7954d649c54cae90ba840a705fbae1d36b8b0b48ac0f2ba621dbe3
74911144727956	0x781887ca8f967cb5a978c020e081ac9179ccab0d	85212094	67246153850609578289	false	0x9e0921645512b2da495d19154cb677853ba21fa2	340	18057118	2023-09-03T16:20:23.000Z	0x184e6073f74d587f18eec3f9ab2f7c90949dd745fa4ec0b9fe9bf5b862f8935c
44542891232587528834	0x1a262266364bdb34df4c1337ad5f8b9b57182251	799017264269531316	2569997904261326232715	false	0x9e0921645512b2da495d19154cb677853ba21fa2	336	18057118	2023-09-03T16:20:23.000Z	0xfe8fe63b86c516143ddc67767f035b534b8b587c5a98098f0b545988057a7524

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_ethereum.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	in_qty1	removed	in_paid0	in_paid1	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x5030c96b4a3bc3ce7afba2167f09d2821a83227d	0	9214150005	false	0	3685660	0x00000000006004dfb6ab427a47994f2a6a4f6334	152	17861619	0x00000000006004dfb6ab427a47994f2a6a4f6334	2023-08-07T07:38:11.000Z	0xeb38a570f9826ad410b4fcb81fba92489bfdf8053a4de5c323120c65ce464091
0x5030c96b4a3bc3ce7afba2167f09d2821a83227d	0	12774040380	false	0	5109616	0x00000000006004dfb6ab427a47994f2a6a4f6334	78	17859046	0x00000000006004dfb6ab427a47994f2a6a4f6334	2023-08-06T22:59:11.000Z	0xc325a53583a0c6fda2bd1b0d56ff379b4a8bcbf5fe7cc6db5acc63b8621d8187

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_ethereum.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
31685761736749256	0x36240069ff26cecbde04d9e49a2af8d39146263e	16477845328798542358	15199934	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	547	18118034	-276358	-276338	2023-09-12T05:00:59.000Z	0x3958bf5a2e0448a243274b441aca82136d3c35edc138e2fe524598023ecc221c
11524172497736613	0x4db4ee18960c5cef92c2fc874daaa8e83f1608aa	3999999999942781385	7503685769	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	448	18121672	-201554	-200948	2023-09-12T17:15:35.000Z	0xcdf1a951fe98afc32c5eb2a9918199741fd6b169a4094ef8a32f5019f9b10bbe
5711464798574719	0x4db4ee18960c5cef92c2fc874daaa8e83f1608aa	4799579999835560167	9457751757	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	454	18121672	-202038	-200516	2023-09-12T17:15:35.000Z	0xcdf1a951fe98afc32c5eb2a9918199741fd6b169a4094ef8a32f5019f9b10bbe

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_ethereum.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
0x2bbbf9dbf1e831fa3bce299b43415f54226da242	false	15720638532946371364170465	0x00000000000006b2ab6decbc6fc7ec6bd2fbc720	18	18150665	66721943449804708	-2726681104	217714080074922	0x00000000000006b2ab6decbc6fc7ec6bd2fbc720	-170511	2023-09-16T19:07:23.000Z	0xc754630f58c3887d715a8672c26eceb70368e05fa07bb12608ebb7e6f602e0bb
0x74675a0aa6644db97c0424eddd1461e53ac482b2	false	4190979201972653288617321018434	0x0000690000a5fe503ac89500eb11519c2dc00084	87	18145240	203126519097222211	-545436833529633911518	0	0x0000690000a5fe503ac89500eb11519c2dc00084	79371	2023-09-16T00:44:47.000Z	0x6d64d0eb58ed2282e2d4c54f513800e5e2aa2a57abba43244e8303c6d5de33a8
0x6e23bebd3fece8967f66b020eb1d71fb6c2c9a69	false	3970513971157081147170324739605	0x0000690000a5fe503ac89500eb11519c2dc00084	121	18146814	-160275688767143581	406324303563971158797	11669849123913626333311	0x0000690000a5fe503ac89500eb11519c2dc00084	78290	2023-09-16T06:03:11.000Z	0x38f11dee30bd925e0904b3a1d61dc704dae57f7cd5875aaf4ac722bcdff2ed5b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_ethereum.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	0x5d17ad286cc917e7262c5a39126cac9567431dbe	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x66eff5221ca926636224650fd3b9c497ff828f7d	97	16653501	2023-02-18T05:38:47.000Z	300	60	0x34aee947c5ca77ba9f47baa249ef6fb3a6939dc08d227538a1bc3558f7412a15
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0xc175ebde0ed25bbbebc457d7fd045ce9bfe5df1c	false	0x853d955acef822db058eb8505911ed77f175b99e	0xdac17f958d2ee523a2206206994597c13d831ec7	112	16179424	2022-12-14T00:42:23.000Z	10	1	0xbb1129a482d477dad9b2afcdcdad0286d05d8d24f9e42c6f10244ecfcad68830
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0xaed94908236484f69ad4f748bfb856b378be21e8	false	0x808507121b80c02388fad14726482e061b8da827	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	205	16167302	2022-12-12T08:01:11.000Z	1000	200	0xc80a127daaa7724907e5f13f30430c6600a67600093fa074cb1067ecde51bb3f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_ethereum.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
288439565514067438	0xe6bcb55f45af6a2895fadbd644ced981bfa825cb	0	2468137165595	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	175	16584365	-206760	-202072	2023-02-08T13:29:47.000Z	0x3536920161ec37112a4f56a659c1a88015aec57b696bf69d55c878802e64bac1
3100369482927592	0xe6bcb55f45af6a2895fadbd644ced981bfa825cb	3556179833531942305	11358993479	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	270	16584298	-202856	-200064	2023-02-08T13:16:23.000Z	0xa0cc1ac43abcab6366179dfa3519f3aa35971fd942f6500f9213b74f7691ae49
25084807634595978	0xe6bcb55f45af6a2895fadbd644ced981bfa825cb	28772727744031176862	91904583605	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	196	16584306	-202856	-200064	2023-02-08T13:17:59.000Z	0xa7bb7d6ce2e55efc5dbb99b9c36bb112250eddc4282d7441cf282a61a84e0855

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_ethereum.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
1872056141776	0xe6bcb55f45af6a2895fadbd644ced981bfa825cb	51492577051555618	68164790	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	181	16329545	2023-01-03T23:28:59.000Z	0xe6c34aa78686cdfa80c2d19cdeee522afb3586fa6da729d942e6dfc38cd368d6
269333357	0xe6bcb55f45af6a2895fadbd644ced981bfa825cb	7425566075278	9784	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	321	16327439	2023-01-03T16:25:23.000Z	0xb59ff10716fb92bc704b683519665c14340d9352111e2e7877aefd6e3e2c5a0a
3097674595902	0xe6bcb55f45af6a2895fadbd644ced981bfa825cb	85365679646114482	112578013	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	252	16327095	2023-01-03T15:16:35.000Z	0x1181369617bffa0a6693ba5c8a881553a361d62babaf410730e953e9f6e2e2f2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_ethereum.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
0xe6bcb55f45af6a2895fadbd644ced981bfa825cb	1778447772	false	711379	0x27cc12685d31d713ca8a00d8f8ea1f3761b56f9f	113	17111998	0x27cc12685d31d713ca8a00d8f8ea1f3761b56f9f	2023-04-23T22:30:59.000Z	0xccd9a0b0858b3042ccb2b6ed1ccddce740854be48df34a10d9ec74e9f0045c8d
0xe6bcb55f45af6a2895fadbd644ced981bfa825cb	1778034168	false	711213	0x27cc12685d31d713ca8a00d8f8ea1f3761b56f9f	69	17111884	0x27cc12685d31d713ca8a00d8f8ea1f3761b56f9f	2023-04-23T22:07:59.000Z	0x7dd09575548179e2b507d2743b1b194d3a1f869a0e891155d972a1e0268bfa18
0xe6bcb55f45af6a2895fadbd644ced981bfa825cb	1833569256	false	733427	0x27cc12685d31d713ca8a00d8f8ea1f3761b56f9f	37	17112233	0x27cc12685d31d713ca8a00d8f8ea1f3761b56f9f	2023-04-23T23:17:59.000Z	0xc3b95ad117cc0ec863d23b127c329ed071c45e7df4341ff857eea75f5489d4d9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_ethereum.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
95858511680073890359	0x2c104235eb170e72a19377b07e2dfbd4d7f0c51f	26710315351	69104999999085232046468	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	216	15605843	276305	276325	2022-09-24T21:16:23.000Z	0x1e860639dbdc028149ff0f4cda193a64477292311706ed22850cdab0aa70b6ce
4754969584802216792605	0x588b6b91e83e3d3485c5129c75708f94c6fa2041	107489163314690406	0	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	94	15603617	155040	156120	2022-09-24T13:48:23.000Z	0x9aefb619f98d59385dfae16f35be4bd9de278f8dff6f35a27b33829a8695156f
5439140368626600335028	0x588b6b91e83e3d3485c5129c75708f94c6fa2041	119934579076657842	0	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	116	15603557	155063	156117	2022-09-24T13:36:23.000Z	0x68123915e497f247453b9e242de5bee15893c125a64a04ea728454f124261ce8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_ethereum.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
0x952ffc4c47d66b454a8181f5c68b6248e18b66ec	false	79224389382832083832086074282	0xc1e7dfe73e1598e3910ef4c7845b68a9ab6f4c83	168	16775838	-1457445432	1457423183	72786699435428222	0x22f9dcf4647084d6c31b2765f6910cd85c178c18	-1	2023-03-07T10:29:47.000Z	0xfe5dfb4c309b00478dfdf70cc6ae1f66d74bc684893005c7c9843878fc9a1f60
0x952ffc4c47d66b454a8181f5c68b6248e18b66ec	false	79226719086586892033810029663	0x6c44083427293681db3410a6e488f5062d95b8bb	330	16773281	-728732476128	728756928410	72786699435428222	0x6c44083427293681db3410a6e488f5062d95b8bb	-1	2023-03-07T01:51:59.000Z	0xccfcde4c17a54a3ca70f89b5fb516313dce6e0bee6ea558a463a43fd85c93874
0x952ffc4c47d66b454a8181f5c68b6248e18b66ec	false	79224824827876776775844955356	0x6c44083427293681db3410a6e488f5062d95b8bb	317	16776596	-249987999087	249986077187	72786699435428222	0x6c44083427293681db3410a6e488f5062d95b8bb	-1	2023-03-07T13:02:47.000Z	0x8bd79ef1bd5779ad0df7ac94ea5366212ab0c7b1f9a72a777c4d4c7fb8b2630f

Example Query

Query with partition filter

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

RewardsDistributor_Claimed_event

Reward claim events from KyberSwap V3’s RewardsDistributor contract on Ethereum, tracking user withdrawals of incentive tokens across distribution cycles. Used for analyzing liquidity mining participation and reward claiming behavior by cycle and token.

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_cycle`	`STRING`	Rewards distribution cycle identifier indicating which periodic distribution period the claim belongs to. Increments sequentially with each new rewards period, as shown by cycles 12 and 13 in the sample data.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_claimAmounts`	`ARRAY<STRING>`	Token amount(s) claimed by the user in this rewards distribution event, denominated in the smallest unit of the corresponding token(s). Each amount corresponds to a token address in the in_tokens array, typically containing 18-decimal precision values.

Sample Data

address	in_user	removed	in_cycle	in_tokens	log_index	block_number	block_timestamp	in_claimAmounts	transaction_hash
0x5ec0dcf4f6f55f28550c70b854082993fdc0d3b2	0x5565d64f29ea17355106df3ba5903eb793b3e139	false	12	[“0xdefa4e8a7bcba345f687a2f1456f5edd9ce97202”]	255	18141449	2023-09-15T11:53:35.000Z	[“3945730523823436788851”]	0x4783604b07ee3160b1126ebf118cecc7877ead85ad63c487766247094e0d9adb
0x5ec0dcf4f6f55f28550c70b854082993fdc0d3b2	0xa6c883e2dde82fbed20e025bd717a6b7f34f5e6e	false	12	[“0xdefa4e8a7bcba345f687a2f1456f5edd9ce97202”]	270	18142114	2023-09-15T14:08:47.000Z	[“3155149530174242583395”]	0x9693e1d2a5611d7baedd2e56b89fb266b0f04ea3fde05aed161c62d74779d358
0x5ec0dcf4f6f55f28550c70b854082993fdc0d3b2	0xfa24b9db83c5f4e3e2df79750ed8450a95cfdfaa	false	12	[“0xdefa4e8a7bcba345f687a2f1456f5edd9ce97202”]	166	18141488	2023-09-15T12:01:35.000Z	[“56657252753480068774”]	0xe6e79578d90aa88a8816a93627408fd7f4f89f95033541b9bc6ff51dd7e6de5d

Example Query

Query with partition filter

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

RewardsDistributor_Claimed_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

​RewardsDistributor_Claimed_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

RewardsDistributor_Claimed_event