flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
comp liquidations
CryptoLion
comp liquidations
Updated 2021-06-14
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
date_trunc
(
'day'
,
block_timestamp
)
as
day
,
SUM
(
liquidation_amount_usd
)
as
liquidation_value
,
COUNT
(
tx_id
)
as
liquidations
FROM
compound
.
liquidations
WHERE
block_timestamp
>=
getdate
(
)
-
interval
'6 months'
GROUP
BY
1
ORDER
BY
1
Results