Look up the holders of the NEAR tokens to understand if those match the expectations

[frol]

There are several groups of token holders:

• Foundation
• Exchanges
• Investors (individual or otherwise)

I wonder if "whales" group is reasonable: https://near.flipsidecrypto.com/

"whales" are accounts owning 100k+ NEAR (on Flipside dashboard, the delegated tokens are properly mapped to the owners, but let's ignore that fact, let's assume that all the staked tokens are delegated from whales, and currently 400M NEAR are staked [scroll to the bottom])

[telezhnaya]

I took a snapshot of the system on a block 33039470 (Thu Mar 25 2021 13:52:45 GMT+0000). That block was selected because there is no changes in the blockchain 10 blocks before and after that.

By snapshot, I mean that I asked RPC for the balance of each and every account in the system and I summed up all these numbers.

Amount      613595482305167496766530766586266
Locked      407216955208179845432306793925403
Total:     1020812437513347342198837560511669
Expected:  1020812437513347342198837560511669 (total_supply)

The numbers are equal, even with broken account that was found during collecting of data. Read about it here.

I took the list of all users from DB. all_users.txt

It's not completely honest, it's not the list of users for the block 33039470. I collected this data slightly after the right moment. There were 14 users created after block, I do not include them in the final accountings.

The resulting files are: balance.txt deleted.txt

(We do not need the file with deleted users, I collected them just because I can. It's also interesting for me to analyse this data a little 🙂)

I will publish all results later in this issue

[telezhnaya]

Just because I was curious: some info about deleted accounts.

Implicit: 8017  (hash with length of 64 symbols)
Lockup:   311   (format ***.lockup.near)
Test:     12548 (format test-account-***.goodbot.near)
Other:    29

Only 29 look-like-natural accounts were deleted, here is the list:

v1.miguel.zest.near
officeofficeofficeofficeofficeoffice1234
tydfgdgrsfefse88888888888888888888888888
tysfefse88888888888888888888888888
f1113.bridge.near
0x0abde5c47a88d01ee0f15c2a315a3223bb803905
f1114.bridge.near
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxok
apptest1.marco.near
jasminex.near
f1112.bridge.near
main20201112.bridge.near
factory20201112.bridge.near
client20201112.bridge.near
prover20201112.bridge.near
recv1.apptest1.marco.near
f1225.bridge.near
afaefawefa.near
near.redbag.near
volodya.near
wxx.near
fuck.shitfuck.near
0xhacker.near
test44.near
lazarm.near
art.cards.berryclub.ek.near
prot_test.flux_dev.near
arno.near
sarasvati.near

[telezhnaya]

Let's compare the data. Guys gives the information for yesterday, so we are analysing the same day, 25th of March. We do not worry about exact numbers, we want to check the information roughly.

Let's convert the image to the table. Unfortunately, the information is limited, but let's work with what we have.

type	total	percent
whales	721500000	68.38
foundation	255100000	24.18
exchanges	33200000	3.15
large	29500000	2.8
small	8900000	0.84
validators	7000000	0.66
total	1055200000	100.0

This is the table based on real data collected from RPC. [updated 5th of April after Frol's comment where to get foundation accounts]

wallet type	total	percent	number of users	total amount	total locked
whales	356090941.28	34.88	222	356090941279079320513687915454959	0
foundation	243725434.32	23.88	201	243725434319808504083805161015105	0
exchanges	?	?	?	?	?
large	6523461.05	0.64	225	6523461046172812562431297960767	0
small	3829566.27	0.38	51594	3829566274483306223106633131790	0
validators	410643034.59	40.23	61	3426079385623553383499759023645	407216955208179845432306793925403
total	1020812437.51	100.0	52303	613595482305167496766530766586266	407216955208179845432306793925403

We have different categories. I don't know what is "exchanges".

Regarding your initial question: if we sum up whales amount and validators stake, it will be 75%. Dashboard has 68%, so it looks like this number is close to truth.

The question is: where do they find additional 35M of tokens?

[telezhnaya]

About whales: [updated 5th of April after Frol's comment where to get foundation accounts] 199 of 222 are lockup contracts, 10 are implicit. Rest of the accounts are: (desc sorted)

binance1.near                  5150573.94
ashert.poolv1.near             3249952.46
bscdeposit.near                2500001.0
ideocolabventures.poolv1.near  2124049.28
dafund.near                    1694432.53
binancecold3.near              1501778.71
huobipool.poolv1.near          1254851.49
ggcinternational.near          1083387.13
7z9thy3j.01.near               1000100.02
nearcoldtree.near              287486.92
lsdanila.near                  217911.3
mona.near                      166705.67
minto.near                     130008.0

[telezhnaya]

It would be nice to talk with the author of this dashboard. Do I need to find them? Do we have other questions here that should be analysed? @frol @khorolets feel free to ask any other questions regarding balances. I will try to research that 🙂

BTW,

on Flipside dashboard, the delegated tokens are properly mapped to the owners

how do they perform such mapping?

[frol]

It would be nice to talk with the author of this dashboard. Do I need to find them?

I will point them to this thread. I think Amos will take a lead on our side; let's wait if specific questions arise.

how do they perform such mapping?

They maintain their own indexer implementation and their own database. They are specialized in data analysis.

[frol]

FYI, here is a more comprehensive list of foundation-related accounts: https://velocity-app.flipsidecrypto.com/shareable/near-foundation-addresses-qM90nK (I am sorry I did not bring it to your earlier)

[telezhnaya]

Just to track intermediate results: foundation.txt My list is shorter because some accounts in provided link never existed (nfendowment56.near, nfendowment58.near, nfendowment59.near, nfendowment57.near, nfendowment60.near), some of them were deleted (prover20201112.bridge.near, client20201112.bridge.near, factory20201112.bridge.near, f1112.bridge.near, f1113.bridge.near, f1114.bridge.near)