Loans - Allium Documentation Hub

The 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:

select
  project,
  protocol,
  symbol,
  amount,
  usd_amount,
  from_address,
  block_timestamp
from solana.lending.loans
where block_timestamp >= current_timestamp - interval '7 days'
order by block_timestamp desc
limit 100

Calculate daily loan volume by protocol:

select
  date(block_timestamp) as day,
  project,
  protocol,
  count(*) as loan_count,
  sum(usd_amount) as total_volume_usd
from solana.lending.loans
where block_timestamp >= current_timestamp - interval '30 days'
group by day, project, protocol
order by day desc, total_volume_usd desc

​Table Columns

​Sample Query

Table Columns

Sample Query