dopex_v1_arbitrum

Tables

ArbMonthlyCallsSsovV3_Purchase_event

Option purchase events from Dopex V1 monthly call SSOV (Single Staking Option Vault) on Arbitrum. Tracks call option buys with strike prices, premiums, amounts, and epoch identifiers for analyzing options trading activity and vault utilization.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0x9d40074db2f8570e2a608ad45ab66a1dbb95193b	1089956249529304	0xdf3d96299275e2fb40124b8ad9d270acfdcc6148	false	2	999970893542491980	0x8bebc5e26592e7439600f92811a8e53e203a16c5	110000000	20	43295994263959236	100957357	2023-06-14T04:11:01.000Z	0xa661a21a89de1276d9ab04c6247ae09a3b5fc1463d64cde04d2e6fe4d4987bc6
0xee85ae5daab560731243403f56c51654def8bc6e	12477500000000000000	0xdf3d96299275e2fb40124b8ad9d270acfdcc6148	false	6	7750000000000000000000	0xee85ae5daab560731243403f56c51654def8bc6e	128000000	9	7836901739385006763	141653893	2023-10-18T09:24:50.000Z	0x2d08401ad53aeaaf022a7e29ac2ff34f521187b371e8ec475084498eb541ce41
0xbce05e49d1c2ae2ef30fec16c30b8786254028a5	472769977456489649	0xdf3d96299275e2fb40124b8ad9d270acfdcc6148	false	6	459000000000000000000	0xbce05e49d1c2ae2ef30fec16c30b8786254028a5	81000000	10	7532109939555260649	141552296	2023-10-18T01:34:28.000Z	0xcdcad832ec32f6ffcc28f55bb2f0a933e8ef88b5b2e08d55ac5c63971526231b

Example Query

Query with partition filter

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

CrvWeeklyPutsSsovV3_Purchase_event

Put option purchase events from Dopex’s CRV (Curve DAO) weekly Single Staking Option Vault (SSOV) V3 on Arbitrum. Records include strike price, premium paid, option amount, epoch identifier, and fee data for analyzing DeFi options trading 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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0x4594de64d7ffcabf324d6420f186b6325bce5c64	67242389348420036	0x7c5ac7e4e352b733cf65721d9fe28a17da890159	false	4	57647000000000000000	0x4594de64d7ffcabf324d6420f186b6325bce5c64	85000000	12	1145908408156083648	26322117	2022-09-24T05:31:17.000Z	0x0f169bad50e2eb3e9b5d9d481d1edbac906277a80684d3ad78fc377e08dd36e3
0xa94184c5d58dce066451ae8eb66b8411d4bd9eac	8082163994883806148	0x7c5ac7e4e352b733cf65721d9fe28a17da890159	false	4	6991050000000000000000	0xa94184c5d58dce066451ae8eb66b8411d4bd9eac	75000000	12	27789842179885497821	26340835	2022-09-24T07:33:12.000Z	0xb6412695fae6ffc8c22e82cf029f5b1ed002f693def50365735041d8503983d9
0xfbaa6104ce2321ea98f0ad6c5ab3d49871bc0f4f	1709434339354045689	0x7c5ac7e4e352b733cf65721d9fe28a17da890159	false	16	2500000000000000000000	0xfbaa6104ce2321ea98f0ad6c5ab3d49871bc0f4f	50000000	12	25229628538618982689	46830367	2022-12-17T08:21:43.000Z	0x44497edd3191606a2917aba13c40711150e2465285fed725a5aea7a3a9426319

Example Query

Query with partition filter

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

DpxMonthlyCallsSsovV3_Purchase_event

Option purchase events from Dopex DPX Monthly Calls Single Staking Option Vault (SSOV) V3 on Arbitrum. Records buyer addresses, strike prices, option amounts, premiums paid, and fees for analyzing options trading activity and vault utilization across monthly 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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0x1164fa17505e7196889d698b0c348c50dfc3eccd	8549999800353855	0x05e7aced3b7727f9129e6d302b488cd8a1e0c817	false	14	6000000000000000000	0x1164fa17505e7196889d698b0c348c50dfc3eccd	8800000000	5	201382299542997385	139665270	2023-10-11T12:31:02.000Z	0x6f18b1eaf0ea16e79375271b567e07b6bf43b1dd750bbda71cae97efe8cf35be
0x1164fa17505e7196889d698b0c348c50dfc3eccd	29860999926142656	0x05e7aced3b7727f9129e6d302b488cd8a1e0c817	false	14	22970000000000000000	0x1164fa17505e7196889d698b0c348c50dfc3eccd	8000000000	5	1474399438634298504	139665124	2023-10-11T12:30:27.000Z	0xfec401d0f1cef0d0d90526eb76330370fb05b2247a6c0e511659ae8ccfcb8485
0x5e49492c0dcd3e7e631929b64214e1a3628aeddd	629999999933531177	0x05e7aced3b7727f9129e6d302b488cd8a1e0c817	false	7	350000000000000000000	0x5e49492c0dcd3e7e631929b64214e1a3628aeddd	39000000000	5	9210041009911835953	69137217	2023-03-12T12:41:33.000Z	0x852216993d8e5754d97d0b203833de2b0f1a21213dec9e485b664963b2d09a38

Example Query

Query with partition filter

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

DpxWeeklyCallsSsovV3_Purchase_event

Option purchase events from Dopex V1 weekly DPX call Single Staking Option Vaults (SSOV) on Arbitrum. Tracks buyer addresses, strike prices, option amounts, premiums paid, and epoch identifiers for analyzing options trading activity and vault utilization.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0x1f916bbf39ab189a9e3d9e1823a7b1a8e9e5f204	10499999987931123	0x10fd85ec522c245a63239b9fc64434f58520bd1f	false	27	8000000000000000000	0x1f916bbf39ab189a9e3d9e1823a7b1a8e9e5f204	37000000000	5	511860037452986339	66812034	2023-03-04T22:19:08.000Z	0x3dd2e9a66f94e601f13bea611037cf034066bac659a10f50a68f03540afd8253
0x1f916bbf39ab189a9e3d9e1823a7b1a8e9e5f204	36874999976613880	0x10fd85ec522c245a63239b9fc64434f58520bd1f	false	27	25000000000000000000	0x1f916bbf39ab189a9e3d9e1823a7b1a8e9e5f204	41500000000	21	748548995301654958	66812217	2023-03-04T22:19:59.000Z	0xdb8550037daf86f5ca7bfe194a0564df2c087f912649efe7784f8277180f1580
0x6e2a497a065674ab8b129fd7ddb301c6243c6362	137499936841129	0x10fd85ec522c245a63239b9fc64434f58520bd1f	false	34	100000000000000000	0x6e2a497a065674ab8b129fd7ddb301c6243c6362	22000000000	15	378694379001364	84102781	2023-04-25T09:33:53.000Z	0xb9b714a3b54a5d096743b5d91b555dae6f84d86d6a60e3701a5590bb041b9e5b

Example Query

Query with partition filter

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

DpxWeeklyPutsSsovV3_Purchase_event

Option purchase events from Dopex V1 weekly DPX put Single Staking Option Vaults (SSOV) on Arbitrum. Tracks put option buys with strike prices, premium amounts, fees, and epoch identifiers for analyzing options trading patterns and vault utilization.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0x9c63104a0dfe3e1bf838120d9a3de9b9e5332e92	2001764073796856343	0xf71b2b6fe3c1d94863e751d6b455f750e714163c	false	18	7000000000000000000	0x9c63104a0dfe3e1bf838120d9a3de9b9e5332e92	16500000000	12	1989439269590113510	49837905	2022-12-30T17:07:31.000Z	0x7b00217bf8242d3e9887dfa60c75ca7fde073ae10409f9e1c14285ee7af53fcf
0x7bd8955b131e4576e7525ac47bef77a3ea4ecdc4	72463014325099550	0xf71b2b6fe3c1d94863e751d6b455f750e714163c	false	39	405770424793465728	0x7bd8955b131e4576e7525ac47bef77a3ea4ecdc4	14000000000	13	577306985835563376	96298726	2023-05-31T09:29:36.000Z	0x7a7948c8178d3561d6a42532b320f57072841b6f7b5378b0caf413eeda0bdec3
0xa14ae8cfcf1d4293b199c3ab2c7598efad1edf60	4931600096616887550	0xf71b2b6fe3c1d94863e751d6b455f750e714163c	false	20	14000000000000000000	0xa14ae8cfcf1d4293b199c3ab2c7598efad1edf60	24000000000	12	1487042552838324846	53292314	2023-01-15T16:59:25.000Z	0x4c0670dcb3d30583f4d57d260b6632b672a372fcaf1ca156a9999fbee47472b8

Example Query

Query with partition filter

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

EthMonthlyCallsSsovV3_Purchase_event

ETH monthly call option purchase events from Dopex SSOV (Single Staking Options Vault) V3 on Arbitrum, recording buyer addresses, strike prices, option amounts, premiums paid, and epoch identifiers. Used for analyzing options trading behavior and vault participation in DeFi structured 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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0x4d2b82979cffca02117f936c656589bddfc6825d	1029992587143	0xc59836fec63cfb2e48b0aa00515056436d74dc03	false	5	1000000000000000	0x4d2b82979cffca02117f936c656589bddfc6825d	160000000000	5	24589466224715	61087128	2023-02-15T08:35:26.000Z	0x18934203632ce5a0107875d431ea757d3ced77f8015da0395008d44d47c13968
0x74ddca784c513b5afa991d1f7a1da8226319cdb2	3398997749127	0xc59836fec63cfb2e48b0aa00515056436d74dc03	false	5	3300000000000000	0x74ddca784c513b5afa991d1f7a1da8226319cdb2	160000000000	6	82868318169505	61048281	2023-02-15T05:38:31.000Z	0x30a21d03ac63beb10b21bd4b95039ed57a08d85f2eb7d8767b92db0aacb098df
0x80e4fef53f450a375556354ecd94018096e73028	4016989464402	0xc59836fec63cfb2e48b0aa00515056436d74dc03	false	5	3900000000000000	0x80e4fef53f450a375556354ecd94018096e73028	160000000000	5	96026860355338	61071569	2023-02-15T07:28:11.000Z	0x9f315cf41d3a9c99bf64681a80e6cdd49f71c0f9662409adcd61e25a51fab579

Example Query

Query with partition filter

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

EthWeeklyCallsSsovV3_Purchase_event

ETH weekly call option purchase events from Dopex V1 SSOV (Single Staking Options Vault) V3 contract on Arbitrum, capturing strike price, premium, amount, fee, and epoch data for each options trade.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0x2d23b731e5f04996a2dfdbe434c7d922afdb5e00	17359999991983160	0x9cc9beffe64868cb4b97890a19219449890e6ea0	false	2	14000000000000000000	0x2d23b731e5f04996a2dfdbe434c7d922afdb5e00	220000000000	5	42539054905143369	24117972	2022-09-11T16:45:00.000Z	0xda546b87b436882b6a094f1148a24db5cecf284867748916df140d774ae714c6
0xff628b747c4e70825af24e3d59748bac477dcbf6	200000000000000	0x9cc9beffe64868cb4b97890a19219449890e6ea0	false	2	200000000000000000	0xff628b747c4e70825af24e3d59748bac477dcbf6	170000000000	5	14456031999229125	24029265	2022-09-11T04:15:57.000Z	0x528296f02a4f5a5f86d14148394cb5ea03788bf0433c58e6c3e42e79f2478f40
0x98f8193394791fa8a34237f8216d236405acbf4c	1000000000000000	0x9cc9beffe64868cb4b97890a19219449890e6ea0	false	17	1000000000000000000	0x98f8193394791fa8a34237f8216d236405acbf4c	120000000000	5	20120229507374335	49386594	2022-12-28T11:04:14.000Z	0x2e0ce99796ec2678157cd29dd8ce6d8622de43bce842ab6059a4fdd7a8b0ece6

Example Query

Query with partition filter

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

EthWeeklyPutsSsovV3_Purchase_event

Purchase events from Dopex V1 ETH Weekly Puts SSOV V3 (Single Staking Options Vault) on Arbitrum. Records put option purchases with strike prices, premiums, amounts, and fees for analyzing options trading activity and user 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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0xca748cb3e3de6ceab581db13bb9362d4d55353b9	267719380553052846712	0x32449df9c617c59f576dfc461d03f261f617ad5a	false	22	139000000000000000000	0xca748cb3e3de6ceab581db13bb9362d4d55353b9	130000000000	12	244378056251284874805	56714189	2023-01-30T19:32:45.000Z	0x34ea56fb5a2b481ec21ae3cc4d59bdd4f9c0ad64a32d928d363b9423b53c17b3
0x765a3f26bcafc024746f856a0345dc83f1b1e02a	7053272144079773	0x32449df9c617c59f576dfc461d03f261f617ad5a	false	8	3708529634468172	0x765a3f26bcafc024746f856a0345dc83f1b1e02a	120000000000	26	1337248986308	32763808	2022-10-26T13:54:20.000Z	0x33e289918ae0e063c99e33f205f30fa1984cda17325eef171d5ba1cd29a62753
0x765a3f26bcafc024746f856a0345dc83f1b1e02a	7555640854731407	0x32449df9c617c59f576dfc461d03f261f617ad5a	false	8	3972671438043135	0x765a3f26bcafc024746f856a0345dc83f1b1e02a	125000000000	15	2865226390020	32763808	2022-10-26T13:54:20.000Z	0x33e289918ae0e063c99e33f205f30fa1984cda17325eef171d5ba1cd29a62753

Example Query

Query with partition filter

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

GmxWeeklyPutsSsovV3_Purchase_event

Put option purchase events from Dopex GMX weekly Single Staking Option Vault (SSOV) V3 on Arbitrum. Tracks option buys with strike prices, premiums, fees, and epoch identifiers for analyzing options trading activity and pricing dynamics.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0xca748cb3e3de6ceab581db13bb9362d4d55353b9	72516235262141223813	0xf071f0c56543a2671a2dfc5ff51d5d858be91514	false	14	1100000000000000000000	0xca748cb3e3de6ceab581db13bb9362d4d55353b9	3500000000	12	43810952892564788047	43675723	2022-12-05T00:26:51.000Z	0x38f8a6409803bbcf89adc2808d4d03d7d4993ad3abb91d35ad8a686939295617
0xca748cb3e3de6ceab581db13bb9362d4d55353b9	2966573259959446336	0xf071f0c56543a2671a2dfc5ff51d5d858be91514	false	14	45000000000000000000	0xca748cb3e3de6ceab581db13bb9362d4d55353b9	4600000000	12	54017508664824150597	43675482	2022-12-05T00:25:03.000Z	0xaef7a46e68ffe0a43c29f616b0e8e921b1bff95983c2da6d780cf7593d136a6e
0xca748cb3e3de6ceab581db13bb9362d4d55353b9	8833795931196037250	0xf071f0c56543a2671a2dfc5ff51d5d858be91514	false	14	134000000000000000000	0xca748cb3e3de6ceab581db13bb9362d4d55353b9	4200000000	12	60958210861340265858	43675551	2022-12-05T00:25:39.000Z	0xfa65ce278a82272438715f14efa758550abf3921c2cc419f242a554d6bb863f9

Example Query

Query with partition filter

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

GohmWeeklyPutsSsovV3_Purchase_event

Option purchase events from Dopex gOHM (governance OHM) weekly put SSOV (Single Staking Option Vault) V3 on Arbitrum. Records buyer address, strike price, option amount, premium paid, and epoch for analyzing covered options trading activity.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0xb8c2c00cc883d087c0cbd443cec51a4d04f8b147	41531161742363714888	0x4269af9076586230bf5fa3655144a5fe9cb877fd	false	13	15384000000000000000	0xb8c2c00cc883d087c0cbd443cec51a4d04f8b147	195000000000	12	169652451807858931249	41070078	2022-11-25T10:59:27.000Z	0x52022bd56f2c133429621318ee390aa31b23eed250dea6f9fdc4c1bcf1e62350
0xa94184c5d58dce066451ae8eb66b8411d4bd9eac	7225004913382946006	0x4269af9076586230bf5fa3655144a5fe9cb877fd	false	3	2500000000000000000	0xa94184c5d58dce066451ae8eb66b8411d4bd9eac	200000000000	12	4091409258645528817	25097097	2022-09-18T08:55:30.000Z	0xa8ece538c4b3232d83e86c6c148a59278818c2e8b4f571b5ac9e8127c4afd894
0x36be8614ef0a6606e40746141eea9aea8394557b	5272212905858762861	0x4269af9076586230bf5fa3655144a5fe9cb877fd	false	25	1500000000000000000	0x36be8614ef0a6606e40746141eea9aea8394557b	260000000000	12	725276596012327446	61996754	2023-02-18T05:14:55.000Z	0x422a049bd18a603970e8b37536fe01624d3276cfed61d92fea3f2f86ff1b45f2

Example Query

Query with partition filter

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

RdpxMonthlyCallsSsovV3_Purchase_event

Option purchase events from Dopex V1 RDPX (Rebate Dollar Index) Monthly Calls Single Staking Option Vault V3 on Arbitrum. Records call option buys with strike prices, premiums, amounts, and fees for analyzing user positioning and vault utilization.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0xc6caaf025c30290843ac3a43f83a29afe7e0f041	3474999152941684	0xd74c61ca8917be73377d74a007e6f002c25efb4e	false	9	1000000000000000000	0xc6caaf025c30290843ac3a43f83a29afe7e0f041	2800000000	17	11156242540473524	88433662	2023-05-08T02:42:43.000Z	0x4e73b4aa41407b73aa2b954f242335961f76007f7865fb19a0adaa7a3d963146
0x617d7b99b78bdd3afbd05db2dd026d2a4ad410cc	228749999317100577	0xd74c61ca8917be73377d74a007e6f002c25efb4e	false	5	50000000000000000000	0x617d7b99b78bdd3afbd05db2dd026d2a4ad410cc	6100000000	5	462896289267474885	50601601	2023-01-03T17:52:23.000Z	0x4a908a3637a3259305c8d870cdf36b520922c8a00ee01962240b9385ec9e5d40
0xc26cf823ae06c9eb2b1752121ac6fec6eebd1043	1249999999774496613	0xd74c61ca8917be73377d74a007e6f002c25efb4e	false	5	500000000000000000000	0xc26cf823ae06c9eb2b1752121ac6fec6eebd1043	3200000000	5	80153398552566943702	50595133	2023-01-03T17:18:23.000Z	0x4a9a9f61bdb26a31c3c5b053fe2721a235bfdd97973b1f9fbaecf87a6d92fe5b

Example Query

Query with partition filter

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

RdpxMonthlyCallsSsovV3Active_Purchase_event

Call option purchase events from Dopex rDPX Monthly Calls SSOV V3 (Single Staking Options Vault) on Arbitrum. Tracks buyer addresses, strike prices, option amounts, premiums paid, and protocol fees for analyzing options trading activity and pricing.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0xae2a6ce639c1ec0951655da99e38182c2d81e2e1	8399999999915530130	0xd74c61ca8917be73377d74a007e6f002c25efb4e	false	8	2000000000000000000000	0xae2a6ce639c1ec0951655da99e38182c2d81e2e1	4000000000	5	21514518754177314836	77660968	2023-04-06T14:17:13.000Z	0x4e528df938852d0726a08ad6f3cacba44ecbab109ce15f0df339743c49f74714
0x4eb18956b00a45a240c8eb85c90f82fc18482605	8624999999470145580	0xd74c61ca8917be73377d74a007e6f002c25efb4e	false	8	3000000000000000000000	0x4eb18956b00a45a240c8eb85c90f82fc18482605	3000000000	22	239014244795426254722	77499428	2023-04-06T03:06:40.000Z	0xa2a9ff3c6c0ba6dae6c8fe1ffb2a7ae35883c94c51f1cbc71fd9afd47a61778f
0xd65f08b87f36bc1bc6b496e8bb23041384566925	2499891760688	0xd74c61ca8917be73377d74a007e6f002c25efb4e	false	3	1000000000000000	0xd65f08b87f36bc1bc6b496e8bb23041384566925	2700000000	5	209703159411735	35328141	2022-11-05T01:25:18.000Z	0xa8e2302eaa2dff2ed3f343c6e9845687c4c95474e79b46b58eff84ae163efd97

Example Query

Query with partition filter

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

RdpxMonthlyCallsSsovV3DiffIndex_Purchase_event

Purchase event records from Dopex rDPX (Dopex Rebate Token) monthly call options SSOV (Single Staking Options Vault) V3 on Arbitrum. Captures option purchases with strike prices, premium amounts, fees, and epoch identifiers for analyzing rDPX derivatives trading activity.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0x84a9165bbc73baaf09017a9f132630ced8723485	62499999894404253	0xafd90af84ae892c2dfeea6d379087a7b4d21ec34	false	2	50000000000000000000	0x84a9165bbc73baaf09017a9f132630ced8723485	3000000000	5	12946768569869563071	20043519	2022-08-11T23:50:21.000Z	0x8af48b34e74868201ca6ce0678b1f8cce1e7bcfabaab0db94bf25d66ef7baad2
0xbc2530c310276d9b4d2497c58e5adadb09f2ba41	148749999976575064	0xafd90af84ae892c2dfeea6d379087a7b4d21ec34	false	2	119000000000000000000	0xbc2530c310276d9b4d2497c58e5adadb09f2ba41	4000000000	5	27737640342632263603	19953859	2022-08-11T00:40:10.000Z	0xa70631a6c0ca8665de76df47a4ed577c98376d3cb3de43f82e88c3ce18650b5f
0x8040a47a3cf62a139b13d87005b88e75bf50f629	264999999832268261	0xafd90af84ae892c2dfeea6d379087a7b4d21ec34	false	2	200000000000000000000	0x8040a47a3cf62a139b13d87005b88e75bf50f629	5000000000	5	30814238104247342032	19962292	2022-08-11T02:22:25.000Z	0x5db187213dec29ceb2e5cdc105d4a99cb805be5045fe4eecdd19fdf6c027f961

Example Query

Query with partition filter

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

RdpxWeeklyCallsSsovV3_Purchase_event

Weekly call option purchase events from Dopex rDPX (Rebate Dopex) Single Staking Option Vault (SSOV) V3 on Arbitrum. Tracks buyer addresses, option amounts, strike prices, premiums paid, and fees for analyzing rDPX derivatives trading 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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0xbce05e49d1c2ae2ef30fec16c30b8786254028a5	128749999548855298	0xcdaacf37726bf1017821b5169e22eb34734b28a8	false	45	50000000000000000000	0xbce05e49d1c2ae2ef30fec16c30b8786254028a5	1900000000	16	493618751706223824	110416873	2023-07-12T10:19:17.000Z	0x9f34cc95cf88deadcd4429169d0e7abbb6f4dea3583b9a22e96baed017beb1f4
0x711f1bf759d3f749b938cf040ab65110b8524de9	16760528063070647	0xcdaacf37726bf1017821b5169e22eb34734b28a8	false	17	6704211267017015052	0x711f1bf759d3f749b938cf040ab65110b8524de9	3500000000	6	715361694009964429	48264894	2022-12-23T11:44:57.000Z	0xbfea8e8468893d706df67757fb6c7b08f6b1a2940092c18757cd32fb387c1a35
0x711f1bf759d3f749b938cf040ab65110b8524de9	17873779022789204	0xcdaacf37726bf1017821b5169e22eb34734b28a8	false	17	7149511645177633300	0x711f1bf759d3f749b938cf040ab65110b8524de9	3500000000	6	763876843440732228	48260130	2022-12-23T11:19:58.000Z	0x4283a3d40ecace04cba6360718a0012f484d06f4f3aaf701c82b976fe4cc34c2

Example Query

Query with partition filter

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

RdpxWeeklyPutsSsovV3_Purchase_event

Purchase events from Dopex’s RDPX Weekly Puts Single Staking Option Vault (SSOV) V3 on Arbitrum. Tracks put option purchases with strike prices, premiums, amounts, fees, and epoch identifiers for analyzing options trading activity and vault deposits.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0x1d3f6c9ed9298ee9f256d2ad61d63b6a7c4d77a1	30413552571456526548	0xb4ec6b4ec9e42a42b0b8cdd3d6df8867546cf11d	false	3	1000555000000000000000	0x1d3f6c9ed9298ee9f256d2ad61d63b6a7c4d77a1	1800000000	12	214761785119072258977	24935198	2022-09-16T20:18:50.000Z	0x4913c87785f09fd3abe6571810618a4afa4a8dc68a54e4a4f90ff3850b2ce272
0xf51e5a0a85d29aa0508894405d734bcf044dcb5b	8575309832677794306	0xb4ec6b4ec9e42a42b0b8cdd3d6df8867546cf11d	false	15	188000000000000000000	0xf51e5a0a85d29aa0508894405d734bcf044dcb5b	3300000000	12	203599550122881599452	45153625	2022-12-10T19:32:38.000Z	0xcec93749136e0e89c17b14787de9207e5e12d509627747a1bc477ac36a193169
0xa14ae8cfcf1d4293b199c3ab2c7598efad1edf60	5134203648322205489	0xb4ec6b4ec9e42a42b0b8cdd3d6df8867546cf11d	false	20	100000000000000000000	0xa14ae8cfcf1d4293b199c3ab2c7598efad1edf60	3500000000	23	4979818493753485560	53292619	2023-01-15T17:01:09.000Z	0xa7bd72050fc40f3eb7a68b46715523ccc6d510d855f90c91df4b80a423f456b9

Example Query

Query with partition filter

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

StEthMonthlyCallsSsovV3_Purchase_event

Call option purchase events from Dopex V1 stETH (Staked Ethereum) monthly Single Staking Option Vault (SSOV) V3 on Arbitrum. Tracks buyer addresses, strike prices, option amounts, premiums paid, and fees for analyzing options trading activity and vault usage 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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0x63e62588330657c99ba79139e7c21af0c0db1e7e	581656722227284	0x475a5a712b741b9ab992e6af0b9e5adee3d1851b	false	12	670000000000000000	0x63e62588330657c99ba79139e7c21af0c0db1e7e	230000000000	5	39363810464289125	165104036	2023-12-29T23:36:12.000Z	0xbf5cc1c0b0bc0cd62d62090cba00469f08ff4a557656873a461bda06cacbd952
0x36be8614ef0a6606e40746141eea9aea8394557b	868232118411517	0x475a5a712b741b9ab992e6af0b9e5adee3d1851b	false	12	1000000000000000000	0x36be8614ef0a6606e40746141eea9aea8394557b	230000000000	21	63036706970375592	165041844	2023-12-29T19:06:45.000Z	0x84ebd68cc35dfe30d727213ccfe90d22e212ca32b06548797ea90915d889df33
0x36be8614ef0a6606e40746141eea9aea8394557b	937690684580645	0x475a5a712b741b9ab992e6af0b9e5adee3d1851b	false	12	1000000000000000000	0x36be8614ef0a6606e40746141eea9aea8394557b	250000000000	5	36022996060832592	165041993	2023-12-29T19:07:24.000Z	0x95c411425bd0b181848b5d8265001b9ea153fd4ea61fba5650b6532af40f83fd

Example Query

Query with partition filter

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

StEthWeeklyCallsSsovV3_Purchase_event

Option purchase events from Dopex stETH weekly call SSOV (Single Staking Option Vault) V3 on Arbitrum. Records call option buys with strike prices, premiums, amounts, and epoch identifiers for analyzing staked ETH derivative trading 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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_fee	address	removed	in_epoch	in_amount	in_sender	in_strike	log_index	in_premium	block_number	block_timestamp	transaction_hash
0x7dd430ee4d3251e0944e7f6ee72541312581ee60	4322449418331378	0xfca61e79f38a7a82c62f469f55a9df54cb8df678	false	57	5000000000000000000	0x7dd430ee4d3251e0944e7f6ee72541312581ee60	260000000000	22	89395175463888483	180063481	2024-02-12T17:33:16.000Z	0x951826f403e120ff068f5719573b1d59f7302cc31b01460b45e2c958382d2a6d
0x36be8614ef0a6606e40746141eea9aea8394557b	8048511759374690	0xfca61e79f38a7a82c62f469f55a9df54cb8df678	false	51	9000000000000000000	0x36be8614ef0a6606e40746141eea9aea8394557b	240000000000	5	134140625421700085	165043223	2023-12-29T19:12:40.000Z	0x6ccf1678a19b37aa6dcc5c63be8e5d5f4ea86fc483f6fdebfa330ce217e3aaca
0x36be8614ef0a6606e40746141eea9aea8394557b	8682321210395358	0xfca61e79f38a7a82c62f469f55a9df54cb8df678	false	51	10000000000000000000	0x36be8614ef0a6606e40746141eea9aea8394557b	230000000000	5	292278522469735951	165043132	2023-12-29T19:12:16.000Z	0x014622a3c8429cd240e1d74dea9ef112d7ad62792467d7404020c1a750829266

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ArbMonthlyCallsSsovV3_Purchase_event

CrvWeeklyPutsSsovV3_Purchase_event

DpxMonthlyCallsSsovV3_Purchase_event

DpxWeeklyCallsSsovV3_Purchase_event

DpxWeeklyPutsSsovV3_Purchase_event

EthMonthlyCallsSsovV3_Purchase_event

EthWeeklyCallsSsovV3_Purchase_event

EthWeeklyPutsSsovV3_Purchase_event

GmxWeeklyPutsSsovV3_Purchase_event

GohmWeeklyPutsSsovV3_Purchase_event

RdpxMonthlyCallsSsovV3_Purchase_event

RdpxMonthlyCallsSsovV3Active_Purchase_event

RdpxMonthlyCallsSsovV3DiffIndex_Purchase_event

RdpxWeeklyCallsSsovV3_Purchase_event

RdpxWeeklyPutsSsovV3_Purchase_event

StEthMonthlyCallsSsovV3_Purchase_event

StEthWeeklyCallsSsovV3_Purchase_event

​Tables

​ArbMonthlyCallsSsovV3_Purchase_event

​CrvWeeklyPutsSsovV3_Purchase_event

​DpxMonthlyCallsSsovV3_Purchase_event

​DpxWeeklyCallsSsovV3_Purchase_event

​DpxWeeklyPutsSsovV3_Purchase_event

​EthMonthlyCallsSsovV3_Purchase_event

​EthWeeklyCallsSsovV3_Purchase_event

​EthWeeklyPutsSsovV3_Purchase_event

​GmxWeeklyPutsSsovV3_Purchase_event

​GohmWeeklyPutsSsovV3_Purchase_event

​RdpxMonthlyCallsSsovV3_Purchase_event

​RdpxMonthlyCallsSsovV3Active_Purchase_event

​RdpxMonthlyCallsSsovV3DiffIndex_Purchase_event

​RdpxWeeklyCallsSsovV3_Purchase_event

​RdpxWeeklyPutsSsovV3_Purchase_event

​StEthMonthlyCallsSsovV3_Purchase_event

​StEthWeeklyCallsSsovV3_Purchase_event

Tables

ArbMonthlyCallsSsovV3_Purchase_event

CrvWeeklyPutsSsovV3_Purchase_event

DpxMonthlyCallsSsovV3_Purchase_event

DpxWeeklyCallsSsovV3_Purchase_event

DpxWeeklyPutsSsovV3_Purchase_event

EthMonthlyCallsSsovV3_Purchase_event

EthWeeklyCallsSsovV3_Purchase_event

EthWeeklyPutsSsovV3_Purchase_event

GmxWeeklyPutsSsovV3_Purchase_event

GohmWeeklyPutsSsovV3_Purchase_event

RdpxMonthlyCallsSsovV3_Purchase_event

RdpxMonthlyCallsSsovV3Active_Purchase_event

RdpxMonthlyCallsSsovV3DiffIndex_Purchase_event

RdpxWeeklyCallsSsovV3_Purchase_event

RdpxWeeklyPutsSsovV3_Purchase_event

StEthMonthlyCallsSsovV3_Purchase_event

StEthWeeklyCallsSsovV3_Purchase_event