premia_v1_arbitrum

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
0xb0bbe7a71162fc57df10c15a5bc74f4cae772782	false	9671486555048	3	122298856	0x211af786ec6cc8a3564a2b8a8575f1b5d3efbdae	2023-08-17T14:44:01.000Z	2261564242916331941866620801526928668261423020846767986730224054551169938227	0x733f76a21e1bdda11a9932a0dd695b2ddb190dd8506c6508ec9b8022078a7a53
0xb0bbe7a71162fc57df10c15a5bc74f4cae772782	false	77409674657534246	11	122211134	0xce8108474c346cf3643acf3be83f2c2d9eb320d0	2023-08-17T08:27:25.000Z	3166189940082864718613269121907155946382584930630868715448852533708787495731	0xf45bea5f528e36025bbbb4ab61b363058c3355a2d116b9ae3d9bba2f79d0ae8c
0xb5fe3bc2ef4c34cc233922dff2fcb1b1bf89a38e	false	755315670979198374	4	122217117	0x5d0ac389c669d6efe3ba96b9878d8156f180c539	2023-08-17T08:52:34.000Z	3166189940082864718613269121907155946382584930630869264217352633679496609792	0x9dfd22ae8d253ab0ef9f26819767e32f10c1521f4dd941fe10049667daa32358

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_arbitrum.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
0x41cbe7879d887fe84cd9dce4bd6de37f2eeb9ace	0xad7951e4d4608ad0890c10ae5d03ab2a4d87b42e	false	18288720665322464000000	3	18898811	false	2022-07-29T20:59:09.000Z	0x3a30998370f1f0ae7fdd35c82bf2657549b8a8da1a6f5986d96017021d4f0377
0x41cbe7879d887fe84cd9dce4bd6de37f2eeb9ace	0x4ffad6ac852c0af0aa301376f4c5dea3a928b120	false	2436804331962484950000	2	18857870	false	2022-07-29T09:46:23.000Z	0x1dd327ea261629af1bed11d1b75f80b198ed56a93badcfc6a7d48b74ce0ef67a
0xb5fe3bc2ef4c34cc233922dff2fcb1b1bf89a38e	0x4f4366b13d499b4248b084a4c3f00ad960c53ea0	false	20000000000000000000000	2	18858138	false	2022-07-29T09:51:39.000Z	0x871ea8ac265f68d417f998d94d5be1418b39f89edd458eff5cd73287f6185bcb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_arbitrum.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
0xb5fe3bc2ef4c34cc233922dff2fcb1b1bf89a38e	0x631ea523db0deefd25ed308594b1830974f1f4ad	false	2	59050726	1809251394333065553493296641331008450891703172014179022308836666588029517824	2023-02-08T08:44:06.000Z	2500000	22490	0xdfdf213dcc93eaee62d40c979396f3877f7837bf681d81f24d6e0b012b5df2dc
0xe5dbc4edf467b609a063c7ea7fab976c6b9baa1a	0xdeca374441eb1b2b3c2b607d139c34d6df5a8b8d	false	5	59050562	1809251394333065553493296641331008450891703172014178629208720455837484580864	2023-02-08T08:43:24.000Z	100000000000000000	0	0x31f962a44091e630a5d90406765753f6a9e28ed9c57177f925ad61afcede855b
0xe5dbc4edf467b609a063c7ea7fab976c6b9baa1a	0x1cab647aed688da43b1d38aa2027f35e5b61cde3	false	3	59050634	2713877091499598330239944961711382730995374927214495532262101456894491099136	2023-02-08T08:43:42.000Z	100000000000000000	0	0xaf957638676acbbae05b1a261856b48df07de8f726d534d20fc4bca941a89803

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_arbitrum.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
0xb5fe3bc2ef4c34cc233922dff2fcb1b1bf89a38e	0xc98b1c64b32f1c6c795fac68418b7d2003bc083a	false	10	772	25758	60192132	402194755516397559863388	1809251394333065553493296641332507871113303595259584202199720673420953780224	2023-02-12T07:45:21.000Z	1000000	0xbacc4468caf84188946cc4e1cfa1ad20bf78919361e4a4e223714ce3468f9188
0xb5fe3bc2ef4c34cc233922dff2fcb1b1bf89a38e	0x8c702a9a6e0cd14a53251c630743c4f5327edde8	false	23	802	26756	60250930	403805839960778899618822	1809251394333065553493296641331478857235734677346070772919406269253994676224	2023-02-12T12:23:40.000Z	1000000	0xd9589031e8d0d5d0d6690beb49180fbbae4b19efeec6e102995a151accce85b3
0xb5fe3bc2ef4c34cc233922dff2fcb1b1bf89a38e	0x4e182b2176992f5fa6a178bdee1d1160396974fe	false	25	4106	136867	60243795	403582250882908248560986	1809251394333065553493296641331273054460220893763368123956831535839706087424	2023-02-12T11:50:12.000Z	8500000	0xee255c114be7286b3f931246e7605df518ae8154464d25d1928f8ab1e3496203

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_arbitrum.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
0xc631e2179862046a4da964a245559a53205b2bfd	0x79374fdf37d880354c89cbdb89a50c4471aee336	false	10	16154045822387039	522314148257180953	69982841	35093830485119447080348	1809251394333065553493296641332037464769272089927691876050735971016978202624	2023-03-15T06:08:53.000Z	10000000000000000000	0x61d85aa18cb35edecdd893c847d4d566c29de2049db50315509908fbc98a824f
0xb5fe3bc2ef4c34cc233922dff2fcb1b1bf89a38e	0xa83292a3ebf2e6473c457cc6b01e015d9858b176	false	30	3530172527101376393	114142245042944503495	99649922	474173122872864108123200	2713877091499598330239944961715175382144128938952873389424288255253411790848	2023-06-10T07:38:05.000Z	8800000	0xa48a541baec4b70697a944717063ba2679e6fb3f201a22454b9eb99b3566c617
0xb5fe3bc2ef4c34cc233922dff2fcb1b1bf89a38e	0x597da53a39ea634be355e6028136b5e5f28c25d9	false	20	8522679507113677033	275566637396675557673	99725238	473623151988194285697733	2713877091499598330239944961715351784523140753452332794851787444051704283136	2023-06-10T12:51:06.000Z	24875764	0xfa9d466fedf4e55c92d6ef82cada6c72ef18bed95600a7d13ddf92ac1d3d0474

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_arbitrum.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
0xc631e2179862046a4da964a245559a53205b2bfd	0xd6d7ea4833f22edbed3dbd3d71adf3cdd8e36a01	false	2308968200938959265	4	44419335	true	1670035274	2022-12-07T18:45:02.000Z	0x2d24ae27dcb679e30deeefa75a547ee6bfaa7a2f7d632c76bca388edafdd9b87
0xe5dbc4edf467b609a063c7ea7fab976c6b9baa1a	0x4fd9ccac9662cabcc6f4a9141b31be5b35bbc296	false	33000000000000000	5	44303062	true	1669974319	2022-12-07T09:09:03.000Z	0xb919c261ff8ce01a0e0a5dcf7617d6ab6be79373b001bf3de97117bef72b7b6d
0xe5dbc4edf467b609a063c7ea7fab976c6b9baa1a	0x21094fe24dc84b4fb9f8eeaa9eb2080e387814f3	false	2000000000000000000	4	44353431	true	1669536197	2022-12-07T13:27:47.000Z	0x6f232623b888831de9763e9de4e3b51834e9ddf56fe05901b2fdb1415eb3c113

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_arbitrum.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
0xbc3c01d954282eed8433da4359c1ac1443a7d09a	0xf87ca9eb60c2e40a6c5ab14ca291934a95f845ff	0x32844a824f458f24878515923f1fa120b6b711f2	false	3	10036676	true	2022-04-18T15:42:36.000Z	14801555602465206744	0xa2aedd91dab414c8f12a70e579ae2dd572e90205594fde37ce8f0208c8bc7361
0xbc3c01d954282eed8433da4359c1ac1443a7d09a	0xe5dbc4edf467b609a063c7ea7fab976c6b9baa1a	0x32844a824f458f24878515923f1fa120b6b711f2	false	1	10036676	true	2022-04-18T15:42:36.000Z	57017934698419571847	0xa2aedd91dab414c8f12a70e579ae2dd572e90205594fde37ce8f0208c8bc7361
0xbc3c01d954282eed8433da4359c1ac1443a7d09a	0xe5dbc4edf467b609a063c7ea7fab976c6b9baa1a	0x87e32d4631d728d6ad7ebcd133b11febc9da9b93	false	1	10005642	true	2022-04-18T04:05:04.000Z	21943286728979337402	0x08becd626ef4918d21a5b2743b63d88dd13463d2eafcedb8921c4aca97f479ca

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_arbitrum.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
0x89b36ce3491f2258793c7408bd46aac725973ba2	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	0xf87ca9eb60c2e40a6c5ab14ca291934a95f845ff	false	1	3304887	0xc5c8e77b397e531b8ec06bfb0048328b30e9ecfb	0xf97f4df75117a78c1a5a0dbb814af92458539fb4	2021-11-24T18:40:36.000Z	0x363d50c20174df16984531d73ad510364ffe2a1703a590c29efdfa6f18337ebf	0x86e53cf1b870786351da77a57575e79cb55812cb	50143449209799256683
0x89b36ce3491f2258793c7408bd46aac725973ba2	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	0xe5dbc4edf467b609a063c7ea7fab976c6b9baa1a	false	1	3304878	0xc5c8e77b397e531b8ec06bfb0048328b30e9ecfb	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2021-11-24T18:40:36.000Z	0x93581b9cb5ebd66d4aeea3578f3d38ea07ff0d2b43ccbc18424b1268ae4d57a8	0x639fe6ab55c921f74e7fac1ee960c0b6293ba612	50143449209799256683
0x89b36ce3491f2258793c7408bd46aac725973ba2	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	0xb5fe3bc2ef4c34cc233922dff2fcb1b1bf89a38e	false	1	3304882	0xc5c8e77b397e531b8ec06bfb0048328b30e9ecfb	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2021-11-24T18:40:36.000Z	0x47d536b8c807a0f4eb28922a547be6d8ab4aecaaf6712a693aa7f896ff1b0c14	0x6ce185860a4963106506c203335a2910413708e9	50143449209799256683

Example Query

Query with partition filter

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

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

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