Skip to main content
Schema: monad.defi Table: ez_lending_ohlc_rates Type: View

​
What

This table provides OHLC (Open, High, Low, Close) interest rate data for lending protocols, aggregated by day. It tracks supply, stable borrow, and variable borrow rates with forward-filling for missing data points, enabling analysis of interest rate trends and volatility across lending mar

​
Columns

Column NameData TypeDescription
BLOCKCHAINTEXTThe blockchain network where the data was sourced from.
… | | DAY | TEXT | The date for which the OHLC interest rate data is calcula… | | EZ_OHLC_RATES_ID | TEXT | Primary key - unique identifier for each row ensuring dat… | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first added to the Flip… | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp of the most recent update to this record. … | | PLATFORM | TEXT | The lending protocol where the transaction occurred. Exa… | | PROTOCOL | TEXT | The lending protocol name (e.g., Aave, Compound). Exampl… | | RATE_UPDATES_COUNT | NUMBER | The number of rate updates that occurred during the day. … | | STABLE_BORROW_RATE_CLOSE | TEXT | The closing stable borrow interest rate for the day (last… | | STABLE_BORROW_RATE_HIGH | TEXT | The highest stable borrow interest rate observed during t… | | STABLE_BORROW_RATE_LOW | TEXT | The lowest stable borrow interest rate observed during th… | | STABLE_BORROW_RATE_OPEN | TEXT | The opening stable borrow interest rate for the day (firs… | | SUPPLY_RATE_CLOSE | TEXT | The closing supply interest rate for the day (last rate o… | | SUPPLY_RATE_HIGH | TEXT | The highest supply interest rate observed during the day… | | SUPPLY_RATE_LOW | TEXT | The lowest supply interest rate observed during the day. … | | SUPPLY_RATE_OPEN | TEXT | The opening supply interest rate for the day (first rate … | | TOKEN_ADDRESS | TEXT | The contract address of the underlying asset being lent o… | | TOKEN_SYMBOL | TEXT | The ticker symbol of the asset involved in the lending tr… | | VARIABLE_BORROW_RATE_CLOSE | TEXT | The closing variable borrow interest rate for the day (la… | | VARIABLE_BORROW_RATE_HIGH | TEXT | The highest variable borrow interest rate observed during… | | VARIABLE_BORROW_RATE_LOW | TEXT | The lowest variable borrow interest rate observed during … | | VARIABLE_BORROW_RATE_OPEN | TEXT | The opening variable borrow interest rate for the day (fi… | | VERSION | TEXT | The version of the protocol (e.g., v2, v3). Example: ‘v3’ |