flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
LUNA supply in past 7 days
amin-z
LUNA supply in past 7 days
Updated 2022-04-19
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
date_trunc
(
'day'
,
date
)
as
block_day
,
SUM
(
balance
)
as
UST_balance
FROM
terra
.
daily_balances
WHERE
currency
=
'LUNA'
AND
balance_type
=
'liquid'
AND
date
>=
current_date
-
7
AND
balance
>
0
Group
by
block_day
order
by
1
Results
Run a query to Download Data