FatemeTheLadyWB 1 - Total holders
Updated 2022-11-04
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
›
⌄
⌄
select sum (balance/ pow(10,6))/count(distinct address) as Average
,median (balance/ pow(10,6)) as Median
,max (balance/ pow(10,6)) as Max
,min(balance/ pow(10,6)) as Min
,count(distinct address) as "Total wallets"
,sum(balance/ pow(10,6)) as "Total balance"
from osmosis.core.fact_daily_balances
where CURRENCY = 'uosmo'
and date::date = CURRENT_DATE-1
/*
Wallet Balances & Ecosystem Growth
How has the ratio of liquid to staked OSMO changed overtime?
Are the top 100 OSMO holders the same now as they were at the start of the year?
What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth.
Do wallets normally hold a majority of OSMO, or another token? How has this changed over time?
Grand Prize: 63.026 OSMO
Payout: 42.017 OSMO
Level: Intermediate
Difficulty: Hard
*/
Run a query to Download Data