crosschain.defi Table: ez_lending_deposits Type: View
What
A comprehensive table that contains all blockchain and platform specific deposits. This table contains deposit eventss across Arbitrum, Avalanche, Base, BSC, Gnosis, Ethereum, Optimism, Polygon, Solana and Aptos. 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 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. |
| DEPOSITOR | TEXT | Address that initiated a deposit event. |
| TOKEN_ADDRESS | TEXT | The address of the token associated with the lending action. |
| TOKEN_SYMBOL | TEXT | The symbol of the token associated with the lending action. |
| AMOUNT_RAW | NUMBER | AMOUNT_RAW column |
| AMOUNT | FLOAT | The decimal adjusted amount of tokens involved in the lending transaction, where available. |
| AMOUNT_USD | FLOAT | The value of the tokens in USD at the time of the lending transaction, where available. |
| EZ_LENDING_DEPOSITS_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. |