flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Untitled Query
apostleoffinance
Untitled Query
Updated 2022-10-20
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
COUNT
(
*
)
AS
total_transaction
,
CASE
WHEN
AAVE_VERSION
=
'Aave v2'
then
'v2'
ELSE
'V1'
END
AS
aave_versions
FROM
ethereum
.
aave
.
ez_flashloans
GROUP
BY
2
ORDER
BY
1
;
-- there 59526 flashloan transactions on aave deployed on ethereum
Results
Run a query to Download Data