Skip to main content
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
ColumnData TypeDescription
dateDATEDate of the market snapshot
projectVARCHARName of the lending project (e.g., aave, compound, morpho_blue)
protocolVARCHARUnderlying protocol version (e.g., aave_v2, compound_v2, euler_v2)
idVARCHARUnique identifier for the market
contract_addressVARCHARAddress of the lending market contract
token_addressVARCHARAddress of the token in the market
token_nameVARCHARName of the token
token_symbolVARCHARSymbol of the token
token_decimalsINTEGERNumber of decimals for the token
usd_exchange_rateFLOATUSD exchange rate of the token at the time of the snapshot
outstanding_loansFLOATTotal outstanding loans in token units
outstanding_loans_usdFLOATTotal outstanding loans in USD
available_liquidityFLOATAvailable liquidity in token units
available_liquidity_usdFLOATAvailable liquidity in USD
supplied_amountFLOATTotal supplied amount in token units
supplied_amount_usdFLOATTotal supplied amount in USD
transaction_hashVARCHARHash of the last transaction affecting this market
transaction_indexINTEGERIndex of the last transaction in the block
last_activity_block_timestampTIMESTAMP_NTZ(9)Timestamp of the last activity block
last_activity_block_numberINTEGERBlock number of the last activity
last_activity_block_hashVARCHARHash of the last activity block
_created_atTIMESTAMP_NTZ(9)Timestamp of when the record was created
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the record was last updated