flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
luna balance by wallet
boomer77
luna balance by wallet
Updated 2021-12-07
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
address
,
sum
(
balance
)
as
total
,
currency
,
date
from
terra
.
daily_balances
where
currency
in
(
'LUNA'
)
and
date
=
CURRENT_DATE
-
1
and
address
!=
'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh'
group
by
1
,
3
,
4
order
by
2
desc
limit
1000
Results
Run a query to Download Data