Withdrawals - Token Terminal Docs

One row per withdrawal from a lending market, including the sending side of a receipt-token transfer. amount is the tokens taken out, and summing it per user_address replays a position.

Columns

Column	Type	Description
`block_timestamp`	TIMESTAMP	Time of the block containing the withdrawal. Partition column.
`block_number`	INT64	Number of the block containing the withdrawal.
`transaction_hash`	STRING	Hash of the transaction that emitted the withdrawal event.
`log_index`	INT64	Position of the withdrawal event in the block.
`unique_id`	INT64	Row key: fingerprint of chain_id, block_number, transaction_hash, log_index.
`event_type`	STRING	Constant ‘withdrawals’; 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 withdrawal happened on.
`lending_market_id`	STRING	Market the withdrawal 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	Receipt token whose balance moved (the aToken for Aave); null where positions are not tokenised.
`token_id`	STRING	Token withdrawn: {token_address}-{chain_id}.
`token_address`	STRING	Contract address of the token withdrawn.
`token_symbol`	STRING	Symbol of the token withdrawn.
`token_decimals`	INT64	Decimals of the token withdrawn.
`withdrawer_address`	STRING	Where the value went: the receiver of the withdrawal, or the recipient on a receipt-token transfer.
`user_address`	STRING	Account whose supplied balance fell; the position key across the lending facts.
`shares_raw`	BIGNUMERIC	Movement in the protocol’s interest-bearing unit, exact integer; summing per position replays the 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 withdrawals per app

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

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