Metrics - Token Terminal Docs

metrics.lending_markets_daily holds one row per lending market per day: total value locked, active loans and collateral. Figures are in USD. lending_market_id joins Registry.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Day of the row. The partition column.
`lending_market_id`	`STRING`	Market the row describes. Joins `dimensions.lending_markets`.
`tvl`	`BIGNUMERIC`	Total value supplied to the market, USD: idle plus borrowed.
`active_loans`	`BIGNUMERIC`	USD value of open loans (outstanding borrows) on the market.
`collateral`	`BIGNUMERIC`	USD value of the market’s tokens posted as collateral, backing open loans.

Sample queries

One market's series
Markets by TVL

Read one market’s daily TVL, active loans and collateral.

select
    metrics.timestamp,
    dims.underlying_symbol,
    dims.chain_id,
    metrics.tvl,
    metrics.active_loans,
    metrics.collateral
from `metrics.lending_markets_daily` as metrics
join `dimensions.lending_markets` as dims
    using (lending_market_id)
where dims.underlying_symbol = 'USDC'
  and dims.chain_id = 'ethereum'
  and metrics.timestamp >= timestamp('2026-06-01')
order by metrics.timestamp

Rank markets by TVL on one day.

select
    dims.underlying_symbol,
    dims.chain_id,
    dims.lending_pool_name,
    metrics.tvl
from `metrics.lending_markets_daily` as metrics
join `dimensions.lending_markets` as dims
    using (lending_market_id)
where metrics.timestamp = timestamp('2026-08-01')
order by metrics.tvl desc
limit 25

⌘I