keshanLUNA circulating supply and top 100
Updated 2022-01-24
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
›
⌄
select ((select sum(holding) from
(SELECT DISTINCT address, address_label_type, address_label_subtype, address_name,
sum(balance) as holding FROM terra.daily_balances
where BALANCE_TYPE = 'liquid'
and CURRENCY = 'LUNA'
and address_label_subtype != 'mints_burns'
and address_label_subtype != 'mint_burn'
--and address_label_type != 'dex'
and address_label_subtype != 'staking'
and address_label_subtype != 'staking_contract'
and address_label_subtype != 'token_vesting'
--and address_name != 'community pool'
and date_trunc('day', date) = date_trunc('day', CURRENT_DATE())-1
group by 1, 2, 3, 4
order by holding desc
LIMIT 100))
/
(SELECT sum(balance) FROM terra.daily_balances
where BALANCE_TYPE = 'liquid'
and CURRENCY = 'LUNA'
and address_label_subtype != 'mints_burns'
and address_label_subtype != 'mint_burn'
--and address_label_type != 'dex'
and address_label_subtype != 'staking'
and address_label_subtype != 'staking_contract'
and address_label_subtype != 'token_vesting'
--and address_name != 'community pool'
and date_trunc('day', date) = date_trunc('day', CURRENT_DATE()) - 1)) * 100 as pct
Run a query to Download Data