Markets Daily

The solana.lending.markets_daily table contains daily, forward-filled snapshots of individual lending markets (one row per market/reserve per day), currently covering Kamino and Jupiter Lend in full, and Save partially. MarginFi is not covered at all — its share-based accounting can’t be reliably reconstructed into a market-state snapshot. This table captures outstanding loans, available liquidity, and supplied amounts at the market level, both in token units and USD.

Table Details

Property	Value
Table Name	`solana.lending.markets_daily`
Table Status	Production-Ready
Unique Key	`date`, `id`
Clustering Key(s)	`date, project`

Save’s rows come from periodic RPC reads of on-chain Reserve accounts rather than event-reconstructed state, so coverage is partial: no history before 2026-06-23, and known gaps remain (long-tail mints missing prices, protocol fees not netted out). Treat Save’s markets_daily figures as directionally useful rather than exact. See the overview page for how this table’s supplied_amount_usd differs from tvl_daily.usd_balance.

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`, `jupiter`, `save`).
protocol	VARCHAR(16777216)	Specific version or variant of the protocol (e.g. `klend`, `juplend`, `save`).
id	VARCHAR(16777216)	Reserve account address (unique identifier for this lending market / reserve pair).
program_id	VARCHAR(16777216)	Program-owned market PDA (reserve / bank / vault), not the Solana program ID.
mint	VARCHAR(16777216)	Base58-encoded mint address of the token in the market.
token_name	VARCHAR(16777216)	Full name of the token.
token_symbol	VARCHAR(16777216)	Ticker symbol of the token.
token_decimals	NUMBER(38,0)	Number of decimal places used to represent the token’s smallest unit.
usd_exchange_rate	FLOAT	USD price per unit of the token at the time of the snapshot.
outstanding_loans	FLOAT	Total amount of tokens borrowed from the market, normalized by token decimals.
outstanding_loans_usd	FLOAT	Total USD value of loans currently outstanding in this lending market.
available_liquidity	FLOAT	Amount of tokens available for borrowing, normalized by token decimals.
available_liquidity_usd	FLOAT	Total USD value of assets available to borrow from this lending market.
supplied_amount	FLOAT	Total amount of tokens supplied to the market, normalized by token decimals.
supplied_amount_usd	FLOAT	Total USD value of assets currently supplied to this lending market.
last_activity_block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the last on-chain event that updated this reserve’s state on the snapshot date.
last_activity_block_hash	VARCHAR(16777216)	Cryptographic hash of the block header that contains the last activity record.
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

Market Snapshots
Top Markets by Supply

Get the latest snapshot for each Kamino market:

select
  date,
  project,
  protocol,
  token_symbol,
  supplied_amount_usd,
  outstanding_loans_usd,
  available_liquidity_usd
from solana.lending.markets_daily
where project = 'kamino'
order by date desc, supplied_amount_usd desc

Find the top 10 markets by supplied amount on a specific date:

select
  date,
  project,
  protocol,
  token_symbol,
  id,
  supplied_amount_usd
from solana.lending.markets_daily
where date = '2026-08-01'
order by supplied_amount_usd desc
limit 10

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