kyber_v2_avalanche

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
0x07749429d3d9047a966b28a489500325bac9f1b6	0xc6710e83abbbbaa6d1576dd30df3baf6147823d8	false	0x07749429d3d9047a966b28a489500325bac9f1b6	67	33133621	291702376	293686916135344461675	2023-07-27T06:27:53.000Z	0xd5e3f9e1d02e34b5a1775404d4d8bf35dee13441b0522e1a08f5552d06cf8f0b	201507837574707
0x07749429d3d9047a966b28a489500325bac9f1b6	0x88d23fc2df1e5d07e58105301a560cf92a4e6ecb	false	0x07749429d3d9047a966b28a489500325bac9f1b6	39	33145296	33007069	32993162	2023-07-27T13:12:40.000Z	0x41e2420a48ad7c855f7db18ee4c3e6ab9498f29a3531a22952d94eb4a35d5357	654932452503771
0x07749429d3d9047a966b28a489500325bac9f1b6	0xe1dad9e06380bc8962e259ddd6a5257a4f56d525	false	0x07749429d3d9047a966b28a489500325bac9f1b6	67	33162424	72168854	72145214	2023-07-27T23:07:02.000Z	0xfe07d1c26e3726771b98cf8064fab04746859f04feffdd3bdf4bfee966c08495	200529067864729

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_avalanche.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	in_vReserve0	in_vReserve1	block_timestamp	transaction_hash
0x88d23fc2df1e5d07e58105301a560cf92a4e6ecb	false	3	12937861445	13956555262	18135213	5259287570605	5260306264414	2022-08-02T22:03:52.000Z	0xdd236e697d95d755461481d209f5cc31864393e92d1c727b2f0cc86f9eeb13f9
0xd87cd5aa7efdc4de73ef8c7166d4d1daa37e2330	false	3	125046195749	128129372130	18132620	49362026688436	49365212524756	2022-08-02T20:36:28.000Z	0x1836759f0d35ccd06d37143bb0500ed083a3e4199ec8efd3a1568d0afbf5f5a8
0xd87cd5aa7efdc4de73ef8c7166d4d1daa37e2330	false	3	136353217655	116820284055	18127132	49373333710342	49353903436681	2022-08-02T17:32:10.000Z	0x42bce07f6fbc03f91fbb5d1f48f12743a4e91da2b82546c61595da2225415aa1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_avalanche.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
0x10908c875d865c66f271f5d3949848971c9595c9	0x7c1f9c5965986a332ffe2baac8b54962be3571f4	false	2000000	0x4fbf0429599460d327bd5f55625e30e4fc066095	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664	11	6282874	23	2021-10-30T02:34:41.000Z	0x66560ea0e7503f3b1f30bc761cc7fecb5f4a31d47d237b0fb810e06302a66a8b
0x10908c875d865c66f271f5d3949848971c9595c9	0x6234f8db0e28120f6b0d30e63bc9f7efe37c5090	false	10000	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	0xd3ac016b1b8c80eeadde4d186a9138c9324e4189	9	23322103	76	2022-12-07T09:00:11.000Z	0x822f10ed386bdfd63675a3e4d7cc9823bdebcd2cbcd72fdb696c1c8d587d4348
0x10908c875d865c66f271f5d3949848971c9595c9	0x90e289717503580ed300a17db0196b9274cf8289	false	10000	0x19860ccb0a68fd4213ab9d8266f7bbf05a8dde98	0xd586e7f844cea2f87f50152665bcbc2c279d8d70	1	9960603	38	2022-01-23T18:44:12.000Z	0x52b5377e7a2e281d21b1e4605a86fc8b6ff220a0429265fa559ec5ab6b8a8d76

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_avalanche.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	0xb15b10c9642ff9c22fc5c108429752c83ee39431	false	40000	0x18fc6360e83fe91404d47ea4400a221dfbbacf06	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	0	1000	26038487	21	2023-02-09T14:06:22.000Z	0x68e73017706bbe546a87a03d36fbaa2f6d3fcf1b575891816fefab1cfde2c4fd
0x1c758af0688502e49140230f6b0ebd376d429be5	0xf6f49932ecfc01dd69d404a8628f59acc5bff3bf	false	160000	0x39fc9e94caeacb435842fadedecb783589f50f5f	0x5947bb275c521040051d82396192181b413227a3	2	1000	28900413	22	2023-04-18T09:19:15.000Z	0x6770aee80d2309ec678c46d265b982b3dac4cabf0dc397a00be18cb60358f5f7
0x1c758af0688502e49140230f6b0ebd376d429be5	0x52a371c20863dc7e3866e065cf172a59eb49e13b	false	4294900000	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	1	8	16993760	3	2022-07-07T00:24:19.000Z	0x7fef3176911fd6af212e6a596f9eac6e49acb5177a433315276aa2256d5765e8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_avalanche.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_amount1Out	block_timestamp	transaction_hash	in_feeInPrecision
0x07daed15a13a5a39751c05301de2409136d56b20	0xc2995a065106b5c5c738b2320387460ebd12c12d	false	0x92cbfc3f9466e9d0a65ed63af277d1eed69558e7	45	24700024	1008034360428319044181	1000079988	2023-01-09T02:49:55.000Z	0x5baaabe9bdd43dc5e9a696752454043947587f796dd66cd4ed19a89ec6949dc1	80000000000000
0x92cbfc3f9466e9d0a65ed63af277d1eed69558e7	0xc2995a065106b5c5c738b2320387460ebd12c12d	false	0x92cbfc3f9466e9d0a65ed63af277d1eed69558e7	48	24725441	880000000000000000000	873086128	2023-01-09T17:15:18.000Z	0xc023c47178555d5afa961729dd60369185851f97999af54ff65040ce8fd8b939	80000000000000
0x92cbfc3f9466e9d0a65ed63af277d1eed69558e7	0x990078d800c22f738a238c4e07a1b2c05d236f1f	false	0x92cbfc3f9466e9d0a65ed63af277d1eed69558e7	26	24698287	9000000000000000000	736530719395347885	2023-01-09T01:51:33.000Z	0xb8de1b991ae2ed560cd2aaa56c803bbf5b4af86ee94d5dce79c187a072577ada	5000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_avalanche.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
0xc2995a065106b5c5c738b2320387460ebd12c12d	false	2	260424154860832703814185	119840094933	27072639	38058701709001902605364726	37918118569415	2023-03-06T02:44:30.000Z	0xf770bdac163679315ad57e9207ddb0436dbeea0cc7b88eafe58ba5a75c792980
0xc2995a065106b5c5c738b2320387460ebd12c12d	false	3	259415358047569007110820	119662637657	27093589	37937205520539560186187559	37797453717555	2023-03-06T15:11:50.000Z	0x05839c396e6eefbdf87504d86c6b9cfc0040bd9d81b7d419f668c8bab8c9febb
0xc2995a065106b5c5c738b2320387460ebd12c12d	false	3	263950263144261594650343	116327652103	27081964	38062227817285331496200884	37914606126585	2023-03-06T08:22:06.000Z	0x195bcc6776415ea0d8d4e9a5e459d924ba294a397ad7095e8baf00cf1ef4d510

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_avalanche.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
0xf530a090ef6481cfb33f98c63532e7745abab58a	false	1	0x0000000000000000000000000000000000000000	51	4830191	0xf28f1503d460a5c1be71d2dedcbe602b6aba530f	2021-09-25T14:07:11.000Z	0xaa73541c52b2f7e9d6fb6ba73bcbc7251181cbcb2a753568e3708df2fb984129	147556770866507203
0xf530a090ef6481cfb33f98c63532e7745abab58a	false	0	0x0000000000000000000000000000000000000000	50	4830191	0xf28f1503d460a5c1be71d2dedcbe602b6aba530f	2021-09-25T14:07:11.000Z	0xaa73541c52b2f7e9d6fb6ba73bcbc7251181cbcb2a753568e3708df2fb984129	46419329932280338
0xf530a090ef6481cfb33f98c63532e7745abab58a	false	12	0x0000000000000000000000000000000000000000	25	4835663	0x89d0726379976d64342158d0c5a9b32e62be43e1	2021-09-25T17:18:03.000Z	0xf40197ff30561850627a9f89d3aed75ec98e9b3acb3682d6c785692a8f1df937	98973870300524500

Example Query

Query with partition filter

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