lending.flashloans

Flash loan executions across DeFi protocols — borrowed amounts, fees, and initiator details.

The lending.flashloans table contains all flash loan transactions across DeFi lending protocols.

Table Schema

Column	Type	Description
blockchain	VARCHAR	Blockchain name
project	VARCHAR	Lending protocol name
version	VARCHAR	Protocol contract version
token_address	VARBINARY	Token contract address
symbol	VARCHAR	Token symbol
recipient	VARBINARY	Flashloan recipient address
amount	DOUBLE	Token amount in display units
amount_raw	UINT256	Raw token amount
amount_usd	DOUBLE	Token amount in USD
fee	DOUBLE	Flashloan fee amount
project_contract_address	VARBINARY	Protocol contract address
block_month	TIMESTAMP	Block month (partition key)
block_time	TIMESTAMP	Block timestamp in UTC
block_number	BIGINT	Block number
tx_hash	VARBINARY	Transaction hash
evt_index	INTEGER	Event index

Table sample

Query performance

Partition keys: blockchain, project. Always include blockchain in your filter.