Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_numPairsSTRINGTotal 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_pairAddressSTRINGContract address of the newly created liquidity pair on Flow blockchain. Hex-encoded string with 0x prefix representing the deployed swap pair contract.
in_stableModeSTRINGBoolean 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_token0KeySTRINGContract 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_token1KeySTRINGCadence 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.
addressblock_idevent_nameevent_indexin_numPairsblock_numberin_token0Keyin_token1Keycontract_namein_stableModein_pairAddresstransaction_idblock_timestamp
b063c16cac85dbd178d9d221fa02076c63b214c95223a0012c48f572cb3e963be01dd173eaeb6a0fPairCreated129464426729A.921ea449dffec68a.FlovatarDustTokenA.7bf07d719dcb8480.brasilSwapFactorytrue0x1d1f0d6072579aaf55fa3ab1753af505de785c2077930ccf8045e268caae9fc1f60cc864f0c2c0e82023-10-31T00:26:27.174128000Z
b063c16cac85dbd1e6605e08a9a378f4e7704b636a5a89c0b2f8cede7a02cada94d55141a9267229PairCreated129364425806A.921ea449dffec68a.FlovatarDustTokenA.7bf07d719dcb8480.brasilSwapFactoryfalse0x065b89738b254277b46d2b96f22bf6636b9998b5a2b7d7c67b93ce3b7ab3da0afd3d71b41ab2e6a52023-10-31T00:12:23.833760000Z
b063c16cac85dbd1bb9fcd24bbc6abf9f4aea642a9bf147200b26deda42fa7a33307f8f09a81b6e7PairCreated1213275737640A.687e1a7aef17b78b.BeaverA.cbba4d41aef83fe3.UtahJazzLegendsClubSwapFactoryfalse0x6acb0b7e220555215dd906d80ca85235cf7c6f39d97166d1ff69e4749328d8faa81a222acce93f402024-04-08T19:04:56.885152000Z
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amount0InSTRINGAmount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
in_amount0OutSTRINGAmount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
in_amount0TypeSTRINGToken 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_amount1InSTRINGAmount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
in_amount1OutSTRINGAmount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
in_amount1TypeSTRINGToken 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_directionSTRINGDirection indicator for the swap or market position. Integer value where 0 represents one side of the position and 1 represents the opposite side.
in_inTokenAmountSTRINGAmount 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_outTokenAmountSTRINGAmount 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_reserve0AfterSTRINGLiquidity 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_reserve1AfterSTRINGReserve amount of token1 in the liquidity pool after the swap execution. Denominated in the token1’s native units as specified by in_amount1Type.
addressblock_idevent_nameevent_indexblock_numberin_amount0Inin_amount1Inin_directioncontract_namein_amount0Outin_amount1Outin_amount0Typein_amount1Typetransaction_idblock_timestampin_inTokenAmountin_reserve0Afterin_reserve1Afterin_outTokenAmount
0b08c2d482a6295b1a74c6ca3b3c3f7c4f08668f6c2bd9cf5060a4313165d415eb46f39a0ab98d9fSwap31042115362808.60SwapPair01.01623617A.1e4aa0b87d10b141.EVMVMBridgedToken_d8ad8ae8375aa31bff541e17dc4b4917014ebdaaA.1654653399040a61.FlowToken74b1fc0eeaab9a41077c9f2102f30bd0e08c5a730b03c7d9d142de058fc1da1c2025-02-21T01:17:01.762592000Z94420695.0902492134266.03672046
0b08c2d482a6295b47a1a509a7a84313e6231ec0d5b0c11ac1862dcddd5e13a112aa5428a51472c2Swap1610422325001.11568455SwapPair3064.966957210A.1e4aa0b87d10b141.EVMVMBridgedToken_d8ad8ae8375aa31bff541e17dc4b4917014ebdaaA.1654653399040a61.FlowTokenac19406ead6519fdf4890952ccf6630523d8425cc71a9edd13691d4141c3e08f2025-02-21T03:57:18.622561000Z94417638.0335431134267.1552757
0b08c2d482a6295b67c572dfadf1fcf635184b8d2be7deb09e8d1fd2ae6122f0a7160dde5baf080bSwap61042265200607SwapPair1638535.904013680A.1e4aa0b87d10b141.EVMVMBridgedToken_d8ad8ae8375aa31bff541e17dc4b4917014ebdaaA.1654653399040a61.FlowToken1f0af5260bc23e64bc15e996214d82a8f4087ddc499464609ee5ffe1330977d92025-02-21T04:42:02.630986000Z92779102.1295294334874.1552757
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