flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Query #1 - Get all flashloan txns
40qzoNds3u
Query #1 - Get all flashloan txns
Updated 2021-09-03
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
tx_id
,
date_trunc
(
'day'
,
block_timestamp
)
as
DATE
,
flashloan_amount_usd
,
initiator_address
,
aave_version
,
symbol
from
aave
.
flashloans
WHERE
aave_version
in
(
'Aave V1'
,
'Aave V2'
)
Results
Run a query to Download Data