flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
WORKING WITH AAVE
mcfemi6
WORKING WITH AAVE
Updated 2022-10-21
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
COUNT
(
*
)
AS
total_transactions
,
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
;
Results
Run a query to Download Data