> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# incrementfi_v1_flow

> Tables in tt-contracts.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.

<Accordion title="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.                                   |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.incrementfi_v1_flow.SwapFactory_PairCreated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                                                           |
</Accordion>

<Accordion title="Sample Data">
  | address          | block\_id                                                        | event\_name | event\_index | block\_number | in\_amount0In | in\_amount1In | in\_direction | contract\_name | in\_amount0Out   | in\_amount1Out | in\_amount0Type                                                                | in\_amount1Type              | transaction\_id                                                  | block\_timestamp               | in\_inTokenAmount | in\_reserve0After | in\_reserve1After | in\_outTokenAmount |
  | ---------------- | ---------------------------------------------------------------- | ----------- | ------------ | ------------- | ------------- | ------------- | ------------- | -------------- | ---------------- | -------------- | ------------------------------------------------------------------------------ | ---------------------------- | ---------------------------------------------------------------- | ------------------------------ | ----------------- | ----------------- | ----------------- | ------------------ |
  | 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     |                    |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.incrementfi_v1_flow.SwapPair_Swap_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***