> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# premia_v1_fantom

> Tables in tt-contracts.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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.premia_v1_fantom.Pool_APYFeePaid_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.premia_v1_fantom.Pool_Deposit_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.        |
</Accordion>

<Accordion title="Sample Data">
  | in\_fee | address                                    | in\_user                                   | removed | log\_index | block\_number | in\_longTokenId                                                              | block\_timestamp         | in\_contractSize       | in\_exerciseValue | transaction\_hash                                                  |
  | ------- | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ---------------------------------------------------------------------------- | ------------------------ | ---------------------- | ----------------- | ------------------------------------------------------------------ |
  | 0       | 0x7c7ec9d8672dfead60d6a533c3c5610dd8916c48 | 0x56ebc608fd6b8f8cef2775a3ee0dddaec01a7000 | false   | 1          | 46325338      | 1809251394333065553493296641326392588640894025944990614163813142733485579960 | 2022-09-04T08:13:16.000Z | 2000000000000000000000 | 0                 | 0x724c493a01f7d314ecc97c06989edeb4409a6935eed7bd7b08fef661205d327b |
  | 0       | 0xd888b9aa5ef1a85968892c12e8cc83c73d69c8a1 | 0xc7a2ec652d8273cae26a4bec91cfe30e1c83ae7c | false   | 175        | 46325342      | 1809251394333065553493296641326392588640894025944990644300812338274991341568 | 2022-09-04T08:13:21.000Z | 1000000000000000000    | 0                 | 0x0c70ea5fcbeb055e98715679ed4c7e94d046e67b0f2472392cb4b5c2aebe0f5f |
  | 0       | 0x3a098984f1c3ecbab0d5866f35438ec0db3ec8c2 | 0xc7a2ec652d8273cae26a4bec91cfe30e1c83ae7c | false   | 2          | 46325365      | 2713877091499598330239944961706766868744565781145307895960762844295104299008 | 2022-09-04T08:14:03.000Z | 10000000               | 68766431          | 0x48bb18ab76ac7975ac065728a9ab60810ff5e98a5d01086ff0372fcddb092f45 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.premia_v1_fantom.Pool_Exercise_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                       |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.premia_v1_fantom.Pool_Purchase_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                       |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.premia_v1_fantom.Pool_Sell_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.premia_v1_fantom.Pool_Withdrawal_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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).             |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.premia_v1_fantom.PremiaMine_Claim_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                                                                                                     |
</Accordion>

<Accordion title="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   |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.premia_v1_fantom.ProxyManager_DeployPool_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***