thetanuts_v1_bsc

Tables

CoveredCallBnb_Deposit_event

Deposit events from Thetanuts Finance covered call vaults on BNB Chain, recording user deposits of BNB with depositor address, amount, and epoch identifier. Used for tracking vault participation and capital inflows across option selling cycles.

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
0x9ef72de1782431cf54518c42c06e26014e7201d1	100000000000000	false	0xf51d9c8311cc58d1e26d425425568f7e2c5cc5c1	10	304	25212356	0xf51d9c8311cc58d1e26d425425568f7e2c5cc5c1	2023-01-29T18:03:01.000Z	0x7ccd50b977ee62b864ce08d421584eb06d322fd8e156a735501b286dc7e8dd1c
0xc75c3be0bc41857b9c1a675475f6e0a7c5db63fc	100250000000000000000	false	0x6ec8b8cec5645066fda40c6c6d6c3b749a565755	9	187	24914238	0x6ec8b8cec5645066fda40c6c6d6c3b749a565755	2023-01-19T06:20:20.000Z	0xe1f52fcbe3425fc0c8cf45e09d71c8802c04b3ddfec222adc0ffac93229424aa
0x9ef72de1782431cf54518c42c06e26014e7201d1	100000000000000000	false	0x7270339e4cc37be1d5093a758aff645fbab24b9b	24	118	30996591	0x7270339e4cc37be1d5093a758aff645fbab24b9b	2023-08-19T18:37:55.000Z	0x54e576a038f60b01baffde5237ecc31b09a136367b58fc325f0840ff3fa75e20

Example Query

Query with partition filter

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

CoveredCallBnb_NewEpoch_event

Epoch initialization events from Thetanuts covered call vaults on BSC, capturing strike price, premium, and minimum vault size when new option-selling periods begin. Used for tracking vault strategy parameters and analyzing option pricing across different BNB call vault contracts.

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
0x9ef72de1782431cf54518c42c06e26014e7201d1	false	0x198d95ba9e9a4ed1b8e3982ce223ff5f727a2351	26	119	946630000000000000	31637154	238300000	2023-09-11T02:45:45.000Z	0x1a453328238c300bba7d6b429e572c7fc0e87c6a858e34d6a4d03c14a8f34e09	181000000000000000000
0xf98297a842f52cd1f6c6f5f003cd701813b1c461	false	0xb8dd07ef9ed7090cce388d9d2772b1291265e72f	7	15	30516245877915551095	23570592	400000	2022-12-02T22:17:17.000Z	0x6c0e29555936b90870555938d0cc767c4415e3172d69291277eeb465cd98f57d	3814530734739443886886
0xc879ecc0d2cda26072e9049178a99b26c51edf8a	false	0xb8dd07ef9ed7090cce388d9d2772b1291265e72f	7	126	23994200291613819	23570593	139000000	2022-12-02T22:17:20.000Z	0x082b20dc0361242515f281fcd9191ffcc5c5f0bf6b01476a5dcf2b6b29a7ed65	2999275036451727429

Example Query

Query with partition filter

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

CoveredCallBnb_Withdraw_event

Withdrawal events from ThetaNuts Finance covered call vaults for BNB on BSC (BNB Smart Chain), tracking user redemptions with withdrawal amounts, vault addresses, and epoch identifiers. Used for analyzing vault liquidity flows and user exit patterns in decentralized options protocol.

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
0xc75c3be0bc41857b9c1a675475f6e0a7c5db63fc	11689520456966629527	false	0xe65fdb1fd715c3ffd3ff87700a19c1baafc087d8	9	292	25144956	0xe65fdb1fd715c3ffd3ff87700a19c1baafc087d8	2023-01-27T09:05:00.000Z	0x62415629254d93601cdbc011677ab7899c524dcd6d1100a120d72820a18af6d1
0xc75c3be0bc41857b9c1a675475f6e0a7c5db63fc	6436726829718591664	false	0x86d67879ce0ad6bb4f58e87c792890ded462b565	4	472	22965415	0x86d67879ce0ad6bb4f58e87c792890ded462b565	2022-11-11T14:12:54.000Z	0x9a1f5b7e4cd7beb167e4b23350f398a0cdda4b3304e8d247397253c9727a5616
0x9ef72de1782431cf54518c42c06e26014e7201d1	95577705268732639	false	0xa551bf8d2a604e39f7043eb19c66c817d22fcba9	7	201	24118646	0xa551bf8d2a604e39f7043eb19c66c817d22fcba9	2022-12-22T07:43:35.000Z	0x10d6d427b14b13c49fd4f3d464042e195a160827736c2c86eab4677a8b43c791

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

CoveredCallBnb_Deposit_event

CoveredCallBnb_NewEpoch_event

CoveredCallBnb_Withdraw_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CoveredCallBnb_Deposit_event

​CoveredCallBnb_NewEpoch_event

​CoveredCallBnb_Withdraw_event

Tables

CoveredCallBnb_Deposit_event

CoveredCallBnb_NewEpoch_event

CoveredCallBnb_Withdraw_event