premia_v1_ethereum

Tables

DiamondProxy_DiamondCut_event

Diamond standard (EIP-2535) upgrade events from Premia v1 options protocol on Ethereum, recording facet additions, replacements, and removals with function selectors. Used to track protocol upgrades and proxy contract evolution over time.

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_facetCuts`	`ARRAY<STRUCT<target STRING, action INT64, selectors ARRAY<STRING>>>`	Array of facet modifications in this DiamondCut operation, each specifying an action (add=0, replace=1, remove=2), target facet address, and function selectors being modified. Used in EIP-2535 Diamond Proxy pattern for modular smart contract upgrades.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

address	in_data	removed	in_target	log_index	block_number	in_facetCuts	block_timestamp	transaction_hash
0x4f273f4efa9ecf5dd245a338fad9fe0bab63b350	0x	false	0x0000000000000000000000000000000000000000	89	14057191	[{“action”:1,“target”:“0xc73fc9215a9e6824b15b212918b5f8d0892ebaad”,“selectors”:[“0x815f1665”,“0x531aa03e”,“0xd41dcbea”]}]	2022-01-22T19:08:29.000Z	0x4a0f9efb97eb28720824d154396b215982b80b2df1619d742b0a26220b08779d
0x4f273f4efa9ecf5dd245a338fad9fe0bab63b350	0x	false	0x0000000000000000000000000000000000000000	531	13509380	[{“action”:0,“target”:“0x7bf2392bd078c8353069cffeacc67c094079be23”,“selectors”:[“0x815f1665”,“0x531aa03e”,“0xd41dcbea”]}]	2021-10-29T02:05:50.000Z	0x95f9edde32a77e4c67618a7dd72d64d914000eba0a1f44e3becc205456ea58fe
0x4f273f4efa9ecf5dd245a338fad9fe0bab63b350	0x	false	0x0000000000000000000000000000000000000000	283	13509301	[{“action”:0,“target”:“0x4f273f4efa9ecf5dd245a338fad9fe0bab63b350”,“selectors”:[“0x1f931c1c”,“0x7a0ed627”,“0xadfca15e”,“0x52ef6b2c”,“0xcdffacc6”,“0x01ffc9a7”,“0x8da5cb5b”,“0x8ab5150a”,“0xf2fde38b”,“0x79ba5097”,“0x2c408059”,“0x91423765”]}]	2021-10-29T01:48:54.000Z	0x399eb1b1d81238c8dab79df60d250e068c85a9046b8af1cc1abbc77d16c0ba63

Example Query

Query with partition filter

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

DiamondProxy_OwnershipTransferred_event

Contract ownership transfer events from Premia v1 options protocol on Ethereum, tracking changes in diamond proxy contract ownership with previous and new owner addresses.

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_previousOwner`	`STRING`	Address of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_newOwner	block_number	block_timestamp	in_previousOwner	transaction_hash
0x4f273f4efa9ecf5dd245a338fad9fe0bab63b350	false	68	0xc22fae86443aeed038a4ed887bba8f5035fd12f0	13533129	2021-11-01T19:51:36.000Z	0xc7f8d87734ab2cbf70030ac8aa82abfe3e8126cb	0x6abfae61e25e90d8461ef3a4e08a7661787437c8be98b017b6370981dd98c5da

Example Query

Query with partition filter

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

Pool_APYFeePaid_event

APY fee payment events from Premia V1 options pools, recording fees paid to underwriters for providing liquidity. Contains underwriter address, short token identifier, and fee amount denominated in the pool’s base token.

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_underwriter`	`STRING`	Address of the underwriter who provided liquidity or backstopped the position. Hex-encoded, 0x-prefixed, 42-character string.
`in_shortTokenId`	`STRING`	Token identifier for the short position in the options pool. Numeric string representation of a 256-bit unsigned integer.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_underwriter	block_timestamp	in_shortTokenId	transaction_hash
0xa4492fcda2520cb68657d220f4d4ae3116359c10	false	10553732242516	210	17271202	0x140d73e46e7bed1a87268b458f013c6943e6ced2	2023-05-16T08:52:11.000Z	2261564242916331941866620801524047429404230050688930934242490213765920849920	0x838f592576153bd69e871261b59baa0d26c8004117a5766aa709293fc2e41861
0xfdd2fc2c73032ae1501ef4b19e499f2708f34657	false	4290471603881278530	287	15321597	0x25431341a5800759268a6ac1d3cd91c029d7d9ca	2022-08-11T15:51:25.000Z	2261564242916331941866620801515903519573184614630554649580406647423333354700	0x3a18d16dc13750d1570effaa336b6cfb3d7bbc62a5a0261874efb3bb69f22600
0x1b63334f7bfdf0d753ab3101eb6d02b278db8852	false	8176	432	15319119	0x8eb69f50762a4d021373d206c325b7ee424c6b48	2022-08-11T06:22:45.000Z	2261564242916331941866620801515903519573184614630555073693188994894376468480	0xb11f1293e2dee04134777378d3cb35357fe7bb6b032afff9f285a221a43f76d3

Example Query

Query with partition filter

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

Pool_Deposit_event

Liquidity pool deposit events recording user contributions to option pools (Premia) or trading pools (UniDex). Contains depositor address, deposit amount, and pool-specific parameters such as option type or currency token.

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_isCallPool`	`BOOL`	Boolean flag indicating whether the pool is a call option pool (true) or a put option pool (false).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	in_isCallPool	block_timestamp	transaction_hash
0xa4492fcda2520cb68657d220f4d4ae3116359c10	0x32a0e98df127f7af5add5e34d377b3f950ffe2c1	false	1000000000000000000	579	14453636	true	2022-03-25T05:45:30.000Z	0xf7232c73146e72df29d37fcd666515262e442497f2b482ac1f850ca7e5525e0b
0xa4492fcda2520cb68657d220f4d4ae3116359c10	0x8d218e4d1b9e763fc34479f1e4e7d2bea902a314	false	1000000000000000000	407	14454390	true	2022-03-25T08:33:57.000Z	0x211fadc38453dfd655345fe8075de90fef354416fcb8ac7e14f912bba4d339cf
0x4fcb6363acf29133540f85df2f2a0cab9eefd3c0	0x8d218e4d1b9e763fc34479f1e4e7d2bea902a314	false	12977316000000000000	484	14453538	true	2022-03-25T05:20:51.000Z	0xac827efcd83966b09dabeba0735c647ea3f89f70b25a84c4ce84cf087687a28c

Example Query

Query with partition filter

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

Pool_Exercise_event

Options exercise events from Premia V1 liquidity pools recording when long position holders execute their contracts. Tracks user address, contract size, exercise value, associated fees, and long token identifier for options settlement analysis.

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_longTokenId`	`STRING`	Token identifier for the long position in an options contract. String-encoded integer representing the unique ID of the long option token.
`in_contractSize`	`STRING`	Size of the options contract in the transaction. String-encoded integer value representing the quantity in the smallest unit of the underlying token.
`in_exerciseValue`	`STRING`	Value received by the option holder upon exercising the contract. String-encoded integer representing the payout amount in the smallest unit of the settlement token.
`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.

Sample Data

address	in_user	removed	log_index	block_number	in_longTokenId	block_timestamp	in_contractSize	in_exerciseValue	transaction_hash
0xa4492fcda2520cb68657d220f4d4ae3116359c10	0xc65cde65e26caf4be3036b5b9b2a530319a4531c	false	283	14067683	1809251394333065553493296641319836300220954920381749132728732156365608321024	2022-01-24T10:04:09.000Z	190000000000000000000	0	0xea2acdcdb839ca2833d3b3d4354840a8256b9115d63fa0253792bb67b12f9fe6
0xfdd2fc2c73032ae1501ef4b19e499f2708f34657	0x79374fdf37d880354c89cbdb89a50c4471aee336	false	337	15566477	1809251394333065553493296641326833594588423562193639147797638046025307389952	2022-09-19T08:48:59.000Z	12500000000000000000000	0	0x3530f8a054e2d0ebb6159320ea44b66e2b54b94bf26823538dee420c3e831e24
0xa4492fcda2520cb68657d220f4d4ae3116359c10	0xa77906d1f174ea6800a1f404e17ff652a70dc99b	false	249	15566235	2713877091499598330239944961708354490155672111640442274489667887339967348736	2022-09-19T08:00:11.000Z	2000000000000000000	994695157273607283984	0xed16cc13864f5082dd125f70bfe9564d8ffe05dac0c36be02d04a783921b1d8b

Example Query

Query with partition filter

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

Pool_Purchase_event

Options contract purchase events from Premia v1 decentralized options protocol. Contains buyer address, contract size, base cost, fees, long token ID, and spot price at transaction time for tracking 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_longTokenId`	`STRING`	Token identifier for the long position in an options contract. String-encoded integer representing the unique ID of the long option token.
`in_contractSize`	`STRING`	Size of the options contract in the transaction. String-encoded integer value representing the quantity in the smallest unit of the underlying token.
`in_baseCost`	`STRING`	Cost of purchasing or selling an options contract before fees. String-encoded integer representing the amount in smallest denomination of the payment token.
`in_feeCost`	`STRING`	Fee amount charged for the options transaction. String-encoded integer representing the fee in smallest denomination of the payment token.
`in_spot64x64`	`STRING`	Spot price of the underlying asset at the time of the transaction. String-encoded integer in 64.64 fixed-point format.

Sample Data

address	in_user	removed	log_index	in_feeCost	in_baseCost	block_number	in_spot64x64	in_longTokenId	block_timestamp	in_contractSize	transaction_hash
0xfdd2fc2c73032ae1501ef4b19e499f2708f34657	0x79374fdf37d880354c89cbdb89a50c4471aee336	false	232	4545965846786126517	151532194892870884031	14899623	126314170085790756252	1809251394333065553493296641323717152559214839369856177774488195963799207936	2022-06-03T22:11:32.000Z	10000000000000000000000	0x34918552f3ace4f52558ca9a73bb90194f2cfb20a51dbac2dc29e3b209e3c0ca
0xfdd2fc2c73032ae1501ef4b19e499f2708f34657	0xd87450448d12b5f93af5da3184a6970e41700abf	false	112	6242645571544729949	208088185718157665175	15202600	127511005177936855325	2713877091499598330239944961705561452487985048732334862638700484106481408409	2022-07-24T02:14:37.000Z	1000000000000000000000	0xe4e794b17ea658d456ab8e11066acfc383d0386ce03e6a56b46c9187ca79a4d3
0xfdd2fc2c73032ae1501ef4b19e499f2708f34657	0xd87450448d12b5f93af5da3184a6970e41700abf	false	437	9117202117359962692	303906737245332090018	15202617	127511005177936855325	2713877091499598330239944961705561452487985048732334862640545158513852363571	2022-07-24T02:17:38.000Z	1000000000000000000000	0x4cada522264aca2ed82b3d0bd73860abed40ac52a74d00c28ee7fb4c66f97d48

Example Query

Query with partition filter

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

Pool_Sell_event

Options contract sale events from Premia V1 pools capturing user address, contract size, long token identifier, base cost, fees, and spot price at execution time. Used for analyzing options trading activity and pricing dynamics across DeFi 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_longTokenId`	`STRING`	Token identifier for the long position in an options contract. String-encoded integer representing the unique ID of the long option token.
`in_contractSize`	`STRING`	Size of the options contract in the transaction. String-encoded integer value representing the quantity in the smallest unit of the underlying token.
`in_baseCost`	`STRING`	Cost of purchasing or selling an options contract before fees. String-encoded integer representing the amount in smallest denomination of the payment token.
`in_feeCost`	`STRING`	Fee amount charged for the options transaction. String-encoded integer representing the fee in smallest denomination of the payment token.
`in_spot64x64`	`STRING`	Spot price of the underlying asset at the time of the transaction. String-encoded integer in 64.64 fixed-point format.

Sample Data

address	in_user	removed	log_index	in_feeCost	in_baseCost	block_number	in_spot64x64	in_longTokenId	block_timestamp	in_contractSize	transaction_hash
0x2fb48b41e3bf0c86e8a90e7ca168e6b63622855f	0xa77906d1f174ea6800a1f404e17ff652a70dc99b	false	255	21158483780798977393	684124308912500269681	15424251	438285424177740407873	2713877091499598330239944961708354490155672111640442241968058085390027849728	2022-08-27T22:43:17.000Z	50000000000000000000	0xba41b53a01ebcf5292c924f81327689c3cdbbdefa5cbd7ffafbb085615d039cc
0xa4492fcda2520cb68657d220f4d4ae3116359c10	0xa83292a3ebf2e6473c457cc6b01e015d9858b176	false	302	9384710674056846705	303438978461171377099	15418363	27806154838069965046344	2713877091499598330239944961706619866762055935729091374338383018702841839616	2022-08-27T00:00:51.000Z	1550000000000000000	0xe2d5cab91ff049dd60e9dfec4740ba3ad202e8e051bf5679499955be1621a003
0xa4492fcda2520cb68657d220f4d4ae3116359c10	0xa83292a3ebf2e6473c457cc6b01e015d9858b176	false	211	8467054142237981043	273768083932361387321	15418403	27656713936906599278587	2713877091499598330239944961706678667555059873895577845470547228249781436416	2022-08-27T00:10:12.000Z	1320000000000000000	0xf41d6d00759141a28e2824035974e0fd92d9aef52c386356ff1137cdf21ecac2

Example Query

Query with partition filter

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

Pool_Withdrawal_event

Withdrawal events from Premia V1 option liquidity pools recording user address, withdrawn amount, pool type (call or put), and original deposit timestamp. Used for tracking liquidity provider exits and pool participation analytics.

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_isCallPool`	`BOOL`	Boolean flag indicating whether the pool is a call option pool (true) or a put option pool (false).
`in_depositedAt`	`STRING`	Unix timestamp when the liquidity was deposited into the pool. Numeric string representation of seconds since epoch.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	in_isCallPool	in_depositedAt	block_timestamp	transaction_hash
0xa4492fcda2520cb68657d220f4d4ae3116359c10	0x53e213da8c28d85dc6663c3b5e35bb0ffbb05752	false	1000000000000000000	686	15648860	true	1664454587	2022-09-30T21:32:23.000Z	0xd2c600e86e7c5c3fd81d9e0bfeab040c76e7fa42ebbdc452524985a27712a9c2
0xa4492fcda2520cb68657d220f4d4ae3116359c10	0x85c5489f74fe5000ff0701535d9ec8ef49dfe704	false	10000000000000000000000	147	15648007	false	1637648900	2022-09-30T18:41:23.000Z	0x8a9620546866e992fda56c99a90d0b5b4225c06735900553a75d9dbcca019b4e
0xa4492fcda2520cb68657d220f4d4ae3116359c10	0xe006e905de2c1762fe90d216ef604f3e628465b4	false	3058100132204902000000	346	15643004	false	1664370635	2022-09-30T01:54:47.000Z	0x37379b4ba388ceb43fd282ba9664f6903421c7be8daf3ed2aedf1e96fb29f56f

Example Query

Query with partition filter

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

PremiaMine_Claim_event

Mining reward claims from Premia option pools, recording user addresses, pool identifiers, and reward token amounts. Used for tracking liquidity mining distributions across call and put option 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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_isCallPool`	`BOOL`	Boolean flag indicating whether the pool is a call option pool (true) or a put option pool (false).
`in_rewardAmount`	`STRING`	Amount of rewards claimed or distributed. Numeric value represented as a string in the token’s smallest unit (wei for ETH-based tokens).

Sample Data

address	in_pool	in_user	removed	log_index	block_number	in_isCallPool	block_timestamp	in_rewardAmount	transaction_hash
0x9abb27581c2e46a114f8c367355851e0580e9703	0xfdd2fc2c73032ae1501ef4b19e499f2708f34657	0xfe0d6838338d62709c0afaae9cfc36bdf8964c1e	false	124	14694416	true	2022-05-01T21:45:32.000Z	406426908133959246810	0xc7a8eb6eace6c5d01e12ce120382a870d7b6169d457913f24877e0279a02b325
0x9abb27581c2e46a114f8c367355851e0580e9703	0xfdd2fc2c73032ae1501ef4b19e499f2708f34657	0x7d3a61907f6e2ef5ed901b6d9e5baf36827625af	false	301	14691184	true	2022-05-01T09:31:05.000Z	40966	0x320c1a42b43c978b2ec0b13cbd6147baa3de1cedcd27917f138d3b7faa1634c8
0x9abb27581c2e46a114f8c367355851e0580e9703	0xfdd2fc2c73032ae1501ef4b19e499f2708f34657	0x7d3a61907f6e2ef5ed901b6d9e5baf36827625af	false	303	14691184	false	2022-05-01T09:31:05.000Z	335434220315179262480	0x320c1a42b43c978b2ec0b13cbd6147baa3de1cedcd27917f138d3b7faa1634c8

Example Query

Query with partition filter

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

ProxyManager_DeployPool_event

Options pool deployment events emitted by the Premia V1 ProxyManager contract. Records the creation of new liquidity pools with base and underlying asset addresses, oracle references, and initial C-level parameters for options trading.

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_base`	`STRING`	Token or asset identifier serving as the base asset in a trading pair or financial instrument. String representation that can be either a contract address (hex-encoded, 0x-prefixed, 42-character string) or a ticker symbol.
`in_underlying`	`STRING`	Contract address of the underlying asset. Hex-encoded, 0x-prefixed, 42-character string.
`in_initialCLevel64x64`	`STRING`	Initial C-level parameter for the pool in 64x64 fixed-point format. Numeric string representation of a signed 128-bit fixed-point number with 64 bits for the integer and 64 bits for the fractional part.
`in_baseOracle`	`STRING`	Contract address of the price oracle for the base asset. Hex-encoded, 0x-prefixed, 42-character string.
`in_underlyingOracle`	`STRING`	Contract address of the price oracle for the underlying asset. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_base	in_pool	removed	log_index	block_number	in_baseOracle	in_underlying	block_timestamp	transaction_hash	in_underlyingOracle	in_initialCLevel64x64
0x4f273f4efa9ecf5dd245a338fad9fe0bab63b350	0x6b175474e89094c44da98b954eedeac495271d0f	0xb7cd1bb23c69b6becdf5aa0fe17c444db67f5d93	false	150	14277241	0xaed0c38402a5d19df6e4c03f4e2dced6e29c1ee9	0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e	2022-02-25T19:48:11.000Z	0xd1a04ae31bdc54a3d4464129b38176173ad9ccdd4bd7e2596cc439168335f990	0xa027702dbb89fbd58938e4324ac03b58d812b0e1	50143449209799256683
0x4f273f4efa9ecf5dd245a338fad9fe0bab63b350	0x6b175474e89094c44da98b954eedeac495271d0f	0x2fb48b41e3bf0c86e8a90e7ca168e6b63622855f	false	199	14057345	0xaed0c38402a5d19df6e4c03f4e2dced6e29c1ee9	0xdbdb4d16eda451d0503b854cf79d55697f90c8df	2022-01-22T19:41:30.000Z	0x6880a113068ed1c4f6583d9c21653d1ef0ce367ad09aab50b25c5b01e7e96c9c	0x1d5d4dec31e8aadfbffe167d844ad734a169c695	50143449209799256683
0x4f273f4efa9ecf5dd245a338fad9fe0bab63b350	0xbc6da0fe9ad5f3b0d58160288917aa56653660e9	0x9998ca8ea9e39d5c84a171ecb3303674e666ef9c	false	176	14057306	0xaed0c38402a5d19df6e4c03f4e2dced6e29c1ee9	0x0100546f2cd4c9d97f798ffc9755e47865ff7ee6	2022-01-22T19:33:09.000Z	0x827a4edfeb9a679d74b7ad8b449e3c71d330d0869d59e4ebc7aadedffce19ec8	0x5f4ec3df9cbd43714fe2740f5e3616155c5b8419	50143449209799256683

Example Query

Query with partition filter

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

ProxyManager_OwnershipTransferred_event

Ownership transfer events from Premia v1’s ProxyManager contract on Ethereum. Tracks administrative control changes with previous and new owner addresses for protocol governance monitoring.

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_previousOwner`	`STRING`	Address of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_newOwner	block_number	block_timestamp	in_previousOwner	transaction_hash
0x4f273f4efa9ecf5dd245a338fad9fe0bab63b350	false	68	0xc22fae86443aeed038a4ed887bba8f5035fd12f0	13533129	2021-11-01T19:51:36.000Z	0xc7f8d87734ab2cbf70030ac8aa82abfe3e8126cb	0x6abfae61e25e90d8461ef3a4e08a7661787437c8be98b017b6370981dd98c5da

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

DiamondProxy_DiamondCut_event

DiamondProxy_OwnershipTransferred_event

Pool_APYFeePaid_event

Pool_Deposit_event

Pool_Exercise_event

Pool_Purchase_event

Pool_Sell_event

Pool_Withdrawal_event

PremiaMine_Claim_event

ProxyManager_DeployPool_event

ProxyManager_OwnershipTransferred_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​DiamondProxy_DiamondCut_event

​DiamondProxy_OwnershipTransferred_event

​Pool_APYFeePaid_event

​Pool_Deposit_event

​Pool_Exercise_event

​Pool_Purchase_event

​Pool_Sell_event

​Pool_Withdrawal_event

​PremiaMine_Claim_event

​ProxyManager_DeployPool_event

​ProxyManager_OwnershipTransferred_event

Tables

DiamondProxy_DiamondCut_event

DiamondProxy_OwnershipTransferred_event

Pool_APYFeePaid_event

Pool_Deposit_event

Pool_Exercise_event

Pool_Purchase_event

Pool_Sell_event

Pool_Withdrawal_event

PremiaMine_Claim_event

ProxyManager_DeployPool_event

ProxyManager_OwnershipTransferred_event