Withdrawals - Allium Documentation Hub

The solana.lending.withdrawals table contains Solana lending withdrawal events. This table tracks all withdrawal activities across supported lending protocols on Solana. Use this table to analyze withdrawal patterns, track capital outflows, and understand liquidity dynamics in 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 withdrawn.
name	VARCHAR	Name of the token being withdrawn.
symbol	VARCHAR	Symbol of the token being withdrawn.
decimals	NUMBER	Number of decimals of the token being withdrawn.
raw_amount	VARCHAR	Raw amount of tokens withdrawn.
amount	FLOAT	Normalized amount of tokens withdrawn.
usd_amount	FLOAT	USD value of the tokens withdrawn 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 Withdrawals
Daily Withdrawal Volume

Get recent withdrawal events with essential details:

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

Calculate daily withdrawal volume by protocol:

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

⌘I