solana.lending.withdrawals table contains Solana lending withdrawal events. This table tracks all withdrawal activities across supported lending protocols on Solana.
Use this table to analyze withdrawal patterns, track capital outflows, and understand liquidity dynamics in lending protocols.
Table Columns
Unique Key:unique_id
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR | Name of the lending project. |
| protocol | VARCHAR | Underlying protocol that the lending protocol is utilizing. |
| action | VARCHAR | Type of lending action. |
| lending_id | VARCHAR | Address of the lending market or bank. |
| lending_reserve_id | VARCHAR | Address of the specific lending reserve. |
| from_address | VARCHAR | Address of the token account from which tokens were transferred. |
| token_acc_from | VARCHAR | Token account address from which tokens were transferred. |
| to_address | VARCHAR | Address of the token account to which tokens were transferred. |
| token_acc_to | VARCHAR | Token account address to which tokens were transferred. |
| mint | VARCHAR | Address of the token being withdrawn. |
| name | VARCHAR | Name of the token being withdrawn. |
| symbol | VARCHAR | Symbol of the token being withdrawn. |
| decimals | NUMBER | Number of decimals of the token being withdrawn. |
| raw_amount | VARCHAR | Raw amount of tokens withdrawn. |
| amount | FLOAT | Normalized amount of tokens withdrawn. |
| usd_amount | FLOAT | USD value of the tokens withdrawn at the time of the transaction. |
| signer | VARCHAR | Address of the account that signed the transaction. |
| block_slot | NUMBER | Solana block slot number. |
| block_height | NUMBER | Block height of the transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block. |
| block_hash | VARCHAR | Hash of the block. |
| txn_id | VARCHAR | Transaction ID. |
| txn_index | NUMBER | Index of the transaction in the block. |
| instruction_index | NUMBER | Index of the instruction in the transaction. |
| inner_instruction_index | NUMBER | Index of the inner instruction. |
| pseudo_instruction_order | NUMBER | Order of the instruction for sorting purposes. |
| liquidity_vault | VARCHAR | Address of the liquidity vault for the lending market. |
| unique_id | VARCHAR | Unique identifier for the event. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the event was created. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the event was last updated. |
Sample Query
- Recent Withdrawals
- Daily Withdrawal Volume
Get recent withdrawal events with essential details: