# DEX Key Tables: * **Pools**: Details of liquidity pools, including token pairs, liquidity provided, and fee rates. * **LP Position Snapshot**: Snapshots of liquidity provider positions, tracking token amounts and USD values. * **Pool Snapshot**: Snapshot of individuals pools, including token volume, fees, and transaction data. * **Trades**: Records of user trades, capturing swap amounts, tokens involved, and fees.\\ {% tabs %} {% tab title="Pools" %} | Property | Description | Type | | ----------------------- | --------------------------------------------------------------------------------------------------------------- | ------ | | chain\_id | The standard id of the chain. | number | | creation\_block\_number | The block this pool was created in. | number | | timestamp | The timestamp of the block that this pool was created in. | number | | pool\_address | The contract address of the LP pool. | string | | lp\_token\_address | The token address of the LP token for this pool. | string | | lp\_token\_symbol | The symbol of the LP token. | string | | token\_address | The token address of the pool token at token\_index. | string | | token\_symbol | The symbol of the pool token. | string | | token\_decimals | The decimals of the pool token. | string | | token\_index | The index in the pool smart contract that this token appears at, default 0 (ie, one entry per token in a pool). | number | | fee\_rate | The fee rate of the pool, as a percentage (ie, 2.3% as 0.023). | number | | dex\_type | The type of the DEX (ie, CPMM, CLMM, Orderbook). | string | | {% endtab %} | | | {% tab title="LP Position 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 | The standard id of the chain. | number | | pool\_address | The contract address of the pool. | string | | user\_address | The address of the liquidity provider. | string | | token\_index | The token index based on the smart contract. | number | | token\_address | The contract address of the token provided as liquidity. | string | | token\_symbol | The symbol of the token. | string | | token\_amount | The amount of the underlying liquidity position in the pool, decimal normalized (ie, the amount of USDC provided by the LPer in a USDC/WETH pool). | number | | token\_amount\_usd | The amount of the token 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 | The standard id of the chain. | number | | pool\_address | The contract address of the LP pool. | string | | token\_index | The token index in the smart contract. | number | | token\_address | The contract address of the token in the pool. | string | | token\_symbol | The symbol of the token. | string | | token\_amount | The amount of the token in this pool at the snapshot. | number | | token\_amount\_usd | The amount of the token in USD. | number | | volume\_amount | The volume of the token transacted in this pool during the given snapshot, decimal normalized. | number | | volume\_usd | The volume transacted in the given snapshot, in USD. | number | | fee\_rate | The fee rate of the pool, as a percentage (ie, 2.3% as 0.023). | number | | total\_fees\_usd | The total amount of revenue and fees paid in this pool in the given snapshot, in USD. | number | | user\_fees\_usd | The amount of total fees accrued to liquidity providers of the protocol, in USD. | number | | protocol\_fees\_usd | The amount of total fees accrued to the protocol, in USD. | number | | {% endtab %} | | | {% tab title="Trades" %} | Property | Description | Type | | ------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ | | timestamp | The timestamp of the transaction. | number | | chain\_id | The standard id of the chain. | number | | block\_number | The block number of the trade. | number | | log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number | | transaction\_hash | The hash of the transaction. | string | | user\_address | The address that initiates the transaction (ie, the transaction signer). | string | | taker\_address | The taker, the address that receives the output of the swap (ie, could be the same as user\_address unless a proxy contract/router is used). | string | | pair\_name | The name of the token pair. | string | | pool\_address | The contract address of the LP pool being traded in. | string | | input\_token\_address | The contract address of the input token (ie, the tokenIn or the token being sold to the pool). | string | | input\_token\_symbol | The symbol of the input token. | string | | input\_token\_amount | The amount of the input token, decimal normalized. | number | | output\_token\_address | The contract address of the output token (ie, the tokenOut of the token being bought by the user and sent to the taker). | string | | output\_token\_symbol | The symbol of the output token. | string | | output\_token\_amount | The amount of the output token, decimal normalized. | number | | spot\_price\_after\_swap | The spot price in the pool after the swap is complete. This is the price ratio a user would get if they made an infinitesimal swap immediately after this one. | number | | swap\_amount\_usd | The amount of the swap in USD. | number | | fees\_usd | The fees paid by the user. | number | | {% 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/dex.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.