strawbettystaking percentage
Updated 2022-05-11
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
›
⌄
with cs as (
select
date as day,
sum(balance) as Luna_Circulating_Supply
from terra.daily_balances
where date >= CURRENT_DATE - interval '90 days'
and currency = 'LUNA'
and address_label_type is NULL
group by day
order by day
), staking as (
select
date as day,
sum(balance) as Luna_Staked
from terra.daily_balances
where date >= CURRENT_DATE - interval '90 days'
and currency = 'LUNA'
and address_label_type is NULL
and BALANCE_TYPE = 'staked'
group by day
order by day
)
select cs.day, Luna_Circulating_Supply, Luna_Staked, (Luna_Staked/Luna_Circulating_Supply)*100 as prcnt
from cs left join staking on cs.day = staking.day
order by day
Run a query to Download Data