blast.defi Table: ez_lending_withdraws Type: View
This table contains transactions in which a user withdraws liquidity across the ORBIT, JUICE AND
INIT protocols. Users need to make sure there is enough liquidity (not borrowed) in order to
withdraw, if this is not the case, users need to wait for more liquidity from depositors or
borrowers repaying.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_NUMBER | NUMBER | Also known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block was produced. |
| TX_HASH | TEXT | Transaction 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_ADDRESS | TEXT | The address interacted with for a given event. |
| EVENT_NAME | TEXT | The decoded event name for a given event. |
| EVENT_INDEX | NUMBER | Event number within a transaction. |
| ORIGIN_FUNCTION_SIGNATURE | TEXT | The function signature of this transaction. |
| ORIGIN_FROM_ADDRESS | TEXT | The from address of this transaction. |
| ORIGIN_TO_ADDRESS | TEXT | The to address of this transaction. |
| PLATFORM | TEXT | The specific protocol where lending event occurred. |
| DEPOSITOR | TEXT | Its the address of the user who is Borrowing or repaying the loan, depending on the action. |
| PROTOCOL_MARKET | TEXT | The protocol’s specific lending asset token, ie cWBTC or aETHUni. |
| 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_UNADJ | FLOAT | The non-decimal adjusted amount of tokens involved in the lending transaction. |
| 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_WITHDRAWS_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. |