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.