flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Total number of flashloans per day
shadil
Total number of flashloans per day
Updated 2022-08-12
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
count
(
*
)
as
total
,
date
(
block_timestamp
)
as
date_time
from
flipside_prod_db
.
aave
.
flashloans
where
date_time
>=
'{{start_date}}'
and
date_time
<=
'{{end_date}}'
and
aave_version
=
'Aave V2'
and
symbol
like
'{{token_name}}'
group
by
date_time
Results
Run a query to Download Data