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_uidis 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
Columns
| Column | Type | Description |
|---|---|---|
chain_id | BIGINT | EVM chain identifier; see Chain. |
block_number | BIGINT | Block of the event. |
block_time | TIMESTAMPTZ | Block time. |
tx_index | INTEGER | Transaction index. |
log_index | INTEGER | Log index. |
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. |
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). |
fee_rate_exact | TEXT | Exact fee_amount / amount_borrowed as lossless text. |
_tracing_id | BYTEA | Unique tracing ID. |
_parent_tracing_ids | BYTEA[] | Parent tracing IDs. |
_created_at | TIMESTAMPTZ | Insert time (no _updated_at in DDL). |
Related datasets
Swap fees
Fee accounting on directional swaps.