Skip to main content
Schema: blast.defi Table: ez_lending_deposits Type: View This table contains deposit transactions across ORBIT, JUICE AND INIT protocols. A user deposits their preferred asset and amount. After depositing, users earn passive income based on the market borrowing demand. Additionally, depositing allows users to borrow by using their deposited assets as a collateral. Any interest earned by depositing funds helps offset the interest rate accumulated by borrowing.

​
Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed. This field will not be unique in this table, as a given transaction can include multiple events.
CONTRACT_ADDRESSTEXTThe address interacted with for a given event.
EVENT_NAMETEXTThe decoded event name for a given event.
EVENT_INDEXNUMBEREvent number within a transaction.
ORIGIN_FUNCTION_SIGNATURETEXTThe function signature of this transaction.
ORIGIN_FROM_ADDRESSTEXTThe from address of this transaction.
ORIGIN_TO_ADDRESSTEXTThe to address of this transaction.
PLATFORMTEXTThe specific protocol where lending event occurred.
PROTOCOL_MARKETTEXTThe protocol’s specific lending asset token, ie cWBTC or aETHUni.
DEPOSITORTEXTAddress that initiated a deposit event.
TOKEN_ADDRESSTEXTThe address of the token associated with the lending action.
TOKEN_SYMBOLTEXTThe symbol belonging to the address of the token
AMOUNT_UNADJFLOATThe non-decimal adjusted amount of tokens involved in the lending transaction.
AMOUNTFLOATThe decimal adjusted amount of tokens involved in the lending transaction, where available.
AMOUNT_USDFLOATThe value of the tokens in USD at the time of the lending transaction, where available.
EZ_LENDING_DEPOSITS_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.