Borrows - Token Terminal Docs

One row per borrow from a lending market. amount is the tokens drawn, and Interest rates has the rate that applied.

Columns

Column	Type	Description
`block_timestamp`	TIMESTAMP	Time of the block containing the borrow. Partition column.
`block_number`	INT64	Number of the block containing the borrow.
`transaction_hash`	STRING	Hash of the transaction that emitted the borrow event.
`log_index`	INT64	Position of the borrow event in the block.
`unique_id`	INT64	Row key: fingerprint of chain_id, block_number, transaction_hash, log_index.
`event_type`	STRING	Constant ‘borrows’; stacking key across the lending facts.
`project_id`	STRING	Protocol operating the market, such as aave.
`app_id`	STRING	Deployment of the protocol the market belongs to.
`chain_id`	STRING	Chain the borrow happened on.
`lending_market_id`	STRING	Market the borrow left; joins `dimensions.lending_markets`.
`lending_market_reserve_id`	STRING	Reserve within the market; joins `dimensions.lending_market_reserves`.
`lending_market_contract_address`	STRING	Contract the market lives on; not a key.
`receipt_token_address`	STRING	Debt token whose balance moved (the variable debt token for Aave); null where debt is not tokenised.
`token_id`	STRING	Token borrowed: {token_address}-{chain_id}.
`token_address`	STRING	Contract address of the token borrowed.
`token_symbol`	STRING	Symbol of the token borrowed.
`token_decimals`	INT64	Decimals of the token borrowed.
`borrower_address`	STRING	Account the borrowed tokens went to (the delegatee under credit delegation).
`user_address`	STRING	Account whose debt rose; the position key across the lending facts.
`shares_raw`	BIGNUMERIC	Movement in the protocol’s debt unit, exact integer; summing per position replays the borrow-share balance.
`shares`	BIGNUMERIC	shares_raw decimal-corrected.
`amount_raw`	BIGNUMERIC	Event-time amount in the token’s stored unit, exact integer.
`amount`	BIGNUMERIC	amount_raw decimal-corrected into whole tokens. */}

Sample queries

This table is large and split by day. Bound block_timestamp and filter chain_id on every query, or you read the whole table and the whole table is billed to you.

One day, one app
Daily borrows per app

amount is whole tokens and amount_raw the integer the contract emitted. user_address is whose debt rose.

select
    events.block_timestamp,
    events.token_symbol,
    events.amount,
    events.user_address
from `facts_lending_markets.borrows` as events
where events.block_timestamp >= timestamp('2026-09-01')
  and events.block_timestamp < timestamp('2026-09-02')
  and events.chain_id = 'ethereum'
  and events.app_id = 'aave-v3'
limit 100

Group by token_symbol as well as app: amount is in each token’s own units, so one sum per token is the comparable figure.

select
    date(events.block_timestamp) as day,
    events.app_id,
    events.token_symbol,
    sum(events.amount) as borrowed
from `facts_lending_markets.borrows` as events
where events.block_timestamp >= timestamp('2026-08-01')
  and events.block_timestamp < timestamp('2026-09-01')
  and events.chain_id = 'ethereum'
group by day, events.app_id, events.token_symbol
order by day, borrowed desc