Skip to main content
POST

Overview

  • Dataset ID: 0305 - Flash Loan Prints
  • 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.
  • CSV Sample: Download
  • JSON Sample: Download

Parameters

number
required
Target EVM network. See the Chain enumeration.

Range filters (mutually exclusive)

number
Starting block number (inclusive). Use with to_block.
number
Ending block number (inclusive). Use with from_block.
string
Starting timestamp (ISO-8601). Use with to_timestamp.
string
Ending timestamp (ISO-8601). Use with from_timestamp.
Scoping rule: Provide exactly one of:
  1. Block range — from_block and to_block
  2. Time range — from_timestamp and to_timestamp
  3. Direct selectors — presented below
Direct selectors may be used on their own, without a block or time range. Do not combine scoping modes. Omitting all three returns HTTP 400.

Direct selectors

string[]
Filter to pool UIDs (32-byte hex, no 0x). Omitted or null pool_uid rows (vault-level) require other selectors if you need them.
string[]
Emitter contracts (20-byte hex, no 0x): pool or vault that emitted the event.
string[]
Borrowed token addresses (20-byte hex, no 0x).

Pagination

number
default:"250"
Recommended default 250; maximum 1000 to stay under ~10 MB responses.
string
Opaque pagination cursor from a previous response.

Decimals-Adjusted Amounts

boolean
default:"false"
Off by default. When set to true, the response includes data.amount_borrowed, data.amount_repaid, and data.fee_amount (decimals-adjusted, may be null) alongside the raw integer fields. Enabling it adds a per-request ERC-20 decimals lookup (extra join) that increases latency, so it is opt-in; when omitted or false, those fields are returned as null and only the always-present *_raw fields are populated.

Response fields

Meta

object
Echo of request metadata applied to the response.
number
EVM chain ID echoed from the request.
object
Pure echo of the window you sent (from_block/to_block/from_timestamp/to_timestamp); unset bounds are null.
object | null
The concrete window the query actually executed against, after resolving the request. For a block range on a time-bucketed endpoint (OHLC/VWAP/VWAP-aggregate/fiat VWAP), from_timestamp/to_timestamp hold the resolved timestamp window (and from_block/to_block echo your request). For a time range on a block-keyed endpoint, from_block/to_block hold the resolved block range (and the timestamps echo your request). null for selector-only requests (no window). No extra database work is done — these are the values the query already computed.
number | null
Resolved/echoed start block of the executed window.
number | null
Resolved/echoed end block of the executed window.
string | null
Resolved/echoed start timestamp (ISO-8601) of the executed window.
string | null
Resolved/echoed end timestamp (ISO-8601) of the executed window.
object
Echo of selectors and pagination from the request.

Data

object[]
Flash loan print records matching the request.
number
Block height of the event.
string
UTC timestamp of the block.
number
Transaction index within the block.
number
Log index within the transaction.
string | null
32-byte internal pool id (hex), or null for vault-level flash loans.
number | null
Present when pool_uid is set; otherwise null.
number | null
Pool type id when pool_uid is set; otherwise null.
string
20-byte address of the contract that emitted the event (hex, no 0x).
string
20-byte ERC-20 token borrowed in this row (hex, no 0x).
string
Raw amount borrowed as a uint256 integer in the borrowed token’s smallest denomination. String-encoded.
string | null
Decimals-adjusted form of amount_borrowed_raw (resolved against token). null when decimals are unknown or include_adjusted_amounts=false.
string
Raw amount repaid (borrowed + fee) as a uint256 integer in the borrowed token’s smallest denomination.
string | null
Decimals-adjusted form of amount_repaid_raw. Same null semantics as amount_borrowed.
string
Raw fee: amount_repaid_raw − amount_borrowed_raw, in the borrowed token’s smallest denomination.
string | null
Decimals-adjusted form of fee_amount_raw. Same null semantics as amount_borrowed.
string
Row tracing id (hex, no 0x).
string[]
Parent tracing ids.
string
Record creation timestamp (ISO-8601).
string
Record last update timestamp (ISO-8601).

Envelope

string | null
Pagination cursor.
number
Number of rows in data.
Last modified on July 19, 2026