# Lending Key Tables: * **Pools**: Contains information about different lending pools, including the token types, interest rates, and liquidity. * **Position Snapshot**: Snapshot of user positions in lending pools, including the amounts borrowed and supplied. * **Pool Snapshot**: Tracks the state of the pool over time, including Total Value Locked, fees earned, and interest rates. * **Events**: Tracks lending events like deposits, withdrawals, borrowing, and repayments. * **Liquidations**: Tracks liquidation events. {% 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 | | underlying\_token\_address | The contract address of the underlying token. | string | | underlying\_token\_symbol | The symbol of the underlying token. | string | | receipt\_token\_address | The contract address of the receipt token. | string | | receipt\_token\_symbol | The symbol of the receipt token. | string | | pool\_address | The contract address of the pool. | string | | pool\_type | The type of the pool (collateral\_only, isolated, supply\_pool, cdp). | string | | {% endtab %} | | | {% tab title="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 | | underlying\_token\_address | The contract address of the underlying token. | string | | underlying\_token\_symbol | The symbol of the underlying token. | string | | user\_address | The address of the user who has the position. | string | | supplied\_amount | The amount supplied by the user in the underlying token, decimal normalized. | number | | supplied\_amount\_usd | (Optional) The supplied amount in USD. | number | | borrowed\_amount | The amount borrowed by the user in the underlying token, decimal normalized. | number | | borrowed\_amount\_usd | (Optional) The borrowed amount in USD. | number | | collateral\_amount | (Optional) The amount of collateral-only tokens of this asset, decimal normalized. | number | | collateral\_amount\_usd | (Optional) The amount of collateral-only tokens 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 pool. | string | | underlying\_token\_address | The contract address of the underlying token. | string | | underlying\_token\_symbol | The symbol of the underlying token. | string | | underlying\_token\_price\_usd | (Optional) The token price of the underlying asset in USD. | number | | available\_amount | The amount of token's available to borrow (liquidity or net supply or supply - borrow). | number | | available\_amount\_usd | (Optional) The available amount of token's in this pool in USD. | number | | supplied\_amount | The total amount of the underlying token supplied in this pool, decimal normalized. | number | | supplied\_amount\_usd | (Optional) The supplied amount in USD. | number | | collateral\_amount | (Optional) The amount of collateral only tokens in this pool. | number | | collateral\_amount\_usd | (Optional) The amount of collateral only tokens in the pool. | number | | collateral\_factor | The collateral factor of the pool (defined as a decimal percentage, between 0-100). | number | | supply\_index | The supply index of the pool. | number | | supply\_apr | The current annual percentage rate for supplied amount, as a decimal percentage. | number | | borrowed\_amount | The amount of underlying tokens borrowed from this pool in the underlying token, decimal normalized. | number | | borrowed\_amount\_usd | (Optional) The borrowed amount in USD. | number | | borrow\_index | The borrow index of the pool. | number | | borrow\_apr | The current annual percentage rate for borrow, as a decimal percentage. | number | | total\_fees\_usd | (Optional) The total revenue or fees accrued in this pool during the given snapshot period (ie, user\_fees\_usd + protocol\_fees\_usd = total\_fees\_usd). | number | | user\_fees\_usd | (Optional) The portion of total revenue or fees accrued to users of the protocol during the given snapshot period. | number | | protocol\_fees\_usd | (Optional) The portion of total revenue or fees accrued to protocol during the given snapshot period. | number | | {% endtab %} | | | {% tab title="Events" %} | 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 address that receives the output of the event (ie, account that receives aTokens in an Aave Deposit). | string | | pool\_address | The contract address of the pool. | string | | token\_address | The address of the underlying token that was interacted with (ie, USDC and not aUSDC in Aave). | string | | amount | The amount of token\_address transacted, decimal normalized. | number | | amount\_usd | The amount of token\_address transacted, in USD. | number | | event\_type | The type of lending event, corresponds to the action taken by the user (ie, deposit, withdrawal, borrow, repay, liquidation, flashloan). | string | | {% endtab %} | | | {% tab title="Liquidations" %} | 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 | | liquidator\_address | The address that initiates the liquidation. | string | | user\_address | The address that was liquidated. | string | | pool\_address | The contract address of the pool. | string | | token\_address | The address of the underlying token that was repaid by the liquidator (ie, USDC and not aUSDC in Aave). | string | | amount | The amount of token\_address transacted, decimal normalized. | number | | amount\_usd | The amount of token\_address transacted, in USD. | number | | profit\_usd | The amount of profit the liquidator made from liquidating user\_address (can be negative). | 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/lending.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.