Lending
Interest Rates
The <chain>.lending.interest_rates table contains supply and borrowing interest rate as well as outstanding loans from Aave and Morpho Blue.
Table Columns
Unique Key: unique_id
| Column | Data Type | Description |
|---|---|---|
| project | VARCHAR | Name of the lending project (e.g., ‘aave’, ‘morpho’). |
| protocol | VARCHAR | Specific protocol version or variant (e.g., ‘aave_v3’, ‘morpho_blue’). |
| contract_address | VARCHAR | Address of the main protocol contract. |
| market_address | VARCHAR | Address of the specific lending market. This field is the ID of the market for Morpho Blue protocol. |
| token_address | VARCHAR | Address of the loan token in the market. |
| token_name | VARCHAR | Name of the loan token. |
| token_symbol | VARCHAR | Symbol of the loan token. |
| token_decimals | INTEGER | 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 | Transaction hash where the interest rate update occurred. |
| transaction_index | INTEGER | Index of the transaction in the block. |
| block_timestamp | TIMESTAMP | Timestamp of the block when the interest rate was updated. |
| block_number | INTEGER | Block number when the interest rate was updated. |
| block_hash | VARCHAR | Hash of the block when the interest rate was updated. |
| unique_id | VARCHAR | 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. |