Repayments - Token Terminal Docs

One row per repayment, including the debt leg of a liquidation. amount is the tokens returned, and Liquidations shows that same leg from the collateral side.

Columns

Column	Type	Description
`block_timestamp`	TIMESTAMP	Time of the block containing the repayment. Partition column.
`block_number`	INT64	Number of the block containing the repayment.
`transaction_hash`	STRING	Hash of the transaction that emitted the repayment event.
`log_index`	INT64	Position of the repayment event in the block.
`unique_id`	INT64	Row key: fingerprint of chain_id, block_number, transaction_hash, log_index.
`event_type`	STRING	Constant ‘repayments’; 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 repayment happened on.
`lending_market_id`	STRING	Market the repayment entered; 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 repaid: {token_address}-{chain_id}.
`token_address`	STRING	Contract address of the token repaid.
`token_symbol`	STRING	Symbol of the token repaid.
`token_decimals`	INT64	Decimals of the token repaid.
`repayer_address`	STRING	Account that paid (the liquidator on a liquidation).
`user_address`	STRING	Account whose debt fell; 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 repayments per app

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

select
    events.block_timestamp,
    events.token_symbol,
    events.amount,
    events.user_address
from `facts_lending_markets.repayments` 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 repaid
from `facts_lending_markets.repayments` 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, repaid desc