steemit 隐藏神技之: 富豪榜 / The rich list of steemit & How to get it from SteemData
富豪榜 / 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
- Amount of Holding SP
- Amount of Holding STEEM
- 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 😎
我超级喜欢DOS系统。
我也喜欢,😄
is Steem data the one made by @complexring?
by @furion
很荣幸地看到 @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!
原来前几名都是交易所。。。
这么重大的密码都被你发现了:)
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东西
Meow Yeah !!!! Thank you so much although I don't understand :)