Yields

A yield is a rate, written as a fraction: 0.05 is five percent. Asset yields are the apy column on metrics.assets_daily and metrics.asset_tokens_daily, one figure per asset per day. Lending rates are the deposit_rate and borrow_rate pair on facts.lending_market_interest_rates, one pair per market per rate change. Every column is documented at Assets ▸ Metrics and Lending ▸ Interest rates. Rates never add up, across assets, markets or days. Average an asset yield with a supply weight, or read it one asset at a time.

Sample queries

The asset tables carry one row per asset per day. Bound timestamp in every query, and read the asset table rather than the deployment table when the question is about the asset.

Highest asset yields
One asset over time
Supply-weighted average
Lending rates

Rank tokenized assets by the yield they pay. market_cap_circulating_total gives the weight to read the rate against.

select
    assets.name,
    assets.asset_type,
    daily.apy,
    daily.market_cap_circulating_total
from `metrics.assets_daily` as daily
join `dimensions.assets` as assets
    using (asset_id)
where daily.timestamp = timestamp('2026-08-20')
  and daily.apy is not null
order by daily.apy desc
limit 25

Read one asset’s yield against its supply. Both figures sit on the same asset row.

select
    timestamp,
    apy,
    market_cap_circulating_total
from `metrics.assets_daily`
where asset_id = 'buidl'
  and timestamp >= timestamp('2026-06-01')
order by timestamp

Average the yield across a class of assets, weighted by supply. An unweighted average of rates has no meaning.

select
    daily.timestamp,
    sum(daily.apy * daily.market_cap_circulating_total)
        / sum(daily.market_cap_circulating_total) as weighted_apy
from `metrics.assets_daily` as daily
join `dimensions.assets` as assets
    using (asset_id)
where assets.asset_type = 'rwa'
  and daily.timestamp >= timestamp('2026-07-01')
  and daily.apy is not null
  and daily.market_cap_circulating_total > 0
group by daily.timestamp
order by daily.timestamp

In progress. facts.lending_market_interest_rates is not served yet. The query below reads the rate pair per market once it lands.

select
    rates.block_timestamp,
    markets.project_id,
    markets.underlying_symbol,
    rates.deposit_rate,
    rates.borrow_rate
from `facts.lending_market_interest_rates` as rates
join `dimensions.lending_markets` as markets
    using (lending_market_id)
where markets.project_id = 'aave'
  and markets.chain_id = 'ethereum'
  and rates.block_timestamp >= timestamp('2026-08-01')
  and rates.block_timestamp < timestamp('2026-08-08')
order by rates.block_timestamp

Overview

Core entities

Core datasets

Market verticals

Chain verticals

Sample queries

​Sample queries

Sample queries