Skip to content

Flashloans

The ethereum.flashloans table provides indexed views for flash loan transactions, where a token is borrowed and subsequently paid back in the same transaction.

Columns

Name Type Description
block_number integer The block number at which the event occurred.
borrower_address text The address that received the initial funds of the flashloan.
contract_version text The version of the protocol.
log_index integer The log index at which the event occurred.
market_address text The address that lent the funds for the flashloan.
protocol_name text The name of the protocol that facilitated the flash loan.
quantity numeric The quantity of the token that flashloaned.
sender_address text The address that sent the transaction.
timestamp timestamp without time zone The timestamp at which the event occurred.
token_address text The token that was lent out in the flashloan.
transaction_hash text The transaction hash at which the event occurred.
__block_number integer An internal identifier for the indexer that updates this row. Use block_number instead when querying.
__confirmed boolean Flag indicating whether the transfer has been confirmed.
__last_modified timestamp The date at which this row was last updated (in ISO-8601 format).

Indexes

Index
timestamp, log_index
transaction_hash, log_index
__last_modified
__indexer_id WHERE __confirmed = false
__indexer_id, __block_number
block_number, log_index

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.