thetanuts_v1_polygon

Tables

CoveredCallMatic_Deposit_event

Deposit events from ThetaNuts V1 MATIC covered call vaults on Polygon, recording user deposits with amounts, epochs, and depositor addresses. Used for tracking vault participation and analyzing deposit patterns across weekly option 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
0x1724b8679a9cad6cabdef7dbee1d5b03b44584b2	100000	false	0x4150f2cd0f10e6253c318deb4971463fea87cc93	29	766	48874321	0x4150f2cd0f10e6253c318deb4971463fea87cc93	2023-10-18T18:41:50.000Z	0xa2dcc17fdcc677ba1d4f61c29a5fbf2207e05d71e9e343fdd6bfbd45bc4a0c7f
0x1724b8679a9cad6cabdef7dbee1d5b03b44584b2	200000	false	0x7d3d40e9491713ba9297733ab497c3fa962ca14a	29	190	48863941	0x7d3d40e9491713ba9297733ab497c3fa962ca14a	2023-10-18T12:30:01.000Z	0x6c1c27c48b75c7375b66035b579dbe826e93e6566b8998551306c9ded608574e
0x1724b8679a9cad6cabdef7dbee1d5b03b44584b2	200000	false	0xd97948ba6c13eb79a55a614e818336e7570f3add	29	213	48864288	0xd97948ba6c13eb79a55a614e818336e7570f3add	2023-10-18T12:42:19.000Z	0xed95133b2660c36e8286a5dfcfadeefd10e408d63fa3978374d49c236b71c598

Example Query

Query with partition filter

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

CoveredCallMatic_NewEpoch_event

Epoch initialization events from Thetanuts Finance covered call vaults on Polygon, recording strike prices (strikeX1e6 in micro-units), premiums collected, and minimum vault sizes for MATIC options. Used for tracking vault parameters and analyzing options strategy performance across weekly 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__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
0x1724b8679a9cad6cabdef7dbee1d5b03b44584b2	false	0x4a4c7c5549359b9fff0137bb3ec4d48c4aa79cc7	2	200	993014774	33749019	620000	2022-09-30T09:32:23.000Z	0xab50e3251c1f77009812a451b9b2ec70879a7d4a63b639d7ae40ee6ddfba472f	68407684498
0x9da79023af00d1f2054bb1eed0d49004fe41c5b5	false	0xca436e14855323927d6e6264470ded36455fc8bd	2	235	4466470480000000000000	33749489	960000	2022-09-30T09:48:31.000Z	0x990850d5b2ed99cea68a0d06eb32951687fadf30510ab82192f46bd480acdce1	526210000000000000000000
0x9da79023af00d1f2054bb1eed0d49004fe41c5b5	false	0x573ef2e5336fb7ed9b567694109606ac988d5d26	64	225	1750956480000000000000	68103630	387700	2025-02-19T06:12:07.000Z	0x1c903fc639d5d685773450efc9a9db32dc9c161d08f32d90591d85bf3061af47	140301000000000000000000

Example Query

Query with partition filter

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

CoveredCallMatic_Withdraw_event

Withdrawal events from Thetanuts Finance covered call vaults on Polygon, tracking MATIC-denominated position exits with withdrawal amounts, user addresses, and epoch identifiers. Used for analyzing vault participation patterns and capital flows 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
0x1724b8679a9cad6cabdef7dbee1d5b03b44584b2	3794811	false	0xa4e8b9ebdc7a9fbbd73e4557420d182ad610eb60	29	648	48799104	0xa4e8b9ebdc7a9fbbd73e4557420d182ad610eb60	2023-10-16T20:53:03.000Z	0x95a00e7ce76ea8ed797d23da64a5da2bb5ec01c3171cea5fdbda022fcc137441
0x9da79023af00d1f2054bb1eed0d49004fe41c5b5	2999999999999999996	false	0x3591e03172dd55a6e0e701354cf9abb6c25d4eda	29	255	48779421	0x3591e03172dd55a6e0e701354cf9abb6c25d4eda	2023-10-16T08:49:44.000Z	0x1090c308cf97fb0afd826d73156d35f49e2ce9f1666653eb65aa27a3033d7573
0x9da79023af00d1f2054bb1eed0d49004fe41c5b5	20535800032815799862	false	0xd055690f1ba91bfb197dfffda3d03ff9103399cb	35	341	52531961	0xd055690f1ba91bfb197dfffda3d03ff9103399cb	2024-01-20T04:59:19.000Z	0x1d454916412063cdf72d237b681045df976b2fb0bae9a36d1dc1fc814526be26

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CoveredCallMatic_Deposit_event

CoveredCallMatic_NewEpoch_event

CoveredCallMatic_Withdraw_event

​Tables

​CoveredCallMatic_Deposit_event

​CoveredCallMatic_NewEpoch_event

​CoveredCallMatic_Withdraw_event

Tables

CoveredCallMatic_Deposit_event

CoveredCallMatic_NewEpoch_event

CoveredCallMatic_Withdraw_event