flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Total Anchor Liquidations
shreyash-5873
Total Anchor Liquidations
Updated 2022-03-11
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
count
(
*
)
as
total_liquidations_per_day
from
terra
.
msgs
where
substring
(
msg_value
:
execute_msg
::
string
,
3
,
20
)
=
'liquidate_collateral'
and
tx_status
=
'SUCCEEDED'
and
date
(
block_timestamp
)
>=
CURRENT_DATE
(
)
-
90
;
Results
Run a query to Download Data