kyber_v3_optimism

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	0x7ec31b73fbbdfa0b0f57b75191c0934aed81d92a	false	0x4200000000000000000000000000000000000006	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0	100860216	2023-05-23T20:49:18.000Z	100	10	0xc8f40110cfa11de0630d95416ed3c9209d27b48c579ad181910d5cfda2c441f3
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0x006106a90563a398e66add382fe26e2661210c09	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0xeb466342c4d449bc9f53a865d5cb90586f405215	46	105366499	2023-06-09T17:29:35.000Z	40	8	0xf8a7d8876c042121f85d98546fb94393837b093b898f16b89d2fa63a4e3577e4
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0x64ece27b9f0c0356aa61cb387410718bed6eb881	false	0x4200000000000000000000000000000000000006	0x4200000000000000000000000000000000000042	2	105362640	2023-06-09T15:20:57.000Z	5000	100	0xc85bbf731b40befb1a0b9cc95a15ada1b8d54f64a2366f74aee2e1aa8f1c8df5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_optimism.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
36562110592218179082	0x10f6a9448a070c7267bd1bb16170b9f4a568794c	594903048573914185	45410934858260676052	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	5	113543379	-4600	14900	2023-12-16T00:12:15.000Z	0xa387536acd468be2f116244d7e9a5a6c03a640db16b2f010e4ce6ac18003ada1
830974447769815122543	0x225b3c06ec4cdbdfa239b979c53c000bdc403d89	0	34501831080484258665	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	18	113576436	6200	6800	2023-12-16T18:34:09.000Z	0x15cb86c3d87cf70fe031cf87fd1031d286ac97feae06520298f059a6c39eb60a
403782405610450138274	0x225b3c06ec4cdbdfa239b979c53c000bdc403d89	0	12664430246582754426	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	136	113576480	8800	9200	2023-12-16T18:35:37.000Z	0x5e2df115fad472c1982ce40b6cb70da9a06eb836abcf56d10bba2b298cc5d61e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_optimism.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
25692604257095430329	0x0e2b7bc3095aaca6df3c107cabf4f5146bc3b343	758574556033144762	892371335294052586294	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	38	107565155	2023-07-30T14:58:07.000Z	0x3b6c7348c968bfbc04468665264b78449fb1387a920bb4d0dc6ae755435b8106
943954379230445105	0x0e2b7bc3095aaca6df3c107cabf4f5146bc3b343	27705698571210835	32976836394514214609	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	38	107554710	2023-07-30T09:09:57.000Z	0xff508b1259698106ee86af93032b8a3b8dfdf18f6a6aa33ad6714d79a6304763
1140999173292413368	0x0e2b7bc3095aaca6df3c107cabf4f5146bc3b343	33573206294782933	39768181953267247763	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	36	107575838	2023-07-30T20:54:13.000Z	0x5b96fb479aeee4f6a4bccfa6fcbeb317ffe3cc394e2d7b6970c48f79350e4c17

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_optimism.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_qty1	removed	in_paid1	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x9ba7b142ea73c8d1560e47296f169d6c748d89ae	20727913799742886000	false	1658233103979431	0x00b3d330e646fdc8da390e43d85b998a5b1f189f	39	111731670	0x00b3d330e646fdc8da390e43d85b998a5b1f189f	2023-11-04T01:41:57.000Z	0x257eb9e1c464acd2d2c398c3b0d413ac41c33094ae0cf93ac105271cfa8df2ac
0x9ba7b142ea73c8d1560e47296f169d6c748d89ae	7238329717056645000	false	579066377364532	0x00b3d330e646fdc8da390e43d85b998a5b1f189f	24	111731673	0x00b3d330e646fdc8da390e43d85b998a5b1f189f	2023-11-04T01:42:03.000Z	0x0e99930bd3344c1b5e2e4b8c5b06efdd40930a1e2284a5d3626d6c01dbb97726
0x9ba7b142ea73c8d1560e47296f169d6c748d89ae	7843522587168298000	false	627481806973464	0x00b3d330e646fdc8da390e43d85b998a5b1f189f	21	111741721	0x00b3d330e646fdc8da390e43d85b998a5b1f189f	2023-11-04T07:16:59.000Z	0x74e4d0c692becb811420b02a7e8a173286d1680830ab290a6863e852e712187e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_optimism.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
162852432898	0x006106a90563a398e66add382fe26e2661210c09	112623571	82726362	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	94	106179787	-8	16	2023-06-28T13:19:11.000Z	0x55549427739d1481d4a7fe57ddeff0fe2e023553a9ef5759fd55bfa1c6e26d1a
67229001753	0x006106a90563a398e66add382fe26e2661210c09	46484524	34160150	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	16	106177875	-8	16	2023-06-28T12:15:27.000Z	0xc9cd7535a3e1bac77f1f4cd967f3fd7eaf8c882144df385bf8c91cc514dff7d3
21581993463174693045664	0x0e2b7bc3095aaca6df3c107cabf4f5146bc3b343	1181000000000000000	2389848474945134372920	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	17	106166138	72700	72800	2023-06-28T05:44:13.000Z	0x42fdf41537c9b206b2235278d96b7e16c1dc1f78bb4fe8bd6fa000ebbfe91ef4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_optimism.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
0x9766b7fa623a65dfe56d9788c2d39ab4718c80a6	false	79223060296177820596684608066	0x4bde8be121d80349662cb98be900d5d03a78cacf	7	102456461	-3003541986	3003393795	5550576773830274	0xc2995a065106b5c5c738b2320387460ebd12c12d	-2	2023-05-29T00:07:14.000Z	0x5dbf63babf05bbc8c7fd477e8c17f74809192c4e1ea53ec12b6eb99b53e9e7ac
0x7ec31b73fbbdfa0b0f57b75191c0934aed81d92a	false	3457045372477934214201648	0x4bde8be121d80349662cb98be900d5d03a78cacf	3	102513449	27500000000000000	-52315173	6631830114943634	0x7892d498f22c9393385f4a798788126f7090d2cc	-200804	2023-05-29T06:28:00.000Z	0x10174ef0a95df5c49976fbba32cb4c6983b4df8c448108ecb85e29150615cb21
0x683860e93fab18b8e2e52f9be310d9b36b49677a	false	3441565025268960169718886	0xf9c2b5746c946ef883ab2660bbbb1f10a5bdeab4	5	102679187	-256341445155743977	483748316	40324106523640017	0x731efd6cf4504154ec7268ac5152f1d279191f8a	-200894	2023-05-29T17:42:16.000Z	0x10a9ec3550710f7a6c14c11532855bf81f77bcf3586d8433826ca13a3c45b615

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_optimism.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	block_number	block_timestamp	in_swapFeeUnits	in_tickDistance	transaction_hash
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x2a4d93eaa67f3f3781301a4b27cf45539b758599	false	0xdfa46478f9e5ea86d57387849598dbfb2e964b02	0xfe8b128ba8c78aabc59d4c64cee7ff28e9379921	83058029	2023-03-23T02:42:13.000Z	2000	100	0x04e95d0a619bd4a24183802f6c22cc9935cc3233d80d1054727b1fb1812e18f3
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x91de93402f78e556e3f57ccd8eaa776d3442342e	false	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	0x9bcef72be871e61ed4fbbc7630889bee758eb81d	66965244	2023-01-15T05:40:20.000Z	1000	200	0x0e6e964b92d3a27f7cad7d96a4ed8adb97297b4189d6accd80f91fd264fb1b4f
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x170be7b68513d25bd7a979baac4d1a1da7d94324	false	0x4200000000000000000000000000000000000006	0xa00e3a3511aac35ca78530c85007afcd31753819	23433221	2022-09-16T14:31:23.000Z	1000	200	0x93b7ea848a9d824c53930168233b310dd691c7afa75d09a9b7e691066a1be661

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_optimism.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
73478653331092907	0x23eea91e9c051122a7dc1fdd6afdaa40f1e45d64	999999999999999	1002127601397081200	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	2	43774828	62200	85200	2022-11-30T06:44:18.000Z	0xc5aa981553f161d0809c6e043b9643ecf84ca853c7811174caa7dec042fec653
1	0x427464d9434f99a3d942c60210ee2376166975ce	0	27	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	3	43984220	276324	276325	2022-11-30T18:27:24.000Z	0x9f80f1d71815c305bf8029c0fffd0aab68084c009a45302bcbf36ccc7448a436
1	0x427464d9434f99a3d942c60210ee2376166975ce	0	27	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	3	44042899	276324	276325	2022-11-30T23:32:12.000Z	0xfa9a014422c0d263a3e51368bfef33ffd0a2529bcdacf7bb696ba413f1dcbd94

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_optimism.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
99211558314164355	0x28bc0a25dc9581cfd9920ad0d273c006270e00fa	2248802402357474	4498943360323101052	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	9	74231436	2023-02-14T07:30:36.000Z	0xee6f42310f655a8ce4ad61f4e2347691ba640b2ce2baaef00cbfc498c41a5003
638300626199	0x32d84fe7ec28e18db25dea34eb88f6e6002cc6f6	638465	638149255487042430	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	8	74213290	2023-02-14T04:54:48.000Z	0xc2e1de44c16398806cfe472151f19724ed6c3f92f0998733efbfbbad7c6beead
2423682058142064616	0x5047a457901c03afe24da1ccbfde1c767dcd071f	2765374562631076343	2161808613225761989	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	9	74380108	2023-02-14T23:17:53.000Z	0x1d7aae295afeebbb4f9e80d4a553504e22abc7de226c12687d200189b8486653

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_optimism.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
0xda74db17023750d02b83be2559a4eaa013b65c54	0	150400774720018456	false	0	15040077472001	0x077543ab8ec393d9180a3d0c6012da869eadfbe5	58	75225684	0x077543ab8ec393d9180a3d0c6012da869eadfbe5	2023-02-19T00:23:07.000Z	0xc422de9b748c359d34e368ddc214b199dfdd04cc84501a186c134d208492a1e2
0x9ed87916f525b0981325ab42f1b1242b8b8238b5	50000000000	0	false	4000000	0	0x077543ab8ec393d9180a3d0c6012da869eadfbe5	34	81808366	0x077543ab8ec393d9180a3d0c6012da869eadfbe5	2023-03-18T03:47:48.000Z	0xc79346e984a832fe12367fbe55155bee6057d5ce9a0c0652812b264defb58b2d
0xda74db17023750d02b83be2559a4eaa013b65c54	0	100000000000000000	false	0	10000000000000	0x077543ab8ec393d9180a3d0c6012da869eadfbe5	34	85045114	0x077543ab8ec393d9180a3d0c6012da869eadfbe5	2023-03-31T05:26:08.000Z	0xdd00ba60bc0e81f12b10ad367b50c02755e8e4cb05bbb7a2b7ae0919562377e8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_optimism.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
4309598830583650801812	0x2a68e3830071d65b07fb3a1fd59543e0839d504d	563516376080945871	797333389750338565962	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	3	81947946	75800	76000	2023-03-18T16:40:37.000Z	0x0ba1d6ab9feeec14947f62c48ba43c80dd90bc2a715f1c56b021578685f8209a
612637404795297308637	0x2a68e3830071d65b07fb3a1fd59543e0839d504d	84266845928339887	104505795413764903532	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	3	81810431	76000	76200	2023-03-18T04:02:22.000Z	0x04d51d7b725f053e7480700664b64e0f6c4f6f24fd7e0c43ae79d8c11394f8ce
612637404795297308637	0x2a68e3830071d65b07fb3a1fd59543e0839d504d	84266845928339887	104505795413764903532	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	3	81810306	76000	76200	2023-03-18T04:01:52.000Z	0x35fe529da17512636f50ac20a17bb4cf48e1a3d08d455528caa5bbd45091e359

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_optimism.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
0x381db320dc534209ff93348b281e86c256ba09dd	false	79257508886705326391510550180330399	0x122ac641994c217a84baab438637a2df7b26e103	5	105600331	-229402647	229565560186787102382	1754750817914906743	0x122ac641994c217a84baab438637a2df7b26e103	276331	2023-06-15T03:23:59.000Z	0xb4188721185b5c83f6838a7bbaca37dd25110436ad3fa6f8940f014115993f63
0x381db320dc534209ff93348b281e86c256ba09dd	false	79279789159159459536859005588851771	0x1aa298ae7c53d8dafa200ed49608649bfa76a446	47	105631167	-27482748	27520897933386951610	1754750817914906743	0x1aa298ae7c53d8dafa200ed49608649bfa76a446	276337	2023-06-15T20:31:51.000Z	0x073b0d48452d4d0a07761db1bc9a6d92da2fdacf088095553619d1e36e469a16
0x3f676045603b4b17d37a5f2afab3249c1930453d	false	3340268909584832739594181	0x1aa298ae7c53d8dafa200ed49608649bfa76a446	38	105623345	574891275416	-1020	13919935932	0x1aa298ae7c53d8dafa200ed49608649bfa76a446	-201491	2023-06-15T16:11:07.000Z	0x8da9e7a5e2b1d337894f89c0496cbe4a8d6d83dcbab2d0f2182e89d53264ed9a

Example Query

Query with partition filter

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