thetanuts_v1_avalanche

Tables

CoveredCallAvax_Deposit_event

Deposit events from Thetanuts Finance covered call vaults on Avalanche, tracking AVAX deposits by users into option-writing strategies. Records depositor addresses, amounts (in wei for AVAX, smallest units for stablecoins), and epoch identifiers for analyzing vault participation and deposit patterns.

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
0xd06bd68d58ed40cc2031238a3993b99172ea37ca	30000000000000000	false	0x66a3719b28f1bfb49797f78b30797c6685d5ee8a	17	19	29790541	0x66a3719b28f1bfb49797f78b30797c6685d5ee8a	2023-05-09T09:26:50.000Z	0x0f3b691d1cadbc5fa654f7553f66885bd9ed414204a704d2cfe730ce35690d8c
0xd06bd68d58ed40cc2031238a3993b99172ea37ca	20000000000000000	false	0x0e437c109a4c1e15172c4da557e77724d7243f71	17	75	29789776	0x0e437c109a4c1e15172c4da557e77724d7243f71	2023-05-09T09:01:05.000Z	0x48ce4eb3b55622963f0e92a37f128ebcbe63ed248d5537656337ea5bf882ca9b
0xa84aa41b6287afe467cce688f3796a2205198f07	813	false	0x61ee3ca7448fb3c096729b58c536b1f310e34607	17	60	29813338	0x61ee3ca7448fb3c096729b58c536b1f310e34607	2023-05-09T22:17:08.000Z	0xf29ac50c76cc0b02f1c9abe7512c2d1657ecaac62fb29fda360357b1ecf9a6c8

Example Query

Query with partition filter

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

CoveredCallAvax_NewEpoch_event

New epoch initialization events from Thetanuts covered call vaults on Avalanche, capturing strike prices, premiums, and vault parameters for each options selling period. Used to analyze vault strategy configuration and premium generation over time.

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
0xd06bd68d58ed40cc2031238a3993b99172ea37ca	false	0x4e81b871c1dce8bfa0b3050703716a9176c77a35	8	7	32474400000000000000	24302624	12200000	2022-12-30T14:37:03.000Z	0x8027f41198eb2ea91156c22433bf091c772016a6cc4ddcac263a5bc4e1b9419a	11598000000000000000000
0xa84aa41b6287afe467cce688f3796a2205198f07	false	0x4a4c7c5549359b9fff0137bb3ec4d48c4aa79cc7	8	2	98673821	24294509	9300000	2022-12-30T10:01:36.000Z	0xdd614897a2e1d26da35fb36595780a1debcd1f13e186aabc754447550bd27df5	19118052841
0xd06bd68d58ed40cc2031238a3993b99172ea37ca	false	0x950a1d93c9d51409a6d537c49ad34cf42e01d31a	12	29	47500000000000000000	26678409	22700000	2023-02-24T15:07:39.000Z	0x1356656a4e6cfc3ce67d089083ff536e1401d2ad444b1c52a3cd82ec8e2d37fe	1900000000000000000000

Example Query

Query with partition filter

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

CoveredCallAvax_Withdraw_event

Withdrawal events from Thetanuts Finance covered call vaults on Avalanche, tracking user redemptions with withdrawal amounts and epoch identifiers. Used for analyzing vault liquidity flows and user withdrawal patterns 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
0xd06bd68d58ed40cc2031238a3993b99172ea37ca	3714244851950116011	false	0xa5bc6a65d927b70a7dcd1f76233eb2c31649a9b9	10	11	25691561	0xa5bc6a65d927b70a7dcd1f76233eb2c31649a9b9	2023-02-01T11:30:06.000Z	0x2789877f300b2935340cbbacf69c0eebbed2feef9a8626168c48120c078f24ee
0xa84aa41b6287afe467cce688f3796a2205198f07	10206367189	false	0xd3aa34a9e80d62d937e26ee77921396f70211a44	3	96	21359900	0xd3aa34a9e80d62d937e26ee77921396f70211a44	2022-10-21T18:24:25.000Z	0xde9cf16f6bbbb4cde7443c2f8d21cd3af0c56673ff5b92367699a3c6abc99a39
0xd06bd68d58ed40cc2031238a3993b99172ea37ca	41613459079180844879	false	0xbc9e59f9fbb048f7d0faa593a0d197d420653572	11	1	26129886	0xbc9e59f9fbb048f7d0faa593a0d197d420653572	2023-02-11T17:53:34.000Z	0xd9074c47bd7b610d8f1b02a77404b495060f9ca760206a11623e8049002321fb

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CoveredCallAvax_Deposit_event

CoveredCallAvax_NewEpoch_event

CoveredCallAvax_Withdraw_event

​Tables

​CoveredCallAvax_Deposit_event

​CoveredCallAvax_NewEpoch_event

​CoveredCallAvax_Withdraw_event

Tables

CoveredCallAvax_Deposit_event

CoveredCallAvax_NewEpoch_event

CoveredCallAvax_Withdraw_event