Skip to main content
Schema: blast.defi Table: ez_lending_borrows Type: View This table contains transactions where users borrowed assets across ORBIT, JUICE AND INIT protocols. In order to borrow assets, a user must first deposit their preferred asset and amount as collateral.

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.
BORROWERTEXTAddress that initiated the borrow 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_BORROWS_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.