kyber_v2_arbitrum

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_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash	in_feeInPrecision
0xef09879057a9ad798438f3ba561bcdd293d72fc7	0x9de8e8c5658262cf2dd79646ac96b383d027bb8c	false	0xeae47c5d99f7b31165a7f0c5f7e0d6afa25cfd55	5	5850568	100000000000000	0	0	301527	2022-02-11T10:35:48.000Z	0xcb1fc2da851c28f42fe3f05892e04e6f0edf2c7ab3b4c235eecb8f809515c39a	1002555749004588

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_arbitrum.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
0x9de8e8c5658262cf2dd79646ac96b383d027bb8c	false	4	10100000000000000	29948473	5850568	45100000000000000	135823473	2022-02-11T10:35:48.000Z	0xcb1fc2da851c28f42fe3f05892e04e6f0edf2c7ab3b4c235eecb8f809515c39a
0xef07828031970c6bb67d52624396e416aef7a95c	false	7	10000000000000000	30250000	5850601	60000000000000000	181500000	2022-02-11T10:35:48.000Z	0xbe2be35aba6b87bde14bc383fb6a4c87a3bd147c03cd073f7b89b4f41d3266e9
0x9de8e8c5658262cf2dd79646ac96b383d027bb8c	false	7	10000000000000000	30250000	5847544	45000000000000000	136125000	2022-02-11T09:10:58.000Z	0x207f4d82ba94f04de540e2d3e6e0927d4e9d0818652eb6e5de4f599beb618314

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_arbitrum.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
0xd9bfe9979e9ca4b2fe84ba5d4cf963bbcb376974	0x9de8e8c5658262cf2dd79646ac96b383d027bb8c	false	45000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0	5847544	1	2022-02-11T09:10:58.000Z	0x207f4d82ba94f04de540e2d3e6e0927d4e9d0818652eb6e5de4f599beb618314
0xd9bfe9979e9ca4b2fe84ba5d4cf963bbcb376974	0xef07828031970c6bb67d52624396e416aef7a95c	false	60000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0	5850601	2	2022-02-11T10:35:48.000Z	0xbe2be35aba6b87bde14bc383fb6a4c87a3bd147c03cd073f7b89b4f41d3266e9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_arbitrum.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_feeBps`	`STRING`	Fee tier for this liquidity pool expressed in basis points (BPS), where 100 BPS equals 1%. Sample values range from 1 to 100 BPS, representing fee tiers from 0.01% to 1%.
`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_feeBps	in_token0	in_token1	block_number	in_totalPool	block_timestamp	transaction_hash
0x51e8d106c646ca58caf32a47812e95887c071a62	0x8e4f9d2e233a1f5aa904bb329ed2333fadaa73a4	false	360000	100	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	10653997	8	2022-04-27T11:52:07.000Z	0xd5b497cab53ffb770ae3be4d86a32d83312e9094489de94bccf319cae6fbeae3
0x51e8d106c646ca58caf32a47812e95887c071a62	0x957d685fa5618a32151ac846fb29bb5cc08db049	false	360000	100	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	10653214	7	2022-04-27T11:40:14.000Z	0x5108d7422444f249ded1855df8743e91e6c5eca80034cc09de7a7b27096b9028
0x51e8d106c646ca58caf32a47812e95887c071a62	0x2db515d226c849d7136998538dc974b00bf68ea1	false	360000	100	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	10655222	10	2022-04-27T12:10:05.000Z	0xfce80aeeb2b6d545107aafa9827582669cf4d6d2fdfe3043bc69103408010a2e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_arbitrum.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_amount1In	in_amount0Out	block_timestamp	transaction_hash	in_feeInPrecision
0x9b99e9c620b2e2f09e0b9fced8f679eecf2653fe	0xfba13b2a525d2b11c6c138a3a31040a663921213	false	0x9b99e9c620b2e2f09e0b9fced8f679eecf2653fe	31	236584674	56396	17262229613223	2024-07-27T12:08:15.000Z	0xc2f8964ab5910dec1139e2f0bb448ef6ea9d19fbb3dfdc32abd5af9960070574	3000000000000000
0x9b99e9c620b2e2f09e0b9fced8f679eecf2653fe	0xfba13b2a525d2b11c6c138a3a31040a663921213	false	0x9b99e9c620b2e2f09e0b9fced8f679eecf2653fe	76	236601511	978261	297445057917607	2024-07-27T13:18:28.000Z	0x7f84fe8cb2f564184eb12a946a98672f24eb716afdcde7d83f0437315fc8d58d	3000000000000000
0x9b99e9c620b2e2f09e0b9fced8f679eecf2653fe	0xfba13b2a525d2b11c6c138a3a31040a663921213	false	0x9b99e9c620b2e2f09e0b9fced8f679eecf2653fe	135	236601552	1096389	328935161401319	2024-07-27T13:18:39.000Z	0xbb6cb554c386f0155c54e312b2d6d5e0dfc021ec453b88f6b42b0eaeb8eb7937	3000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_arbitrum.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
0x957d685fa5618a32151ac846fb29bb5cc08db049	false	13	1	66369726	233193534	296182557734420593	915877919	2024-07-17T15:26:27.000Z	0x78d2012b249e0cf58c3a34b72a85d914e1636ae081c1ba790d69271260e77cfc
0xfba13b2a525d2b11c6c138a3a31040a663921213	false	3	10198077212563353	48808520	233230983	46269154862260510	157021812	2024-07-17T18:03:06.000Z	0x510de10e015eb42385ee58247bed6e50539cf14ec4f6d2c564e99d6976273639
0xfba13b2a525d2b11c6c138a3a31040a663921213	false	40	9686064900162497	50555430	233153582	45757142549859654	158768722	2024-07-17T12:39:51.000Z	0xac3e3fbae4191630bb3582b551383d6f0a5ac5b70da2acb195c43b12d28f85b9

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​DMMPool_Swap_event

​DMMPool_Sync_event

​Factory_PoolCreated_event

​KSFactory_PoolCreated_event

​KSPool_Swap_event

​KSPool_Sync_event

Tables

DMMPool_Swap_event

DMMPool_Sync_event

Factory_PoolCreated_event

KSFactory_PoolCreated_event

KSPool_Swap_event

KSPool_Sync_event