| 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) | [TODO: Add description for note] |
| 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. |
