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.

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

Example Query

Query with partition filter

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

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.

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

Example Query

Query with partition filter

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

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.

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

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CoveredCallFtm_Deposit_event

CoveredCallFtm_NewEpoch_event

CoveredCallFtm_Withdraw_event

​Tables

​CoveredCallFtm_Deposit_event

​CoveredCallFtm_NewEpoch_event

​CoveredCallFtm_Withdraw_event

Tables

CoveredCallFtm_Deposit_event

CoveredCallFtm_NewEpoch_event

CoveredCallFtm_Withdraw_event