incrementfi_v1_flow

Tables

SwapFactory_PairCreated_event

Liquidity pool creation events from IncrementFi decentralized exchange (DEX) on Flow blockchain, recording new trading pair deployments with token identifiers, pair addresses, and stable/volatile pool mode settings. Used to track DEX market expansion and token listing 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.
`block_id`	`STRING`	Unique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`contract_name`	`STRING`	Name of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_numPairs`	`STRING`	Total number of trading pairs that exist in the Increment Finance swap factory after this pair creation event. Represents the cumulative count of all liquidity pools deployed on Flow blockchain.
`in_pairAddress`	`STRING`	Contract address of the newly created liquidity pair on Flow blockchain. Hex-encoded string with 0x prefix representing the deployed swap pair contract.
`in_stableMode`	`STRING`	Boolean flag indicating whether the created pair uses a stableswap curve optimized for assets with similar values (true) or a constant product curve for volatile pairs (false). Null for early pairs created before this parameter was added.
`in_token0Key`	`STRING`	Contract address identifier for the first token in the newly created trading pair on Flow blockchain. Formatted as A.{address}.{token_name} following Flow’s account-based token standard.
`in_token1Key`	`STRING`	Cadence resource identifier for the second token in the created liquidity pair, formatted as A.{contract_address}.{token_name}. Always paired with in_token0Key to define the trading pair composition.

Sample Data

address	block_id	event_name	event_index	in_numPairs	block_number	in_token0Key	in_token1Key	contract_name	in_stableMode	in_pairAddress	transaction_id	block_timestamp
b063c16cac85dbd1	78d9d221fa02076c63b214c95223a0012c48f572cb3e963be01dd173eaeb6a0f	PairCreated	12	94	64426729	A.921ea449dffec68a.FlovatarDustToken	A.7bf07d719dcb8480.brasil	SwapFactory	true	0x1d1f0d6072579aaf	55fa3ab1753af505de785c2077930ccf8045e268caae9fc1f60cc864f0c2c0e8	2023-10-31T00:26:27.174128000Z
b063c16cac85dbd1	e6605e08a9a378f4e7704b636a5a89c0b2f8cede7a02cada94d55141a9267229	PairCreated	12	93	64425806	A.921ea449dffec68a.FlovatarDustToken	A.7bf07d719dcb8480.brasil	SwapFactory	false	0x065b89738b254277	b46d2b96f22bf6636b9998b5a2b7d7c67b93ce3b7ab3da0afd3d71b41ab2e6a5	2023-10-31T00:12:23.833760000Z
b063c16cac85dbd1	bb9fcd24bbc6abf9f4aea642a9bf147200b26deda42fa7a33307f8f09a81b6e7	PairCreated	12	132	75737640	A.687e1a7aef17b78b.Beaver	A.cbba4d41aef83fe3.UtahJazzLegendsClub	SwapFactory	false	0x6acb0b7e22055521	5dd906d80ca85235cf7c6f39d97166d1ff69e4749328d8faa81a222acce93f40	2024-04-08T19:04:56.885152000Z

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.incrementfi_v1_flow.SwapFactory_PairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SwapPair_Swap_event

Swap execution events from Increment Finance DEX on Flow blockchain, capturing token exchange details including input/output amounts, reserve balances, and token types. Used for analyzing trading activity, liquidity pool dynamics, and price impact on Flow-based token pairs.

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.
`block_id`	`STRING`	Unique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`contract_name`	`STRING`	Name of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`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_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_amount0Type`	`STRING`	Token contract identifier for amount0 in the swap pair. Formatted as Flow address and contract name (e.g., A.1654653399040a61.FlowToken for native Flow tokens).
`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_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_amount1Type`	`STRING`	Token contract identifier for amount1 in the swap pair, using Flow blockchain’s qualified type notation. Format follows `A.\{address\}.\{contract\}` pattern, with common values including FlowToken and bridged EVM tokens.
`in_direction`	`STRING`	Direction indicator for the swap or market position. Integer value where 0 represents one side of the position and 1 represents the opposite side.
`in_inTokenAmount`	`STRING`	Amount of input token transferred into the swap, denominated in the input token’s smallest unit. Typically null in this implementation as amount details are captured in amount0In/amount1In fields.
`in_outTokenAmount`	`STRING`	Amount of output token received by the swapper in the swap transaction. Currently unpopulated (null) in this dataset; swap amounts tracked via amount0Out/amount1Out fields instead.
`in_reserve0After`	`STRING`	Liquidity pool reserve amount of token0 after the swap execution, denominated in token0 units. Represents the updated pool balance used for calculating subsequent swap prices.
`in_reserve1After`	`STRING`	Reserve amount of token1 in the liquidity pool after the swap execution. Denominated in the token1’s native units as specified by in_amount1Type.

Sample Data

address	block_id	event_name	event_index	block_number	in_amount0In	in_amount1In	contract_name	in_amount0Out	in_amount1Out	in_amount0Type	in_amount1Type	transaction_id	block_timestamp	in_reserve0After	in_reserve1After
0b08c2d482a6295b	1a74c6ca3b3c3f7c4f08668f6c2bd9cf5060a4313165d415eb46f39a0ab98d9f	Swap	3	104211536	2808.6	0	SwapPair	0	1.01623617	A.1e4aa0b87d10b141.EVMVMBridgedToken_d8ad8ae8375aa31bff541e17dc4b4917014ebdaa	A.1654653399040a61.FlowToken	74b1fc0eeaab9a41077c9f2102f30bd0e08c5a730b03c7d9d142de058fc1da1c	2025-02-21T01:17:01.762592000Z	94420695.09024921	34266.03672046
0b08c2d482a6295b	47a1a509a7a84313e6231ec0d5b0c11ac1862dcddd5e13a112aa5428a51472c2	Swap	16	104223250	0	1.11568455	SwapPair	3064.96695721	0	A.1e4aa0b87d10b141.EVMVMBridgedToken_d8ad8ae8375aa31bff541e17dc4b4917014ebdaa	A.1654653399040a61.FlowToken	ac19406ead6519fdf4890952ccf6630523d8425cc71a9edd13691d4141c3e08f	2025-02-21T03:57:18.622561000Z	94417638.03354311	34267.1552757
0b08c2d482a6295b	67c572dfadf1fcf635184b8d2be7deb09e8d1fd2ae6122f0a7160dde5baf080b	Swap	6	104226520	0	607	SwapPair	1638535.90401368	0	A.1e4aa0b87d10b141.EVMVMBridgedToken_d8ad8ae8375aa31bff541e17dc4b4917014ebdaa	A.1654653399040a61.FlowToken	1f0af5260bc23e64bc15e996214d82a8f4087ddc499464609ee5ffe1330977d9	2025-02-21T04:42:02.630986000Z	92779102.12952943	34874.1552757

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.incrementfi_v1_flow.SwapPair_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

SwapFactory_PairCreated_event

SwapPair_Swap_event

​Tables

​SwapFactory_PairCreated_event

​SwapPair_Swap_event

Tables

SwapFactory_PairCreated_event

SwapPair_Swap_event