> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# lending.flashloans

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

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

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

<TableSample tableSchema="lending" tableName="flashloans" />

## Query performance

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