Deposits - Allium Documentation Hub

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

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

Calculate daily deposit volume by protocol:

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

⌘I