kyber_v2_fantom

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
0x0a1e3cc9997efbbbe2d49b6ddfc30b8de00240b3	0xd4ecc4b71d70159f9cdaa9960453da5558639c51	false	0x0a1e3cc9997efbbbe2d49b6ddfc30b8de00240b3	60	31206420	243956120	118164971263885070089	2022-02-17T06:26:51.000Z	0x4c3c4190e75d73a0ef48761ae70abf63a98f1f5a744d2103de591d88d968c1dd	1504165046613757
0x0a1e3cc9997efbbbe2d49b6ddfc30b8de00240b3	0xd4ecc4b71d70159f9cdaa9960453da5558639c51	false	0x0a1e3cc9997efbbbe2d49b6ddfc30b8de00240b3	14	31245976	219107734	111171144358598830928	2022-02-17T16:18:49.000Z	0xf04c1626d57924d96798a1d9b4a2f67192fc2244f89f5d08f1719dd8bf06e1ac	1505112727207038
0x0a1e3cc9997efbbbe2d49b6ddfc30b8de00240b3	0xd4ecc4b71d70159f9cdaa9960453da5558639c51	false	0x0a1e3cc9997efbbbe2d49b6ddfc30b8de00240b3	5	31211567	255546380	121208172340602905953	2022-02-17T07:46:54.000Z	0x5b0e07737be004ba3b5953077b6d1c2714decf16b02bf4dad22839a9ce109c4c	2725950473063798

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_fantom.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
0xa4e35c30f2a22ae8e45f1a67e97bd4a868cf68a3	false	55	249080	982246272295335489	55915473	705933	1182620756025023028	2023-02-16T12:00:34.000Z	0x05b34ba3932194afb1a9235afccfd08b647f2403ad43796803e0616764962a35
0x4dae522a0d8df4bd800a72ff82dccd569bb81a98	false	8	513673	2478803740498825274	55889416	1498176	2978803740498825274	2023-02-16T03:33:00.000Z	0x00c1685e8db06fe5887c219312251d73ad0240c5350e70e8ab5c685f2205f68b
0x42e7cbcfa832ac45bdd5a7dc3d0ca2246bd5cfda	false	47	533240	942526094094910258	55889595	0	0	2023-02-16T03:36:20.000Z	0x39e11bad38877296bf14ee8a9c89f893eada2cff6d1dc2e56be72e4ecd01d72e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_fantom.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
0x78df70615ffc8066cc0887917f2cd72092c86409	0xebb19f5f66d8eba10ff0a8d99756221f1ac3ef1a	false	20000	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0x337dc89ebcc33a337307d58a51888af92cfdc81b	0	33760510	27	2022-03-18T14:59:42.000Z	0x6e356580ab44697cf4951295842a868710aaac40d79aa83253b018589f573999
0x78df70615ffc8066cc0887917f2cd72092c86409	0x2884ff7ac6ca35e06151ef1b0368a4d28d3b73fe	false	20000	0x337dc89ebcc33a337307d58a51888af92cfdc81b	0xa686bb86b258adefc6bbc6e896d7c1520b3d5510	44	33777235	28	2022-03-18T19:33:02.000Z	0x8126c6f48cdd68286103b736976a6eb60bc9791f6bd3326c2530af44951dd3b0
0x78df70615ffc8066cc0887917f2cd72092c86409	0xa5a31b4683da95cc20200c2366e8de702f797ea8	false	20000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0x337dc89ebcc33a337307d58a51888af92cfdc81b	7	34758348	29	2022-03-30T02:47:45.000Z	0xad51c0f22b2eb37f4c5a470d18622284ff77d9700e4f96f83530130b5a047371

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_fantom.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	0xc2995a065106b5c5c738b2320387460ebd12c12d	false	10000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0x744c01bb3a9cb59392e7f0d515f6b3e92b11c2ef	12	1000	66142953	8	2023-07-21T11:07:49.000Z	0xb7ea89adb28ce39a370d3f423adb0c07a66aa31fd7d6a893d51cfc449d7676a7
0x1c758af0688502e49140230f6b0ebd376d429be5	0x023c2773aa71b4b1ca7d30dd11748fe32a4fa02e	false	14000	0x179590b7a31f96c7f0625fee792a4f144097778c	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0	1000	41201398	2	2022-06-24T04:21:19.000Z	0x301b39ec659bb91ac4fbd60f82843a2521205df3d04834cb13f49ddcfd615722
0x1c758af0688502e49140230f6b0ebd376d429be5	0x5cd7c1efec89f0a6bcec73ec72b69e7376ed6349	false	17000	0x179590b7a31f96c7f0625fee792a4f144097778c	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0	300	41069853	1	2022-06-22T09:17:55.000Z	0x3b14c3adee7ec048061b1888e51a98ccacf260c208c7f54862cea15ecf3e46f5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_fantom.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
0xccf6b19bc2419e776b6ee030044811da846686fb	0x52a371c20863dc7e3866e065cf172a59eb49e13b	false	0xccf6b19bc2419e776b6ee030044811da846686fb	14	50023837	9995	0	0	46481939708722665	2022-10-26T09:14:18.000Z	0x9e7576bae26f8d3a067faa92525825e8f1319ede795ef3a05158e616c513f3f7	500000000000000
0x1d5702c6d7eb30e42a8c94b8db7ea2e8444a37fd	0x52a371c20863dc7e3866e065cf172a59eb49e13b	false	0x1d5702c6d7eb30e42a8c94b8db7ea2e8444a37fd	9	54736798	68646	0	0	147106880441680963	2023-01-30T20:08:32.000Z	0xea45fa40487d86c946977f2789b725ae930fdef0465cde001f96a1d59b038382	500000000000000
0x1d5702c6d7eb30e42a8c94b8db7ea2e8444a37fd	0x52a371c20863dc7e3866e065cf172a59eb49e13b	false	0x1d5702c6d7eb30e42a8c94b8db7ea2e8444a37fd	21	54740465	0	21122000675904024	10160	0	2023-01-30T21:21:45.000Z	0x4ce96f6c8e1ff5c5d24c7c06244c403a96e077651c56cae8fbf6b0e276226b1e	500000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v2_fantom.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
0x52a371c20863dc7e3866e065cf172a59eb49e13b	false	35	462202	1432815349113826120	53738114	2023-01-14T07:09:43.000Z	0xb5e2309366d73adb51c18be497653e5d934eae5af7ae7edf92107b8410fd1b80
0x52a371c20863dc7e3866e065cf172a59eb49e13b	false	75	367286	1802495835507125662	49664746	2022-10-21T04:58:04.000Z	0x228f7bfd6e25d032ec6ead72e79b0e1b4ec57db54dd1cde34e3c3c9bfb5c1140
0x52a371c20863dc7e3866e065cf172a59eb49e13b	false	115	365261	1812495835507125662	49679822	2022-10-21T09:38:20.000Z	0xe7061d755b4777d7fbde949824da2a9a2493618e0fa6b4e097712301d2839dbb

Example Query

Query with partition filter

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