premia_v1_fantom

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
0x3a098984f1c3ecbab0d5866f35438ec0db3ec8c2	false	38238	57	67125628	0x2a6be69cd729288006f831737d5032f15626d52c	2023-08-18T08:56:30.000Z	2261564242916331941866620801526811066675415144513795570166742271254205562880	0xe6b60f5b1d595d24a666ad513d2b80e9bc2f8429a9f050bf49a2ff10a593f520
0x3a098984f1c3ecbab0d5866f35438ec0db3ec8c2	false	5348	22	67125668	0xbd1b3513bb0ce1529242cfb28926618809592362	2023-08-18T08:58:09.000Z	2261564242916331941866620801526811066675415144513795597836858381818532986880	0x6344644f820d764b0f92302e831874aa6235571eafec72b2e51ff45e6aa91454
0x3a098984f1c3ecbab0d5866f35438ec0db3ec8c2	false	193698	4	67125635	0xf2eaeb6a0c248bcd69fd314180d69907b9be7491	2023-08-18T08:56:52.000Z	3166189940082864718613269121907185346779086899714112375267912240913493000192	0x402cf9cefe09c36f0de4f43578a874f39519dfdd4f09b815602de86eb9e106c4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_fantom.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
0x07bbb494cc048da39b5a11938f405424c66b75fb	0xe76bc1cc2a58176249d92be86d988470b8c5760e	false	36000000000	2	37215067	false	2022-04-29T12:24:01.000Z	0x0b5dbcd75eed118b21ca6be097664bed9bd853c2b6976bd5a66c047319656245
0x07bbb494cc048da39b5a11938f405424c66b75fb	0x4f4366b13d499b4248b084a4c3f00ad960c53ea0	false	40000000000	17	37212084	false	2022-04-29T11:18:00.000Z	0xd39f18c2c2a0120e8cb7ba55f38f2be0a9144fa3221f82451d3ded1c9acb1f56
0x07bbb494cc048da39b5a11938f405424c66b75fb	0xd84b9909a087872efb9b08bae8171625a3ccb653	false	8000000000	4	37228457	false	2022-04-29T17:24:04.000Z	0x4910956e7607d9aa9a8ea84aac6e790efb0f021ec0089bee428125c3ad16a481

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_fantom.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
0x7c7ec9d8672dfead60d6a533c3c5610dd8916c48	0x56ebc608fd6b8f8cef2775a3ee0dddaec01a7000	false	1	46325338	1809251394333065553493296641326392588640894025944990614163813142733485579960	2022-09-04T08:13:16.000Z	2000000000000000000000	0	0x724c493a01f7d314ecc97c06989edeb4409a6935eed7bd7b08fef661205d327b
0xd888b9aa5ef1a85968892c12e8cc83c73d69c8a1	0xc7a2ec652d8273cae26a4bec91cfe30e1c83ae7c	false	175	46325342	1809251394333065553493296641326392588640894025944990644300812338274991341568	2022-09-04T08:13:21.000Z	1000000000000000000	0	0x0c70ea5fcbeb055e98715679ed4c7e94d046e67b0f2472392cb4b5c2aebe0f5f
0x3a098984f1c3ecbab0d5866f35438ec0db3ec8c2	0xc7a2ec652d8273cae26a4bec91cfe30e1c83ae7c	false	2	46325365	2713877091499598330239944961706766868744565781145307895960762844295104299008	2022-09-04T08:14:03.000Z	10000000	68766431	0x48bb18ab76ac7975ac065728a9ab60810ff5e98a5d01086ff0372fcddb092f45

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_fantom.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
0x7c7ec9d8672dfead60d6a533c3c5610dd8916c48	0x4a59e8a04842c60f5fe2ebf7e7de5ddbd10a991d	false	9	8021576	267385873	42561325	4492748930504311175	2713877091499598330239944961705208647729961419733416035719723964801407590072	2022-07-12T00:31:46.000Z	10000000000000000000000	0x43f7c7b6b200196619ddea7d4d8d2abc0084319419c7437333b6a31038b8dea2
0x7c7ec9d8672dfead60d6a533c3c5610dd8916c48	0x4a59e8a04842c60f5fe2ebf7e7de5ddbd10a991d	false	42	15349976	511665899	42578367	4541343593081994227	2713877091499598330239944961705208647729961419733416035719908432242144685588	2022-07-12T06:49:25.000Z	15000000000000000000000	0x7d8f1f5adaad3b7545de0714512f94c5137f5cf5b1f6561435daa175cfdc7a40
0x7c7ec9d8672dfead60d6a533c3c5610dd8916c48	0x4a59e8a04842c60f5fe2ebf7e7de5ddbd10a991d	false	112	10015377	333845919	42576591	4574471245266813857	2713877091499598330239944961705208647729961419733416035719723964801407590072	2022-07-12T06:09:18.000Z	15000000000000000000000	0xc171ab3db1ca3d8c0157a4cf8fce60f4108225f8ec4fba21d047383bedfc7b39

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_fantom.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
0x7c7ec9d8672dfead60d6a533c3c5610dd8916c48	0xbcb5f95758fee1a28c24a4c4f8473896f57f6a56	false	11	479258	15496036	50631119	3918859850482791670	2713877091499598330239944961708707294913695740639361068082756563081365217607	2022-11-08T20:08:51.000Z	891100000000000000000	0x2841ac11554e10419df53000b883f2b2bfaebda920238b8f663ccb7aaa5e51a5
0x7c7ec9d8672dfead60d6a533c3c5610dd8916c48	0xba64294b01d43f0b942879efd5184352bb33a5a4	false	79	970137	31367783	50606255	4492634750246910812	2713877091499598330239944961708677894517193771556117832517043393189369610240	2022-11-08T07:23:42.000Z	5000000000000000000000	0x8a8927519c79800bcbb3c454b5c9b380cd883b1d0d002f31de196bc3b65c7fed
0x7c7ec9d8672dfead60d6a533c3c5610dd8916c48	0x1ae74f5f0d55d82ab60b381cacec1445eaa1b26a	false	13	2167099	70069555	50634059	3932409821956044338	2713877091499598330239944961708766095706699678805847539214367370306093527859	2022-11-08T21:08:06.000Z	20000000000000000000000	0xa3bd5a4b9809ff006d1427ca9f9e17635370c051e26bc2e4e0fd787900eec836

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_fantom.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
0x07bbb494cc048da39b5a11938f405424c66b75fb	0x725ba8d6b5299b6d3b4e923348cb66c14fe6b388	false	193651009	4	39702387	false	1654187206	2022-06-03T16:27:06.000Z	0x5c3a59c9e97ff579d5c08e748aa4e92d53ef706a454b5398afcb8da8f5c86e78
0x07bbb494cc048da39b5a11938f405424c66b75fb	0xabdb1f94bff885bd8933ac4f8aaacda4326491de	false	13844000000	4	39665568	false	1654132758	2022-06-03T04:40:49.000Z	0x9d34a11a4bb80966d2153d9c12a3e26dd5e55fdc62833c4f164843e438d4aaf0
0x07bbb494cc048da39b5a11938f405424c66b75fb	0x58fc8a5d2bc89dc1a353537271a217a6f64c92a4	false	68410523063933792	35	39712423	true	1651149712	2022-06-03T19:45:46.000Z	0xc1c4c65130ca7e59bdb907881a262b6a4e96ff4cd7a930a86d0b781798fa962a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_fantom.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
0x0389996552f5da35fa6ddc80b083f78622df3a6f	0x3a098984f1c3ecbab0d5866f35438ec0db3ec8c2	0x8f22cee99b55ffba8c55f27181d14bcd34e202ed	false	30	59460565	true	2023-04-09T06:53:15.000Z	459637957318951007374	0x8141b036cbb2403f2841eb87ef263d6528473443012800c05348d172d9cc79f6
0x0389996552f5da35fa6ddc80b083f78622df3a6f	0x7c7ec9d8672dfead60d6a533c3c5610dd8916c48	0x8f22cee99b55ffba8c55f27181d14bcd34e202ed	false	27	59460565	true	2023-04-09T06:53:15.000Z	197729663331485651653	0x8141b036cbb2403f2841eb87ef263d6528473443012800c05348d172d9cc79f6
0x0389996552f5da35fa6ddc80b083f78622df3a6f	0x3a098984f1c3ecbab0d5866f35438ec0db3ec8c2	0xa8439a8c84fd3e569d4c3a33ecd88e415426d3a8	false	82	53019616	true	2022-12-29T22:16:22.000Z	694495001601419631	0x5fded48e12240a5cf1fe24dc1648f572824fc62d5d5063a2f49fbd63864cf40c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_fantom.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
0xd9e169e31394efccd78cc0b63a8b09b4d71b705e	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0x7c7ec9d8672dfead60d6a533c3c5610dd8916c48	false	21	37104542	0x2553f4eeb82d5a26427b8d1106c51499cba5d99c	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2022-04-27T23:18:02.000Z	0x3510f002fe0efd9870f1d562b6f1844de8642ef4e0ce1b1493dadc87b0195f33	0xf4766552d15ae4d256ad41b6cf2933482b0680dc	50143449209799256683
0xd9e169e31394efccd78cc0b63a8b09b4d71b705e	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0x07bbb494cc048da39b5a11938f405424c66b75fb	false	12	37104559	0x2553f4eeb82d5a26427b8d1106c51499cba5d99c	0x29b0da86e484e1c0029b56e817912d778ac0ec69	2022-04-27T23:18:21.000Z	0x0e06d1c62178e53324d86cb4217e9749fdfaa95393bcc473c051464d82d85264	0x9b25ec3d6acff665dfbbfd68b3c1d896e067f0ae	50143449209799256683
0xd9e169e31394efccd78cc0b63a8b09b4d71b705e	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0x3a098984f1c3ecbab0d5866f35438ec0db3ec8c2	false	12	37104555	0x2553f4eeb82d5a26427b8d1106c51499cba5d99c	0x321162cd933e2be498cd2267a90534a804051b11	2022-04-27T23:18:16.000Z	0x76818b0eca314ceaa37eeb46ff97768c652e826193782d0a029251698fd55b76	0x8e94c22142f4a64b99022ccdd994f4e9ec86e4b4	50143449209799256683

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.premia_v1_fantom.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