LTirrellterradash_daily-balance
Updated 2022-04-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- select
-- date,
-- sum(balance)
-- from terra.daily_balances
-- where currency='LUNA'
-- and balance_type = 'liquid'
-- and address_label not in (
-- 'terraform'
-- )
-- and date>'2022-04-18'
-- group by date
-- order by date
-- select
-- date ,
-- sum(balance) as "LUNA Circulating Supply"
-- from terra.daily_balances
-- where date >= '2021-04-18'
-- and currency = 'LUNA'
-- -- and address_label_type is NULL
-- and address_label not in (
-- 'terraform'
-- )
-- group by date, 'balance_type'
-- order by date
select
round(
sum(balance) / pow(10, 6),
2
) as "Balance (Mil)",
case
when address = 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts' then 'bLUNA' --anchor hub
else balance_type
end as type
Run a query to Download Data