kyber_v2_polygon

Tables

DMMPool_Swap_event

KyberSwap Dynamic Market Maker (DMM) pool swap events capturing token exchange activity within liquidity pools. Records sender, recipient, input/output amounts for both tokens (token0/token1), and precision-scaled swap fees for DEX trading 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_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeInPrecision`	`STRING`	Swap fee amount expressed in high-precision fixed-point format. Stored as decimal string representing the fee scaled by a precision factor.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount1In	in_amount0Out	block_timestamp	transaction_hash	in_feeInPrecision
0x0000072d6627254ae3ae5cd95ceae4f5268f620b	0x2536158c73eb74063d36fc2738ac3fc6e78daa4f	false	0x546c79662e028b661dfb4767664d0273184e4dd1	188	32396837	240701677591161222725369137	1370208533535551831	2022-08-28T01:24:39.000Z	0x03a9e6e2a07bd1cbe74c3696ed908c20de32c1268fad65530c1e2f7ed8503c9d	1503833647978477
0x0000072d6627254ae3ae5cd95ceae4f5268f620b	0xecf185d8114664e42dae0701eaff1a50a3613a05	false	0x9abfc1d5005a66652a704959712d9d63978f73b0	211	32413172	15030373471360100563932	441832	2022-08-28T12:46:08.000Z	0x34f03f291249563a1d5fd4cf799c32228ef18c8a2590a2ae288cf029e69d7aba	3758801959338999
0x0000072d6627254ae3ae5cd95ceae4f5268f620b	0xecf185d8114664e42dae0701eaff1a50a3613a05	false	0x9abfc1d5005a66652a704959712d9d63978f73b0	171	32415992	1217408019234673017555738	35833928	2022-08-28T14:52:56.000Z	0x6beb10340bf301281543338a6918cc4591530116ea80123b3d479ddb330fdba2	3408666331191938

Example Query

Query with partition filter

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

DMMPool_Sync_event

Kyber Dynamic Market Maker (DMM) pool synchronization events emitted after reserve balance updates. Contains actual and virtual reserve amounts for both tokens in the pool pair, used for tracking liquidity state changes and amplified liquidity calculations.

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_vReserve0`	`STRING`	Virtual reserve amount of the first token in a Kyber liquidity pool. Stored as decimal string representing the smallest unit of the token.
`in_vReserve1`	`STRING`	Virtual reserve amount of the second token in a Kyber liquidity pool. Stored as decimal string representing the smallest unit of the token.
`in_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x75682f76c9056dca273176bad1cad24a2bbd2615	false	255	1582826992	111924010867859111747933	43843095	2023-06-12T23:09:44.000Z	0x0798e8fe91ea8421617dfbf7eeb7cdbcf469918cbdca53d3e9e419a61d3a7ecd
0x75682f76c9056dca273176bad1cad24a2bbd2615	false	408	1579183814	112181831234859143167383	43833787	2023-06-12T17:08:25.000Z	0x7b81b9aedb6fef4c99193ac7e87e1ee17467a24866a54a99a0c7bc446c7de679
0x75b64428086fd78f480b1e05a8ccfd8071994fa9	false	442	201884590518207839221	127968714	43837425	2023-06-12T19:27:48.000Z	0x824e524cc81782010477036ace220b2d3d5b7eeb7d4972de470111d89af41c1d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_polygon.DMMPool_Sync_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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_ampBps`	`STRING`	Amplification factor of the liquidity pool expressed in basis points (BPS). Numeric string value that defines the pool’s price curve characteristics in the Kyber protocol.
`in_totalPool`	`STRING`	Total number of liquidity pools created by the factory contract at the time of this pool creation event. Numeric string value that increments sequentially with each new pool.

Sample Data

address	in_pool	removed	in_ampBps	in_token0	in_token1	log_index	block_number	in_totalPool	block_timestamp	transaction_hash
0x5f1fe642060b5b9658c15721ea22e982643c095c	0x5e9bd3744dfa441549c37c6c05963e7830e6fc50	false	60000000	0x344ed19c1014511e5d3d8551c5bce779b2ec7aaf	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	201	29148307	659	2022-06-04T08:45:42.000Z	0x6c56ad3dc3f0ed599e9fbd32d9cbb95f433fee3c58c0e9e204c56a864334fadd
0x5f1fe642060b5b9658c15721ea22e982643c095c	0x038f72184c2eff16de5da383c8de125d9eaf41a0	false	15000	0x15e99d827c1d2fc2b9b5312d1e71713c88110bdb	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	169	29158178	660	2022-06-04T14:36:02.000Z	0x15203cd16b5512053f266c2e296b7d02e73e1858b1ad9358f4a494d1f0c3d327
0x5f1fe642060b5b9658c15721ea22e982643c095c	0xa25d20fee9badb427b10683d94331940a4808340	false	11000	0x6d34ec0a46c66364fa326c08976c711dd57483ee	0x7d645cbbcade2a130bf1bf0528b8541d32d3f8cf	143	26139606	494	2022-03-20T06:54:43.000Z	0xbc55004101258f78a3a133ce6f25a7d1b18eece8cd4fabec299ac304da5caf7e

Example Query

Query with partition filter

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

KSFactory_PoolCreated_event

Liquidity pool creation events emitted by the KyberSwap factory contract. Records token pair addresses, amplification parameters, fee configuration, and cumulative pool count for tracking DEX deployment activity.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_ampBps`	`STRING`	Amplification factor of the liquidity pool expressed in basis points (BPS). Numeric string value that defines the pool’s price curve characteristics in the Kyber protocol.
`in_feeUnits`	`STRING`	Fee charged by the liquidity pool for trades. Numeric string value representing the fee in basis points or fee units defined by the Kyber protocol.
`in_totalPool`	`STRING`	Total number of liquidity pools created by the factory contract at the time of this pool creation event. Numeric string value that increments sequentially with each new pool.

Sample Data

address	in_pool	removed	in_ampBps	in_token0	in_token1	log_index	in_feeUnits	block_number	in_totalPool	block_timestamp	transaction_hash
0x1c758af0688502e49140230f6b0ebd376d429be5	0x6b593b2c38938a6f62145eac063dcde0c74ba8b3	false	20000	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0xdddca1d1fd4e72b85b7b95f07651ab36b62f69e9	163	8	31604303	24	2022-08-06T23:50:02.000Z	0x1d7ad9574c7fa4ab7d5c423334417d529b014336252191b51048ac97eaa965dd
0x1c758af0688502e49140230f6b0ebd376d429be5	0x7e843450bf4f0be50b177ae1598b271b8210d3a7	false	20000	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	0xdddca1d1fd4e72b85b7b95f07651ab36b62f69e9	200	8	31604473	25	2022-08-06T23:55:50.000Z	0x2ab69c0de8474726f536f1690ce2cf27ad41cdb320b29c971d83141fad44c15d
0x1c758af0688502e49140230f6b0ebd376d429be5	0xcb7d96c88bb71524143c1c70893e3522b4c6dc71	false	20000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x3a58a54c066fdc0f2d55fc9c89f0415c92ebf3c4	148	10	33647785	66	2022-09-27T22:55:48.000Z	0x7c7b838777816ba70267662cbb4d230bbf18fa149a218d59a348cb7f6490320d

Example Query

Query with partition filter

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

KSPool_Swap_event

KyberSwap pool swap events recording token exchanges within liquidity pools. Contains input and output amounts for both token0 and token1, swap fees, initiating sender, and recipient address for tracking DEX trading activity and volume 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_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeInPrecision`	`STRING`	Swap fee amount expressed in high-precision fixed-point format. Stored as decimal string representing the fee scaled by a precision factor.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash	in_feeInPrecision
0xf62985bf237c2bd8402ec423c79c7abdc1244fd7	0xc2c0fd360c66db3f1e2e7888a3c6933ada6c260f	false	0x332a2f53664424e110bf7b9967ef66e727e62f3d	266	53672471	0	110441711387681950065	3953628784230631308	0	2024-02-18T15:44:49.000Z	0xd4c5f497d6340706cd4c91b8222ca1b93118f6688accf878f7590d8eed1e87fa	10000000000000000
0x332a2f53664424e110bf7b9967ef66e727e62f3d	0xc2c0fd360c66db3f1e2e7888a3c6933ada6c260f	false	0x332a2f53664424e110bf7b9967ef66e727e62f3d	1324	53672666	502888832033663744	0	0	14531621939660557465	2024-02-18T15:51:43.000Z	0xa5c4580f6071545cc5a380dbbafd115bf5bf0448fff3ee1f120d10597636fd50	10000000000000000
0x332a2f53664424e110bf7b9967ef66e727e62f3d	0xc2c0fd360c66db3f1e2e7888a3c6933ada6c260f	false	0x332a2f53664424e110bf7b9967ef66e727e62f3d	174	53673738	508140631700187075	0	0	13606332174561123276	2024-02-18T16:29:50.000Z	0xd9497e2499d79819637856b0f13d6cf189462e733a2992749340b6ac1f807421	10000000000000000

Example Query

Query with partition filter

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

KSPool_Sync_event

KyberSwap pool synchronization events emitted when liquidity pool reserves are updated. Contains actual reserve balances (reserve0, reserve1) and virtual reserves (vReserve0, vReserve1) used in Kyber’s dynamic market maker pricing mechanism.

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_vReserve0`	`STRING`	Virtual reserve amount of the first token in a Kyber liquidity pool. Stored as decimal string representing the smallest unit of the token.
`in_vReserve1`	`STRING`	Virtual reserve amount of the second token in a Kyber liquidity pool. Stored as decimal string representing the smallest unit of the token.
`in_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	in_vReserve0	in_vReserve1	block_timestamp	transaction_hash
0xdbacd060f23858f289111e85674472d9e7d94d9a	false	60	1010903049232719635393	5844504790821344539651	37994245	45010903049232719635393	41088504790821344539651	2023-01-12T18:06:04.000Z	0xc8b4806401ab57b39efc2ba5d2a0f8cd2b9d0d880fe6e2ddb575475336c405c1
0xdbacd060f23858f289111e85674472d9e7d94d9a	false	266	1076809915218062061519	5784127787633004239445	37994241	45076809915218062061519	41028127787633004239445	2023-01-12T18:05:56.000Z	0x6e158f77a149d118823a437ddca6f4a0d9b5ada1c52944400c3ac1328be150f9
0xdbacd060f23858f289111e85674472d9e7d94d9a	false	160	1116645876744715368898	5747719924420087995479	37993985	45116645876744715368898	40991719924420087995479	2023-01-12T17:57:08.000Z	0x7d630910ba4b8afd01f5133e0ebd9703bc60ed86fa7328ce2df490000199175c

Example Query

Query with partition filter

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

RewardLocker_Vested_event

RewardLocker vesting events emitted when locked reward tokens become available for withdrawal by beneficiaries. Records the beneficiary address, token contract, vested quantity, and schedule index for tracking time-locked reward distributions in Kyber Network V2 protocols.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_vestedQuantity`	`STRING`	Amount of tokens that have vested and become available to the beneficiary. Numeric string representation in the token’s smallest unit (wei for native tokens, base units for ERC20 tokens).
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	in_token	log_index	block_number	in_beneficiary	block_timestamp	transaction_hash	in_vestedQuantity
0x063dd8b5a42aae93a014ce5fabb5b70474667961	false	13	0x0000000000000000000000000000000000000000	180	19063581	0xf9ebfe2b0c205c437214a714a28903859349cede	2021-09-13T14:41:01.000Z	0x00196368b02f539122d53d93b0eb080cbcc9cb87437760ff41ad65278c544706	10542106884096040
0x063dd8b5a42aae93a014ce5fabb5b70474667961	false	6	0x0000000000000000000000000000000000000000	173	19063581	0xf9ebfe2b0c205c437214a714a28903859349cede	2021-09-13T14:41:01.000Z	0x00196368b02f539122d53d93b0eb080cbcc9cb87437760ff41ad65278c544706	18287575349929228
0x063dd8b5a42aae93a014ce5fabb5b70474667961	false	11	0x0000000000000000000000000000000000000000	178	19063581	0xf9ebfe2b0c205c437214a714a28903859349cede	2021-09-13T14:41:01.000Z	0x00196368b02f539122d53d93b0eb080cbcc9cb87437760ff41ad65278c544706	26886996751659713

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

DMMPool_Swap_event

DMMPool_Sync_event

Factory_PoolCreated_event

KSFactory_PoolCreated_event

KSPool_Swap_event

KSPool_Sync_event

RewardLocker_Vested_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​DMMPool_Swap_event

​DMMPool_Sync_event

​Factory_PoolCreated_event

​KSFactory_PoolCreated_event

​KSPool_Swap_event

​KSPool_Sync_event

​RewardLocker_Vested_event

Tables

DMMPool_Swap_event

DMMPool_Sync_event

Factory_PoolCreated_event

KSFactory_PoolCreated_event

KSPool_Swap_event

KSPool_Sync_event

RewardLocker_Vested_event