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

# Flash Loan Prints

> Flash loan borrow and repay events across Uniswap-style and Balancer Vault sources.

## Overview

* **Dataset ID:** `0305`
* **Table:** `blockdb_evm.b0305_flash_loan_prints_v1`
* **Description:** One row per borrowed token per on-chain flash loan event (V2-style flash swap, V3 Flash event, Balancer V2 Vault, etc.). `pool_uid` is NULL for vault-level events not tied to a single pool.
* **Primary key:** `(block_number, tx_index, log_index, token)`
* **API:** [POST /evm/flash-loans/prints](/api-reference/evm/flash-loans/flash-loan-prints)
* **CSV Sample:** [Download](https://huggingface.co/datasets/BlockDB/Flash-Loan-Prints-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0305_flash_loan_prints_v1.csv?download=true)
* **JSON Sample:** [Download](https://huggingface.co/datasets/BlockDB/Flash-Loan-Prints-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0305_flash_loan_prints_v1.json?download=true)

## Sample Viewer

<Frame>
  <iframe src="https://huggingface.co/datasets/BlockDB/Flash-Loan-Prints-Ethereum-And-EVM-Cryptocurrency-Data/embed/viewer/default/train" frameborder="0" width="100%" height="600px" />
</Frame>

## Columns

| Column                | Type            | Description                                                |
| --------------------- | --------------- | ---------------------------------------------------------- |
| `pool_uid`            | `BYTEA`         | 32B pool id when pool-scoped; NULL for vault-level events. |
| `exchange_id`         | `INTEGER`       | Exchange id when `pool_uid` set; NULL otherwise.           |
| `type_id`             | `INTEGER`       | Pool type id when `pool_uid` set; NULL otherwise.          |
| `block_number`        | `BIGINT`        | Block of the event.                                        |
| `block_time`          | `TIMESTAMPTZ`   | Block time.                                                |
| `tx_index`            | `INTEGER`       | Transaction index.                                         |
| `log_index`           | `INTEGER`       | Log index.                                                 |
| `flash_loan_source`   | `BYTEA`         | 20B emitter (pool or vault contract).                      |
| `token`               | `BYTEA`         | 20B borrowed token for this row.                           |
| `amount_borrowed`     | `NUMERIC(78,0)` | Raw borrowed amount.                                       |
| `amount_repaid`       | `NUMERIC(78,0)` | Raw repaid amount (includes fee).                          |
| `fee_amount`          | `NUMERIC(78,0)` | `amount_repaid - amount_borrowed` (raw).                   |
| `_tracing_id`         | `BYTEA`         | Unique tracing ID.                                         |
| `_parent_tracing_ids` | `BYTEA[]`       | Parent tracing IDs.                                        |
| `_created_at`         | `TIMESTAMPTZ`   | Record creation timestamp.                                 |
| `_updated_at`         | `TIMESTAMPTZ`   | Record update timestamp.                                   |

## Related datasets

<Card title="Swap fees" icon="coins" href="/data-catalog/evm/swaps/liquidity-pools-swap-fees">
  Fee accounting on directional swaps.
</Card>