solana.lending.deposits table contains Solana lending deposit events. This table tracks all deposit activities across supported lending protocols on Solana.
Use this table to analyze deposit patterns, track liquidity provision, and understand capital flows into 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 deposited. |
| name | VARCHAR | Name of the token being deposited. |
| symbol | VARCHAR | Symbol of the token being deposited. |
| decimals | NUMBER | Number of decimals of the token being deposited. |
| raw_amount | VARCHAR | Raw amount of tokens deposited. |
| amount | FLOAT | Normalized amount of tokens deposited. |
| usd_amount | FLOAT | USD value of the tokens deposited 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 Deposits
- Daily Deposit Volume
Get recent deposit events with essential details: