lending.flashloans

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

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