Vault Tvl Daily

The solana.lending.vault_tvl_daily table contains the daily total value locked (TVL) for Solana lending vault products, currently covering Kamino’s kvault (managed vault) product. Vault balances reflect net deposits into the vault (each vault’s proportional share of the underlying Kamino reserves it lends into) — not the liquidity available to borrow in the underlying markets.

Table Details

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

Table Columns

Column Name	Data Type	Description
date	TIMESTAMP_NTZ(9)	Calendar date (UTC) this record represents.
project	VARCHAR(6)	Business name of the protocol being used (e.g. `kamino`).
protocol	VARCHAR(6)	Specific version or variant of the protocol (e.g. `kvault`).
vault_id	VARCHAR(16777216)	Unique identifier (address) of the lending vault account.
mint	VARCHAR(16777216)	Base58-encoded mint address of the token held by the vault.
token_name	VARCHAR(16777216)	Full name of the token.
symbol	VARCHAR(16777216)	Ticker symbol of the token.
decimals	NUMBER(38,0)	Number of decimal places used to represent the token’s smallest unit.
raw_balance_str	VARCHAR(16777216)	Vault token balance in the smallest unit, as a string, to retain precision.
raw_balance	FLOAT	Vault token balance in the token’s smallest unit (not decimal-adjusted).
balance_str	FLOAT	Normalized vault token balance, as a string, to retain precision.
balance	FLOAT	Vault token balance normalized by the token’s decimal precision.
usd_balance	FLOAT	USD value of the vault’s token balance at the time of the snapshot.
usd_exchange_rate	FLOAT	USD price per unit of the token at the time of the snapshot.
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

Vault TVL Over Time
Total Vault TVL by Token

Get daily TVL for a specific Kamino vault:

select date, vault_id, symbol, usd_balance
from solana.lending.vault_tvl_daily
where vault_id = 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA' -- vault address
order by date desc

Sum TVL across all Kamino vaults, grouped by token:

select date, symbol, sum(usd_balance) as total_vault_tvl_usd
from solana.lending.vault_tvl_daily
where project = 'kamino'
group by all
order by date desc, total_vault_tvl_usd desc

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