premia_v1_optimism

Tables

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
0x9623bf820a0b9db26aff216fcfbc119c92d3cd96	false	2857615	4	112002712	0x5ca1ea5549e4e7cb64ae35225e11865d2572b3f9	2023-11-10T08:16:41.000Z	3166189940082864718613269121909654980085252302706543769903160271871506644992	0x7ff395e7acc51e77214c9ccde10923934cea153c42725c009c88e6af1a039a21
0x9623bf820a0b9db26aff216fcfbc119c92d3cd96	false	679528951040081	41	112002342	0x5ca1ea5549e4e7cb64ae35225e11865d2572b3f9	2023-11-10T08:04:21.000Z	2261564242916331941866620801529280699981580547506226863344897896809685319680	0xa9558c477197d360936f8fc4e33d8fcb507871ee8c6683435edaea14dfb8a1cb
0x31b665daac80752b6089329d14a55a02bdf7faed	false	10288527397260273	7	108288589	0x5d0ac389c669d6efe3ba96b9878d8156f180c539	2023-08-16T08:52:35.000Z	2261564242916331941866620801526752265882411206347308573327275065484552804761	0xaf6075661769ab3aebbf414840806c15c9b684962ee75614a4726eb459fba45e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_optimism.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
0x31b665daac80752b6089329d14a55a02bdf7faed	0x0b047d8a08012dae90124c05d9be68605db34b68	false	1571383708	4	67177396	false	2023-01-15T11:46:16.000Z	0x6f5ec8e05674dd96f649f4b202212bcdc29e810d4defa75315cce34606e4d565
0x31b665daac80752b6089329d14a55a02bdf7faed	0x01a66607e2f13f89c1af094e7bac50082f094686	false	5373695030	5	66840969	false	2023-01-15T00:15:52.000Z	0xb9ed5fbcd9ccc29786510516ba28215735862ac18420c95083125a52ca4106db
0x31b665daac80752b6089329d14a55a02bdf7faed	0xb646d2010fd291d79b693189c95a0efb1c7ac2de	false	536552431989963530	4	67253413	true	2023-01-15T13:42:17.000Z	0xcf96872de644eb5f1fb5768b649e61fc302993811c520423b47368b30caad1be

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_optimism.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	transaction_hash
0x31b665daac80752b6089329d14a55a02bdf7faed	0x34f7b7e57bf4987f30e74d86b6e4d31aafcef613	false	2	74027545	1809251394333065553493296641331155452874213017430394775926852424986303817318	2023-02-13T08:14:28.000Z	474947188622708754388	0x041c05a67d82f2a6accad6093c0c54c03663ecdcab4f1f46c9c1a9cc39623a3c
0x31b665daac80752b6089329d14a55a02bdf7faed	0x34f7b7e57bf4987f30e74d86b6e4d31aafcef613	false	1	74026017	1809251394333065553493296641331155452874213017430394775926852424986303817318	2023-02-13T08:07:12.000Z	14025052811377291245612	0xec8133208d157948fefbb69406c226da7ff287932d3a1c169e73dc3e603f5978
0x31b665daac80752b6089329d14a55a02bdf7faed	0x6255cb7a706314835a22889500c8d55130912926	false	1	74036782	1809251394333065553493296641331155452874213017430394775928697099393674772480	2023-02-13T08:55:56.000Z	33900000000000000000000	0x6b0953d5a85e8490d2708552683a9d17aa49c1758cafa3e6e0ee029aadf8890f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_optimism.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
0x31b665daac80752b6089329d14a55a02bdf7faed	0x446ccd4633512f321b400cf89c1877f8307f6c26	false	8	399134	13304477	72008207	51728087888176307352	2713877091499598330239944961711265129409367050881522562379307810642671226060	2023-02-03T03:16:40.000Z	100000000000000000000	0xa0029f4973d2a5be2f344ca6b75e2b78d31df7ad974470bc9e25a3453b8aa887
0x31b665daac80752b6089329d14a55a02bdf7faed	0xe05023bfa996f01c15c4dc549d29352c3f6231e8	false	8	215023	7167462	72021657	53346835422124437150	2713877091499598330239944961711441531788378865380981975770266416061377150976	2023-02-03T05:47:49.000Z	100000000000000000000	0xf7432347b9a6fb1dd414baba4c11123207c4ccaea0c6d0de47907d0daa8f9102
0x31b665daac80752b6089329d14a55a02bdf7faed	0x6632b50b00e16bc9807d6173142d950819b93fef	false	8	2159938	71997958	72094562	55200206094195058860	2713877091499598330239944961712882151216975350459900518513823573183510138060	2023-02-03T14:21:47.000Z	100000000000000000000	0x6519f7dcb40976bc98db785fd2b2dd01cf41ce6c89e23c559a780578a464a194

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_optimism.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
0x9623bf820a0b9db26aff216fcfbc119c92d3cd96	0xc4313fcdcc95e1352c8e9892eacc43f3c0302241	false	11	28945134292994	935892675473504	108299244	33619141440876914772115	1809251394333065553493296641336829729399093050496339273322119049092555341824	2023-08-16T14:47:45.000Z	50000000000000000	0x437081fd90e2c950ae21758e36c8c7161c477ea14f9881e6fdf6db816cac4336
0x9623bf820a0b9db26aff216fcfbc119c92d3cd96	0x85b3f50e9d3e902123fa6d3469511029be7c51f2	false	19	1418986977034702	45880578924122050	108280397	33691153370323125852020	1809251394333065553493296641336741528209587143246609566623872734772145946624	2023-08-16T04:19:31.000Z	2500000000000000000	0xfe0302ddc99693d31c2ff380d12b69e64d673936a69134340bfc94ed529ec02d
0x31b665daac80752b6089329d14a55a02bdf7faed	0xdaac88fcbaaa821f19793f7340bd73545d0fe007	false	59	92539599030688873	2992113701992273574	108302295	26374320533869795416	1809251394333065553493296641336623926623579266913636591181230424704267216486	2023-08-16T16:29:27.000Z	100000000000000000000	0xee4e1e18aa9920fe98e487444567c8bf0e6beec42cd3db06e71e864c034b61d4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_optimism.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
0x31b665daac80752b6089329d14a55a02bdf7faed	0xd99687ba7bd3d8a96ad3d4a7a9f15493750c5bdb	false	40000000	4	23072531	false	1662051601	2022-09-14T05:14:21.000Z	0xd836acd30a478c32a9f79bcf9c47d08d3f58c81c38916a9d70d188c26fc04789
0x31b665daac80752b6089329d14a55a02bdf7faed	0x1cbd4704f528cc2293b9822c6ed2eb52fdaaa845	false	5435929090	4	23141940	false	1663065916	2022-09-14T17:04:38.000Z	0x5c80982840f2df05c88dc22a449486c0c37b661974d233cd4bd9ab06f6896541
0x31b665daac80752b6089329d14a55a02bdf7faed	0x8f22cee99b55ffba8c55f27181d14bcd34e202ed	false	3000000000	4	23144573	false	1663082170	2022-09-14T17:42:45.000Z	0x788b18066f978591df1c15b38e60f6c7fe056e58e9cbef0b6880fa95ee8a5715

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_optimism.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
0xbfdc37499d99046710a9c567016791c71cd25cf6	0x31b665daac80752b6089329d14a55a02bdf7faed	0xdb611d682cb1ad72fcbacd944a8a6e2606a6d158	false	8	95591953	false	2023-04-30T22:44:13.000Z	300726684092333344414	0xe74cc2c000df47ed07e51161327a33fccc4c5083429a5506a6634b545f16aaf8
0xbfdc37499d99046710a9c567016791c71cd25cf6	0x9623bf820a0b9db26aff216fcfbc119c92d3cd96	0xdb611d682cb1ad72fcbacd944a8a6e2606a6d158	false	2	95591953	false	2023-04-30T22:44:13.000Z	59958832625275522946	0xe74cc2c000df47ed07e51161327a33fccc4c5083429a5506a6634b545f16aaf8
0xbfdc37499d99046710a9c567016791c71cd25cf6	0x31b665daac80752b6089329d14a55a02bdf7faed	0xdb611d682cb1ad72fcbacd944a8a6e2606a6d158	false	5	95591953	true	2023-04-30T22:44:13.000Z	130021835981592358173	0xe74cc2c000df47ed07e51161327a33fccc4c5083429a5506a6634b545f16aaf8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_optimism.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
0x48d49466cb2efbf05faa5fa5e69f2984edc8d1d7	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0x31b665daac80752b6089329d14a55a02bdf7faed	false	1	16597542	0x16a9fa2fda030272ce99b29cf780dfa30361e0f3	0x4200000000000000000000000000000000000042	2022-07-29T21:38:04.000Z	0x9be509155f3f83d17dd3bc6bbcc08dc7c3a6cf6c4cd949899afa1b58da84848d	0x0d276fc14719f9292d5c1ea2198673d1f4269246	50143449209799256683
0x48d49466cb2efbf05faa5fa5e69f2984edc8d1d7	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0x02f4ad09392ae5e8a312eda4cb63d464a8b3987c	false	1	16597508	0x16a9fa2fda030272ce99b29cf780dfa30361e0f3	0x68f180fcce6836688e9084f035309e29bf0a2095	2022-07-29T21:38:04.000Z	0x83c6556a6f0fc1c3370efa096039c0316d5505133fe99ff19212a79e5fb8da0f	0xd702dd976fb76fffc2d3963d037dfdae5b04e593	50143449209799256683
0x48d49466cb2efbf05faa5fa5e69f2984edc8d1d7	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0x9623bf820a0b9db26aff216fcfbc119c92d3cd96	false	1	16597466	0x16a9fa2fda030272ce99b29cf780dfa30361e0f3	0x4200000000000000000000000000000000000006	2022-07-29T21:37:49.000Z	0x409367aee7a38d913aa337f54240daa80b4c53b1a874b82ec7567eef699ba7fc	0x13e3ee699d1909e989722e753853ae30b17e08c5	50143449209799256683

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Pool_APYFeePaid_event

Pool_Deposit_event

Pool_Exercise_event

Pool_Purchase_event

Pool_Sell_event

Pool_Withdrawal_event

PremiaMine_Claim_event

ProxyManager_DeployPool_event

​Tables

​Pool_APYFeePaid_event

​Pool_Deposit_event

​Pool_Exercise_event

​Pool_Purchase_event

​Pool_Sell_event

​Pool_Withdrawal_event

​PremiaMine_Claim_event

​ProxyManager_DeployPool_event

Tables

Pool_APYFeePaid_event

Pool_Deposit_event

Pool_Exercise_event

Pool_Purchase_event

Pool_Sell_event

Pool_Withdrawal_event

PremiaMine_Claim_event

ProxyManager_DeployPool_event