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

# Interest Rates

### Table Details

| Property          | Value                             |
| ----------------- | --------------------------------- |
| Table Name        | `hyperevm.lending.interest_rates` |
| Table Status      | Production-Ready                  |
| Unique Key        | `block_timestamp`, `unique_id`    |
| Clustering Key(s) | `block_timestamp::date`           |

### Table Columns

| Column Name                  | Data Type         | Description                                                                                                                                            |
| ---------------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ |
| project                      | VARCHAR(16777216) | Name of the lending project (e.g., 'aave', 'morpho').                                                                                                  |
| protocol                     | VARCHAR(16777216) | Specific protocol version or variant (e.g., 'aave\_v3', 'morpho\_blue').                                                                               |
| note                         | VARCHAR(16777216) | Additional note or annotation for the interest rate record (e.g., protocol-specific context).                                                          |
| contract\_address            | VARCHAR(16777216) | Address of the main protocol contract.                                                                                                                 |
| market\_address              | VARCHAR(16777216) | Address of the specific lending market. This field is the ID of the market for Morpho Blue protocol.                                                   |
| token\_address               | VARCHAR(16777216) | Address of the loan token in the market.                                                                                                               |
| token\_name                  | VARCHAR(16777216) | Name of the loan token.                                                                                                                                |
| token\_symbol                | VARCHAR(16777216) | Symbol of the loan token.                                                                                                                              |
| token\_decimals              | NUMBER(38,0)      | Number of decimals of the loan token.                                                                                                                  |
| usd\_exchange\_rate          | FLOAT             | USD exchange rate of the loan token at the time of the rate update.                                                                                    |
| supply\_apy                  | FLOAT             | Annual Percentage Yield for suppliers/lenders, expressed as a percentage.                                                                              |
| stable\_borrow\_apy          | FLOAT             | Annual Percentage Yield for stable-rate borrowers, expressed as a percentage. Only applicable for protocols with stable rates like Aave.               |
| variable\_borrow\_apy        | FLOAT             | Annual Percentage Yield for variable-rate borrowers, expressed as a percentage.                                                                        |
| cumulative\_supply\_interest | FLOAT             | Cumulative index tracking interest earned by suppliers over time (liquidityIndex in Aave). Only applicable for certain protocols like Aave.            |
| cumulative\_borrow\_interest | FLOAT             | Cumulative index tracking interest accumulated for borrowers over time (variableBorrowIndex in Aave). Only applicable for certain protocols like Aave. |
| outstanding\_loans           | FLOAT             | Total amount of tokens borrowed from the market, normalized by token decimals.                                                                         |
| outstanding\_loans\_usd      | FLOAT             | USD value of the total borrowed tokens.                                                                                                                |
| supplied\_amount             | FLOAT             | Total amount of tokens supplied to the market, normalized by token decimals.                                                                           |
| supplied\_amount\_usd        | FLOAT             | USD value of the total supplied tokens.                                                                                                                |
| available\_liquidity         | FLOAT             | Amount of tokens available for borrowing, normalized by token decimals.                                                                                |
| available\_liquidity\_usd    | FLOAT             | USD value of the tokens available for borrowing.                                                                                                       |
| trace\_params                | VARIANT           | Raw parameters from the trace call that provided the interest rate data.                                                                               |
| logs\_params                 | VARIANT           | Raw parameters from the event logs that provided the interest rate data.                                                                               |
| transaction\_hash            | VARCHAR(16777216) | Transaction hash where the interest rate update occurred.                                                                                              |
| transaction\_index           | NUMBER(38,0)      | Index of the transaction in the block.                                                                                                                 |
| block\_timestamp             | TIMESTAMP\_NTZ(9) | Timestamp of the block when the interest rate was updated.                                                                                             |
| block\_number                | NUMBER(38,0)      | Block number when the interest rate was updated.                                                                                                       |
| block\_hash                  | VARCHAR(16777216) | Hash of the block when the interest rate was updated.                                                                                                  |
| unique\_id                   | VARCHAR(16777216) | Unique identifier for the interest rate update event.                                                                                                  |
| \_created\_at                | TIMESTAMP\_NTZ(9) | Timestamp of when the record was created.                                                                                                              |
| \_updated\_at                | TIMESTAMP\_NTZ(9) | Timestamp of when the record was last updated.                                                                                                         |

### Related Docs

* [EVM Lending Interest Rates](/historical-data/supported-blockchains/evm/core-schemas/lending/interest-rates)