kyber_v2_ethereum

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_amount0In	in_amount1Out	block_timestamp	transaction_hash	in_feeInPrecision
0xdfee68a9adb981cd08699891a11cabe10f25ec44	0x1cf68bbc2b6d3c6cfe1bd3590cf0e10b06a05f17	false	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	393	12721149	8922787	1547509648408629936	2021-06-28T07:16:36.000Z	0xc2314710865510a5261eabf1dd9f2640793a862eccc6436a521b0dc7e80fb3d5	2498102465058119
0x0000000000007f150bd6f54c40a34d7c3d5e9f56	0x1cf68bbc2b6d3c6cfe1bd3590cf0e10b06a05f17	false	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	330	12721134	4336507	754660062003533385	2021-06-28T07:13:30.000Z	0xcef29a32053b1cb719cddc4428e8b1659fa876b76c0b3284e1e1b3b266d0ba3f	2492304407025406
0xdfee68a9adb981cd08699891a11cabe10f25ec44	0x1cf68bbc2b6d3c6cfe1bd3590cf0e10b06a05f17	false	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	177	12721220	8561352	1477672224516174187	2021-06-28T07:34:20.000Z	0xed324dbc2a5c9b83cb5bddc6a7c9b4aa27ef28032216e9b4f5439261fc99ab6c	2850792965110469

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_ethereum.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
0x0fa8e845777e0c6d6a9f2f22c57c53a4b56a150a	false	92	83951389816430236384688	1935428140	15928923	2022-11-09T00:33:59.000Z	0x839ad84c93326fcabcb4db93de0037f521d404897907d928ba8febeb00e7afe6
0x20d6b227f4a5a2a13d520329f01bb1f8f9d2d628	false	29	615044819409020409836	475762014139883535	15929686	2022-11-09T03:07:11.000Z	0x349ad784a56a7e41a62584dc85c1877634b50da0cf969a421c23cb1618ea0bfa
0x5ba740fcc020d5b9e39760cbd2fe236586b9dc0a	false	216	126870992482872123089974	66027549126839285660	15934345	2022-11-09T18:46:35.000Z	0xeb39fcc4885c1478e90f8f1a050cdcfc5ea086440972f03ef07a6dd59c857deb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_ethereum.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
0x833e4083b7ae46cea85695c4f7ed25cdad8886de	0x908d4478b19759d4dd316a99016b4913be342672	false	10000	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0xcc394f10545aeef24483d2347b32a34a44f20e6f	213	12218525	20	2021-04-11T12:07:57.000Z	0x121766aa0e3091d45b02dab0f8e21f3d6e1720cf7fbc03f05fb6c5a651166427
0x833e4083b7ae46cea85695c4f7ed25cdad8886de	0x5d6e3ff93142aa2fc2063465e8e75b957b310351	false	13000	0xbcd515d6c5de70d3a31d999a7fa6a299657de294	0xdac17f958d2ee523a2206206994597c13d831ec7	129	12919283	51	2021-07-29T07:04:40.000Z	0x3a79ef811f209fdaecf3c0ce82c81c7881e159adcd55fa73ed1d558b643e7f48
0x833e4083b7ae46cea85695c4f7ed25cdad8886de	0x898e2fef4cef5592485251fab6da7c819a2df291	false	17000	0x656c00e1bcd96f256f224ad9112ff426ef053733	0xdac17f958d2ee523a2206206994597c13d831ec7	56	13599722	61	2021-11-12T06:31:03.000Z	0x8a53478cd1fb13b3497254a85b9eee00a1e774c8e0a311b87dbfbf305bd8a3b7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_ethereum.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	0x5cd7c1efec89f0a6bcec73ec72b69e7376ed6349	false	110000	0xbf4a2ddaa16148a9d0fa2093ffac450adb7cd4aa	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	375	1000	15228778	1	2022-07-28T04:14:03.000Z	0xe5d9b6ae073933bffcf67f0fda4f1bb523b4b8e1aba6b447143b3d39678fc296
0x1c758af0688502e49140230f6b0ebd376d429be5	0x023c2773aa71b4b1ca7d30dd11748fe32a4fa02e	false	100000000	0xa12a22395289862253f7308fdfc28d71af10a912	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	177	8	15793779	2	2022-10-21T03:25:23.000Z	0xc1c1e0b5d8f34670987073df97cd33cae3877d134ad40b9461c718a7f1db74a5
0x1c758af0688502e49140230f6b0ebd376d429be5	0x2aaf08590c5ef5fb6fe19438028cc900fa219a45	false	10000	0xb08686f3bf55a1ea172542d161a63350baf9e219	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	305	1000	17757504	9	2023-07-23T18:08:59.000Z	0xfa322aa422ff3ef7e6408b28bb79b513a60d1becc275b391902f62d0df0d6542

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_ethereum.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
0xb20f3f78253da4bd8f4a0fb5f19da23ae9cdbe69	0x6a4d5f8385ff6e7fc4ebf6f726e12a958daa1cba	false	0x9db7378614d8d9d7149c4ee4763f88c38f9b1517	189	17685194	0	22572063539850753	1349968584368	0	2023-07-13T14:33:23.000Z	0xefca9a005c2100cfc164a9b76f9b5245b686e7b2f49cae473629d1b513e0fc00	80000000000000
0x1111111254eeb25477b68fb85ed929f73a960582	0x6a4d5f8385ff6e7fc4ebf6f726e12a958daa1cba	false	0x1136b25047e142fa3018184793aec68fbb173ce4	115	17071412	0	49562500000000000	851731093434	0	2023-04-18T05:09:47.000Z	0x42abf50a3bb76f92d83b29f2587bb788a01e2234a1bb1ebc5e8d013142089ff3	80000000000000
0xa478c2975ab1ea89e8196811f51a7b7ade33eb11	0x6a4d5f8385ff6e7fc4ebf6f726e12a958daa1cba	false	0x555b6ee8fab3dfdbcca9121721c435fd4c7a1fd1	264	17072015	828305772000	0	0	48649499081336221	2023-04-18T07:12:11.000Z	0x3645310a1cddb094c5f2faf22995e85c8a303a7c15185d106c9932ca264d50ee	80000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_ethereum.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
0x93669cfce302c9971169f8106c850181a217b72b	false	265	750000000000000000	1000000000000000000000000	17097568	15000000000000000000	20000000000000000000000000	2023-04-21T21:58:11.000Z	0x6ad2291b7efdb9d1ab987a413c48da74042307ea40426f22028cc7fdbac62746
0x6a4d5f8385ff6e7fc4ebf6f726e12a958daa1cba	false	205	2580499643387	93395960419476359	17858068	0	0	2023-08-06T19:42:23.000Z	0x1f5cfea6cfeac51fb14d3bb3f9d0b56d3635ba70864ce1c29c43284133faabc5
0x6a4d5f8385ff6e7fc4ebf6f726e12a958daa1cba	false	50	3667986524648	65687319792845429	17726348	0	0	2023-07-19T09:28:59.000Z	0x1447bbb3bae50b99f6181593d194720931878e75073a1c8cb8a026c6c33303ae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_ethereum.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
0xfab5186a194588f5ad5074bd52659302906b4522	false	5	0xdefa4e8a7bcba345f687a2f1456f5edd9ce97202	374	13400673	0xdb68c0f5f08bbe0f4dd18c9cf409b2e46316d69e	2021-10-12T01:05:48.000Z	0x02289047a012f08be6fbde36c6c95dda90ad1c9fb8d52b7a0bd5b7c6fb8d9361	913560145696447291566
0xfab5186a194588f5ad5074bd52659302906b4522	false	6	0xdefa4e8a7bcba345f687a2f1456f5edd9ce97202	375	13400673	0xdb68c0f5f08bbe0f4dd18c9cf409b2e46316d69e	2021-10-12T01:05:48.000Z	0x02289047a012f08be6fbde36c6c95dda90ad1c9fb8d52b7a0bd5b7c6fb8d9361	2230948390175828949852
0xfab5186a194588f5ad5074bd52659302906b4522	false	2	0xdefa4e8a7bcba345f687a2f1456f5edd9ce97202	371	13400673	0xdb68c0f5f08bbe0f4dd18c9cf409b2e46316d69e	2021-10-12T01:05:48.000Z	0x02289047a012f08be6fbde36c6c95dda90ad1c9fb8d52b7a0bd5b7c6fb8d9361	1098835925736190875933

Example Query

Query with partition filter

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