Skip to main content
Schema: crosschain.defi Table: ez_lending Type: View

What

This is a table that shows all the events across various blockchains and various platforms that are related to providing capital for lending and withdrawing capital

Columns

Column NameData TypeDescription
BLOCK_TIMESTAMPTIMESTAMP_NTZThe block timestamp of this transaction in UTC
BLOCK_NUMBERNUMBERThe block number at which the transaction is finalized.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
ACTIONTEXTThe action that the user is taking. Deposit: user is depositing funds to be used for lending Withdraw: user has changed their mind and are no longer willing to lend, so they withdraw their asset
BLOCKCHAINTEXTBLOCKCHAIN column
PLATFORMTEXTThis field denotes which application the liquidity pool belongs to.
ORIGIN_FROM_ADDRESSTEXTThe address of the user who initiates the transaction.
ORIGIN_TO_ADDRESSTEXTThe person who initiates the depositing transaction has to interact with this address. This address belongs to the lending platform or directs the transactio there.
ORIGIN_FUNCTION_SIGNATURETEXTORIGIN_FUNCTION_SIGNATURE column
ASSETTEXTASSET column
DEPOSITORTEXTThe address of the user or contract that is depositing funds for lending
LENDER_IS_A_CONTRACTTEXTIf the depositor is a contract then its a Yes, if the depositor is a normal address it is a No.
LENDING_POOL_ADDRESSTEXTThe contract address for the lending pool.
ASSET_AMOUNTFLOATASSET_AMOUNT column
ASSET_AMOUNT_USDFLOATASSET_AMOUNT_USD column
LENDING_POOLTEXTThe name of the lending pool.
SYMBOLTEXTThe symbol of the asset that is being deposited for lending.
_LOG_IDTEXTThis is the primary key for this table. This is a concatenation of the transaction hash and the event index at which the event occurred. This field can be used within other event based tables such as & .