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

What

This table contains loan repayment transactions across lending protocols. Repayments reduce or eliminate outstanding debt positions, with amounts including both principal and accrued interest. Understanding repayment patterns helps analyze user behavior and protocol health.

Key Use Case

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_REPAYMENTS_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… | | PAYER | TEXT | The address that paid the loan or deposit. Example: ‘0x5… | | 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… |