Lending Tvl Daily - Allium Documentation Hub

Table Details

Property	Value
Table Name	`solana.defi.lending_tvl_daily`
Table Status	Production-Ready
Unique Key	`date`, `project`, `protocol`, `lending_id`, `lending_reserve_id`, `mint`
Clustering Key(s)	`date`
Search Optimization	`project`, `lending_id`, `mint`

Key Metrics Explained

NET_DEPOSITS: The net flow of assets into the lending vault on a given date. Calculated as total deposits minus total withdrawals for that day.
UNPAID_LOANS: The net change in unpaid loans on a given date. Calculated as borrows minus repayments for that day.

Table Columns

Column Name	Data Type	Description
date	TIMESTAMP_NTZ(9)	End-of-day date (UTC) of the balance snapshot.
project	VARCHAR(8)	Business name of the protocol being used (e.g. `uniswap`, `aave`, `lido`, `paraswap`). Consistent across verticals — every table with a `project` column uses this field to identify the top-level protocol brand.
protocol	VARCHAR(8)	Specific version or variant of the protocol (e.g. `uniswap_v3`, `aave_v2`, `stargate_v2`). Qualifies the `project` field with version information.
lending_id	VARCHAR(16777216)	Internal Allium identifier for a lending position or market instance. Used to join lending event tables with position or market metadata.
lending_reserve_id	VARCHAR(16777216)	Internal Allium identifier for a specific lending reserve (a single asset’s supply/borrow pool within a market).
mint	VARCHAR(16777216)	Base58-encoded mint address of the SPL token. Analogous to `token_address` on EVM chains. Each mint uniquely identifies a fungible or non-fungible token on Solana.
raw_borrow	FLOAT	Raw (non-decimal-adjusted) borrowed amount.
raw_repay	FLOAT	Raw (non-decimal-adjusted) repaid amount.
raw_deposit	FLOAT	Raw (non-decimal-adjusted) deposited amount.
raw_withdraw	FLOAT	Raw (non-decimal-adjusted) withdrawal amount.
raw_tvl_gain_bankruptcy	FLOAT	Raw TVL change due to bankruptcy events (bad debt absorption or liquidation spread recovery).
raw_net_deposits	FLOAT	Raw (non-decimal-adjusted) net deposit amount.
raw_unpaid_loans	FLOAT	Raw outstanding unpaid loan principal.
raw_tvl	FLOAT	Total value locked in raw token units before price conversion.
borrow	FLOAT	Decimal-adjusted amount borrowed in this lending transaction.
repay	FLOAT	Decimal-adjusted amount repaid toward an outstanding loan.
deposit	FLOAT	The deposit amount required for stake key or pool registrations in lovelace.
withdraw	FLOAT	Decimal-adjusted amount withdrawn from a position or protocol.
tvl_gain_bankruptcy	FLOAT	Decimal-adjusted TVL gain from bankruptcy events such as bad debt recovery or liquidation spreads.
net_deposits	FLOAT	Decimal-adjusted net deposit amount after subtracting withdrawals from deposits.
unpaid_loans	FLOAT	Decimal-adjusted total outstanding loan principal not yet repaid.
tvl	FLOAT	Total value locked (USD) in this protocol or chain’s smart contracts at the snapshot timestamp.
usd_borrow	FLOAT	USD value of the borrowed amount at transaction time.
usd_repay	FLOAT	USD value of the repaid amount at transaction time.
usd_deposit	FLOAT	USD value of the deposited amount at transaction time.
usd_withdraw	FLOAT	USD value of the withdrawal amount at transaction time.
usd_tvl_gain_bankruptcy	FLOAT	USD value of TVL gain from bankruptcy or default recovery events.
usd_net_deposits	FLOAT	USD value of net deposits after subtracting withdrawals.
usd_unpaid_loans	FLOAT	USD value of outstanding unpaid loan principal.
usd_tvl	FLOAT	Total value locked in USD across all active positions in this protocol.
token_symbol	VARCHAR(16777216)	Ticker symbol of the token (e.g. “USDC”, “WETH”).