steemit 隐藏神技之: 富豪榜 / The rich list of steemit & How to get it from SteemData

in #cn7 years ago

富豪榜 / The rich list

你可能见过steemit上的各种榜单,什么每日发帖排行榜、每日得奖排行榜、每日回复排行榜等等。 但是你知道吗,这里有一个很重要的榜单: 富豪榜

Here is a very important list: The rich list.
https://steemd.com/richlist

在这里,列出了持有SP最多的、持有STEEM最多的、持有SBD最多的各5000名用户
There are three accounts lists, sorted by

  1. Amount of Holding SP
  2. Amount of Holding STEEM
  3. Amount of Holding SBD

快来看看你是否在这个列表里吧。

Top 10 of the lists

这里我把三个列表的前十名截取过来了,快来崇拜一下吧

Get rich list from SteemData

在之前的文章中,我们简要地介绍过SteemData
简单介绍一下SteemData

那么我们是否可以获取使用SteemData获取rich list呢?
答案是肯定的,而且我们还可以获取用户存款账户信息哦,这是上边richlist里不包含的哦。

1: Get Top 10 SP holders from SteemData

查询语句:
rets = db.Accounts.find({}, {'name':1, 'sp':1, '_id':0}).sort('sp',-1).limit(10)

结果如下:

{'name': 'steemit', 'sp': 70769848.699}
{'name': 'freedom', 'sp': 7190048.222}
{'name': 'steem', 'sp': 4917755.824}
{'name': 'dan', 'sp': 4165217.731}
{'name': 'ned', 'sp': 3552240.243}
{'name': 'blocktrades', 'sp': 2844940.108}
{'name': 'val-a', 'sp': 2545454.998}
{'name': 'mottler', 'sp': 2233127.725}
{'name': 'abit', 'sp': 1951864.398}
{'name': 'databass', 'sp': 1692808.919}

2: Get Top 10 STEEM holders from SteemData

查询语句:
rets = db.Accounts.find({}, {'name':1, 'balance.amount':1, '_id':0}).sort('balance.amount',-1).limit(10)

结果如下:

{'name': 'poloniex', 'balance': {'amount': 26664594.378}}
{'name': 'bittrex', 'balance': {'amount': 8382739.044}}
{'name': 'steemit2', 'balance': {'amount': 1022874.459}}
{'name': 'dantheman', 'balance': {'amount': 964296.224}}
{'name': 'firefire', 'balance': {'amount': 893204.0}}
{'name': 'imadev', 'balance': {'amount': 788297.713}}
{'name': 'tombstone', 'balance': {'amount': 678857.312}}
{'name': 'ben', 'balance': {'amount': 644064.704}}
{'name': 'steemit', 'balance': {'amount': 500001.183}}
{'name': 'openledger', 'balance': {'amount': 488797.205}}

3: Get Top 10 SBD holders from SteemData

查询语句:
rets = db.Accounts.find({}, {'name':1, 'sbd_balance.amount':1, '_id':0}).sort('sbd_balance.amount',-1).limit(10)

结果如下:

{'name': 'poloniex', 'sbd_balance': {'amount': 1408592.375}}
{'name': 'bittrex', 'sbd_balance': {'amount': 634380.987}}
{'name': 'imadev', 'sbd_balance': {'amount': 71103.439}}
{'name': 'teamsmooth-mm', 'sbd_balance': {'amount': 69739.446}}
{'name': 'openledger', 'sbd_balance': {'amount': 43110.053}}
{'name': 'blocktrades', 'sbd_balance': {'amount': 38257.748}}
{'name': 'teamsmooth', 'sbd_balance': {'amount': 28113.009}}
{'name': 'nextgencrypto', 'sbd_balance': {'amount': 23056.34}}
{'name': 'azeroth', 'sbd_balance': {'amount': 20966.206}}
{'name': 'dang007', 'sbd_balance': {'amount': 19965.703}}

4:Get Top 10 SAVINGS SBD holders in from SteemData

查询语句:
rets = db.Accounts.find({}, {'name':1, 'savings_sbd_balance.amount':1, '_id':0}).sort('savings_sbd_balance.amount',-1).limit(10)

结果如下:

{'name': 'cryptomancer', 'savings_sbd_balance': {'amount': 20000.0}}
{'name': 'leesunmoo', 'savings_sbd_balance': {'amount': 6000.0}}
{'name': 'permacryptofolio', 'savings_sbd_balance': {'amount': 5000.0}}
{'name': 'camilla', 'savings_sbd_balance': {'amount': 4175.353}}
{'name': 'superstar', 'savings_sbd_balance': {'amount': 4012.435}}
{'name': 'clains', 'savings_sbd_balance': {'amount': 3800.712}}
{'name': 'psylains', 'savings_sbd_balance': {'amount': 3297.548}}
{'name': 'opheliafu', 'savings_sbd_balance': {'amount': 2782.369}}
{'name': 'dan-atstarlite', 'savings_sbd_balance': {'amount': 2000.0}}
{'name': 'chitty', 'savings_sbd_balance': {'amount': 1500.0}}

5: Get Top 10 SAVINGS STEEM holders in from SteemData

查询语句:
rets = db.Accounts.find({}, {'name':1, 'savings_balance.amount':1, '_id':0}).sort('savings_balance.amount',-1).limit(10)

结果如下:

{'name': 'steemit', 'savings_balance': {'amount': 18372915.751}}
{'name': 'ned', 'savings_balance': {'amount': 1328211.4}}
{'name': 'val', 'savings_balance': {'amount': 419040.606}}
{'name': 'bitone', 'savings_balance': {'amount': 120106.303}}
{'name': 'thejohalfiles', 'savings_balance': {'amount': 114362.882}}
{'name': 'goldenunicorn', 'savings_balance': {'amount': 110101.011}}
{'name': 'skan', 'savings_balance': {'amount': 64999.9}}
{'name': 'arhag', 'savings_balance': {'amount': 60000.0}}
{'name': 'opheliafu', 'savings_balance': {'amount': 16038.007}}
{'name': 'sofaking2020', 'savings_balance': {'amount': 9000.0}}


是不是很有意思,这只是最简单的查询哦,你可以编程实现很复杂的查询和筛选,快来玩吧

感谢阅读 / Thank you for reading.
欢迎upvote、resteem以及 following me @oflyhigh 😎

Sort:  

很荣幸地看到 @abit 排名第9,这是整个 #cn 区的骄傲。

@oflyhigh 你也排名在1000名以内哦。

1000名和10000名没差多少:)

Great post, thank you for sharing 🙏

This post is on the MONEY! Thank you for showing me how to find and review the Rich List. It's pure Gold!

10260026_766365990081175_4413829164540147171_n.jpg

Meow Yeah !!!! Thank you so much although I don't understand :)

Very interesting! 謝謝分享

很骄傲。我希望我们能成为朋友

看到了真正的大鲸鱼们!

Thanks for sharing.. One day i hope to be on that list

Thats the spirit. Hope you wont forget me then :)

希望有朝一日能上榜。
……
白日做梦!

加油,你是最胖的

那倒是,我确实蛮胖的,没毛病,社区我最胖,oh yeah

哈哈哈哈

Oh how I wish these people can help us gain momentum in the platform.

它是一个Richie Rich东西

very helpful information .

abit 大神也在 (^__^) 嘻嘻……

必须在啊,哈哈

Great source of info thanks

你的script是用什么语言写的?

我也在研究用sql玩这个。还没一撇。

这个也有在研究.就是相比较下有何不同.

Hi oflyhigh,it seems you are a statistician. i love your statistical analogy.you are doing a great job at least from this i can equally figure out the whales and the dolphins too.keep it up. upvoted and resteem.

Thank you.

原来前几名都是交易所。。。

这么重大的密码都被你发现了:)

大鲸鱼啊~謝謝分享

不客气:)

這都不關我們的事吧!!?(哭)

风声雨声读书声声声入耳
家事国事天下事事事关心

额,好像不相干,哈哈

多谢。学习了

客气了,一起学习

great post!

hi, I learning steemit,please you can help me

ABIT大大是我們中國的代表

What about steemwhales? Is the information provided by them reliable?

Among the biggest 200 or so, sorted by value, there are a lot of accounts with very low reputation, like 25 or 30. Does this mean the owners of these accounts are not using them? Could it be that they are not posting, but they are still voting around, or curating?

Thank you very much for this very valuable contribution.

You are welcome.
You can find more information of any account at steemd.com.

I know I will definitely be on that list someday. Cheers!!!

Ond day you be on rich list.

poloniex in the first place interesting

oh to be on it lol

Congratulations @oflyhigh!
Your post was mentioned in my hit parade in the following category:

  • Pending payout - Ranked 10 with $ 245,47
 7 years ago  Reveal Comment

我也喜欢,😄

is Steem data the one made by @complexring?