flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
144. LUNA Distribution, Mvmt II_$Luna daily balance_Class A
Eman-Raz
144. LUNA Distribution, Mvmt II_$Luna daily balance_Class A
Updated 2022-07-06
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
date_trunc
(
'DAY'
,
date
)
as
BLOCK_DAY
,
sum
(
balance
)
as
total_LUNA
from
terra
.
daily_balances
where
currency
=
'LUNA'
AND
balance_type
=
'liquid'
and
balance
>
'0'
and
balance
<=
'100'
group
by
block_DAY
ORDER
BY
block_DAY
DESC
LIMIT
90
;
Results
Run a query to Download Data