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

# stfx_v1_avalanche

> Tables in tt-contracts.stfx_v1_avalanche

## Tables

### StfxVault\_Claimed\_event

Investor claim events from STFX protocol vaults on Avalanche, recording withdrawal amounts and vault addresses. Used for tracking investor redemptions and vault liquidity outflows across different STFX vault strategies.

<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_investor`      | `STRING`    | Address of the investor depositing funds into or claiming funds from the vault. Hex-encoded, 0x-prefixed, 42-character string.                       |
  | `in_stfxAddress`   | `STRING`    | Contract address of the STFX fund or vault instance. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_amount | log\_index | in\_investor                               | block\_number | in\_stfxAddress                            | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 19775080   | 3          | 0x53a096fef0df25034ad6cc8030d566c8d06c1c51 | 25685743      | 0x1e87a5d91ce819b710ee8bef1955e13b4e84e607 | 2023-02-01T08:15:38.000Z | 0x9202efe03642db4f1c328871ba238a296372f69d03af6893018bf9f1293f3b85 |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 27607472   | 6          | 0x53a096fef0df25034ad6cc8030d566c8d06c1c51 | 25685389      | 0xdeb56c0c6cb64e8bc5a0d33d7ea1c8eb637c1f0d | 2023-02-01T08:03:47.000Z | 0x130f1401d2c80a572b58175ac6cbe66bb590487a4a2aa6212eada521be9432c3 |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 19639543   | 6          | 0x5405ffa5b9acf32bb639c37a7817133b02a7934b | 25675541      | 0x7854956ebec4b23a5ae15ddfdaa7541c5d0adeaa | 2023-02-01T02:34:37.000Z | 0x7397d5fd01a371a30aa5993d037677c54019fa8bd97eb9667b015b32c2926a5f |
</Accordion>

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

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

***

### StfxVault\_DepositIntoFund\_event

Deposit events from STFX vault contracts on Avalanche, capturing investor contributions with deposit amounts, investor addresses, and STFX vault identifiers. Used for tracking capital inflows and vault subscription activity across the STFX protocol.

<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__stfxAddress`  | `STRING`    | Address of the STFX token or fund contract associated with the vault operation. Hex-encoded, 0x-prefixed, 42-character string.                       |
  | `in_investor`      | `STRING`    | Address of the investor depositing funds into or claiming funds from the vault. Hex-encoded, 0x-prefixed, 42-character string.                       |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_amount | log\_index | in\_investor                               | block\_number | block\_timestamp         | in\_\_stfxAddress                          | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 20000000   | 9          | 0x9a17d557faa46b202a31f2d5e740688a2e5699e1 | 24832387      | 2023-01-12T05:46:07.000Z | 0x987b3e8887335df2de1c1178742267b0564c07f2 | 0x211273d6530aa39efe86a80a2637338b3ecfd35d284ba3c31aff5d8a89ecb2d3 |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 20000000   | 27         | 0x5af39def9d41c9970f75f507f2e3d9369b3b418e | 24827626      | 2023-01-12T03:05:42.000Z | 0x864d81ddf591df6128fcb55ce55b0cbcb7103a94 | 0xd0c3c2472fdae9b04355cb8a966d0795685f31d536a64f254d05e23f347c97ca |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 20000000   | 11         | 0x1c8adce0dd05a975f6628d7979a4fc8243aa1c39 | 24825248      | 2023-01-12T01:45:31.000Z | 0xd6c46368ba3ea59376bc9b10a7c99472661fd713 | 0x2b3d0a604270c3c4ab520f04cc9dcb58142d70a3e7276e902157a544e4d29dde |
</Accordion>

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

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

***

### StfxVault\_FeesTransferred\_event

Fee transfer events from STFX protocol vaults on Avalanche, recording manager and protocol fee distributions along with vault balances. Used for tracking revenue splits and vault performance metrics across the STFX trading infrastructure.

<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__stfxAddress`      | `STRING`    | Address of the STFX token or fund contract associated with the vault operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                  |
  | `in__remainingBalance` | `STRING`    | Vault balance remaining after manager and protocol fees have been deducted. Denominated in the vault's base token units (typically 6-9 decimals), ranging from millions to hundreds of millions in sample data. |
  | `in__managerFee`       | `STRING`    | Fee amount charged to the manager for the issuance, redemption, or operation. Numeric string representation in smallest token unit (wei).                                                                       |
  | `in__protocolFee`      | `STRING`    | Fee amount charged by the protocol for the issuance, redemption, or operation. Numeric string representation in smallest token unit (wei).                                                                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_\_managerFee | block\_timestamp         | in\_\_protocolFee | in\_\_stfxAddress                          | transaction\_hash                                                  | in\_\_remainingBalance |
  | ------------------------------------------ | ------- | ---------- | ------------- | ---------------- | ------------------------ | ----------------- | ------------------------------------------ | ------------------------------------------------------------------ | ---------------------- |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 2          | 25675514      | 0                | 2023-02-01T02:33:43.000Z | 0                 | 0x7854956ebec4b23a5ae15ddfdaa7541c5d0adeaa | 0x8bd4f6715cf321707e13d9c22de0d8ce5c7b6ce31c9c21eb25a6a5f83e73cd45 | 39279086               |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 31         | 25740190      | 0                | 2023-02-02T14:23:41.000Z | 0                 | 0x6e4e179d11bc66f5e470278e1e2a9267f82f6543 | 0xda8a52a82b04fae0c958363f51e038d14a5fb95491a91e05577c938cf257e431 | 20229608               |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 2          | 25723196      | 0                | 2023-02-02T04:57:13.000Z | 0                 | 0x8657d6e2a6607fd3048c26700fbb4d56cecc93db | 0x0b4eed73185236efcab3a7a0f096548c28929af33d4e970bdab8b918bbd5c09e | 19925973               |
</Accordion>

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

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

***

### StfxVault\_NewFundCreated\_event

Fund creation events from STFX (Stacked Finance) copy-trading vaults on Avalanche, capturing leveraged trading positions with manager address, entry/target/liquidation prices, trade direction, and fundraising period parameters. Used for analyzing vault strategy configurations and fund manager trading setups.

<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_baseToken`         | `STRING`    | Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                    |
  | `in_fundraisingPeriod` | `STRING`    | Duration of the fundraising period for the vault in seconds. Common values include 604800 (7 days), 72000 (20 hours), and 3600 (1 hour).                                                                |
  | `in_entryPrice`        | `STRING`    | Price at which the trading position was entered. String-encoded numeric value representing the entry price in the smallest denomination or with extended precision.                                     |
  | `in_targetPrice`       | `STRING`    | Target price for the leveraged position expressed in base token units with precision-adjusted decimals. Represents the manager's profit-taking level where the fund aims to close the trade.            |
  | `in_liquidationPrice`  | `STRING`    | Price level at which the leveraged position will be automatically liquidated to prevent further losses. Expressed in the base token's smallest unit, with zero indicating no liquidation threshold set. |
  | `in_leverage`          | `STRING`    | Leverage multiplier applied to the trading position. String-encoded numeric value representing the multiple of the margin amount used to determine position size.                                       |
  | `in_tradeDirection`    | `BOOL`      | Boolean flag indicating the direction of the leveraged trade (true for long, false for short). Determines whether the fund profits from price increases or decreases relative to the entry price.       |
  | `in_stfxAddress`       | `STRING`    | Contract address of the STFX fund or vault instance. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                     |
  | `in_manager`           | `STRING`    | Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string.                                                                                    |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_manager                                | in\_leverage | block\_number | in\_baseToken                              | in\_entryPrice | in\_stfxAddress                            | in\_targetPrice | block\_timestamp         | transaction\_hash                                                  | in\_tradeDirection | in\_liquidationPrice | in\_fundraisingPeriod |
  | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------------------------ | --------------- | ------------------------ | ------------------------------------------------------------------ | ------------------ | -------------------- | --------------------- |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 31         | 0x0022aa331686560dd555ee252f94ee6d7c293aec | 2000000      | 29838078      | 0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab | 1853030000     | 0x38d2532e9e7a3c78a48e94b1c8183a6b6b04db54 | 1863030000      | 2023-05-10T12:15:53.000Z | 0x173b820b5394f8768a2f83a767b4f0c3924d2c03244f8d2791a04ce928fdfb56 | true               | 1000000000           | 604800                |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 1          | 0x0022aa331686560dd555ee252f94ee6d7c293aec | 1000000      | 29780238      | 0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab | 1846240000     | 0x504f2731deff4426c055b5af8cd759bb4cd3d213 | 1836240000      | 2023-05-09T03:39:14.000Z | 0x6f3438be09a133129b85f2d15c7b6ad114f24bbf0e6912f1ab93fc2d521307a6 | false              | 1000000000           | 604800                |
  | 0xcd9987e26944de1ab817221864d06acd30c1b9f9 | false   | 14         | 0x0022aa331686560dd555ee252f94ee6d7c293aec | 2000000      | 29779769      | 0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab | 1844150000     | 0x8867172515523a212d8d45168ee6bf62f67ad9e7 | 1854150000      | 2023-05-09T03:23:35.000Z | 0xad21af75492c910498b900deec4bb092654e2d2fd15294ff318cfe61906fdba3 | true               | 1000000000           | 604800                |
</Accordion>

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

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

***