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

What

A comprehensive table that contains all blockchain and platform specific borrows. This table contains borrows from Arbitrum, Avalanche, Base, BSC, Gnosis, Ethereum, Optimism, Polygon, Solana and Aptos. In order to borrow assets, a user must first deposit their preferred asset and amount as collateral.

Columns

Column NameData TypeDescription
BLOCKCHAINTEXTBLOCKCHAIN column
PLATFORMTEXTThe specific protocol where lending event occurred.
PROTOCOLTEXTPROTOCOL column
VERSIONTEXTVERSION column
BLOCK_NUMBERNUMBERThe block number at which the transaction is finalized.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe block timestamp of this transaction in UTC
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
CONTRACT_ADDRESSTEXTThe address interacted with for a given event.
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 of the token associated with the lending action.
AMOUNT_RAWNUMBERAMOUNT_RAW column
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.