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

> Tables in tt-contracts.thetanuts_v1_ethereum

## Tables

### CoveredCallEthA\_Deposit\_event

Deposit events from Thetanuts Finance's ETH covered call vault on Ethereum, tracking user deposits with amounts, depositor addresses, and vault epoch identifiers. Used for analyzing vault participation patterns and capital inflows across different 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                                                  |
  | ------------------------------------------ | --------- | ------- | ------------------------------------------ | ----------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x3ba337f3167ea35910e6979d5bc3b0aee60e7d59 | 148073605 | false   | 0xcec4707748d9118fb65e321a7a83ac206868d8cd | 42          | 308        | 17581992      | 0xcec4707748d9118fb65e321a7a83ac206868d8cd | 2023-06-29T02:29:35.000Z | 0x70918ce303bc51a6d44059fe0c52f6ab140e9a48b462173bba2e2f2ff5bdcb80 |
  | 0x248038fdb6f00f4b636812ca6a7f06b81a195ab8 | 13950760  | false   | 0xcec4707748d9118fb65e321a7a83ac206868d8cd | 30          | 318        | 17581992      | 0xcec4707748d9118fb65e321a7a83ac206868d8cd | 2023-06-29T02:29:35.000Z | 0x70918ce303bc51a6d44059fe0c52f6ab140e9a48b462173bba2e2f2ff5bdcb80 |
  | 0xe1c93de547cc85cbd568295f6cc322b1dbbcf8ae | 78965561  | false   | 0xcec4707748d9118fb65e321a7a83ac206868d8cd | 31          | 313        | 17581992      | 0xcec4707748d9118fb65e321a7a83ac206868d8cd | 2023-06-29T02:29:35.000Z | 0x70918ce303bc51a6d44059fe0c52f6ab140e9a48b462173bba2e2f2ff5bdcb80 |
</Accordion>

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

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

***

### CoveredCallEthA\_NewEpoch\_event

Epoch initialization events from Thetanuts Finance covered call vaults on Ethereum, recording strike prices, premiums, and minimum vault sizes for ETH option strategies. Used for tracking vault configuration changes and analyzing covered call product parameters across different vault addresses.

<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  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ----------- | ---------- | ------------------ | ------------- | ---------------- | ------------------------ | ------------------------------------------------------------------ | --------------------- |
  | 0xb466a23c77df358b8b1e86514411c5fe0d613896 | false   | 0x629538d6030de25417a67bbd748510e271c7a6ff | 28          | 211        | 4730304000         | 17313490      | 18300000         | 2023-05-22T07:55:47.000Z | 0xa9afed34258b7f89114cf0c35e6105422da9ec2db9eae56bb61e394526aa3a70 | 406406400000          |
  | 0x9014f8e90423766343ed4fe41668563526df6715 | false   | 0x629538d6030de25417a67bbd748510e271c7a6ff | 37          | 190        | 522500000000000000 | 17313701      | 1975000000       | 2023-05-22T08:38:47.000Z | 0xbfe8257cb68ca64d0f451a154b72d6a864b692058ddf194f7007ee8e7c4955f1 | 275000000000000000000 |
  | 0x60a4422b6b52aef50647c67f29d6a7e6dac3ccbc | false   | 0x629538d6030de25417a67bbd748510e271c7a6ff | 37          | 189        | 4242700            | 17313687      | 29150000000      | 2023-05-22T08:35:59.000Z | 0x979cbfb58781e2708c94d380d87e41e97db3edde6a94e06833fa75f64e582499 | 2090000000            |
</Accordion>

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

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

***

### CoveredCallEthA\_Withdraw\_event

Withdrawal events from Thetanuts Finance ETH covered call vault on Ethereum, tracking user redemptions by epoch with amount and account details. Useful for analyzing vault outflows and user behavior in DeFi (decentralized finance) structured products.

<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                                                  |
  | ------------------------------------------ | --------- | ------- | ------------------------------------------ | ----------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x60a4422b6b52aef50647c67f29d6a7e6dac3ccbc | 106015785 | false   | 0xc17006b6f0957a6ea2bb446361eed5eca0383b89 | 28          | 144        | 16847035      | 0xc17006b6f0957a6ea2bb446361eed5eca0383b89 | 2023-03-17T10:47:47.000Z | 0xb059dea0e4694cfedfa6539b1c41abbea12d80886ba2fe3976c29bb35f57eabf |
  | 0x60a4422b6b52aef50647c67f29d6a7e6dac3ccbc | 35072329  | false   | 0x55452c8ffa2434bf5e738d752c5581b409e6633d | 13          | 32         | 16108573      | 0x55452c8ffa2434bf5e738d752c5581b409e6633d | 2022-12-04T02:50:23.000Z | 0xc5012fe18d9068d3e6823e28c46f2586397714859a361baf57a10a76467d266a |
  | 0x6d2cdb589be6037df1aea5dc433829ad5af30013 | 801512034 | false   | 0x01e198818a895f01562e0a087595e5b1c7bb8d5c | 46          | 230        | 17753921      | 0x01e198818a895f01562e0a087595e5b1c7bb8d5c | 2023-07-23T06:06:47.000Z | 0x5380d824b3d8e5887000c21eeb2be78b41adc1c24931dd0b3dac54bdb5d6a2e2 |
</Accordion>

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

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

***