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.
- Sample: Hugging Face Sample
Parameters
Target EVM network. See the Chain enumeration.
Range filters (mutually exclusive)
Starting block number (inclusive). Use with to_block.
Ending block number (inclusive). Use with from_block.
Starting timestamp (ISO-8601). Use with to_timestamp.
Ending timestamp (ISO-8601). Use with from_timestamp.
Provide either a block range or a time range or direct selectors (pool_uids, flash_loan_source_addresses, and/or token_addresses).
Do not mix block and timestamp ranges. Invalid combinations return HTTP 400.
Direct selectors
Filter to pool UIDs (32-byte hex, no 0x). Omitted or null pool_uid rows (vault-level) require other selectors if you need them.
flash_loan_source_addresses
Emitter contracts (20-byte hex, no 0x): pool or vault that emitted the event.
Borrowed token addresses (20-byte hex, no 0x).
Recommended default 250; maximum 1000 to stay under ~10 MB responses.
Opaque pagination cursor from a previous response.
Response fields
Echo of request metadata applied to the response.
EVM chain ID echoed from the request.
Normalized block/timestamp bounds derived from the request.
Echo of selectors and pagination from the request.
Data
Flash loan print records matching the request.
EVM Chain ID for the record.
Block height of the event.
UTC timestamp of the block.
Transaction index within the block.
Log index within the transaction.
32-byte internal pool id (hex), or null for vault-level flash loans.
Present when pool_uid is set; otherwise null.
Pool type id when pool_uid is set; otherwise null.
20-byte address of the contract that emitted the event (hex, no 0x).
20-byte ERC-20 token borrowed in this row (hex, no 0x).
Raw amount borrowed (not decimals-adjusted), as a string integer.
Raw amount repaid including fee (not decimals-adjusted).
Raw fee: amount_repaid − amount_borrowed.
Exact fee rate as lossless text (fee_amount / amount_borrowed).
Row tracing id (hex, no 0x).
Record creation timestamp (ISO-8601). The backing table does not define _updated_at; the API may omit it.
Envelope
curl -X POST "https://api.blockdb.io/v1/evm/flash-loans/prints" \
-H "Authorization: Bearer $BLOCKDB_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"chain_id": 1,
"from_block": 19000000,
"to_block": 19000100,
"limit": 50
}'
{
"meta": {
"chain_id": 1,
"request_window": {
"from_block": 19000000,
"to_block": 19000100,
"from_timestamp": null,
"to_timestamp": null
},
"filters": {
"pool_uids": [],
"flash_loan_source_addresses": [],
"token_addresses": [],
"limit": 50,
"cursor": null
}
},
"data": [
{
"chain_id": 1,
"block_number": 19000050,
"block_time": "2025-11-11T10:00:00Z",
"tx_index": 12,
"log_index": 3,
"pool_uid": "88e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000",
"exchange_id": 1,
"type_id": 201,
"flash_loan_source": "88e6a0c2ddd26feeb64f039a2c41296fcb3f564",
"token": "c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2",
"amount_borrowed": "1000000000000000000",
"amount_repaid": "1003000000000000000",
"fee_amount": "3000000000000000",
"fee_rate_exact": "0.003",
"_tracing_id": "0305c0ffee000000000000000000000000000000000000000000000000000001",
"_parent_tracing_ids": [
"0103c0ffee000000000000000000000000000000000000000000000000000001"
],
"_created_at": "2025-11-11T10:00:05Z"
}
],
"cursor": null,
"count": 1
}