dopex_v2_arbitrum

Tables

ArbDopexV2OptionMarket_LogMintOption_event

Option minting events from Dopex V2 decentralized options protocol on Arbitrum, capturing each new option position created with premium paid, collateral withdrawn, and option type (call/put). Useful for analyzing option trading activity, premium pricing trends, and user behavior 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_isCall`	`BOOL`	Boolean flag indicating whether the minted option is a call option (true) or a put option (false). All sample values show true, indicating call option mints in this Dopex V2 market.
`in_premiumAmount`	`STRING`	Premium amount paid by the option buyer at mint, denominated in the underlying token’s smallest unit (wei for ETH-based tokens). This value represents the upfront cost to acquire the option position.
`in_totalAssetWithdrawn`	`STRING`	Total collateral amount withdrawn from the liquidity pool to back the minted option position. Denominated in the smallest unit of the underlying asset (wei-equivalent), representing the locked collateral for the option contract.

Sample Data

address	in_user	removed	in_isCall	log_index	in_tokenId	block_number	block_timestamp	in_premiumAmount	transaction_hash	in_totalAssetWithdrawn
0x77b6f45a3dcf0493f1b9ac9874e5982ab526aa9e	0x1164fa17505e7196889d698b0c348c50dfc3eccd	false	true	45	2238	155530367	2023-11-30T11:34:21.000Z	4422511268435875603	0x2eada1500215a79405089beff3ed29e44e6d7a1575b77a6ba8c50a2d37d523af	2629194916522506396334
0x77b6f45a3dcf0493f1b9ac9874e5982ab526aa9e	0x1164fa17505e7196889d698b0c348c50dfc3eccd	false	true	108	2241	155530367	2023-11-30T11:34:21.000Z	3627132369140264488	0x2eada1500215a79405089beff3ed29e44e6d7a1575b77a6ba8c50a2d37d523af	3629589430837981557754
0x77b6f45a3dcf0493f1b9ac9874e5982ab526aa9e	0x1164fa17505e7196889d698b0c348c50dfc3eccd	false	true	24	2237	155530367	2023-11-30T11:34:21.000Z	3667316673315589640	0x2eada1500215a79405089beff3ed29e44e6d7a1575b77a6ba8c50a2d37d523af	2005148824207724085431

Example Query

Query with partition filter

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

ArbDopexV2OptionMarket_LogOptionsMarketInitialized_event

Initialization events for Dopex V2 options markets on Arbitrum, recording the configuration of new option markets including call/put asset pairs (e.g., ARB/USDC), pricing contracts, and liquidity pool addresses. Used to track market deployments and reference market infrastructure components.

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_primePool`	`STRING`	Contract address of the prime pool associated with this options market initialization. Hex-encoded, 0x-prefixed 40-character Ethereum address pointing to the liquidity pool contract.
`in_optionPricing`	`STRING`	Contract address of the option pricing oracle or module used by this Dopex V2 options market. This address determines how option premiums and Greeks are calculated for the market.
`in_dpFee`	`STRING`	Contract address of the Dopex fee collector or fee configuration contract for this options market. May be zero address (0x00…) if fees are not configured or handled differently.
`in_callAsset`	`STRING`	Contract address of the call option’s underlying asset token on Arbitrum. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20 token used as collateral for call options in this Dopex V2 options market.
`in_putAsset`	`STRING`	Contract address of the put option’s underlying asset on Arbitrum. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20 token used for put options in this market.

Sample Data

address	removed	in_dpFee	log_index	in_putAsset	block_number	in_callAsset	in_primePool	block_timestamp	in_optionPricing	transaction_hash
0x77b6f45a3dcf0493f1b9ac9874e5982ab526aa9e	false	0x0000000000000000000000000000000000000000	4	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	149743227	0x912ce59144191c1204e64559fe8253a0e49e6548	0xcda53b1f66614552f834ceef361a8d12a0b8dad8	2023-11-12T16:53:36.000Z	0x2b99e3d67dad973c1b9747da742b7e26c8bdd67b	0xfa5815c2bc14d58656868a8f2e86048d890d5df7ef4b4fea96a2de3ba73cb106

Example Query

Query with partition filter

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

WbtcDopexV2OptionMarket_LogMintOption_event

WBTC option minting events from Dopex V2 protocol on Arbitrum, capturing user addresses, token IDs, premiums paid, and collateral withdrawn for each option position created. Used for analyzing option buyer activity, premium flows, and position sizing in wrapped Bitcoin options markets.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_isCall`	`BOOL`	Boolean flag indicating whether the minted option is a call option (true) or put option (false). All sample values show false, representing put options on WBTC.
`in_premiumAmount`	`STRING`	Premium amount paid by the option buyer for minting this option position, denominated in the base asset’s smallest unit (likely satoshis for WBTC). Values typically range from hundreds of thousands to millions, representing the cost to open the option.
`in_totalAssetWithdrawn`	`STRING`	Total collateral withdrawn from the liquidity pool to back the minted option, denominated in the smallest unit of WBTC (satoshis). This represents the amount locked to collateralize the option position being created.

Sample Data

address	in_user	removed	in_isCall	log_index	in_tokenId	block_number	block_timestamp	in_premiumAmount	transaction_hash	in_totalAssetWithdrawn
0x3808e8c983023a125ffe2714e2a703a3bf02be0d	0x3057466df9d5e1c9d3a9a3b0cc256512c2c3661e	false	false	45	9910	180834265	2024-02-15T00:43:40.000Z	1015163	0x3dc35e3c0c5cd972e8b1e7812c6199b82816483123eb95133f757eeccd233447	157331003
0x3808e8c983023a125ffe2714e2a703a3bf02be0d	0x3057466df9d5e1c9d3a9a3b0cc256512c2c3661e	false	false	66	9911	180834265	2024-02-15T00:43:40.000Z	2589012	0x3dc35e3c0c5cd972e8b1e7812c6199b82816483123eb95133f757eeccd233447	472602887
0x3808e8c983023a125ffe2714e2a703a3bf02be0d	0x3057466df9d5e1c9d3a9a3b0cc256512c2c3661e	false	false	24	9909	180834265	2024-02-15T00:43:40.000Z	948597	0x3dc35e3c0c5cd972e8b1e7812c6199b82816483123eb95133f757eeccd233447	129485586

Example Query

Query with partition filter

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

WbtcDopexV2OptionMarket_LogOptionsMarketInitialized_event

Initialization events for Dopex V2 WBTC (Wrapped Bitcoin) options markets on Arbitrum, capturing the deployment configuration including call/put assets, pricing contracts, and liquidity pool addresses. Used to track when new WBTC options markets become active and their initial parameters.

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_primePool`	`STRING`	Contract address of the Dopex V2 prime liquidity pool associated with this WBTC options market. Hex-encoded, 0x-prefixed 40-character string representing the pool providing liquidity for option settlements.
`in_optionPricing`	`STRING`	Contract address of the option pricing module used to calculate premiums and settlement values for this Dopex V2 options market. This address points to the pricing logic contract that determines option costs based on parameters like volatility and time to expiration.
`in_dpFee`	`STRING`	Contract address of the Dopex protocol fee recipient or fee configuration contract. Set to zero address (0x000…000) when fees are disabled or not yet configured.
`in_callAsset`	`STRING`	Contract address of the call option asset (WBTC) for this Dopex V2 options market on Arbitrum. Hex-encoded, 0x-prefixed 40-character string representing the underlying token used for call options.
`in_putAsset`	`STRING`	Contract address of the put option’s underlying asset in the Dopex V2 options market. Typically USDC or other stablecoins used as collateral for put options on Arbitrum.

Sample Data

address	removed	in_dpFee	log_index	in_putAsset	block_number	in_callAsset	in_primePool	block_timestamp	in_optionPricing	transaction_hash
0x3808e8c983023a125ffe2714e2a703a3bf02be0d	false	0x0000000000000000000000000000000000000000	1	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	149742260	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	0xac70bd92f89e6739b3a08db9b6081a923912f73d	2023-11-12T16:49:20.000Z	0x2b99e3d67dad973c1b9747da742b7e26c8bdd67b	0xca3948778235967d1fb23f648ac162efca2722883e898431e019a30d6ed28c45

Example Query

Query with partition filter

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

WethDopexV2OptionMarket_LogMintOption_event

Option minting events from Dopex V2 WETH options market on Arbitrum, recording when users purchase call or put options with premium paid, tokenID assigned, and total collateral withdrawn. Used for tracking options trading activity, premium flows, and market participant behavior.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_isCall`	`BOOL`	Boolean flag indicating the option type: true for call options (right to buy), false for put options (right to sell). Determines the directionality of the minted position in the Dopex V2 WETH option market.
`in_premiumAmount`	`STRING`	Premium paid by the option buyer to mint the position, denominated in the smallest unit of the underlying asset (wei for WETH). Values vary significantly based on option parameters, ranging from small amounts like 11931 to larger premiums exceeding 11.5 quintillion wei.
`in_totalAssetWithdrawn`	`STRING`	Total asset amount withdrawn from liquidity pools to cover the minted option position, denominated in the smallest unit of WETH (wei). This value includes both the premium and collateral requirements for the option.

Sample Data

address	in_user	removed	in_isCall	log_index	in_tokenId	block_number	block_timestamp	in_premiumAmount	transaction_hash	in_totalAssetWithdrawn
0x764fa09d0b3de61eed242099bd9352c1c61d3d27	0x0641bc55ddab3b9636e82cbf87ede3c3c533039d	false	false	43	8147	162572547	2023-12-22T11:30:58.000Z	11931	0xbfd0770a53541d9395638ad146a505a9e7128972b3b4f47505a72ed03f4a1964	2358268
0x764fa09d0b3de61eed242099bd9352c1c61d3d27	0x134f06a09dd9a16b3597810c3990b28447017f49	false	true	167	8195	162595014	2023-12-22T13:04:04.000Z	1324836838728311	0x000d8619156918f9be68baf324b34f21c8fa504e833cf6f7cc22a1f6373ef64a	1324837254969280197
0x764fa09d0b3de61eed242099bd9352c1c61d3d27	0x134f06a09dd9a16b3597810c3990b28447017f49	false	true	125	8193	162595014	2023-12-22T13:04:04.000Z	1223577604638924	0x000d8619156918f9be68baf324b34f21c8fa504e833cf6f7cc22a1f6373ef64a	1223578116478580394

Example Query

Query with partition filter

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

WethDopexV2OptionMarket_LogOptionsMarketInitialized_event

Initialization events for Dopex V2 WETH options markets on Arbitrum, capturing initial configuration of call/put assets, pricing contracts, and liquidity pools. Used to track new market deployments and their associated contract addresses for options trading infrastructure.

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_primePool`	`STRING`	Contract address of the prime pool associated with this options market initialization. This is the liquidity pool that backs the options and handles collateral management for the market.
`in_optionPricing`	`STRING`	Contract address of the option pricing module used by this Dopex V2 options market. This address implements the pricing logic for calculating option premiums and Greeks.
`in_dpFee`	`STRING`	Contract address of the Dopex fee recipient or fee manager for this options market. Can be zero address if fees are not configured or collected at initialization.
`in_callAsset`	`STRING`	Contract address of the call option’s underlying asset in this Dopex V2 options market. Based on samples, this is WETH (0x82af…) on Arbitrum.
`in_putAsset`	`STRING`	Contract address of the put option’s underlying asset on Arbitrum. Hex-encoded, 0x-prefixed address identifying the token used as collateral for put options in this Dopex V2 options market.

Sample Data

address	removed	in_dpFee	log_index	in_putAsset	block_number	in_callAsset	in_primePool	block_timestamp	in_optionPricing	transaction_hash
0x764fa09d0b3de61eed242099bd9352c1c61d3d27	false	0x0000000000000000000000000000000000000000	19	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	149426720	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xc31e54c7a869b9fcbecc14363cf510d1c41fa443	2023-11-11T17:17:47.000Z	0x2b99e3d67dad973c1b9747da742b7e26c8bdd67b	0xfa95652a9282bb6b33d4cd1b1eb0747cdc20b50031487e0b56517df74f7774d3

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ArbDopexV2OptionMarket_LogMintOption_event

ArbDopexV2OptionMarket_LogOptionsMarketInitialized_event

WbtcDopexV2OptionMarket_LogMintOption_event

WbtcDopexV2OptionMarket_LogOptionsMarketInitialized_event

WethDopexV2OptionMarket_LogMintOption_event

WethDopexV2OptionMarket_LogOptionsMarketInitialized_event

​Tables

​ArbDopexV2OptionMarket_LogMintOption_event

​ArbDopexV2OptionMarket_LogOptionsMarketInitialized_event

​WbtcDopexV2OptionMarket_LogMintOption_event

​WbtcDopexV2OptionMarket_LogOptionsMarketInitialized_event

​WethDopexV2OptionMarket_LogMintOption_event

​WethDopexV2OptionMarket_LogOptionsMarketInitialized_event

Tables

ArbDopexV2OptionMarket_LogMintOption_event

ArbDopexV2OptionMarket_LogOptionsMarketInitialized_event

WbtcDopexV2OptionMarket_LogMintOption_event

WbtcDopexV2OptionMarket_LogOptionsMarketInitialized_event

WethDopexV2OptionMarket_LogMintOption_event

WethDopexV2OptionMarket_LogOptionsMarketInitialized_event