volmex_v1_ethereum

Tables

CollateralToken_Collateralized_event

Collateral deposit events from Volmex v1 protocol on Ethereum, recording when users lock collateral to mint position tokens. Tracks collateral amounts, minted position token quantities, and protocol fees for analyzing Volmex volatility index product usage.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralLock`	`STRING`	Amount of collateral tokens locked in the contract when position tokens are minted, denominated in the smallest unit of the collateral token (wei for ERC-20). Values range from small amounts like 25 million wei to billions of wei depending on the collateral token’s decimals.
`in_positionTokensMinted`	`STRING`	Amount of position tokens minted by the sender in this collateralization event, denominated in the token’s smallest unit (wei). Represents the quantity of synthetic position tokens created when collateral is locked in the Volmex protocol.
`in_fees`	`STRING`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.

Sample Data

address	in_fees	removed	in_sender	log_index	block_number	block_timestamp	transaction_hash	in_collateralLock	in_positionTokensMinted
0xa57fc404f69fce71ca26e26f0a4df7f35c8cd5c3	14113410100000000000	false	0xe920ff5b13c4d8e63bfc5a792562ac0c06e34bf0	385	12946248	2021-08-02T13:37:59.000Z	0xcc3f11fccf3d30751403fc6632cc08549983774c69ac8f8efc2f47b9de165fb2	14099296689900000000000	56397186759600000000
0x1bb632a08936e17ee3971e6eeb824910567e120b	25300	false	0x74bc67ed6948f0a4c387c353975f142dc640537a	70	12948366	2021-08-02T21:33:15.000Z	0x045317f1faf20e069ca43be0ed1b11deb3df4c3728cb60353d0e9a8b087cc29f	25274700	101098800000000000
0xa57fc404f69fce71ca26e26f0a4df7f35c8cd5c3	370157200000000000	false	0xbb3b101bd7c6205e2e69406376125a2ef6190f98	208	14418561	2022-03-19T18:39:00.000Z	0xa8c86e94ca44e29c414079a32acc21365678201f57dad0941357828139640ff0	369787042800000000000	1479148171200000000

Example Query

Query with partition filter

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

CollateralToken_Redeemed_event

Collateral redemption events from Volmex protocol on Ethereum, capturing burns of both volatility and inverse volatility index tokens in exchange for released collateral (USDC). Records show paired token burns, fees charged, and net collateral returned for analyzing redemption patterns and protocol liquidity flows.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralReleased`	`STRING`	Amount of collateral tokens returned to the user when redeeming volatility index positions, denominated in the smallest unit of the collateral token. This value represents the net collateral released after burning both long and short volatility tokens and deducting protocol fees.
`in_volatilityIndexTokenBurned`	`STRING`	Amount of volatility index tokens burned during the redemption event, denominated in the token’s smallest unit (wei). This value represents one half of the paired token burn required to release collateral from the Volmex protocol.
`in_inverseVolatilityIndexTokenBurned`	`STRING`	Amount of inverse volatility index tokens burned during redemption, denominated in the smallest token unit (wei). Values typically match the volatility token burn amount as both are required proportionally to redeem collateral.
`in_fees`	`STRING`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.

Sample Data

address	in_fees	removed	in_sender	log_index	block_number	block_timestamp	transaction_hash	in_collateralReleased	in_volatilityIndexTokenBurned	in_inverseVolatilityIndexTokenBurned
0xa57fc404f69fce71ca26e26f0a4df7f35c8cd5c3	3002925000000000000	false	0x4515957daf1c5a1cd2e24d000e909a0ff6be1975	270	14167847	2022-02-08T21:33:05.000Z	0x52759fac0d1cc70aa3043ecf9587a966ca8b9664cfee1e1bcab996be269c8c06	997972075000000000000	4003900000000000000	4003900000000000000
0xa57fc404f69fce71ca26e26f0a4df7f35c8cd5c3	75000000000000000	false	0x070330e027a3e4327ba69f0c8a1885df4b545837	88	12696021	2021-06-24T09:26:46.000Z	0x4bcdde48acf69cd8eb422c95d41c45e232f366561e3aca1fdaf2d7dab4add0ee	24925000000000000000	100000000000000000	100000000000000000
0xa57fc404f69fce71ca26e26f0a4df7f35c8cd5c3	3750000000000000	false	0x070330e027a3e4327ba69f0c8a1885df4b545837	261	12695966	2021-06-24T09:13:33.000Z	0x978bce9bd150cb1a5abd9e59c2f882f8054fc5cbfee238de4001158703473298	1246250000000000000	5000000000000000	5000000000000000

Example Query

Query with partition filter

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

IndexFactory_IndexRegistered_event

Event logs tracking registration of new volatility indexes in the Volmex protocol on Ethereum. Records index contract addresses and sequential counts for monitoring protocol expansion and newly deployed index products.

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_indexCount`	`STRING`	Cumulative count of indices registered in the Volmex factory contract at the time of this event. Increments sequentially with each new index registration, starting from 1.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	log_index	block_number	in_indexCount	block_timestamp	transaction_hash
0x3ceea6a3c98c2489b09b820f62fe568b5e21e797	false	0xa57fc404f69fce71ca26e26f0a4df7f35c8cd5c3	4	12607972	1	2021-06-10T16:59:55.000Z	0x52c85a30f60f714c99b4ffff9d12ed792b2d7ae374719329d1bf7006a27e00d3
0x3ceea6a3c98c2489b09b820f62fe568b5e21e797	false	0x187922d4235d10239b2c6ccb2217ada724f56dda	64	12608030	2	2021-06-10T17:11:31.000Z	0x8e1f1fe892598f979c2e43f849b1f4d17a4133e634543698cb4e9b5071f9afcc
0x3ceea6a3c98c2489b09b820f62fe568b5e21e797	false	0x1bb632a08936e17ee3971e6eeb824910567e120b	38	12946464	3	2021-08-02T14:28:14.000Z	0xcfd399b2ead66faa153ebbb7d497e5ebffe63396f437a8e2e15c7f08af23a62d

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

CollateralToken_Collateralized_event

CollateralToken_Redeemed_event

IndexFactory_IndexRegistered_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CollateralToken_Collateralized_event

​CollateralToken_Redeemed_event

​IndexFactory_IndexRegistered_event

Tables

CollateralToken_Collateralized_event

CollateralToken_Redeemed_event

IndexFactory_IndexRegistered_event