solana.lending.loans table contains Solana lending loan events (borrows). This table tracks all borrowing activities across supported lending protocols on Solana.
Use this table to analyze borrowing patterns, track loan volumes, and understand lending activity across different protocols and tokens.
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 borrowed. |
| name | VARCHAR | Name of the token being borrowed. |
| symbol | VARCHAR | Symbol of the token being borrowed. |
| decimals | NUMBER | Number of decimals of the token being borrowed. |
| raw_amount | VARCHAR | Raw amount of tokens borrowed. |
| amount | FLOAT | Normalized amount of tokens borrowed. |
| usd_amount | FLOAT | USD value of the tokens borrowed 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 Loans
- Daily Loan Volume
Get recent loan events with essential details: