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.

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.

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thetanuts_v1_ethereum.CoveredCallEthA_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.

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.

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thetanuts_v1_ethereum.CoveredCallEthA_NewEpoch_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.

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.

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thetanuts_v1_ethereum.CoveredCallEthA_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

CoveredCallEthA_Deposit_event

CoveredCallEthA_NewEpoch_event

CoveredCallEthA_Withdraw_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CoveredCallEthA_Deposit_event

​CoveredCallEthA_NewEpoch_event

​CoveredCallEthA_Withdraw_event

Tables

CoveredCallEthA_Deposit_event

CoveredCallEthA_NewEpoch_event

CoveredCallEthA_Withdraw_event