# Derivative Key Tables: * **Pools:** Details of liquidity pools, including token addresses, pool creation data, and associated tokens. * **LP Snapshot:** Liquidity provider snapshots, tracking deposits, liquidated amounts, and fees accrued for each token in a pool. * **Pool Snapshot:** Snapshot of individuals pools, including funding rates, fee rates, and open interest for long and short positions. * **Trades:** Records of user trades, including open/close actions, trade amounts, notional values, and profit/loss (P\&L) data for both makers and takers. {% tabs %} {% tab title="Pools" %} | Property | Description | Type | | ----------------------- | -------------------------------------------------------------------------------- | ------ | | chain\_id | Standard chain id. | number | | timestamp | The timestamp of the block the pool was created on. | number | | creation\_block\_number | The block number this pool was created on. | number | | pool\_address | The contract address of the pool. | string | | pool\_name | The name of the pool (ie, name()) in the smart contract). | string | | token\_index | The index of the token in the smart contract (one row for each token in a pool). | number | | token\_address | The contract address of the token. | string | | token\_symbol | The symbol of the token. | string | | {% endtab %} | | | {% tab title="LP Snapshot" %} | Property | Description | Type | | ----------------------- | -------------------------------------------------------------------------------------------------------------------------- | ------ | | timestamp | The timestamp of the snapshot. | number | | block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date | | chain\_id | Standard chain id. | number | | pool\_address | The address of the pool. | string | | lp\_address | The address of the liquidity provider. | string | | token\_index | The index of the token in the smart contract. | number | | token\_address | The address of the token provided as liquidity. | string | | token\_symbol | The symbol of the token. | string | | deposit\_amount | (Optional, for Order Books) The amount deposited into the pool, decimal normalized. | number | | deposit\_amount\_usd | (Optional, for Order Books) The amount deposited, in USD. | number | | amount\_useful | (Optional, for LPs) The amount of tokens supplied that are liquid and usable by users of the protocol, decimal normalized. | number | | amount\_useful\_usd | (Optional, for LPs) The amount of liquid tokens supplied in USD. | number | | liquidated\_amount | The amount of tokens liquidated from the LP, decimal normalized. | number | | liquidated\_amount\_usd | The amount liquidated, in USD. | number | | total\_fees\_usd | (Optional) All fees generated by the LP in the given snapshot in USD. | number | | user\_fees\_usd | (Optional) The portion of fees accrued to users of the protocol, in USD. | number | | protocol\_fees\_usd | (Optional) The portion of fees accrued to the protocol, in USD. | number | | {% endtab %} | | | {% tab title="Pool Snapshot" %} | Property | Description | Type | | --------------------------- | ----------------------------------------------------------------------------------------------------------------- | ------ | | timestamp | The timestamp of the snapshot. | number | | block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date | | chain\_id | Standard chain id. | number | | pool\_address | The smart contract address of the pool. | string | | token\_index | The index of the token in the smart contract (one row for each token in a pool). | number | | funding\_rate | The funding rate in this pool at the time of the snapshot, as a percentage. | number | | fee\_rate | he pool's fee rate, as a percentage. | number | | total\_value\_locked\_usd | The total value locked in USD. | number | | volume\_usd | The volume of positions opened and closed in the given snapshot in USD. | number | | open\_interest\_longs\_usd | The sum of open interest of longs held within this pool in USD. | number | | open\_interest\_shorts\_usd | The sum of open interest in shorts held within this pool in USD. | number | | {% endtab %} | | | {% tab title="Trades" %} | Property | Description | Type | | -------------------- | --------------------------------------------------------------------------------------------------- | ------- | | timestamp | The timestamp of the trade. | number | | chain\_id | Standard chain id. | number | | transaction\_hash | The hash of the transaction this trade was performed in. | string | | log\_index | Event log index. | number | | block\_number | The block number of the trade. | number | | pool\_address | The address of the pool this token was traded in. | string | | maker\_address | The address of the maker. | string | | taker\_address | The address of the taker. | string | | token\_address | The address of the token. | string | | amount | The value that a trader is putting to open a long or short, decimal normalized. | number | | amount\_usd | The trade amount in USD. | number | | notional\_value | The value of the leveraged amount of the trade, decimal normalized. | number | | notional\_value\_usd | The notional value, in USD. | number | | maker\_pnl\_usd | The total profit and loss of the trade on the maker's side, in USD. | number | | taker\_pnl\_usd | The total profit and loss of the trade on the taker's side, in USD. | number | | trade\_action | The action of trade being recorded in this entry (ie, OPEN, CLOSE, INCREASE, DECREASE, LIQUIDATED). | string | | trade\_type | The type of the trade being recorded in this entry (ie, LONG, SHORT). | vstring | | {% endtab %} | | | | {% endtabs %} | | | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.openblocklabs.com/data-offering/defi-canonical-data/derivative.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.