kyber_v3_avalanche

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	0xfbb89d59757660aaf87485132caa02a4ff917ac5	false	0x9b06f3c5de42d4623d7a2bd940ec735103c68a76	0xc7198437980c041c805a1edcba50c1ce5db95118	10	35373763	2023-09-19T05:36:58.000Z	250	25	0xdd9c8ca34d2ba928bc4c0cfd9da07f9e07e973ddb214bfe6283ba313e02ccdf0
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0x0d33881eab95b782265af68b3e91d579347da8f6	false	0x9b06f3c5de42d4623d7a2bd940ec735103c68a76	0xc7198437980c041c805a1edcba50c1ce5db95118	5	35373716	2023-09-19T05:35:23.000Z	300	60	0xe1ef4e41550c32874afb62b073e25f2b512b1c1dca620fea3cdd62a0bd8aa840
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0x1ac32f2e7c7be15c05ac5add50bdeea75a4b69da	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xeeeeeb57642040be42185f49c52f7e9b38f8eeee	26	32818490	2023-07-19T20:23:17.000Z	300	60	0x2f45dd9ca82b30d6afaf945d6ca37b93c6532cf0958ca2cabf817cc3bd6664ce

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_avalanche.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_qty1	removed	in_owner	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
2857127275466952736	0x07e9d0086d869f4b131d73afddb7d12b97280415	7912386430	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	22	32845217	-344400	-342800	2023-07-20T11:22:46.000Z	0xf71e32a692b9ea45220e73131d992f07658167595d1ab9e57c795278861c8a4f
3169204426722323630	0x07e9d0086d869f4b131d73afddb7d12b97280415	8263564260	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	21	32845253	-341300	-340000	2023-07-20T11:23:58.000Z	0x6bbdbdf2ee08e8ced1c88e14439f66982ec0445fbc906cdacd17e827f2d77839
5683665791943780300	0x07e9d0086d869f4b131d73afddb7d12b97280415	15944827670	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	13	32845236	-342800	-341300	2023-07-20T11:23:24.000Z	0x500dee00f07fb0178000c777938a7fe0f1252f36de273ab5c9b37de0d9be2ddc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_avalanche.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
52750910730	0xb2c8e1fa23eace8474e8e1deae1e1aa171664bbb	16455632023423014	171993	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	10	36101688	2023-10-06T10:08:24.000Z	0xbefec6cf89efdd563c478c0aabf62a83ac30a954cefe3a2886206f5685acc0ef
1143637	0x3514a144f56401e62d89a2ef48fc2114e26ac456	6475702972	206	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	40	32974685	2023-07-23T12:43:45.000Z	0x076fc08629db52e3ef1cb9f84ade7bb75df7c660de368718c8b915830f229352
66737271951770	0x07e9d0086d869f4b131d73afddb7d12b97280415	1452814971109041112736	3218522	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	30	33731218	2023-08-10T08:19:48.000Z	0xe305259e5696e52b6c79b817616fed3d6052f3e1b4de6bd14fd9be3b6d4662a7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_avalanche.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
0x9db5dec971cd47b226744e40d4ab082d937aa7f4	314254530	false	25140	0x231262c25d677805fac1efbc9b8013b92e0984a2	62	33145680	0x231262c25d677805fac1efbc9b8013b92e0984a2	2023-07-27T13:25:59.000Z	0x342864ef419e505fb8350924b961892ffe44e18adb4c8fbb1a5391ee60fec73c
0x47684f533d3aa929184980eb2e33892b5ae5aaac	9000000000	false	720000	0x231262c25d677805fac1efbc9b8013b92e0984a2	31	33129453	0x231262c25d677805fac1efbc9b8013b92e0984a2	2023-07-27T03:59:33.000Z	0x99c97dc3db0d2e772adf674b775c26e3456bf07cf30a2d6e1cda4d5ce05b6585
0x47684f533d3aa929184980eb2e33892b5ae5aaac	8415000000	false	673200	0x231262c25d677805fac1efbc9b8013b92e0984a2	63	33129453	0x231262c25d677805fac1efbc9b8013b92e0984a2	2023-07-27T03:59:33.000Z	0x7c1c82ae8885800cd35c1e331542f54ed35069cc3e004f8998f483cbe832b405

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_avalanche.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
123585026492147	0xef40f92f2b3b8d5e5a92aac20ad5c53a8b18c313	9315722303862692	478559093	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	45	30786623	-174180	-173460	2023-06-01T21:27:01.000Z	0xa3d69bf2e832e508318cd03ca7c4dc1ecb8736947fcedbb0233ccbbd26d0d535
45349815601051	0xef40f92f2b3b8d5e5a92aac20ad5c53a8b18c313	3603152635123067	170333702	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	21	30786838	-174180	-173460	2023-06-01T21:34:21.000Z	0xc9e3cd7c074f3dcf0340fbafa9ec7e64777d97c2c0f9d14f57016020f8307034
2547576657283415634	0x38d8dd18884e4280034f298b5a3af142bd21484d	682724409071898555	46445879688351200	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	15	32939585	-27700	-24800	2023-07-22T16:48:52.000Z	0xd85947a0588a7714b13ca5a40ce0f6cae954c5919d1509e31a63cc317404290e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_avalanche.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
0xa19209c1ad62397f779401d3f5db121a027a749e	false	79212391339895588783519012888	0xff153aaab90deb8d88c3e7e9e0737b03a5e8b93c	25	35049680	131497280	-131543409	158664775497	0xff153aaab90deb8d88c3e7e9e0737b03a5e8b93c	-4	2023-09-11T13:35:27.000Z	0x9c8fd05e0d91751097f51df9c0409c7b7856832473a3f98922ed68bb12a35890
0xa19209c1ad62397f779401d3f5db121a027a749e	false	79225918673104156066603622251	0xebf00ad513e398a336c61b3b8a59c8a6fcf4f770	4	35050919	22906525	-22906702	158664775497	0xd7732a40d6a789bf1c3c33f5035c37a97966b74f	-1	2023-09-11T14:16:48.000Z	0x5e12730c507ac3adfbd8974eac250d02affd650e4918fa4bd6760f36c6747bee
0x4db0ae31aff61a48f5dc0a31cc0ca53c2e24a0c9	false	77900102650886017454465	0xebf00ad513e398a336c61b3b8a59c8a6fcf4f770	25	35054755	-3946198782940558996	3636616	78927414598224	0x23ddca8de11eccd8000263f008a92e10dc1f21e8	-276663	2023-09-11T16:26:13.000Z	0xb22781fbaeec96c20f1d9031f53c97cce98b0c71ddd1fd90847b21ec653c9365

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_avalanche.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	0x9badc35e320d0b95b1de78a69a9364fabcdca386	false	0x0da67235dd5787d67955420c84ca1cecd4e5bb3b	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	0	28278897	2023-04-03T20:51:48.000Z	300	60	0x4a82be0262ecf20fa9423cd39b8a4909077a43b4cd849200ecb6f08729f950cd
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0xf64a4a42a15f648e4b0124d6522d339913a9512b	false	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	1	20411933	2022-09-29T04:28:49.000Z	300	60	0x1cb4a403f59200fdb9e4336a5bd53aece24babcb68bbeeedac59fd25dd3e893c
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x647070672228a512f5dbf2a5a807e46a942c7353	false	0x152b9d0fdc40c096757f570a51e494bd4b943e50	0x50b7545627a5162f82a992c33b87adc75187b218	0	21112066	2022-10-15T21:49:49.000Z	40	8	0xdadc628a191fcbe4defc79d111cae44f1559fb71dd70b8cad73dd1ad4302dec2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_avalanche.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
1401429361329098960797327	0xdf9aa2156be229783e8b18c38e51b0c01778c9ca	0	119102526434868167351	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	9	19825545	-30984	-30976	2022-09-13T08:54:49.000Z	0xe0c109ea222f84adbe16214ccb9425825f99b34675dea53930a0b6b21ba81a13
1484064511999517387064635	0xdf9aa2156be229783e8b18c38e51b0c01778c9ca	0	126125395720151826820	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	12	19820972	-30984	-30976	2022-09-13T05:38:04.000Z	0xf9a81659f63620e03997edff35cd469f8b0e589fda44522f0ed6b2e2b3c80150
1485579135618105104842233	0xdf9aa2156be229783e8b18c38e51b0c01778c9ca	2760984056902082376482	0	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	2	19814220	-30728	-30720	2022-09-13T00:52:02.000Z	0xd855192be096f64c6bb2afb538bec5bb8db15837af895ce1875f7040eb0e5fdd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_avalanche.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
119850196318	0x024ba2110590dffa4d6b288761c5ee1e78e62cd4	734682751833124	20095860	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	32	27572610	2023-03-17T22:42:16.000Z	0x213981cca183d3a25a02b4b6300966255ced7568aeac219eea90765c6d70fd9b
752	0x0551827bbd26054b80ed8099fa04f551632e9380	752	751	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	11	27562026	2023-03-17T16:47:47.000Z	0xee4c0c0bc0da882ec65ca7385545b334eb04fce3ebfcc42983ababc931968fd0
29	0x0551827bbd26054b80ed8099fa04f551632e9380	29	28	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	9	27562015	2023-03-17T16:47:25.000Z	0x953837a1a9f330e2722d00492c3a33b37b69c98fe55fd0f44b2a7d63571e2030

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_avalanche.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	in_qty1	removed	in_paid0	in_paid1	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x51a358b21b8c81ede9aeb8bd6f3814f6e7249f08	0	31223343720	false	0	2497867	0xd1967ba114d886238919ff54b132627fcdef9748	55	26355742	0xd1967ba114d886238919ff54b132627fcdef9748	2023-02-17T01:59:52.000Z	0xe5b906385c769a491350a606efbe157b32db8ca47485a9d7455d913e20129d97
0x1701a7e5034ed1e35c52245ab7c07dbdaf353de7	3120170450634020520	0	false	1248068180253608	0	0xd1967ba114d886238919ff54b132627fcdef9748	46	27494729	0xd1967ba114d886238919ff54b132627fcdef9748	2023-03-16T02:28:49.000Z	0x61a4be29ff04f2e8f95957e22b9d90a8c82c6d02e4147d74ae39de8cf54cd6ec
0x0551827bbd26054b80ed8099fa04f551632e9380	0	59279016090	false	0	4742321	0xd1967ba114d886238919ff54b132627fcdef9748	63	26187335	0xd1967ba114d886238919ff54b132627fcdef9748	2023-02-13T02:50:21.000Z	0x33367173f976828523cf899d59bcf080b7925f574db1a89435503514d8e4822e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_avalanche.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
1189583429162407884552307	0xdf9aa2156be229783e8b18c38e51b0c01778c9ca	500203394786781402441	85000000000000000000	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	6	20022287	-28680	-28672	2022-09-19T04:57:17.000Z	0x688b090735b46119e088fa0fc94c67bf9e4477d9fd61a95f9c1d98eb1486b3ef
1064607495232310817439887	0xdf9aa2156be229783e8b18c38e51b0c01778c9ca	1043325437376799163184	41977733251579704749	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	22	20019783	-28424	-28416	2022-09-19T03:09:19.000Z	0xf658d6a6fbba8580242e3e9e0542a60ee7eb31bba9984a8556fc7d69faa1dde7
1530597439341199913488378	0xdf9aa2156be229783e8b18c38e51b0c01778c9ca	1500000000000000000000	60351830427603231073	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	7	20019761	-28424	-28416	2022-09-19T03:08:29.000Z	0xdf9b6234c4d97e9d52fc1ce384553a20a99f578ff6873a4a26b9803853b8f162

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_avalanche.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
0x6038373de7f64da99b2a31951628b7d778b2c3cf	false	79221854057837206035092832022	0x07749429d3d9047a966b28a489500325bac9f1b6	15	34761017	-28156750	28153996	1514147313397	0x07749429d3d9047a966b28a489500325bac9f1b6	-2	2023-09-04T12:56:12.000Z	0x30049489ff9ba541aba1957a9fc858c176984d8ee4d034321c98990c4e97c304
0x6038373de7f64da99b2a31951628b7d778b2c3cf	false	79220381137197654337778070448	0x07749429d3d9047a966b28a489500325bac9f1b6	8	34761034	28156750	-28149490	1514147313397	0x07749429d3d9047a966b28a489500325bac9f1b6	-2	2023-09-04T12:56:46.000Z	0x3c61df8a991eec6e42934e6b863704518b8d9cb89c58e540c7bad64a90f6f854
0x6038373de7f64da99b2a31951628b7d778b2c3cf	false	79220953505517864457027291495	0x07749429d3d9047a966b28a489500325bac9f1b6	14	34767736	-169207667	169171508	1514147313397	0x07749429d3d9047a966b28a489500325bac9f1b6	-2	2023-09-04T17:00:59.000Z	0xd771396964bac9367c7ee4cfed3fe37c40cc519fe74e885efb427757d6c60881

Example Query

Query with partition filter

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