Tracking flash loan activity across various EVM chains.
Flash loan log data is collected from Dune. Currently only Aave V3 flash loans are collected. To categorize flash loans on their purpose, we examine other interactions that are performed with the flash loan.
For the initial flash loan event collection, seperate Dune queries are created for each blockchain with each listed below:
Below is the data schema associated with the Dune queries in the initial flash loan event collection step.
| Columns | Data Type | Description |
|---|---|---|
| evt_tx_hash | hex | Transaction hash that contained that flash loan event. |
| evt_index | int | The specific log index in the block that contained the emitted the floan loan event. |
| evt_block_time | datetime | Time that this was block was mined at. |
| amount | float | Size of flash loan issed in symbol units |
| amount_usd | float | Size of flash loan issued in $USD. |
| premium | float | The flash loan fee to the lending pool in the symbol currency. |
| premium_usd | float | The flash loan fee in $USD paid to the lending pool. |
| gas | float | Amount of gas paid to process this transaction in the blockchain's native currency. |
| gas_usd | float | The gas fee associated with the flash loan in $USD. |
| interestRateMode | int | |
| symbol | string | The currency that the flash loan was issued in. |
| initiator | hex | The address that initated that flash loan. |
| target | hex | The address that received the flash loan funds. |
| tx_type | string | The flash loan's purpose. |
For flash loans that are categorized as Arbitrage, another step is performed: TODO