Position Holdings Daily

The solana.lending.position_holdings_daily table contains daily per-user (per-address) holdings in Solana lending vault products, currently covering Kamino’s kvault (managed vault) product. Each row represents one user’s proportional share of a vault’s underlying reserve balances on a given day, along with metadata about the receipt tokens backing that position.

Table Details

Property	Value
Table Name	`solana.lending.position_holdings_daily`
Table Status	Production-Ready
Unique Key	`date`, `lending_id`, `address`, `mint`
Clustering Key(s)	`date, project`
Search Optimization	`lending_id`, `address`, `mint`

Table Columns

Column Name	Data Type	Description
date	TIMESTAMP_NTZ(9)	Calendar date (UTC) this record represents.
project	VARCHAR(16777216)	Business name of the protocol being used (e.g. `kamino`).
protocol	VARCHAR(16777216)	Specific version or variant of the protocol (e.g. `kvault`).
lending_id	VARCHAR(16777216)	Internal Allium identifier for the vault this position belongs to.
address	VARCHAR(16777216)	Wallet address of the vault depositor holding this position.
mint	VARCHAR(16777216)	Base58-encoded mint address of the underlying token this position is denominated in.
raw_balance_str	VARCHAR(16777216)	Position balance in the smallest unit, as a string, to retain precision.
raw_balance	FLOAT	Position balance in the token’s smallest unit (not decimal-adjusted).
balance	FLOAT	Position balance normalized by the token’s decimal precision.
balance_str	VARCHAR(16777216)	Normalized position balance, as a string, to retain precision.
usd_balance	FLOAT	USD value of the position balance at the time of the snapshot.
usd_exchange_rate	FLOAT	USD price per unit of the underlying token at the time of the snapshot.
token_name	VARCHAR(16777216)	Full name of the underlying token.
symbol	VARCHAR(16777216)	Ticker symbol of the underlying token.
decimals	NUMBER(38,0)	Number of decimal places used to represent the underlying token’s smallest unit.
_extras	VARIANT	JSON object containing additional protocol-specific metadata, including the receipt (c-token) accounts backing this position (mint, symbol, decimals, and raw/normalized amounts per reserve).
last_activity_block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block that last changed this balance.
last_activity_block_slot	NUMBER(38,0)	Solana slot number of the block containing the most recent activity for this position.
last_activity_block_hash	VARCHAR(16777216)	Hash of the block that last changed this balance.
last_activity_txn_index	NUMBER(38,0)	Index of the transaction within its block for the most recent balance-changing activity.
last_activity_txn_id	VARCHAR(16777216)	Transaction ID (signature) of the most recent activity that changed this balance.
last_activity_pseudo_global_order	NUMBER(38,0)	Pseudo-global ordering key of the most recent activity, used to sort events across all transactions.
unique_id	VARCHAR(16777216)	Allium’s deterministic unique identifier for this row.
_created_at	TIMESTAMP_NTZ(9)	Timestamp (UTC) when this row was first written to the Allium platform.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp (UTC) of the most recent update to this row.

Sample Query

A User's Positions
Top Holders of a Vault

Get the latest holdings for a specific depositor across all Kamino vaults:

select date, lending_id, symbol, balance, usd_balance
from solana.lending.position_holdings_daily
where address = 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA' -- depositor wallet
order by date desc

Find the largest positions in a specific vault on a given date:

select date, address, symbol, balance, usd_balance
from solana.lending.position_holdings_daily
where lending_id = 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB' -- vault lending_id
  and date = '2026-08-01'
order by usd_balance desc
limit 20

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Table Columns

Sample Query

​Table Details

​Table Columns

​Sample Query

Table Details

Table Columns

Sample Query