solana.lending.repayments table contains Solana lending repayment events. This table tracks all loan repayment activities across supported lending protocols on Solana.
Use this table to analyze repayment patterns, track loan closure rates, and understand the health of the lending ecosystem.
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 repaid. |
| name | VARCHAR | Name of the token being repaid. |
| symbol | VARCHAR | Symbol of the token being repaid. |
| decimals | NUMBER | Number of decimals of the token being repaid. |
| raw_amount | VARCHAR | Raw amount of tokens repaid. |
| amount | FLOAT | Normalized amount of tokens repaid. |
| usd_amount | FLOAT | USD value of the tokens repaid 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 Repayments
- Daily Repayment Volume
Get recent repayment events with essential details: