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.
Table Details
| Property | Value |
|---|---|
| Table Name | x_layer.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. |