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

# hashflow_v1_avalanche

> Tables in tt-contracts.hashflow_v1_avalanche

## Tables

### HashflowFactoryV2\_CreatePool\_event

Pool creation events emitted by Hashflow V2 factory contracts. Records the deployed pool address, associated operations contract, and privacy status for tracking liquidity pool initialization.

<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_pool`          | `STRING`    | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.                                           |
  | `in_operations`    | `STRING`    | Contract address of the operations controller for the pool. Hex-encoded, 0x-prefixed, 42-character string.                                           |
  | `in_privatePool`   | `BOOL`      | Boolean flag indicating whether the pool is restricted to authorized participants or publicly accessible.                                            |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pool                                   | removed | log\_index | block\_number | in\_operations                             | in\_privatePool | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | --------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x05fb0089bec6d00b2f01f4096eb0e0488c79cd91 | 0x7a2428c8a108a02e36408098171b7fd5234cc570 | false   | 2          | 20916059      | 0x424be4e9295e1917971f2080aea11ac2f960c731 | true            | 2022-10-11T06:14:33.000Z | 0x65627fa7161d032d850a4e054ca168079991f8caed965c25acc68be083c8918c |
  | 0x05fb0089bec6d00b2f01f4096eb0e0488c79cd91 | 0x17e85ca901629709112a35c46e9872fc14d5912c | false   | 2          | 20911491      | 0x6a04941de896e4215eeb8e6eb1b72ad2904d2402 | true            | 2022-10-11T03:37:06.000Z | 0x65b7a2373c3b6df43ed8e18d3884854f30b7add41fb43a1da516eb29e1a17502 |
  | 0x05fb0089bec6d00b2f01f4096eb0e0488c79cd91 | 0xe45c838553c3f3d0ce5e67bf8a6ec8fcfa153c46 | false   | 2          | 20949185      | 0xe68ca421f6fc38ebf9643644adde654f5cc59a4c | false           | 2022-10-12T01:09:31.000Z | 0x8f6599b43eba1432044be1a1079eb9b22eabe799e021b42b4f0198f0d940a53e |
</Accordion>

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

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

***

### PoolV2\_Trade\_event

Trade execution events from Hashflow PoolV2 contracts containing trader address, base/quote token addresses, exchange amounts, and protocol transaction identifier. Used for tracking DEX swap activity and volume analytics across Request-for-Quote (RFQ) based trades.

<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_trader`           | `STRING`    | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.                                             |
  | `in_txid`             | `STRING`    | Unique identifier for the trade operation within the Hashflow protocol. 66-character hex string including 0x prefix.                                 |
  | `in_baseToken`        | `STRING`    | Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                                 |
  | `in_quoteToken`       | `STRING`    | Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                                |
  | `in_baseTokenAmount`  | `STRING`    | Amount of base tokens involved in the operation. String-encoded integer representing the token quantity in its smallest denomination.                |
  | `in_quoteTokenAmount` | `STRING`    | Amount of quote tokens involved in the operation. String-encoded integer representing the token quantity in its smallest denomination.               |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_txid                                                           | removed | in\_trader                                 | log\_index | block\_number | in\_baseToken                              | in\_quoteToken                             | block\_timestamp         | transaction\_hash                                                  | in\_baseTokenAmount | in\_quoteTokenAmount |
  | ------------------------------------------ | ------------------------------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- | -------------------- |
  | 0x7a2428c8a108a02e36408098171b7fd5234cc570 | 0x2867616e64616c6674686562726f776e67786d786e69001a14fa26f92dc10000 | false   | 0xc590175e458b83680867afd273527ff58f74c02b | 20         | 32848071      | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 0x0000000000000000000000000000000000000000 | 2023-07-20T12:58:16.000Z | 0x7fd4f8ee5a8191508a0da5d90699020d7669d4180db19d9e0d88a718f6e32c99 | 2000000             | 140732484434000000   |
  | 0x7a2428c8a108a02e36408098171b7fd5234cc570 | 0x0067616e64616c6674686562726f776e67786d786e69001a16992ebd79670000 | false   | 0x77ece26552523e4be93037e871db25d2d33db9a9 | 19         | 32861538      | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 0x0000000000000000000000000000000000000000 | 2023-07-20T20:31:38.000Z | 0x514f6728509ed5561ccfc346bc7362e3b03b958985b89b703704240ae7377535 | 2300000             | 166775143020399968   |
  | 0x7a2428c8a108a02e36408098171b7fd5234cc570 | 0x0067616e64616c6674686562726f776e67786d786e69001a151c733d2dc10000 | false   | 0x8446fe588dd81865fa837ee2ab6edfb3d31fa8f4 | 15         | 32849180      | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 0x0000000000000000000000000000000000000000 | 2023-07-20T13:35:45.000Z | 0xeb74211c93f3935421f8287c6a72f588e392e2ddee21a5cf29480f5032069c4d | 1420862             | 99769938090364688    |
</Accordion>

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

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

***

### PoolV2\_XChainTrade\_event

Cross-chain trade events from Hashflow Protocol V2 pools containing token swap parameters and destination chain routing information. Records trader address, base and quote token addresses with amounts, destination chain ID (LayerZero), destination pool address, and protocol-specific transaction identifier for tracking bridge transfers across blockchain networks.

<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_dstChainId`       | `STRING`    | Destination chain identifier for cross-chain operations. String-encoded integer representing the target blockchain in LayerZero's chain ID system.   |
  | `in_dstPool`          | `STRING`    | Contract address of the destination pool for cross-chain trades. Hex-encoded, 66-character string with 24 leading zeros before the pool address.     |
  | `in_trader`           | `STRING`    | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.                                             |
  | `in_txid`             | `STRING`    | Unique identifier for the trade operation within the Hashflow protocol. 66-character hex string including 0x prefix.                                 |
  | `in_baseToken`        | `STRING`    | Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                                 |
  | `in_quoteToken`       | `STRING`    | Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                                |
  | `in_baseTokenAmount`  | `STRING`    | Amount of base tokens involved in the operation. String-encoded integer representing the token quantity in its smallest denomination.                |
  | `in_quoteTokenAmount` | `STRING`    | Amount of quote tokens involved in the operation. String-encoded integer representing the token quantity in its smallest denomination.               |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_txid                                                           | removed | in\_trader                                 | log\_index | in\_dstPool                                                        | block\_number | in\_baseToken                              | in\_dstChainId | in\_quoteToken                             | block\_timestamp         | transaction\_hash                                                  | in\_baseTokenAmount | in\_quoteTokenAmount |
  | ------------------------------------------ | ------------------------------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- | -------------------- |
  | 0xe45c838553c3f3d0ce5e67bf8a6ec8fcfa153c46 | 0x0967616e64616c6674686562726f776e67786d786e690016f2859dca98d00000 | false   | 0xfcad316549d9dea45cc91a56d72a23485fee9a38 | 42         | 0x0000000000000000000000005bbe4ab57b924f6876b992e141bf8766b5441421 | 26255103      | 0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664 | 5              | 0xc2132d05d31c914a87c6611c10748aeb04b58e8f | 2023-02-14T17:15:26.000Z | 0x25054c8cc4292f129363eb626d799e0b970f852e4e5c347a68b10fad2177ec15 | 102324263           | 102158862            |
  | 0xe45c838553c3f3d0ce5e67bf8a6ec8fcfa153c46 | 0x0067616e64616c6674686562726f776e67786d786e690016f3ee5d3427d20000 | false   | 0x0087ab85c2af7dfaa677c0a53fcc9fd9f22e8b41 | 14         | 0x000000000000000000000000ff20c5c4d31c3f9decbcdc4aea9f396b36255843 | 26266729      | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 6              | 0x55d398326f99059ff775485246999027b3197955 | 2023-02-14T23:49:39.000Z | 0xe6d8056599931e8b370414d21537394525a0cd756a4300d03c6c3807b150a544 | 89936852            | 89841576939531175330 |
  | 0xe45c838553c3f3d0ce5e67bf8a6ec8fcfa153c46 | 0x0067616e64616c6674686562726f776e67786d786e690016184bea9b2d020000 | false   | 0x8e547006ba6f3305ff0a32390bdacb524115e936 | 4          | 0x000000000000000000000000ff20c5c4d31c3f9decbcdc4aea9f396b36255843 | 24457909      | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 6              | 0x55d398326f99059ff775485246999027b3197955 | 2023-01-03T08:15:26.000Z | 0x626dd7872bf5c4f7fe6244db214a98e2e29f9d2887a815be54f4cd182cdff9b7 | 100000000           | 99954449128733171682 |
</Accordion>

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

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

***