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 Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | BLOCKCHAIN column |
| PLATFORM | TEXT | The specific protocol where lending event occurred. |
| PROTOCOL | TEXT | PROTOCOL column |
| VERSION | TEXT | VERSION column |
| BLOCK_NUMBER | NUMBER | The block number at which the transaction is finalized. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The block timestamp of this transaction in UTC |
| TX_HASH | TEXT | Transaction hash is a unique 66-character identifier that is generated when a transaction is executed. |
| CONTRACT_ADDRESS | TEXT | The address interacted with for a given event. |
| PROTOCOL_MARKET | TEXT | The protocol’s specific lending asset token, ie cWBTC or aETHUni. |
| INITIATOR | TEXT | The address that initiated the flash loan. |
| TARGET | TEXT | The address receiving the flash loan. |
| FLASHLOAN_TOKEN | TEXT | The flashloaned token address. |
| FLASHLOAN_TOKEN_SYMBOL | TEXT | The symbol of the token associated with the lending action. |
| FLASHLOAN_AMOUNT_RAW | NUMBER | FLASHLOAN_AMOUNT_RAW column |
| FLASHLOAN_AMOUNT | FLOAT | The amount of assets flash loaned. |
| FLASHLOAN_AMOUNT_USD | FLOAT | The value of the flash loan amount, in USD. |
| PREMIUM_AMOUNT_RAW | NUMBER | PREMIUM_AMOUNT_RAW column |
| PREMIUM_AMOUNT | FLOAT | The flash loan fee, changeable via the normal governance process, decimal adjusted. |
| PREMIUM_AMOUNT_USD | FLOAT | The flash loan fee, valued in USD. |
| EZ_LENDING_FLASHLOANS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |