kyber_v3_fantom

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	block_number	block_timestamp	in_swapFeeUnits	in_tickDistance	transaction_hash
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0x6993d01c7a99bebcbcb04efbbf106bfa69273cb2	false	0x1b6382dbdea11d97f24495c9a90b7c88469134a4	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	65808953	2023-07-14T20:45:46.000Z	300	60	0xba39fea183a0615f61feca6f9e9599d1baca063cfa8e4de485e1833a15a10ecb
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0x9019fda2bc40ac05798a9f08a5620925a940fe31	false	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0x8669b2bae36561c2c8ac1e8af39a9cd34dc21b55	65818751	2023-07-14T23:41:55.000Z	300	60	0x53650f51ce9efdb4936072a8d54398a2492cefc4e188f0fe14451ad4d7768112
0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a	0xa3b2e6bd9962c8a25e5f763bde5184082b2896f0	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0x8669b2bae36561c2c8ac1e8af39a9cd34dc21b55	65817615	2023-07-14T23:19:50.000Z	300	60	0xa63619bb485230e28951d4470d9f13e57d426aa0507da97274ef955fe838a6c5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_fantom.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
145978552045819111427	0xeb5ffdaabc50b32a20b24e415f34fe9fef913a73	9456150342348204155	0	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	163	69124315	9500	11700	2023-10-08T17:07:57.000Z	0xb93d2a880e12ec77ec884778e94e7032952e4044b54a7d02a171c2c9dab9db47
875697182433991	0xb76d3ef99d06ef1a7334dd5c1fe8d533023a9e89	0	382322348446269132547	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	2	69115036	286800	291400	2023-10-08T10:39:23.000Z	0xbe782d30dab03880003787c210eb5779b8f59bf39a258e6637e359c629e140a6
9515752609572453356074	0x0a7d1349d7bc8bb353bf5915d644b5582932f1ff	0	400151093792613859382	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	3	69115062	600	1400	2023-10-08T10:40:24.000Z	0xab02078c4a0a7303936fb4957ebec424223a140268d3badda59691a357e5a28a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_fantom.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
34259513993	0x2a5f7550f8ef2dce85a4ab368a54c0403b26653f	31192	37643324795772870	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	28	64409456	2023-06-20T18:36:29.000Z	0xa30917f237065b15b3447f4466e185619ca1a2a27e43e0beb110a85f0f41a3bc
1709370846507	0x2a5f7550f8ef2dce85a4ab368a54c0403b26653f	1527027	1913855919342498569	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	10	64406975	2023-06-20T17:50:24.000Z	0xcf4769eb7a87cbc793fe185c6034415ac35a9342893d667c3defbe62f17099d4
106011765842793051	0xc5a4af7ec019546026085f4b84b3f472873a6814	97267288295342674	115550325055695026	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	105	63809083	2023-06-09T07:01:03.000Z	0x0c5b6154db7868bb563e574353788a8050ae2578f91537efff3f09f097996a82

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_fantom.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
0x2a5f7550f8ef2dce85a4ab368a54c0403b26653f	318063087784709500	false	3180630877847095	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	37	67989975	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	2023-09-08T21:35:35.000Z	0x50bdd343c433c03c83a3faf7c170bf43ea8d2e874050943393f693ea641ad93b
0x2a5f7550f8ef2dce85a4ab368a54c0403b26653f	304574018435982400	false	3045740184359824	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	44	67271477	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	2023-08-21T22:45:14.000Z	0x30b35f725d2e599b4a21194d2c9cd6fa4b224d2294e90029091baf81f09c46ce
0x2a5f7550f8ef2dce85a4ab368a54c0403b26653f	135366230415992180	false	1353662304159922	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	35	67271470	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	2023-08-21T22:44:56.000Z	0x260ea5ada202771e3d71e39ddb1281811e354b3c52c881907af73a868295663a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_fantom.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
3846467269132	0x0a2a91b6063a08f516496f7e618dc6e672592db7	6280122837364186795	11653	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	16	65152184	-347100	-344040	2023-07-05T07:35:08.000Z	0xa501c645c35435b3f99cef24f7483497051ec499dfd16b8d3e7ddc7e21880458
7906555627214	0x0a2a91b6063a08f516496f7e618dc6e672592db7	49947235231424388246	309	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	17	65170098	-345600	-341160	2023-07-05T16:33:27.000Z	0x76d7b20de47678df4c97afdd75590ff4eaa19f1d1aa1e3997ec6f0ee5009c55f
14452279035850	0x0a2a91b6063a08f516496f7e618dc6e672592db7	0	98695	false	0xe222fbe074a436145b255442d919e4e3a6c6a480	0xe222fbe074a436145b255442d919e4e3a6c6a480	15	65169834	-350520	-345600	2023-07-05T16:25:47.000Z	0xde1be62e4c7c5744c31f42aee3d4dc672d172c5a892b26ce3de656174e93ef55

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_fantom.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
0x18207a891042cca54b0fa78d4569d7eb2e5bf797	false	320263961502755639056342847810835003	0x06e14af4abba8f7dfd1f10909fe446bc01ce3a73	66	64106395	-9814785	160126615663508895407	9760486656077147	0x831cda98ad2defb7af03156c6a1ab623c9220131	304261	2023-06-14T18:15:16.000Z	0x67a29d0d33c2c3b38e5ca7a8fc91a1dd0c9d54e9324ef3f9338a2fe9dd394a9c
0x18207a891042cca54b0fa78d4569d7eb2e5bf797	false	325799584921377390878441565240161718	0x06e14af4abba8f7dfd1f10909fe446bc01ce3a73	12	64114591	-10496617	177158699619549713654	9760486656077147	0x286ab107c5e9083dbed35a2b5fb0242538f4f9bf	304604	2023-06-14T20:46:09.000Z	0x56888be9353b3b707baa40c84a848f6c4fe3939c876bb43516ff39e6bdf76056
0x7210aa69813e9bfbcd0745d61226859ffbc8ecb6	false	767652961364418824533248118765	0x06e14af4abba8f7dfd1f10909fe446bc01ce3a73	26	64071434	95331405531842412544	-8891803830939322284784	256971913732343183199259	0xb66e5c89eba830b31b3ddcc468dd50b3256737c5	45422	2023-06-14T01:04:09.000Z	0x900df0f4374e6e1bebf444ec07dd9abf6a1ec1f5dbb373b02012d9f1c8bee4f6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_fantom.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	0x90e8ac6382bf4f0bfd58f0b1e074498d9caab2fc	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0x66eed5ff1701e6ed8470dc391f05e27b1d0657eb	0	56080035	2023-02-19T03:15:44.000Z	1000	200	0xd3ecd869907c529923602316242c23642940715695bbf153b7ea2d8501858299
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x02529ba8a0012a4e4f935ef76295958b03ffcb78	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0xf16e81dce15b08f326220742020379b855b87df9	10	60109084	2023-04-17T02:59:58.000Z	1000	200	0x13d5e725c58fff8567a4531b847698f9796f359efc5df5c8e54e7b9466bba9f9
0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a	0x2de1b029e1d103d2815ab8518a180be8540d82b5	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	1	60101850	2023-04-17T00:53:14.000Z	1000	200	0x28c5e0951bf1097fa59e7c2afc42c70731c09aa6c573466fe9772bfb75757ef5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_fantom.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_qty1	removed	in_owner	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
1	0x1b52770b19c8777802e9720c4ad9c112f47e1ec2	0	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	2	59647444	46200	48000	2023-04-11T16:03:26.000Z	0xa8e783edad4ed33f7656cdb14286514a15f31daaf6080e5d355ee3c7686036b6
1	0x57c107bf8bab567daffb324f908e1876ff226f08	411178	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	4	59646934	276400	290200	2023-04-11T15:55:07.000Z	0x046d4f9aeaac419944f6888d99279887bc010f9e31bcdfd8763a8e97d18278d3
1	0x67d1e5dec3500e99b97e699d3fa4c9d4a8afdf00	0	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	4	59639541	-84000	-82325	2023-04-11T14:04:39.000Z	0x162c9d606220f3dd61d37274d9ff50c1f9d8b71614a72b7506a5ec71609c3a0a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_fantom.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
579588627503018690	0x7fe55b652e3f81c4fe2b508c0f1bfdf20a2342f8	577670485521856893	581514305590073093	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	18	46483467	2022-09-06T16:22:01.000Z	0x0082873f239304d8230aae6c448d6eb2d0541e6835a5e76e1d067ae9f1ab3bf6
745334296479368675	0x7fe55b652e3f81c4fe2b508c0f1bfdf20a2342f8	742891530027686440	747786535494893904	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	62	46473125	2022-09-06T12:14:12.000Z	0xdac20d7ff756100e20907e4c3616b6a62e500de6f7862c8871a736e0e1d33624
420991547513546030	0x7fe55b652e3f81c4fe2b508c0f1bfdf20a2342f8	419627921821731156	422360464767285041	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	10	46489468	2022-09-06T19:27:28.000Z	0x202c5385a8db04e3c7aee24532bade9eb2d133aee8224871a999b8033a63bde8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_fantom.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
0x65656e7a0a3ec47f5cc6d10eeb31235d7489e5f3	0	261303479312621040000	false	0	104521391725048417	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	58	59437125	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	2023-04-08T22:57:02.000Z	0x6ae4862e79395d4b9ea7a6b470902823d4f4524f9d2a82e71a7785741dc5af64
0x65656e7a0a3ec47f5cc6d10eeb31235d7489e5f3	0	711022997878940100000	false	0	284409199151576041	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	107	59422371	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	2023-04-08T18:52:21.000Z	0x9a072fc30f7954aaee274253fbca546522333d3c9ced4cd23002f76390cb3af1
0x8dcf5fed6ae6bf0befb5e4f0c9414c2cb9a4ed01	30678898	0	false	3068	0	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	32	60332528	0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e	2023-04-19T23:17:05.000Z	0xda99562bd743e606a14cb34fe75eaf8eb0959b44774f522f53d9425f6a052765

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_fantom.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
144522748182622668904332151	0x0abf6f06552abb62f195e55f9ae370defe2ebf34	7336257916368860422234	0	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	62	48355277	-304	-303	2022-10-03T23:46:36.000Z	0x1c884348c1824490617fb4ba8ad922b0f72846af01f90631395c9a670d3bbd05
4407894115832	0x31a1b84245ac12d40a1ade5921f891290043b0d6	2191220199	2215351891	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	5	56934902	-10	10	2023-03-04T15:01:41.000Z	0x74d0f5e6b8f45578cbae300b8161b04972c38843150345e0e71e6715fbe00e85
4410562360487	0x31a1b84245ac12d40a1ade5921f891290043b0d6	2216311764	2192927768	false	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8	4	56907518	-10	10	2023-03-04T05:17:07.000Z	0xa2580a81053aabe7b44e6fb48be1594ec782b77444d91082e8ea615cc30c4e7b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v3_fantom.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_recipient	in_currentTick	block_timestamp	transaction_hash
0x9cd63066a381fe1b2a271d00add7bdd27c52fd4c	false	62008774753953949918091615279	0x06e14af4abba8f7dfd1f10909fe446bc01ce3a73	28	66596074	4462282963780512790	-3315884983227239542	0x06e14af4abba8f7dfd1f10909fe446bc01ce3a73	-4902	2023-08-04T01:12:26.000Z	0x235452ff7d9645acc1c101354384882f8c1a9949d4c7a4c23bfca4ff69e122f3
0x57c107bf8bab567daffb324f908e1876ff226f08	false	67602387619930178302498771759822963	0x2de4133d5de12561f22c2c740a7bab40e3ef6ca1	23	66623897	-5474781	4000000000000000000	0x2de4133d5de12561f22c2c740a7bab40e3ef6ca1	273150	2023-08-04T20:11:20.000Z	0xf90fc4d245e5e7597acd6e6c0fdcc4fcfbed37d620b09b5b0fdbdb95ec34394b
0x57c107bf8bab567daffb324f908e1876ff226f08	false	66717702496052457202830179357457946	0x2de4133d5de12561f22c2c740a7bab40e3ef6ca1	95	66618478	-5621428	4000000000000000000	0x2de4133d5de12561f22c2c740a7bab40e3ef6ca1	272886	2023-08-04T16:49:12.000Z	0x8e92e0b6148de1577f3b049a4fd620aba08c53af75b1ebabf00972f3421e0571

Example Query

Query with partition filter

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