thetanuts_v1_arbitrum

Tables

CoveredCallArb_Deposit_event

Deposit events from Thetanuts Finance covered call vaults on Arbitrum, tracking user deposits with amounts, depositor addresses, and epoch identifiers. Used for analyzing vault participation patterns and capital inflows across different 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
0x0833ec3262dcc417d88f85ed5e1ebaf768080f41	531784949370678512	false	0x470d235ca1caff614abee02d98ac3aa89a6758bd	10	3	126208442	0x470d235ca1caff614abee02d98ac3aa89a6758bd	2023-08-29T23:05:05.000Z	0xf00c9b65e1c9eabaa24c90950bb78f89b01a67730f7fff5dda1837371e3a87ec
0x0833ec3262dcc417d88f85ed5e1ebaf768080f41	100248037405396978962	false	0x470d235ca1caff614abee02d98ac3aa89a6758bd	10	3	126205151	0x470d235ca1caff614abee02d98ac3aa89a6758bd	2023-08-29T22:45:56.000Z	0xcc321023ddad0f3b88b1274fcc772cf7358e32d8e9a72d6477e4c6b4d68a35ac
0x0833ec3262dcc417d88f85ed5e1ebaf768080f41	134411286764705881	false	0x470d235ca1caff614abee02d98ac3aa89a6758bd	10	3	126191745	0x470d235ca1caff614abee02d98ac3aa89a6758bd	2023-08-29T21:34:36.000Z	0xdaf8ae67d3349a1c43fd36c5e3e7b1e5ec1ca1b33e16af42a8aedbcf9699ce02

Example Query

Query with partition filter

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

CoveredCallArb_NewEpoch_event

Epoch initialization events from Thetanuts covered call vaults on Arbitrum, recording strike prices (in 1e6 format), premiums collected, and minimum vault sizes for each option-selling period. Used for tracking vault strategy parameters and premium generation across covered call 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
0x0833ec3262dcc417d88f85ed5e1ebaf768080f41	false	0x4a4c7c5549359b9fff0137bb3ec4d48c4aa79cc7	31	0	1098834837133659799971	219793344	1320000	2024-06-08T19:25:04.000Z	0x7ccba6ff52977acef6b64dfd168e3b5d71ac4d78a076ee9a61cf3f694411b0b3	177231425344138677414758
0x0833ec3262dcc417d88f85ed5e1ebaf768080f41	false	0x4a4c7c5549359b9fff0137bb3ec4d48c4aa79cc7	12	0	143211052091528336742	131287869	960000	2023-09-15T09:56:46.000Z	0x38a305d3dbc0e519adf29ce27a405d3afa24867fdba703178c704b3e42f3ab43	28642210418305667348401
0x0833ec3262dcc417d88f85ed5e1ebaf768080f41	false	0x4a4c7c5549359b9fff0137bb3ec4d48c4aa79cc7	29	35	1526196415833152414809	209771593	1317000	2024-05-10T10:00:58.000Z	0xb1948230966df3360b08c4dd6062e40fb3df6e3718bdd34bcbaf8445e009153a	206242758896371947947239

Example Query

Query with partition filter

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

CoveredCallArb_Withdraw_event

Withdrawal events from Thetanuts Finance covered call vaults on Arbitrum, recording when users exit positions with withdrawal amounts and epoch identifiers. Used for tracking vault redemptions and user exit patterns across strategy 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
0x0833ec3262dcc417d88f85ed5e1ebaf768080f41	6710372811584232296	false	0x2f2814da81716b7fcd8af15c3e81db2186dc7239	18	41	164776591	0x2f2814da81716b7fcd8af15c3e81db2186dc7239	2023-12-29T00:27:42.000Z	0xa35177a91d74749cfc2d50dceab6551d11af0dbd99900e0546e406681751e9db
0x0833ec3262dcc417d88f85ed5e1ebaf768080f41	233690417029921810230	false	0x4a4c7c5549359b9fff0137bb3ec4d48c4aa79cc7	18	19	164863169	0x2f2814da81716b7fcd8af15c3e81db2186dc7239	2023-12-29T06:35:47.000Z	0xe1e87c0e6aea8a7029f166e49aed30359cf13eacdbaa4e32b99fe5e00583d234
0x0833ec3262dcc417d88f85ed5e1ebaf768080f41	22880061874366138514170	false	0x4a4c7c5549359b9fff0137bb3ec4d48c4aa79cc7	18	20	164862200	0x2f2814da81716b7fcd8af15c3e81db2186dc7239	2023-12-29T06:31:44.000Z	0x48b04976c2f9c4a888c906f6c586ec3bdc988890aa962081ff612447fb27a08e

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CoveredCallArb_Deposit_event

CoveredCallArb_NewEpoch_event

CoveredCallArb_Withdraw_event

​Tables

​CoveredCallArb_Deposit_event

​CoveredCallArb_NewEpoch_event

​CoveredCallArb_Withdraw_event

Tables

CoveredCallArb_Deposit_event

CoveredCallArb_NewEpoch_event

CoveredCallArb_Withdraw_event