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

What

A comprehensive table that contains all blockchain and platform specific flashloans. This table contains deposit events across Arbitrum, Avalanche, Base, BSC, Gnosis, Ethereum, Optimism, and Polygon. Flash loans are a feature designed for developers, due to the technical knowledge required to execute one. Flash Loans allow you to borrow any available amount of assets without providing any collateral, as long as the liquidity is returned to the protocol within one block transaction.

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.
INITIATORTEXTThe address that initiated the flash loan.
TARGETTEXTThe address receiving the flash loan.
FLASHLOAN_TOKENTEXTThe flashloaned token address.
FLASHLOAN_TOKEN_SYMBOLTEXTThe symbol of the token associated with the lending action.
FLASHLOAN_AMOUNT_RAWNUMBERFLASHLOAN_AMOUNT_RAW column
FLASHLOAN_AMOUNTFLOATThe amount of assets flash loaned.
FLASHLOAN_AMOUNT_USDFLOATThe value of the flash loan amount, in USD.
PREMIUM_AMOUNT_RAWNUMBERPREMIUM_AMOUNT_RAW column
PREMIUM_AMOUNTFLOATThe flash loan fee, changeable via the normal governance process, decimal adjusted.
PREMIUM_AMOUNT_USDFLOATThe flash loan fee, valued in USD.
EZ_LENDING_FLASHLOANS_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.