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

# thetanuts_v1_fantom

> Tables in tt-contracts.thetanuts_v1_fantom

## Tables

### CoveredCallFtm\_Deposit\_event

Deposit events from Thetanuts Finance covered call vaults on Fantom, tracking user contributions with amount, epoch identifier, and depositor address. Used for analyzing vault participation patterns and capital inflows across option-selling 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__from`         | `STRING`    | Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.                                                       |
  | `in__epoch`        | `STRING`    | Epoch identifier for the vault or contract cycle. String-encoded integer representing the sequential period number.                                  |
  | `in__amt`          | `STRING`    | Amount of tokens involved in the transaction. String-encoded integer representing the token quantity in its smallest unit.                           |
  | `in__msgSender`    | `STRING`    | Address of the account that called the contract function. Hex-encoded, 0x-prefixed, 42-character string.                                             |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_\_amt             | removed | in\_\_from                                 | in\_\_epoch | log\_index | block\_number | in\_\_msgSender                            | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | --------------------- | ------- | ------------------------------------------ | ----------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x302abd505757fd355c8ef3cf8b4918d6404f4996 | 100000000000000000000 | false   | 0xd613c840caa8eb854abfda79a4b709aa2ab8e620 | 14          | 3          | 58131390      | 0xd613c840caa8eb854abfda79a4b709aa2ab8e620 | 2023-03-22T14:03:48.000Z | 0x095be9c997d01813d299ad6881d6007b6b6b643c0483055eeacb9b8cd2a1f409 |
  | 0x302abd505757fd355c8ef3cf8b4918d6404f4996 | 802000000000000000000 | false   | 0xd613c840caa8eb854abfda79a4b709aa2ab8e620 | 14          | 47         | 58131509      | 0xd613c840caa8eb854abfda79a4b709aa2ab8e620 | 2023-03-22T14:05:50.000Z | 0x5b1e489622ca09cd78506bc232209c9ad1ef862c065c61cd7103b123ddc5f669 |
  | 0x7eda4c29726355d0d8e85001b9152158b35eae4f | 14145901              | false   | 0xfdc6660c90c6fb0c7552f8de237a054c650aa565 | 14          | 2          | 58121353      | 0xfdc6660c90c6fb0c7552f8de237a054c650aa565 | 2023-03-22T10:34:07.000Z | 0xcf07cf582d33f5ad8e0622f2829deb566eac7265487401068768f7444ce56965 |
</Accordion>

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

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

***

### CoveredCallFtm\_NewEpoch\_event

Epoch initialization events from Thetanuts covered call vaults on Fantom, capturing option parameters including strike price (scaled by 1e6), premium amounts, minimum vault size, and epoch numbers. Used for tracking vault option generation cycles and analyzing covered call strategy parameters across different market conditions.

<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__from`           | `STRING`    | Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.                                                                                   |
  | `in__epoch`          | `STRING`    | Epoch identifier for the vault or contract cycle. String-encoded integer representing the sequential period number.                                                              |
  | `in__strikeX1e6`     | `STRING`    | Option strike price scaled by one million. String-encoded integer representing the strike price with six decimal places of precision implied by the 1e6 multiplier.              |
  | `in__premium`        | `STRING`    | Premium received from selling covered call options for the epoch. String-encoded integer representing the option premium amount in the vault's base asset smallest denomination. |
  | `in__minSizeOfVault` | `STRING`    | Minimum total value locked in the vault for the epoch. String-encoded integer representing the vault's base asset amount in smallest denomination.                               |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_\_from                                 | in\_\_epoch | log\_index | in\_\_premium          | block\_number | in\_\_strikeX1e6 | block\_timestamp         | transaction\_hash                                                  | in\_\_minSizeOfVault     |
  | ------------------------------------------ | ------- | ------------------------------------------ | ----------- | ---------- | ---------------------- | ------------- | ---------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
  | 0x7eda4c29726355d0d8e85001b9152158b35eae4f | false   | 0xca436e14855323927d6e6264470ded36455fc8bd | 4           | 51         | 75673000               | 49802608      | 163000           | 2022-10-23T02:11:31.000Z | 0x5af98b3d9f6bbf3695fe6c0c108782afd12211df64596a8e41e27f82bd7abc79 | 12334699000              |
  | 0x302abd505757fd355c8ef3cf8b4918d6404f4996 | false   | 0x629538d6030de25417a67bbd748510e271c7a6ff | 19          | 34         | 2234654000000000000000 | 62844078      | 429000           | 2023-05-22T08:02:59.000Z | 0xcbc63c74a1268d11c2797cb048cc4cc0038b7e92b60c9dd7ba08d6f64b23b571 | 314740000000000000000000 |
  | 0x7eda4c29726355d0d8e85001b9152158b35eae4f | false   | 0x4337941a2fe5d22e3f70850b69931d97044dc176 | 15          | 0          | 486552000              | 58270057      | 403000           | 2023-03-24T10:19:20.000Z | 0x7e608613ba2855b1a2116e8177a8601515b47da70e07654310f56855bdc4bc8b | 16340038000              |
</Accordion>

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

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

***

### CoveredCallFtm\_Withdraw\_event

Withdrawal events from Thetanuts covered call vaults on Fantom, recording when users redeem their vault shares with withdrawal amounts, epoch identifiers, and account addresses. Used for tracking vault redemption activity and calculating user position changes across option selling epochs.

<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__from`         | `STRING`    | Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.                                                       |
  | `in__epoch`        | `STRING`    | Epoch identifier for the vault or contract cycle. String-encoded integer representing the sequential period number.                                  |
  | `in__amt`          | `STRING`    | Amount of tokens involved in the transaction. String-encoded integer representing the token quantity in its smallest unit.                           |
  | `in__msgSender`    | `STRING`    | Address of the account that called the contract function. Hex-encoded, 0x-prefixed, 42-character string.                                             |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_\_amt             | removed | in\_\_from                                 | in\_\_epoch | log\_index | block\_number | in\_\_msgSender                            | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | --------------------- | ------- | ------------------------------------------ | ----------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x302abd505757fd355c8ef3cf8b4918d6404f4996 | 4345808473256968025   | false   | 0x391bf92b788150d6e8f23ecc9624499552e2a092 | 13          | 71         | 56791035      | 0x391bf92b788150d6e8f23ecc9624499552e2a092 | 2023-03-02T12:18:36.000Z | 0x8dd2aa00f8a941564295728a26d25c5c4dc56f80999a426cff5c99a16a361f82 |
  | 0x302abd505757fd355c8ef3cf8b4918d6404f4996 | 612214023755223110743 | false   | 0x5a90d3e6cfcc55d4d63ba4f729922413d9364c67 | 22          | 1          | 65282340      | 0x5a90d3e6cfcc55d4d63ba4f729922413d9364c67 | 2023-07-07T10:17:11.000Z | 0x6510792bb5a31d340061cf6878b0591cf68f39948b03d01d8714ffe0ef19ad5b |
  | 0x302abd505757fd355c8ef3cf8b4918d6404f4996 | 122962524904967165418 | false   | 0xa278e3e569b3b922c4cc3d3045764d127dcc5d38 | 18          | 1          | 62716697      | 0xa278e3e569b3b922c4cc3d3045764d127dcc5d38 | 2023-05-20T05:31:40.000Z | 0xb3573506fd3b58524749260094182ac761795ebd143a8a723a8d5204bb9fb063 |
</Accordion>

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

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

***