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

What

This table provides a comprehensive view of borrowing transactions across all major lending protocols on EVM blockchains. It captures when users borrow assets against their deposited collateral, enabling analysis of lending market dynamics, user behavior, and protocol performance.

Key U

Columns

Column NameData TypeDescription
AMOUNTFLOATThe decimal-adjusted quantity of tokens in the transactio…
AMOUNT_UNADJFLOATThe raw amount of tokens borrowed or repaid without decim…
AMOUNT_USDFLOATThe USD value of tokens at transaction time.
Example: 15… | | BLOCK_NUMBER | NUMBER | Sequential counter representing the position of a block i… | | BLOCK_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the block was produced by validators/m… | | BORROWER | TEXT | The address that initiated a borrow or repayment transact… | | CONTRACT_ADDRESS | TEXT | Smart contract address that emitted this event or receive… | | EVENT_INDEX | NUMBER | Zero-based sequential position of the event within a tran… | | EVENT_NAME | TEXT | The event name as defined in the contract’s ABI. **Forma… | | EZ_LENDING_BORROWS_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. … | | ORIGIN_FROM_ADDRESS | TEXT | The externally-owned account (EOA) or contract address th… | | ORIGIN_FUNCTION_SIGNATURE | TEXT | Function signature (first 4 bytes) of the called method. … | | ORIGIN_TO_ADDRESS | TEXT | The destination address for the transaction - either an E… | | PLATFORM | TEXT | The lending protocol where the transaction occurred. Exa… | | PROTOCOL_MARKET | TEXT | The lending protocol’s receipt token issued to depositors… | | 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… | | TX_HASH | TEXT | Unique 66-character identifier for the transaction. **Fo… |