Markets Daily

The lending.markets_daily table contains daily snapshots of individual lending markets, providing granular data at the market and token level. This table captures detailed information about each lending market including outstanding loans, available liquidity, supplied amounts, and the latest activity metadata.

Sample Query

Finding the daily market data for Aave markets on Ethereum:

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

Finding the top 10 markets by supplied amount on a specific date:

select 
    date,
    project,
    protocol,
    token_symbol,
    contract_address,
    supplied_amount_usd
from ethereum.lending.markets_daily
where date = '2026-01-23'
order by supplied_amount_usd desc
limit 10

Table Columns

Unique Key: id

Column	Data Type	Description
date	DATE	Date of the market snapshot
project	VARCHAR	Name of the lending project (e.g., aave, compound, morpho_blue)
protocol	VARCHAR	Underlying protocol version (e.g., aave_v2, compound_v2, euler_v2)
id	VARCHAR	Unique identifier for the market
contract_address	VARCHAR	Address of the lending market contract
token_address	VARCHAR	Address of the token in the market
token_name	VARCHAR	Name of the token
token_symbol	VARCHAR	Symbol of the token
token_decimals	INTEGER	Number of decimals for the token
usd_exchange_rate	FLOAT	USD exchange rate of the token at the time of the snapshot
outstanding_loans	FLOAT	Total outstanding loans in token units
outstanding_loans_usd	FLOAT	Total outstanding loans in USD
available_liquidity	FLOAT	Available liquidity in token units
available_liquidity_usd	FLOAT	Available liquidity in USD
supplied_amount	FLOAT	Total supplied amount in token units
supplied_amount_usd	FLOAT	Total supplied amount in USD
transaction_hash	VARCHAR	Hash of the last transaction affecting this market
transaction_index	INTEGER	Index of the last transaction in the block
last_activity_block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the last activity block
last_activity_block_number	INTEGER	Block number of the last activity
last_activity_block_hash	VARCHAR	Hash of the last activity block
_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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Sample Query

Table Columns

​Sample Query

​Table Columns

Sample Query

Table Columns