kyber_v3_arbitrum

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	0xa63d0a0cf97520e2e789807430ba639200ce1f9f	false	0x8eda8226c679103535a0620e3f32f50c3b8a0d1b	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	9	102782347	2023-06-19T14:44:40.000Z	5000	100	0xe9a77e545110ff8d3b8ac720b8c621e147d7ce9fe4b2450b01e607adbb87ab3f
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0x83fe9065ed68506a0d2ece59cd71c43bbff6e450	false	0x5979d7b546e38e414f7e9822514be443a4800529	0x9cfb13e6c11054ac9fcb92ba89644f30775436e4	0	127933025	2023-09-04T11:22:17.000Z	8	1	0x880f473d22555e830249a7b7b9e86d0f530a8e489b35aaaf9bd627bd68435edd
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0xd2c8cdf9cb10c0edaa8a7e473a41b9f09bbec529	false	0xd85e038593d7a098614721eae955ec2022b9b91b	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	0	149279943	2023-11-11T06:59:01.000Z	1000	200	0xcae5a93b07dd511b5da61483b3f423638cd5b3e6cf9a1a9f12ecec50456ded86

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_arbitrum.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
99999999999999999900	0x6d8f67f74b7fa67108e11aedb8b3aa57539f459a	0	99999999999999999894	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	1	108827248	-887272	0	2023-07-07T16:16:52.000Z	0xc65099797654b082b80a1bbd1dc36746868fc0f6225876a45b26aae08c913d14
18634242057076986767	0x6bdd1ad85ed3c9c2530d372dd8c37abdc5a22905	79915058727236637924144	9288647999	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	7	108922468	-275300	-275200	2023-07-07T23:25:31.000Z	0xaaa97b5f6ebc281658418e06cf924bb1334b990e7222643897f47456c6c2e707
12491524038484926076	0x705d75ea71d0c57cc44395f0545d4e889fd2cb2d	14226749957461955827073	49999999999	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	17	108819764	-275300	-275200	2023-07-07T15:45:16.000Z	0xdbe95b56d8d8ac0c0d4960e90055f8ff9970f67db3ca8e797cdc576d5465194b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_arbitrum.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
1495706160456155613	0x836edfa0630096f5c387546b00c42ab9e1099812	37392503961494354	59950937403417298689	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	4	98360016	2023-06-06T11:30:40.000Z	0xf56cc79946bd643b69546f605d8b3e06e6f8599e2a1d5ecdd7d18a7e5c935ca8
62674710589282	0x6bdd1ad85ed3c9c2530d372dd8c37abdc5a22905	58316509217756993053	67683714	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	5	98469936	2023-06-06T19:11:54.000Z	0xbace0dc8c9eb994e89bfa18b7422f2c1a91be44744749a09bf8c60024d96b456
4872926290050271707	0xdc8826bf4d22c597aea40e32864d3a2d49c55e0b	3529134613245202768	6734494215555038065	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	5	98283511	2023-06-06T06:12:32.000Z	0x3747adaff2df17bb7b0aa6ea8de3757e99c55a1cd09962abfe87c34d50a0490d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_arbitrum.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
0xc23f1d198477c0bcae0cac2ec734ceda438a8990	0	106848256	false	0	8547	0xefd71ddbf2bf873119b5a8d392f6cf82d364d0a6	25	95855390	0xefd71ddbf2bf873119b5a8d392f6cf82d364d0a6	2023-05-30T02:24:28.000Z	0xd92463e05eee12df55b793d4eb402334d30b1ece0b23ba6a07eb07b88e6f0799
0x29ac9738be0d1f7cba31d7ff67baf5fdd164efc6	0	1724456960	false	0	137956	0xefd71ddbf2bf873119b5a8d392f6cf82d364d0a6	29	95996058	0xefd71ddbf2bf873119b5a8d392f6cf82d364d0a6	2023-05-30T12:19:45.000Z	0xa55a6abf2b9d7a4657cae59af8ff26ade545ac8f71288f6e82169206c78669b1
0x328d434488f420654de553df518ac4198027ef1a	379155000	0	false	151662	0	0x398ca389beeb8aeb3fef9a16723ee9e2552a4524	60	112110206	0x398ca389beeb8aeb3fef9a16723ee9e2552a4524	2023-07-17T11:01:27.000Z	0x7f4fb54b91158f8e4c146f1520032452b62449f499f05d126a1f675dc39ca95a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_arbitrum.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
99765738031455765	0x0559bf66543012022b1aee4c06bdee604e057f95	3999999999990919564	14043630096	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	18	106073541	-201100	-201000	2023-06-29T09:41:35.000Z	0x60edccff1d9b2096943ad09ac38cf813a94eb74f9ba6ef18c971caf2ed6a3860
344966821085434363	0x0848800e13b229e3e9784a19f8a40179c76918a0	168058608231458244	61012041769295678	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	5	106103937	-17100	-3200	2023-06-29T11:47:47.000Z	0x6ccbdefbb2c33cdc45d29f001411bb3465b004b3c48d0d93368c347595185d88
116095844082870906	0x0848800e13b229e3e9784a19f8a40179c76918a0	45948509406615832	18001700505449827	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	8	106157482	-16100	-4700	2023-06-29T15:30:36.000Z	0x3b451b1364d546f82da2d23cbad1b44286a5e9b96d1928f22178759f9b0c50d2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_arbitrum.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
0x33ecc05a09a84af2153c208ee7e61a31c6b1adf1	false	4684084901879732706587108	0x61178775c2239117745ae76c8ab9fcde737c275d	33	224203498	1684426552477977	-5848792	81754969237	0xa669e7a0d4b3e4fa48af2de86bd4cd7126be4e13	-194729	2024-06-21T13:52:18.000Z	0xd002971d43ed8ecb4c6eb97993c4a73ea62f26de0beda3ada55403d1e717f93d
0x33ecc05a09a84af2153c208ee7e61a31c6b1adf1	false	4690697226007068228677241	0x61178775c2239117745ae76c8ab9fcde737c275d	44	224292719	-683536251428564	2416754	81754969237	0x61178775c2239117745ae76c8ab9fcde737c275d	-194700	2024-06-21T20:04:48.000Z	0x67c81072741c130599b30a26b8f4e3b861ff182ecfc76c2036814836fa3820a9
0x6a7dccf168fba624a81b293c2538d31427b5b4bd	false	79087348510691512024723	0x61178775c2239117745ae76c8ab9fcde737c275d	22	224016621	83155881674913361774	-82831145	1839856785527742997	0xa669e7a0d4b3e4fa48af2de86bd4cd7126be4e13	-276360	2024-06-21T00:53:41.000Z	0x4e8d09d3931a52f96b6429cd507778d3a69067be98eb3385116f52bd5e90cc21

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_arbitrum.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	0x2091c673a562b22797e2b2bfb229ef543767bd24	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xa0b862f60edef4452f25b4160f177db44deb6cf1	0	42995989	2022-12-02T13:45:19.000Z	1000	200	0x0b7b6b2bc5ae90738cea6dd93b5608a93939d0b4c125e9520091d90083996f96
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x781cbd1bd33fa149da02fef0b71fe3ff25913b40	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	1	42977126	2022-12-02T12:19:00.000Z	40	8	0x81ba86c5069566c26662c84de3f4cc196818c8b5746df7692235b667b3af5c20
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0xa6ce5714a4859f35738c84c9d760b35a5af5f073	false	0x431402e8b9de9aa016c743880e04e517074d8cec	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0	65559669	2023-02-28T23:23:06.000Z	1000	200	0xfb37b56f4448bd82af9daadc5e084db8d465fa4cc38c2f32b7dd3880792e98e8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_arbitrum.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
5768641552353	0x087abaab9cd85025a8b3916948c69fe173c837ea	8850422050	371587719	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	2	83611738	0	32	2023-04-23T22:53:51.000Z	0x67bf933eb3e6d604a1291984b6ad53c7fbbdf812b09a3c4070da911004801a20
1	0x087abaab9cd85025a8b3916948c69fe173c837ea	0	0	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	3	83611600	0	32	2023-04-23T22:53:11.000Z	0xaadea54c6974d914999364584f063dd1355e79428053c2109a9962f57fa9e49f
1	0x237620283242871979baea07ff110d32f80579cc	0	1	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	15	83420019	70900	73475	2023-04-23T09:27:25.000Z	0x225b06d2a6c14cb196f27f9ff45314e20d11fb73d408d961511767f85a0832e0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_arbitrum.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
82609621464991	0x114de2affc6a335433dbe9d3d51a8f31a5591fdf	79420464349784	85928045840212	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	8	36842295	2022-11-10T06:59:28.000Z	0xa93db288267b32bc9e81dd5f2f7dffae1619f6845b85c7b6da135901e54b3944
7041283178153269	0x114de2affc6a335433dbe9d3d51a8f31a5591fdf	6770254151323590	7323267149696579	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	9	36901603	2022-11-10T11:35:35.000Z	0xd62ac3fb5a30f690a43b41566343aa017300aa7193235483a5663e8528d3609d
1297418430027772	0x114de2affc6a335433dbe9d3d51a8f31a5591fdf	1247697524821439	1349140329650667	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	9	36952605	2022-11-10T15:25:12.000Z	0x9316b5e3bdd8897f7896b1601ab7fa53bdf78ce614b4e5c8a2f767cd871d81cf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_arbitrum.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
0x35758351bdbb30b0704e472ec36e6887ac0d794e	0	21549171901660710057855	false	0	215491719016607100578	0xf3fc94c4af077986490fdff25bb4953a3b7bdb1c	17	68957607	0xf3fc94c4af077986490fdff25bb4953a3b7bdb1c	2023-03-11T21:50:09.000Z	0x8172c110e331d0d832f5adc35a35a319a41e29d79f4793a3005f913f375f20f5
0x204f0bc0b6bb5507b06614478720bb46b0bd9138	2316067361057301936	0	false	6948202083171905	0	0xec451294b453fa611a2e837d5373e7e12aa5ff37	11	406267353	0xf2a3555584c6e20b288094b137f670472ec1bb9c	2025-12-02T03:56:51.000Z	0x41ab8bbd9490e9b26c36e40cbda5fa2faa70afc78ec34a4f9547101294aa4415

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_arbitrum.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
133670291893422	0x04c5e5c496fba29ba74043aa23827e30424c38d2	65999893432295682540	68617	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	9	22330523	-369486	-368333	2022-09-01T11:52:24.000Z	0x947b79584b5653587ecbcc23dd0d0ba440b9364c2b2080ddb7dc920175cf89ff
414481566776	0x4303dbbd7175294609fc498b9d7677f05295856a	3167607032226393	4650509	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	4	22278406	-210240	-196380	2022-09-01T04:15:48.000Z	0xb82ce1a15cce00d0cfac9e24f758279019297c1cd5a9cdd147deb1201d034071
27043866502	0x087abaab9cd85025a8b3916948c69fe173c837ea	15055797	11979892	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	27	57016322	-9	11	2023-02-01T00:18:03.000Z	0xecdf7c611aebc9beeda92fbf50f4eb4c24bdd669fb0e1c4aa563595ee990a0c3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_arbitrum.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
0xb100ba0b98b6d997fbf95c0c051ae66d79bd07b3	false	20893618404693123843867	0xc1e7dfe73e1598e3910ef4c7845b68a9ab6f4c83	21	87184072	19949970492426265574	-8990275	0	0xc1e7dfe73e1598e3910ef4c7845b68a9ab6f4c83	-302984	2023-05-04T10:44:44.000Z	0x489df760a9ca3fcfe4f18d27788f1b26edc3ce091e4bb05de28f61187793d925
0xb100ba0b98b6d997fbf95c0c051ae66d79bd07b3	false	25784494565257309578511	0x0000900e00070d8090169000d2b090b67f0c1050	14	87184073	-4284719178591589399	371494	0	0x0000900e00070d8090169000d2b090b67f0c1050	-298777	2023-05-04T10:44:44.000Z	0x438aedce73f70612284ef81b302963c888eac3e6f3120c03a165da8680ccf7db
0x1729335cdeb0dbfe5ca1ab11c09adc79242d172f	false	49851661024983407599261	0xb3701a61a9759d10a0fc7ce55354a8163496caec	17	87129376	-60003731067043743113	23902552	9487060375839259	0x24704aff49645d32655a76df6d407e02d146dafc	-285591	2023-05-04T06:57:50.000Z	0x529e2ddb6ac91068a4c21ed8b66b9c3ef24dbe9c344979106da8b4dcd3230ab0

Example Query

Query with partition filter

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