kyber_v2_bsc

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
0x04580ce6dee076354e96fed53cb839de9efb5f3f	0x6170b6d96167346896169b35e1e9585feab873bb	false	0x9c4350f527ff7f96b650ee894ae9103bdfec0432	160	18327791	2000000000000000000000	12804432331680500976	2022-06-02T03:54:27.000Z	0xf7800b4036a45239e32c1caa8b1a02732b7b99841784ffed8358730c7921f69a	2281203568715162
0x04580ce6dee076354e96fed53cb839de9efb5f3f	0xc3dac2049616326e7d596ce52062789d96373b55	false	0xbaf9a5d4b0052359326a6cdab54babaa3a3a9643	70	18324581	1000000000000000000000	1000730819759454744316	2022-06-02T01:12:32.000Z	0xfbf270a7dc8d6dcf07ad4c2ab8150669741d57737114dfc556dcb49ae4062db7	202034650702726
0x04580ce6dee076354e96fed53cb839de9efb5f3f	0x6170b6d96167346896169b35e1e9585feab873bb	false	0x9c4350f527ff7f96b650ee894ae9103bdfec0432	23	18334670	1552772000000000000000	9947529226447107998	2022-06-02T09:40:48.000Z	0xb60d001e31c156453e96ca501b8359e05f2f8f5b9be91b91b2a2c4299697ecbf	1511976772093139

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_bsc.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
0x2b7820cfa03293fa051709ec1fe9aee50c9c0e4c	false	391	3982232182743698528160	187144963626525524930	22625561	2022-10-30T14:27:22.000Z	0x6c3bbe014d619a485d47ddb54cecfab850cf07e9f291c9491f8cc460dd9493d1
0x3a853210ef83a75ef4a7c406f22b9f861cdf3c94	false	294	5777374821489	13727639926691418945930	22625755	2022-10-30T14:37:04.000Z	0xcf69cb7e99ee6b7da3fc8d7d83a2a91707c2c193d4828671518f2736b4205039
0x3a853210ef83a75ef4a7c406f22b9f861cdf3c94	false	255	6061443065833	13077603774872690798892	22624180	2022-10-30T13:17:10.000Z	0xd43f0f2a95b0f76420f32a4a16fb919adaf58d9fbb0f5aa8ff3921239922a260

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_bsc.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
0x878dfe971d44e9122048308301f540910bbd934c	0xe2bd6efb72ae2829024baed6499b2ae2e01e664d	false	1000100000	0xc04a23149efdf9a63697f3eb60705147e9f07ffd	0xe9e7cea3dedca5984780bafc599bd69add087d56	704	14583404	59	2022-01-22T09:06:49.000Z	0x78b02d83d176dba996ae69dcb93e7130abd5e80663a045553fad7ad62121b283
0x878dfe971d44e9122048308301f540910bbd934c	0x72a02dfec2f52fb7d4f523de5e0d8ac745dea6f8	false	700000	0x718f7957a1d69883dba8f3150dfc10ee97617f34	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	122	17893242	94	2022-05-17T23:37:54.000Z	0x6b0468894c65e8e4637995c6ce55ba383d648090c948e327b720c59dd6a070ac
0x878dfe971d44e9122048308301f540910bbd934c	0x3b7d934c37370c44da0543949d8e54e6dd723e21	false	10000	0xacfc95585d80ab62f67a14c566c1b7a49fe91167	0xc62ccad7c62a9eafd8e306af42b451a1760d42e2	95	17866071	93	2022-05-17T00:39:43.000Z	0x2df10ef4b136fb6084efee5eb628190c5e73cfaacfa589bb0fb1b4471c462564

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_bsc.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	0x2fe45cb22f9bb58844bb6815f195a23d2c91cd84	false	50000	0x55d398326f99059ff775485246999027b3197955	0xe9e7cea3dedca5984780bafc599bd69add087d56	142	50	26333777	15	2023-03-10T04:04:18.000Z	0x81cf3e3a48164f00f68036b88b351b73f9e24f2449628c1acde67444071d8428
0x1c758af0688502e49140230f6b0ebd376d429be5	0x2aaf08590c5ef5fb6fe19438028cc900fa219a45	false	2000000000	0x47470dab4dbe9b1e564b0d29737f50283cec0ee7	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	32	8	22318791	9	2022-10-19T19:15:28.000Z	0xde50307010a4582e10f3d95e3e1142a1d4d4c695e10e7dba72cbf5f24c55071e
0x1c758af0688502e49140230f6b0ebd376d429be5	0xb15b10c9642ff9c22fc5c108429752c83ee39431	false	10000	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0xcfb70a4f8a3665e7c4d12f903cbd5046a541d887	134	8	27796451	21	2023-04-30T09:05:14.000Z	0xae56b7ddd4125eb0ca1d0c9c0a0b52597fa7f002ff7a957099ad4b2a78b06f66

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_bsc.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
0x96794f03b3114f50b892b0dec79d753658c931ee	0xfd3b7305693956994fc0cc973f4dd046fc3500ac	false	0x96794f03b3114f50b892b0dec79d753658c931ee	466	30725102	235484692228253531682	0	0	14599268839781221365	2023-08-10T07:44:04.000Z	0xafe030a58208d608282d7cc12a0e94d0b84e7b56f67c87916197b47c37b8013d	10000000000000000
0x1111111254eeb25477b68fb85ed929f73a960582	0xfd3b7305693956994fc0cc973f4dd046fc3500ac	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	61	32952745	0	4989996030120015492	96850046942883739065	0	2023-10-26T22:41:26.000Z	0xe0cb052867bea8dfe73d6afba93d2980480202a5e5098ce6ab09f54df38828ff	10000000000000000
0x1111111254eeb25477b68fb85ed929f73a960582	0xfd3b7305693956994fc0cc973f4dd046fc3500ac	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	192	32929804	0	632887137140319181	13273176846800666866	0	2023-10-26T03:29:23.000Z	0x5dcc06806d558db0932a6d20736a2a1ad68aad0bd9eab00435142869ea8ce5c0	10000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_bsc.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	block_timestamp	transaction_hash
0x93669cfce302c9971169f8106c850181a217b72b	false	190	22283172173975578222823	174448311152096138191496	26880279	2023-03-29T08:21:22.000Z	0xb253a69eab1f07ddd6126905487fc6e85fa4e85dee910b48d84b83605f923a22
0xfd3b7305693956994fc0cc973f4dd046fc3500ac	false	14	22956720808941431494542	1360225838590973615803	30789411	2023-08-12T13:31:58.000Z	0x694143d859fba60dd16456ff72627f9da7509556cd4481e0d70e158473ea20a3
0xfd3b7305693956994fc0cc973f4dd046fc3500ac	false	378	22996591679267161467768	1357891058472688247903	30793106	2023-08-12T16:37:26.000Z	0x439b3f9f46ed95e4771e0a867c6ce99cf11ee96bd099ed868528c8a921633e64

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_bsc.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	1	0xfe56d5892bdffc7bf58f2e84be1b2c32d21c308b	236	16334022	0xf25d2efb0f76f213ba16ccd79833aee0199e91fd	2022-03-24T09:29:20.000Z	0xd3c845fa26ba4780abff5368ba701119fac820a91204bc9aa289aa4c50541453	758649846732486958
0xfab5186a194588f5ad5074bd52659302906b4522	false	0	0xfe56d5892bdffc7bf58f2e84be1b2c32d21c308b	235	16334022	0xf25d2efb0f76f213ba16ccd79833aee0199e91fd	2022-03-24T09:29:20.000Z	0xd3c845fa26ba4780abff5368ba701119fac820a91204bc9aa289aa4c50541453	3132423575043917709
0xfab5186a194588f5ad5074bd52659302906b4522	false	0	0x633237c6fa30fae46cc5bb22014da30e50a718cc	240	16334022	0xf25d2efb0f76f213ba16ccd79833aee0199e91fd	2022-03-24T09:29:20.000Z	0xd3c845fa26ba4780abff5368ba701119fac820a91204bc9aa289aa4c50541453	505337007856030226546

Example Query

Query with partition filter

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