TVL Daily - Allium Documentation Hub

The solana.lending.tvl_daily table contains the daily total value locked (TVL) for each Solana lending market by token, covering Kamino, MarginFi, Jupiter Lend, and Save. For a given lending project there may be multiple markets/reserves (market_id), each holding balances that contribute to the project’s total TVL.

Table Details

Property	Value
Table Name	`solana.lending.tvl_daily`
Table Status	Production-Ready
Unique Key	`date`, `market_id`, `mint`
Clustering Key(s)	`date, project`
Search Optimization	`market_id`, `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`, `marginfi`, `jupiter`, `save`).
protocol	VARCHAR(16777216)	Specific version or variant of the protocol (e.g. `klend`, `marginfi`, `juplend`, `save`).
market_id	VARCHAR(16777216)	Internal Allium identifier for the market whose vault balance is captured by this row.
mint	VARCHAR(16777216)	Base58-encoded mint address of the token locked in the market’s 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)	Token balance in the smallest unit, as a string, to retain precision.
raw_balance	FLOAT	Token balance in the token’s smallest unit (not decimal-adjusted).
balance_str	VARCHAR(16777216)	Normalized token balance, as a string, to retain precision.
balance	FLOAT	Token balance normalized by the token’s decimal precision.
usd_exchange_rate	FLOAT	USD price per unit of the token at the time of the snapshot.
usd_balance	FLOAT	USD value of the token balance 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

Daily TVL by Project
TVL by Token Across Protocols

Get daily TVL for MarginFi, grouped by date:

select date, project, sum(usd_balance) as usd_tvl
from solana.lending.tvl_daily
where project = 'marginfi'
group by all
order by date desc

Find total TVL of a specific token across all lending protocols:

select
  date,
  project,
  protocol,
  symbol,
  sum(usd_balance) as usd_tvl
from solana.lending.tvl_daily
where mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC
group by all
order by date desc