Flash loans - Token Terminal Docs

In progress. This table is not served yet. The page documents it as it lands.

facts.lending_market_flash_loans combines the flash-loan events of every lending protocol we decode into one table: one row per flash loan. A flash loan borrows tokens and repays them with a fee inside one transaction. lending_market_id keys each row to its market in the Registry.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Time of the block containing the flash loan. Partition column.
`block_number`	`INT64`	Number of the block containing the flash loan.
`transaction_hash`	`STRING`	Hash of the transaction that emitted the flash-loan event.
`log_index`	`INT64`	Position of the flash-loan event in the block.
`unique_id`	`INT64`	Row key: fingerprint of `chain_id`, `block_number`, `transaction_hash`, `log_index`.
`chain_id`	`STRING`	Chain the flash loan happened on.
`lending_market_id`	`STRING`	Market the loan drew from; joins `dimensions.lending_markets`.
`project_id`	`STRING`	Protocol operating the market, such as `aave`.
`token_id`	`STRING`	Token borrowed: `{token_address}-{chain_id}`.
`token_address`	`STRING`	Contract address of the token borrowed.
`initiator_address`	`STRING`	Account that started the flash loan.
`target_address`	`STRING`	Contract that received the loan.
`amount_raw`	`STRING`	Raw amount as text; a `uint256` exceeds every BigQuery number type.
`premium_raw`	`STRING`	Fee paid for the loan as text, in the borrowed token; null where the protocol charges none.

Sample queries

The table is partitioned on block_timestamp. Bound that column in every query; without a bound the query reads the whole table.

One token, one day
Daily USD volume

Read one token’s flash loans on a single day. Cast amount_raw to BIGNUMERIC and divide by 10^decimals from dimensions.tokens to get the token amount.

select
    flash_loans.block_timestamp,
    flash_loans.transaction_hash,
    flash_loans.initiator_address,
    cast(flash_loans.amount_raw as bignumeric) / pow(10, tokens.decimals) as amount
from `facts.lending_market_flash_loans` as flash_loans
join `dimensions.tokens` as tokens
    using (token_id)
where flash_loans.token_id = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2-ethereum'
  and flash_loans.block_timestamp >= timestamp('2026-08-01')
  and flash_loans.block_timestamp < timestamp('2026-08-02')
limit 100

Sum daily flash-loan volume in USD per protocol. The table carries token amounts; USD comes from Prices.

select
    timestamp_trunc(flash_loans.block_timestamp, day) as day,
    flash_loans.project_id,
    round(sum(cast(flash_loans.amount_raw as bignumeric) / pow(10, tokens.decimals) * prices.price)) as borrowed_usd
from `facts.lending_market_flash_loans` as flash_loans
join `dimensions.tokens` as tokens
    using (token_id)
join `metrics.tokens_prices_daily` as prices
    on prices.token_id = flash_loans.token_id
    and prices.timestamp = timestamp_trunc(flash_loans.block_timestamp, day)
where flash_loans.block_timestamp >= timestamp('2026-08-01')
  and flash_loans.block_timestamp < timestamp('2026-08-08')
group by day, flash_loans.project_id
order by day, borrowed_usd desc

⌘I