Skip to main content

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

Columns

ColumnTypeDescription
chain_idBIGINTEVM chain identifier; see Chain.
block_numberBIGINTBlock of the event.
block_timeTIMESTAMPTZBlock time.
tx_indexINTEGERTransaction index.
log_indexINTEGERLog index.
pool_uidBYTEA32B pool id when pool-scoped; NULL for vault-level events.
exchange_idINTEGERExchange id when pool_uid set; NULL otherwise.
type_idINTEGERPool type id when pool_uid set; NULL otherwise.
flash_loan_sourceBYTEA20B emitter (pool or vault contract).
tokenBYTEA20B borrowed token for this row.
amount_borrowedNUMERIC(78,0)Raw borrowed amount.
amount_repaidNUMERIC(78,0)Raw repaid amount (includes fee).
fee_amountNUMERIC(78,0)amount_repaid - amount_borrowed (raw).
fee_rate_exactTEXTExact fee_amount / amount_borrowed as lossless text.
_tracing_idBYTEAUnique tracing ID.
_parent_tracing_idsBYTEA[]Parent tracing IDs.
_created_atTIMESTAMPTZInsert time (no _updated_at in DDL).

Swap fees

Fee accounting on directional swaps.
Last modified on March 21, 2026