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

​
What

This table tracks all deposit transactions across lending protocols on EVM blockchains. Deposits represent users supplying liquidity to lending pools, earning yield while enabling their assets to serve as collateral for borrowing.

​
Key Use Cases

  • Calculating total value locked (TVL) by

​
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… | | CONTRACT_ADDRESS | TEXT | Smart contract address that emitted this event or receive… | | DEPOSITOR | TEXT | The address that supplied liquidity to the lending protoc… | | 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_DEPOSITS_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… |