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

# integral_v1_arbitrum

> Tables in tt-contracts.integral_v1_arbitrum

## Tables

### TwapFactory\_PairCreated\_event

Liquidity pool creation events from the Integral TWAP (Time-Weighted Average Price) decentralized exchange factory contract on Arbitrum. Tracks new trading pair deployments with token addresses and sequential pair identifiers for monitoring protocol expansion.

<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. |
  | `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_pair`          | `STRING`    | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.                   |
  | `in_anon3`         | `STRING`    | Sequential counter tracking the total number of pairs created by the factory contract.                                                               |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pair                                   | removed | in\_anon3 | in\_token0                                 | in\_token1                                 | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | --------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x717ef162cf831db83c51134734a15d1ebe9e516a | 0x7a0f899ef730fe178e0574b8dab4440ca336e415 | false   | 4         | 0x5979d7b546e38e414f7e9822514be443a4800529 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0          | 159654644     | 2023-12-13T08:38:44.000Z | 0x2984ea48494008226b212fab1b64e2f0e7b61b7e0a4acdd5b6839d3c3548319f |
  | 0x717ef162cf831db83c51134734a15d1ebe9e516a | 0x12b8bc27ca8a997680f49d1a6fc1d93d552aacbe | false   | 2         | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0xaf88d065e77c8cc2239327c5edb3a432268e5831 | 0          | 159654089     | 2023-12-13T08:36:20.000Z | 0x282bd7f4d2651988f53a40225e52fc3c5e7d0a2378f95f6628fbaf4f02342f12 |
  | 0x717ef162cf831db83c51134734a15d1ebe9e516a | 0xf31778748b3364fc43d6ab6aac4f52e2c29b6353 | false   | 3         | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 6          | 159654336     | 2023-12-13T08:37:24.000Z | 0xfc5e0e46275a3be949a93fb8a532361ecf34d119fa95a9ee9c9ab3373512cfd2 |
</Accordion>

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

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

***

### TwapPair\_SetSwapFee\_event

Swap fee configuration events from Integral V1 TWAP (Time-Weighted Average Price) pairs on Arbitrum, recording when liquidity pool fee parameters are updated. Tracks fee changes ranging from 0.01% to 0.05% across different pair contracts for analyzing fee tier adjustments and pool economics.

<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.           |
  | `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_fee`           | `STRING`    | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
</Accordion>

<Accordion title="Sample Data">
  | in\_fee         | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | --------------- | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 100000000000000 | 0x4bca34ad27df83566016b55c60dd80a9eb14913b | false   | 0          | 17463100      | 2022-07-12T06:45:13.000Z | 0x655ed0a8ff566071989d09e6676f4a0abfe0d7b0c86999d40af1db13cf0e20bf |
  | 200000000000000 | 0x4bca34ad27df83566016b55c60dd80a9eb14913b | false   | 0          | 188265955     | 2024-03-08T08:04:35.000Z | 0x0c16f7deec764f3a3d76acb741cf026f7219182855e622c2d34cc8764ee903d0 |
  | 200000000000000 | 0xf31778748b3364fc43d6ab6aac4f52e2c29b6353 | false   | 0          | 188266054     | 2024-03-08T08:05:00.000Z | 0x7afbe8d303f99c8ff49dce9a8c4edb66049b5b8b95d44c04fe0a88bcb7541384 |
</Accordion>

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

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

***

### TwapPair\_Swap\_event

Swap events from Integral Size TWAP (Time-Weighted Average Price) liquidity pools on Arbitrum, capturing token amounts in/out, sender, and recipient addresses. Used for analyzing limit order execution and TWAP strategy performance in Integral's oracle-based AMM.

<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.  |
  | `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.                                       |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | block\_number | in\_amount0In      | in\_amount1In | in\_amount0Out | in\_amount1Out | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------ | ------------- | -------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x9ead888876b3978e8b138d4b6416111255b89e03 | 0x4bca34ad27df83566016b55c60dd80a9eb14913b | false   | 0x7b96662d4dbbf6894a888ba53afbe2f98359c973 | 3          | 39166946      | 43000000000000000  | 0             | 0              | 51919407       | 2022-11-18T23:18:23.000Z | 0x21a15e739bea674bac3f0fe7a60a03c0e2c2292cb0b91aaec30a00ea5673e3f7 |
  | 0xa51b7930684773e0a6ea594a45584f9b9c2ec660 | 0x4bca34ad27df83566016b55c60dd80a9eb14913b | false   | 0x7b96662d4dbbf6894a888ba53afbe2f98359c973 | 3          | 39042676      | 226000000000000000 | 0             | 0              | 274795503      | 2022-11-18T11:55:16.000Z | 0x739ccac3107a15e4026779669972795af28ff7bfaf53a5fe511e3813abf164e4 |
  | 0xa51b7930684773e0a6ea594a45584f9b9c2ec660 | 0x4bca34ad27df83566016b55c60dd80a9eb14913b | false   | 0x7b96662d4dbbf6894a888ba53afbe2f98359c973 | 4          | 39035499      | 8207045555683706   | 0             | 0              | 10000000       | 2022-11-18T11:20:07.000Z | 0x5def48211d6986f40a549d4d9e15c9cc71b0d7422d664ebf41af5cb59ca9cf16 |
</Accordion>

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

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

***