forgashbalance over time
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
›
⌄
with cats as (
select
date,
round(
sum(balance) / pow(10, 6),
2
) as balance,
case
when address = 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts' then 'bLUNA' --anchor hub
else balance_type
end as type
from
terra.daily_balances
where date > current_date - 30
and currency = 'LUNA'
and balance > 0
AND address NOT IN (
'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh', --bonded_token_pool
'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6', --TFL address
'terra1jv65s3grqf6v6jl3dp4t6c9t9rk99cd8pm7utl', --community poolk
'terra1jgp27m8fykex4e4jtt0l7ze8q528ux2lh4zh0f', --mints/burns
'terra1tygms3xhhs3yv487phx3dw4a95jn7t7l8l07dr', --not_bonded_token_pool
'terra1wqwfwh797tf77e2xpvy9xx082pwpxxlm9x4xws' -- whale address, Do Kwon?
)
group by
date, type
)
select
date,
sum(balance) as balance
from cats
group by 1
order by 1
Run a query to Download Data