Metrics Daily - Allium Documentation Hub

The lending.metrics_daily table contains daily aggregated metrics for lending platforms, grouped by project and protocol. This table provides a high-level overview of lending activity across protocols, including outstanding loans, available liquidity, and total supplied amounts in USD.

Sample Query

Finding the daily metrics for Aave across all protocol versions on Ethereum:

select 
    date,
    project,
    protocol,
    outstanding_loans_usd,
    available_liquidity_usd,
    supplied_amount_usd
from ethereum.lending.metrics_daily
where project = 'aave'
order by date desc

Finding the total outstanding loans across all lending protocols on a specific date:

select 
    date,
    sum(outstanding_loans_usd) as total_outstanding_loans_usd,
    sum(available_liquidity_usd) as total_available_liquidity_usd,
    sum(supplied_amount_usd) as total_supplied_usd
from ethereum.lending.metrics_daily
where date = '2026-01-13'
group by date

Table Columns

Unique Key: unique_id

Column	Data Type	Description
date	DATE	Date of the metrics snapshot
project	VARCHAR	Name of the lending project (e.g., aave, compound, morpho_blue)
protocol	VARCHAR	Underlying protocol version (e.g., aave_v1, compound_v2)
outstanding_loans_usd	FLOAT	Total value of outstanding loans in USD
available_liquidity_usd	FLOAT	Total available liquidity in USD
supplied_amount_usd	FLOAT	Total supplied amount in USD (outstanding loans + available liquidity)
usd_balance	FLOAT	USD balance of the protocol
unique_id	VARCHAR	Unique identifier for the record (date + project + protocol)
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the record was created
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the record was last updated

​Sample Query

​Table Columns

Sample Query

Table Columns