Skip to main content
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
ColumnData TypeDescription
dateDATEDate of the metrics snapshot
projectVARCHARName of the lending project (e.g., aave, compound, morpho_blue)
protocolVARCHARUnderlying protocol version (e.g., aave_v1, compound_v2)
outstanding_loans_usdFLOATTotal value of outstanding loans in USD
available_liquidity_usdFLOATTotal available liquidity in USD
supplied_amount_usdFLOATTotal supplied amount in USD (outstanding loans + available liquidity)
usd_balanceFLOATUSD balance of the protocol
unique_idVARCHARUnique identifier for the record (date + project + protocol)
_created_atTIMESTAMP_NTZ(9)Timestamp of when the record was created
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the record was last updated