Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__fromSTRINGAddress initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
in__epochSTRINGEpoch identifier for the vault or contract cycle. String-encoded integer representing the sequential period number.
in__amtSTRINGAmount of tokens involved in the transaction. String-encoded integer representing the token quantity in its smallest unit.
in__msgSenderSTRINGAddress of the account that called the contract function. Hex-encoded, 0x-prefixed, 42-character string.
addressin__amtremovedin__fromin__epochlog_indexblock_numberin__msgSenderblock_timestamptransaction_hash
0x302abd505757fd355c8ef3cf8b4918d6404f4996100000000000000000000false0xd613c840caa8eb854abfda79a4b709aa2ab8e620143581313900xd613c840caa8eb854abfda79a4b709aa2ab8e6202023-03-22T14:03:48.000Z0x095be9c997d01813d299ad6881d6007b6b6b643c0483055eeacb9b8cd2a1f409
0x302abd505757fd355c8ef3cf8b4918d6404f4996802000000000000000000false0xd613c840caa8eb854abfda79a4b709aa2ab8e6201447581315090xd613c840caa8eb854abfda79a4b709aa2ab8e6202023-03-22T14:05:50.000Z0x5b1e489622ca09cd78506bc232209c9ad1ef862c065c61cd7103b123ddc5f669
0x7eda4c29726355d0d8e85001b9152158b35eae4f14145901false0xfdc6660c90c6fb0c7552f8de237a054c650aa565142581213530xfdc6660c90c6fb0c7552f8de237a054c650aa5652023-03-22T10:34:07.000Z0xcf07cf582d33f5ad8e0622f2829deb566eac7265487401068768f7444ce56965
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__fromSTRINGAddress initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
in__epochSTRINGEpoch identifier for the vault or contract cycle. String-encoded integer representing the sequential period number.
in__strikeX1e6STRINGOption 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__premiumSTRINGPremium 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__minSizeOfVaultSTRINGMinimum total value locked in the vault for the epoch. String-encoded integer representing the vault’s base asset amount in smallest denomination.
addressremovedin__fromin__epochlog_indexin__premiumblock_numberin__strikeX1e6block_timestamptransaction_hashin__minSizeOfVault
0x7eda4c29726355d0d8e85001b9152158b35eae4ffalse0xca436e14855323927d6e6264470ded36455fc8bd45175673000498026081630002022-10-23T02:11:31.000Z0x5af98b3d9f6bbf3695fe6c0c108782afd12211df64596a8e41e27f82bd7abc7912334699000
0x302abd505757fd355c8ef3cf8b4918d6404f4996false0x629538d6030de25417a67bbd748510e271c7a6ff19342234654000000000000000628440784290002023-05-22T08:02:59.000Z0xcbc63c74a1268d11c2797cb048cc4cc0038b7e92b60c9dd7ba08d6f64b23b571314740000000000000000000
0x7eda4c29726355d0d8e85001b9152158b35eae4ffalse0x4337941a2fe5d22e3f70850b69931d97044dc176150486552000582700574030002023-03-24T10:19:20.000Z0x7e608613ba2855b1a2116e8177a8601515b47da70e07654310f56855bdc4bc8b16340038000
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__fromSTRINGAddress initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
in__epochSTRINGEpoch identifier for the vault or contract cycle. String-encoded integer representing the sequential period number.
in__amtSTRINGAmount of tokens involved in the transaction. String-encoded integer representing the token quantity in its smallest unit.
in__msgSenderSTRINGAddress of the account that called the contract function. Hex-encoded, 0x-prefixed, 42-character string.
addressin__amtremovedin__fromin__epochlog_indexblock_numberin__msgSenderblock_timestamptransaction_hash
0x302abd505757fd355c8ef3cf8b4918d6404f49964345808473256968025false0x391bf92b788150d6e8f23ecc9624499552e2a0921371567910350x391bf92b788150d6e8f23ecc9624499552e2a0922023-03-02T12:18:36.000Z0x8dd2aa00f8a941564295728a26d25c5c4dc56f80999a426cff5c99a16a361f82
0x302abd505757fd355c8ef3cf8b4918d6404f4996612214023755223110743false0x5a90d3e6cfcc55d4d63ba4f729922413d9364c67221652823400x5a90d3e6cfcc55d4d63ba4f729922413d9364c672023-07-07T10:17:11.000Z0x6510792bb5a31d340061cf6878b0591cf68f39948b03d01d8714ffe0ef19ad5b
0x302abd505757fd355c8ef3cf8b4918d6404f4996122962524904967165418false0xa278e3e569b3b922c4cc3d3045764d127dcc5d38181627166970xa278e3e569b3b922c4cc3d3045764d127dcc5d382023-05-20T05:31:40.000Z0xb3573506fd3b58524749260094182ac761795ebd143a8a723a8d5204bb9fb063
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