The blockchain is a public database, this shouldn't be hard to find out. In [this post](https://helloacm.com/the-python-function-to-retrieve-the-producer-reward-for-witness/) we know how to call the Steem API to find out the witness that procduce each block and the reward (in VESTS) he/she collects for generating the block (mining). Let's create a database in SQLite - with the schema: ``` sqlite> .schema CREATE TABLE witnessblocks ( witness text, number integer, vests real, time text, block integer, constraint pkey primary key (block) ); CREATE INDEX index_block on witnessblocks(block); CREATE INDEX index_witness on witnessblocks(witness); CREATE INDEX index_time on witnessblocks(time); CREATE INDEX index_vests on witnessblocks(vests); CREATE INDEX index_number on witnessblocks(number); ``` Then, we can run a SQL to find out the number of blocks and total rewards for each witness. Results are sorted by total rewards in SP (which can be computed by simply roughly divided by 1943 SP) - see this number at: [https://steemyy.com](https://steemyy.com) Query: ``` sqlite> select witness,count(1), sum(vests/1943.761) as total from witnessblocks where time >= date('now', '-24 hour') group by witness order by total desc limit 30; ``` Result (a bit surprising, more than expected, different than what the steemworld says @steemchiller): I double check the data and everything seems correct. My understanding is that a lot of misses are re-scheduled and that is why the TOP witnesses get more turns to produce blocks. ``` justyy|2326|578.82025257632 steemchiller|2324|578.325146664636 hinomaru-jp|2324|578.322147174472 hivei0|2323|578.073978002953 scissor.sisters|2322|577.826185736312 dlike|2321|577.5771644482 steem-supporter|2320|577.328037061142 inwi|2319|577.082116292075 beargame|2319|577.079035895361 smt-wherein|2318|576.832034089068 steem-dragon|2318|576.831055014993 roundblocknew|2318|576.828982039459 rnt1|2317|576.583037687762 hoasen|2317|576.582024700568 symbionts|2317|576.578049543128 steem-agora|2316|576.338157853255 maiyude|2316|576.336006269803 future.witness|2313|575.584969334193 protoss20|2309|574.593023568226 dev.supporters|2305|573.596812309745 matreshka|193|240.560583586665 parse|192|239.309574386974 cryptoking777|191|238.066390513031 menacamel|191|238.066344493484 juddsmith079|190|236.823358969544 enjoylondon|190|236.815291552305 rlawlstn123|187|233.082098971016 leverfile|186|231.834906382009 upeross|185|230.587764003393 roadofrich|30|37.3927565415707 ``` Once this data is verified, I'll add it to the [witness ranking table](https://steemyy.com/witness-ranking/) <hr/> Every little helps! I hope this helps! **Steem On!~** *[Reposted to Computing & Technology](https://helloacm.com/how-many-blocks-and-total-rewards-for-a-steem-witness-in-the-past-24-hours/)* ------------------ If you like my work, please consider voting for me, thanks! https://steemit.com/~witnesses type in **justyy** and click ***VOTE*** https://steemyy.com/images/vote-for-justyy.jpg <BR/> **Alternatively, you could [proxy to me](https://steemyy.com/witness-voting/?witness=justyy&action=proxy) if you are too lazy to vote!** Also: you can vote me at the tool I made: https://steemyy.com/witness-voting/?witness=justyy ### Visit me at: [https://steemyy.com](https://steemyy.com)
post_id | 86,637,836 |
---|---|
author | justyy |
permlink | how-many-blocks-and-total-rewards-for-a-steem-witness-in-the-past-24-hours |
category | witness-category |
json_metadata | {"tags":["witness-category","witness","whalepower","producer-reward","steem","sql","steem-dev","codeonsteem"],"users":["steemchiller"],"image":["https:\/\/steemyy.com\/images\/vote-for-justyy.jpg"],"links":["https:\/\/helloacm.com\/the-python-function-to-retrieve-the-producer-reward-for-witness\/","https:\/\/steemyy.com","https:\/\/steemyy.com\/witness-ranking\/","https:\/\/helloacm.com\/how-many-blocks-and-total-rewards-for-a-steem-witness-in-the-past-24-hours\/","https:\/\/steemit.com\/~witnesses","https:\/\/steemyy.com\/witness-voting\/?witness=justyy&action=proxy","https:\/\/steemyy.com\/witness-voting\/?witness=justyy"],"app":"steemit\/0.2","format":"markdown"} |
created | 2020-07-09 16:57:18 |
last_update | 2020-07-09 16:57:18 |
depth | 0 |
children | 16 |
net_rshares | 62,579,744,046,535 |
last_payout | 2020-07-16 16:57:18 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 22.470 SBD |
curator_payout_value | 19.152 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 3,313 |
author_reputation | 2,052,211,997,492,585 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
paul-gillbanks | 0 | 157,208,788,199 | 100% | ||
gerber | 0 | 76,035,724,095 | 12.7% | ||
ezzy | 0 | 859,457,378,581 | 12.7% | ||
field | 0 | 19,295,076,100 | 100% | ||
exyle | 0 | 1,255,280,149,236 | 12.7% | ||
ace108 | 0 | 163,677,400,384 | 16% | ||
bullionstackers | 0 | 169,642,399,270 | 20% | ||
jphamer1 | 0 | 2,547,973,272,168 | 100% | ||
shanghaipreneur | 0 | 20,895,661,805 | 100% | ||
justyy | 0 | 21,281,531,802,642 | 100% | ||
happyukgo | 0 | 18,451,228,452 | 100% | ||
fleur | 0 | 38,790,746,861 | 100% | ||
melinda010100 | 0 | 1,009,013,207 | 5% | ||
fortune-master | 0 | 6,556,741,925 | 100% | ||
cristo | 0 | 68,031,528 | 7.55% | ||
skepticology | 0 | 10,026,615,938 | 100% | ||
viance | 0 | 15,641,152,068 | 100% | ||
beoped | 0 | 214,394,576,227 | 100% | ||
xyzashu | 0 | 4,796,555,165 | 100% | ||
techken | 0 | 49,514,938,391 | 100% | ||
wdougwatson | 0 | 1,119,970,411 | 12.7% | ||
doraemon | 0 | 271,090,868 | 100% | ||
whalepower | 0 | 5,470,270,688 | 20% | ||
shebe | 0 | 909,168,670 | 7.55% | ||
robinlee | 0 | 531,794,238 | 100% | ||
dine77 | 0 | 32,896,947,522 | 6.5% | ||
krazypoet | 0 | 196,411,131 | 0.75% | ||
rainyapril | 0 | 528,654,712 | 100% | ||
oldman28 | 0 | 17,906,639,931 | 60% | ||
kikima | 0 | 683,468,679 | 100% | ||
tribesteemup | 0 | 15,562,362,244,881 | 100% | ||
geass | 0 | 574,758,953 | 100% | ||
floatinglin | 0 | 4,051,985,395 | 100% | ||
superbing | 0 | 4,023,385,768 | 100% | ||
dailyfortune | 0 | 3,273,441,259 | 100% | ||
dobartim | 0 | 452,597,697,735 | 34% | ||
stef1 | 0 | 710,346,528,749 | 100% | ||
dailystats | 0 | 5,104,938,221 | 100% | ||
elizibar | 0 | 22,791,756,436 | 100% | ||
khaleelkazi | 0 | 5,526,729,855 | 12.7% | ||
jianan | 0 | 53,953,001,217 | 100% | ||
mpraveen | 0 | 43,055,051,638 | 100% | ||
emrebeyler | 0 | 6,740,927 | 12.7% | ||
cnbuddy | 0 | 1,561,804,646 | 0.1% | ||
chekohler | 0 | 897,066,563 | 7.55% | ||
anxin | 0 | 2,551,214,370 | 100% | ||
cloris | 0 | 1,326,931,228 | 100% | ||
nealmcspadden | 0 | 50,254,974,992 | 12.7% | ||
mermaidvampire | 0 | 29,004,801,527 | 100% | ||
hokulor | 0 | 105,555,238 | 3.77% | ||
nean | 0 | 522,773,439 | 100% | ||
foodielifestyle | 0 | 481,297,482 | 100% | ||
woolfe19861008 | 0 | 2,152,139,696 | 100% | ||
rachaeldwatson | 0 | 1,590,682,287 | 12.7% | ||
dailychina | 0 | 6,122,824,886 | 100% | ||
upfundme | 0 | 5,501,994,825 | 7.5% | ||
yhoh | 0 | 19,954,628,865 | 100% | ||
vincenthan | 0 | 543,221,425 | 100% | ||
the-reef | 0 | 22,428,182,620 | 100% | ||
dongfengman | 0 | 11,156,725,377 | 100% | ||
serenazz | 0 | 1,118,759,209 | 100% | ||
yedda | 0 | 518,236,962 | 100% | ||
futurecurrency | 0 | 4,387,496,070 | 28% | ||
zasilla | 0 | 525,410,148 | 100% | ||
ethanlee | 0 | 4,671,233,544 | 100% | ||
rikaz87 | 0 | 7,965,000,474 | 100% | ||
tloes | 0 | 24,019,659 | 12.7% | ||
twinsnicole | 0 | 532,866,159 | 100% | ||
deepthinking | 0 | 540,418,802 | 100% | ||
fabpoleo24 | 0 | 620,500,733 | 100% | ||
peerzadazeeshan | 0 | 1,437,879,814 | 7.55% | ||
a0i | 0 | 101,689,113 | 0.37% | ||
onepercentbetter | 0 | 15,661,266,106 | 10% | ||
carlos2115 | 0 | 460,473,049 | 100% | ||
fanso | 0 | 1,432,916,350 | 100% | ||
jkramer | 0 | 26,037,951,678 | 100% | ||
yameen | 0 | 3,462,835,071 | 20% | ||
atego | 0 | 83,552,879,887 | 100% | ||
lilypang22 | 0 | 1,298,404,480 | 100% | ||
wdwmemesnzapps | 0 | 0 | 12.7% | ||
mysupport | 0 | 44,260,448,047 | 100% | ||
kgakakillerg | 0 | 10,740,278,383 | 25% | ||
zens | 0 | 523,404,657 | 100% | ||
andrewma | 0 | 5,191,451,651 | 20% | ||
steemitvip | 0 | 528,390,275 | 100% | ||
regals | 0 | 521,631,669 | 100% | ||
wisdomandjustice | 0 | 2,462,861,854,208 | 25% | ||
joelone | 0 | 534,466,693 | 100% | ||
sweet-jenny8 | 0 | 21,366,012,955 | 100% | ||
myskye | 0 | 15,073,373,843 | 100% | ||
camillesteemer | 0 | -276,282,354 | -10% | ||
alpdurm | 0 | 78,431,152 | 30% | ||
merlion | 0 | 3,261,012,027 | 10% | ||
ihal0001 | 0 | 107,970,642 | 7.55% | ||
digital.mine | 0 | 120,718,753,392 | 1% | ||
t50 | 0 | 494,558,700 | 4.25% | ||
tm50 | 0 | 230,914,651 | 4.24% | ||
chineselaw | 0 | 2,467,434,866 | 100% | ||
sonder-an | 0 | 475,027,987 | 100% | ||
weicomenew | 0 | 528,775,059 | 100% | ||
laiyuehta | 0 | 4,534,844,281 | 100% | ||
turtlegraphics | 0 | 2,416,264,805 | 100% | ||
glory7 | 0 | 254,085,394,301 | 100% | ||
jayplayco | 0 | 7,471,401,535 | 5% | ||
dlike | 0 | 37,694,526,069 | 2.8% | ||
block-power | 0 | 22,486,062,212 | 100% | ||
witnesstools | 0 | 6,966,502,857 | 100% | ||
quarantine | 0 | 5,243,692,820 | 100% | ||
anti-bully | 0 | 262,996,907 | 100% | ||
ilovecoding | 0 | 6,416,383,896 | 100% | ||
wherein | 0 | 12,230,157,662,900 | 30% | ||
steemfuckeos | 0 | 3,155,554,965 | 100% | ||
edgarare1 | 0 | 238,931,983,301 | 100% | ||
gargantuan | 0 | 5,318,419,733 | 100% | ||
bluesniper | 0 | 30,012,864,813 | 75% | ||
primeradue | 0 | 1,730,876,409 | 12.7% | ||
morningshine | 0 | 54,564,209,564 | 30% | ||
ctime | 0 | 616,974,066,641 | 10% | ||
goodcontentbot | 0 | 85,199,219 | 2.5% | ||
skymin | 0 | 48,287,200,735 | 50% | ||
maskuncoro | 0 | 143,364,232 | 7.55% | ||
hungrybear | 0 | 267,377,830 | 10% | ||
lolasophiedanton | 0 | 288,568,290 | 12.7% | ||
goomajjang | 0 | 1,986,115,251 | 100% | ||
blockcreate | 0 | 10,435,515,429 | 100% | ||
rull14958 | 0 | 1,059,921,528 | 50% | ||
plankton.token | 0 | 47,767,374,980 | 75% | ||
blockcleaner | 0 | 56,273,056,113 | 100% | ||
bee-smart | 0 | 1,027,618,262 | 100% | ||
kgcoin | 0 | 316,500,676 | 50% | ||
steem.leo | 0 | 15,727,898,771 | 12.7% | ||
cplusplus | 0 | 6,436,920,819 | 100% | ||
leo.voter | 0 | 13,012,893,909 | 12.7% | ||
votebetting | 0 | 598,843,376,720 | 50% | ||
justsoso | 0 | 1,659,497,532 | 100% | ||
perrymine | 0 | 3,984,054,554 | 12% | ||
ufmbot | 0 | 674,233,933 | 5.62% | ||
ufm.pay | 0 | 32,899,405,389 | 5.62% | ||
ufm.reserve | 0 | 171,266,318 | 11.12% | ||
maxuvd | 0 | 12,174,349,049 | 12.7% | ||
icetea | 0 | 2,096,943,103 | 60% | ||
longhash | 0 | 1,488,648,870 | 100% | ||
llfestyle | 0 | 390,275,972 | 100% | ||
tmps | 0 | 4,444,140,457 | 4.25% | ||
cnbuddy-reward | 0 | 56,963,968 | 0.05% | ||
unpopular | 0 | 46,914,767,407 | 100% | ||
megalotto | 0 | 484,382,038 | 3.75% | ||
photosnap | 0 | 1,021,726,159 | 20% | ||
block.token | 0 | 223,330,866 | 15.1% | ||
pitre | 0 | 667,188,701 | 100% | ||
aceh.point | 0 | 5,897,829,707 | 15.1% | ||
lucky-guy | 0 | 2,115,884,531 | 100% | ||
sexybeach | 0 | 6,426,777,152 | 100% | ||
suckmydick | 0 | 3,184,170,573 | 100% | ||
chromebook | 0 | 3,182,936,846 | 100% | ||
successgr | 0 | 211,467,722,884 | 3% | ||
steemcityrewards | 0 | 0 | 12.7% | ||
ericandryan | 0 | 11,578,277,130 | 100% | ||
lovequeen | 0 | 20,774,593,864 | 100% | ||
kjinhyun | 0 | 90,565,188,195 | 50% | ||
dev.supporters | 0 | 127,555,288,139 | 10% | ||
steemgoon | 0 | 2,109,499,536 | 20% | ||
goonz | 0 | 1,067,541,396 | 30% | ||
sometacos | 0 | 1,477,458,564 | 20% | ||
beargame | 0 | 21,818,050,410 | 5% | ||
naturebeauty | 0 | 750,696,808 | 80% | ||
justyy222 | 0 | 3,118,773,601 | 100% | ||
tonimariearnold | 0 | 0 | 0.37% | ||
canero | 0 | 0 | 0.37% | ||
vwatata | 0 | 896,990,593 | 100% | ||
juddsmith079 | 0 | 199,264,245,766 | 40% | ||
roundblocknew | 0 | 12,690,920,109 | 5% | ||
rainnrising | 0 | 0 | 0.37% | ||
kindly-keyin | 0 | 0 | 0.91% | ||
curator-id | 0 | 2,230,413,249 | 15.1% | ||
mildaleblanc | 0 | 187,759,704,335 | 5% | ||
rishihrutu | 0 | 67,205,169,754 | 50% | ||
pharos1999 | 0 | 307,817,895,352 | 5% | ||
dujian | 0 | 104,552,388 | 100% | ||
pluepark | 0 | 10,324,785,161 | 5% |
Hello Justyy, thank you for all the great work you are doing for the Steem blockchain! Would it be possible to create a list of the Most Downvoted Accounts??? The Top Muted Accounts feature was really helpful for my Troll Hunters Community, and I thought it would be great to add to that the most Downvoted accounts, as a way of discovering abusive users. Thanks again!
post_id | 86,637,947 |
---|---|
author | famigliacurione |
permlink | qd7p78 |
category | witness-category |
json_metadata | {"app":"steemit\/0.2"} |
created | 2020-07-09 17:14:00 |
last_update | 2020-07-09 17:14:00 |
depth | 1 |
children | 2 |
net_rshares | 259,158,573,888 |
last_payout | 2020-07-16 17:14:00 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.050 SBD |
curator_payout_value | 0.050 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 369 |
author_reputation | 121,774,275,823,341 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
justyy | 0 | 207,612,195,508 | 1% | ||
happyukgo | 0 | 129,580,932 | 1% | ||
robinlee | 0 | 0 | 1% | ||
rainyapril | 0 | 0 | 1% | ||
kikima | 0 | 0 | 1% | ||
geass | 0 | 0 | 1% | ||
superbing | 0 | 0 | 1% | ||
dailyfortune | 0 | 0 | 1% | ||
dailystats | 0 | 44,811 | 1% | ||
mundharmonika | 0 | 50,100,274,116 | 84% | ||
jianan | 0 | 473,777,015 | 1% | ||
anxin | 0 | 0 | 1% | ||
nean | 0 | 0 | 1% | ||
foodielifestyle | 0 | 0 | 1% | ||
woolfe19861008 | 0 | 0 | 1% | ||
dailychina | 0 | 9,915,518 | 1% | ||
vincenthan | 0 | 0 | 1% | ||
dongfengman | 0 | 58,779,514 | 1% | ||
serenazz | 0 | 0 | 1% | ||
yedda | 0 | 0 | 1% | ||
zasilla | 0 | 0 | 1% | ||
ethanlee | 0 | 0 | 1% | ||
twinsnicole | 0 | 0 | 1% | ||
deepthinking | 0 | 0 | 1% | ||
fanso | 0 | 0 | 1% | ||
lilypang22 | 0 | 0 | 1% | ||
zens | 0 | 0 | 1% | ||
steemitvip | 0 | 0 | 1% | ||
regals | 0 | 0 | 1% | ||
joelone | 0 | 0 | 1% | ||
sweet-jenny8 | 0 | 157,880,624 | 1% | ||
weicomenew | 0 | 0 | 1% | ||
laiyuehta | 0 | 0 | 1% | ||
turtlegraphics | 0 | 0 | 1% | ||
witnesstools | 0 | 18,105,649 | 1% | ||
ilovecoding | 0 | 12,778,361 | 1% | ||
steemfuckeos | 0 | 0 | 1% | ||
blockcleaner | 0 | 496,509,289 | 1% | ||
cplusplus | 0 | 12,971,516 | 1% | ||
justsoso | 0 | 0 | 1% | ||
longhash | 0 | 0 | 1% | ||
llfestyle | 0 | 0 | 1% | ||
sexybeach | 0 | 12,873,281 | 1% | ||
suckmydick | 0 | 0 | 1% | ||
chromebook | 0 | 0 | 1% | ||
ericandryan | 0 | 62,887,754 | 1% | ||
justyy222 | 0 | 0 | 1% |
Thank you. Interesting idea! I'll definitely think about it
post_id | 86,638,462 |
---|---|
author | justyy |
permlink | qd7rzt |
category | witness-category |
json_metadata | {"app":"steemit\/0.2"} |
created | 2020-07-09 18:14:21 |
last_update | 2020-07-09 18:14:21 |
depth | 2 |
children | 1 |
net_rshares | 1,012,425,025,487 |
last_payout | 2020-07-16 18:14:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.214 SBD |
curator_payout_value | 0.214 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 59 |
author_reputation | 2,052,211,997,492,585 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
wisdomandjustice | 0 | 1,012,130,500,453 | 10% | ||
curbot | 0 | 294,525,034 | 100% |
That's excellent! Thank you for considering it, I really appreciate it!
post_id | 86,645,692 |
---|---|
author | famigliacurione |
permlink | qd8y8y |
category | witness-category |
json_metadata | {"app":"steemit\/0.2"} |
created | 2020-07-10 09:27:03 |
last_update | 2020-07-10 09:27:03 |
depth | 3 |
children | 0 |
net_rshares | 0 |
last_payout | 2020-07-17 09:27:03 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 71 |
author_reputation | 121,774,275,823,341 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
Also the sums on SteemWorld are built by adding the vests of all received `producer_reward` operations in that time period. When I multiply the daily amount from SteemWorld (~342.18 SP) by 30 (days), I come to the correct monthly rewards. Maybe it's related to the time in your WHERE clause `time >= date('now', '-24 hour')`. Can it be that your script begins to count from start of the previous day? If the field 'time' in your table is a date (without time) or the `date()` method returns a date instead of a datetime, I think this likely is the case. For time fields I always use integers and store the unix time. I think this makes it easier to work with time ranges.
post_id | 86,638,385 |
---|---|
author | steemchiller |
permlink | qd7rkh |
category | witness-category |
json_metadata | {"app":"steemit\/0.2"} |
created | 2020-07-09 18:05:06 |
last_update | 2020-07-09 18:13:03 |
depth | 1 |
children | 8 |
net_rshares | 1,818,128,303,992 |
last_payout | 2020-07-16 18:05:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.410 SBD |
curator_payout_value | 0.409 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 673 |
author_reputation | 278,255,940,220,712 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
remlaps | 0 | 35,941,054,397 | 100% | ||
justyy | 0 | 623,292,661,418 | 3% | ||
happyukgo | 0 | 489,038,106 | 3% | ||
nokeh | 0 | 0 | 3% | ||
robinlee | 0 | 0 | 3% | ||
rainyapril | 0 | 0 | 3% | ||
kangnajiang | 0 | 0 | 3% | ||
kikima | 0 | 0 | 3% | ||
geass | 0 | 0 | 3% | ||
superbing | 0 | 68,672,655 | 3% | ||
dailyfortune | 0 | 46,837,994 | 3% | ||
dailystats | 0 | 100,216,577 | 3% | ||
mundharmonika | 0 | 60,852,097,111 | 100% | ||
jianan | 0 | 1,522,197,237 | 3% | ||
daxiang | 0 | 0 | 3% | ||
anxin | 0 | 25,785,333 | 3% | ||
anli | 0 | 7,333,628,820 | 99% | ||
andrepol | 0 | 5,565,782,435 | 99% | ||
moobear | 0 | 0 | 3% | ||
nean | 0 | 0 | 3% | ||
foodielifestyle | 0 | 0 | 3% | ||
woolfe19861008 | 0 | 14,172,008 | 3% | ||
dailychina | 0 | 129,845,048 | 3% | ||
vincenthan | 0 | 0 | 3% | ||
yuxuan | 0 | 0 | 3% | ||
dongfengman | 0 | 276,517,331 | 3% | ||
serenazz | 0 | 0 | 3% | ||
yedda | 0 | 0 | 3% | ||
zasilla | 0 | 0 | 3% | ||
fishaa | 0 | 0 | 3% | ||
ethanlee | 0 | 87,568,595 | 3% | ||
twinsnicole | 0 | 0 | 3% | ||
deepthinking | 0 | 0 | 3% | ||
gogoabc | 0 | 0 | 3% | ||
fanso | 0 | 0 | 3% | ||
atego | 0 | 40,324,694,901 | 50% | ||
lilypang22 | 0 | 0 | 3% | ||
fishcc | 0 | 0 | 3% | ||
zens | 0 | 0 | 3% | ||
steemitvip | 0 | 0 | 3% | ||
regals | 0 | 0 | 3% | ||
joelone | 0 | 0 | 3% | ||
sweet-jenny8 | 0 | 573,983,462 | 3% | ||
muelli | 0 | 2,869,147,361 | 50% | ||
ffbank | 0 | 0 | 3% | ||
weicomenew | 0 | 0 | 3% | ||
laiyuehta | 0 | 83,706,206 | 3% | ||
turtlegraphics | 0 | 21,865,322 | 3% | ||
remlaps-lite | 0 | 42,309,212,844 | 100% | ||
muscara | 0 | 2,729,743,725 | 50% | ||
witnesstools | 0 | 154,428,882 | 3% | ||
seo-boss | 0 | 990,040,432,390 | 100% | ||
ilovecoding | 0 | 138,438,121 | 3% | ||
steemfuckeos | 0 | 43,411,402 | 3% | ||
blockcleaner | 0 | 1,590,428,275 | 3% | ||
cplusplus | 0 | 139,017,966 | 3% | ||
holycow2019 | 0 | 287,121,509 | 100% | ||
justsoso | 0 | 0 | 3% | ||
re2pair | 0 | 518,252,099 | 100% | ||
longhash | 0 | 0 | 3% | ||
cnfish | 0 | 0 | 3% | ||
llfestyle | 0 | 0 | 3% | ||
erlcet | 0 | 0 | 3% | ||
leodec | 0 | 0 | 3% | ||
sexybeach | 0 | 138,723,104 | 3% | ||
suckmydick | 0 | 44,231,750 | 3% | ||
chromebook | 0 | 44,200,086 | 3% | ||
ericandryan | 0 | 288,848,613 | 3% | ||
justyy222 | 0 | 42,340,909 | 3% |
Yes, you are right. I should use `datetime('now', '-24 hour')` instead of `date('now', '-24 hour')`
post_id | 86,638,497 |
---|---|
author | justyy |
permlink | qd7s51 |
category | witness-category |
json_metadata | {"app":"steemit\/0.2"} |
created | 2020-07-09 18:17:30 |
last_update | 2020-07-09 18:17:30 |
depth | 2 |
children | 0 |
net_rshares | 1,390,656,514,713 |
last_payout | 2020-07-16 18:17:30 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.304 SBD |
curator_payout_value | 0.304 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 100 |
author_reputation | 2,052,211,997,492,585 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
steemchiller | 0 | 378,247,922,479 | 25% | ||
wisdomandjustice | 0 | 1,012,120,850,037 | 10% | ||
curbot | 0 | 287,742,197 | 100% |
Einen weiteren Verbesserungsvorschlag für das Copy-Vote-Tool hätte ich: Ich werde oft in beide Richtungen überrascht, wie viel bzw. wenig meiner VP verbraucht wird, da ich immer "Copy voted weight" aktiviere. Wieviel % gegeben wurden, kann ich nur aufwändig einzeln feststellen über das Popup mit der Votes-Statistik. Und dann müsste ich auch noch die % zusammenzählen, um feststellen zu können, wieviel % ich ungefähr verbraten werde. In der Liste wäre Platz für die Darstellung des Voteweights und einer Summe dazu. Daraus lässt sich zwar der genaue VP-Verbrauch nicht ermitteln, aber in hinreichender Näherung. Die resultierende ungefähre Wiederaufladezeit liesse sich wiederum daraus leicht errechnen und auch darstellen.
post_id | 86,648,503 |
---|---|
author | mundharmonika |
permlink | qd9c6q |
category | witness-category |
json_metadata | {"app":"steemit\/0.2"} |
created | 2020-07-10 14:28:24 |
last_update | 2020-07-10 14:28:24 |
depth | 2 |
children | 6 |
net_rshares | 1,556,226,818,029 |
last_payout | 2020-07-17 14:28:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.340 SBD |
curator_payout_value | 0.341 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 726 |
author_reputation | 27,471,912,141,256 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
steemchiller | 0 | 1,556,226,818,029 | 100% |
Ja, das halte ich für eine sehr gute Idee, die sich auch recht schnell umsetzen lässt. Vielleicht kann ich das sogar noch heute Abend reinbringen ;)
post_id | 86,649,216 |
---|---|
author | steemchiller |
permlink | qd9ezd |
category | witness-category |
json_metadata | {"app":"steemit\/0.2"} |
created | 2020-07-10 15:28:24 |
last_update | 2020-07-10 15:28:24 |
depth | 3 |
children | 0 |
net_rshares | 1,055,835,116,552 |
last_payout | 2020-07-17 15:28:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.220 SBD |
curator_payout_value | 0.220 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 148 |
author_reputation | 278,255,940,220,712 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
mundharmonika | 0 | 25,778,032,740 | 43% | ||
anli | 0 | 7,069,534,858 | 99% | ||
andrepol | 0 | 5,589,483,933 | 99% | ||
atego | 0 | 40,731,906,956 | 50% | ||
muelli | 0 | 2,869,147,361 | 50% | ||
muscara | 0 | 2,729,743,725 | 50% | ||
seo-boss | 0 | 970,261,893,371 | 100% | ||
holycow2019 | 0 | 287,121,509 | 100% | ||
re2pair | 0 | 518,252,099 | 100% |
Das Vote-Weight ist jetzt schon mal mit in der Liste ;) https://cdn.steemitimages.com/DQmab4D8iS1eNxxUchCdVcgMRZc71UZfa4mTmuDHaQDgtYZ/steemworld-copy-votes-weight.png
post_id | 86,760,733 |
---|---|
author | steemchiller |
permlink | qdqhk4 |
category | witness-category |
json_metadata | {"image":["https:\/\/cdn.steemitimages.com\/DQmab4D8iS1eNxxUchCdVcgMRZc71UZfa4mTmuDHaQDgtYZ\/steemworld-copy-votes-weight.png"],"app":"steemit\/0.2"} |
created | 2020-07-19 20:43:15 |
last_update | 2020-07-19 20:43:15 |
depth | 3 |
children | 4 |
net_rshares | 972,179,420,621 |
last_payout | 2020-07-26 20:43:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.208 SBD |
curator_payout_value | 0.209 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 167 |
author_reputation | 278,255,940,220,712 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
seo-boss | 0 | 972,179,420,621 | 100% |
给行长拍手👏
post_id | 86,641,663 |
---|---|
author | yanhan |
permlink | qd8c3z |
category | witness-category |
json_metadata | {"app":"steemcn\/0.1"} |
created | 2020-07-10 01:28:54 |
last_update | 2020-07-10 01:28:54 |
depth | 1 |
children | 1 |
net_rshares | 219,746,356,354 |
last_payout | 2020-07-17 01:28:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.042 SBD |
curator_payout_value | 0.042 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 6 |
author_reputation | 86,430,428,607,483 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
justyy | 0 | 218,585,509,808 | 1% | ||
happyukgo | 0 | 145,419,066 | 1% | ||
robinlee | 0 | 0 | 1% | ||
rainyapril | 0 | 0 | 1% | ||
kikima | 0 | 0 | 1% | ||
geass | 0 | 0 | 1% | ||
superbing | 0 | 0 | 1% | ||
dailyfortune | 0 | 0 | 1% | ||
dailystats | 0 | 3,001,727 | 1% | ||
jianan | 0 | 495,159,697 | 1% | ||
anxin | 0 | 0 | 1% | ||
nean | 0 | 0 | 1% | ||
foodielifestyle | 0 | 0 | 1% | ||
woolfe19861008 | 0 | 0 | 1% | ||
dailychina | 0 | 12,424,304 | 1% | ||
vincenthan | 0 | 0 | 1% | ||
dongfengman | 0 | 63,991,740 | 1% | ||
serenazz | 0 | 0 | 1% | ||
yedda | 0 | 0 | 1% | ||
zasilla | 0 | 0 | 1% | ||
ethanlee | 0 | 0 | 1% | ||
twinsnicole | 0 | 0 | 1% | ||
deepthinking | 0 | 0 | 1% | ||
fanso | 0 | 0 | 1% | ||
lilypang22 | 0 | 0 | 1% | ||
zens | 0 | 0 | 1% | ||
steemitvip | 0 | 0 | 1% | ||
regals | 0 | 0 | 1% | ||
joelone | 0 | 0 | 1% | ||
sweet-jenny8 | 0 | 168,583,350 | 1% | ||
weicomenew | 0 | 0 | 1% | ||
laiyuehta | 0 | 0 | 1% | ||
turtlegraphics | 0 | 0 | 1% | ||
witnesstools | 0 | 21,889,921 | 1% | ||
ilovecoding | 0 | 16,684,913 | 1% | ||
steemfuckeos | 0 | 0 | 1% | ||
blockcleaner | 0 | 132,751,881 | 1% | ||
cplusplus | 0 | 16,032,852 | 1% | ||
justsoso | 0 | 0 | 1% | ||
longhash | 0 | 0 | 1% | ||
llfestyle | 0 | 0 | 1% | ||
sexybeach | 0 | 15,965,694 | 1% | ||
suckmydick | 0 | 0 | 1% | ||
chromebook | 0 | 0 | 1% | ||
ericandryan | 0 | 68,941,401 | 1% | ||
justyy222 | 0 | 0 | 1% |
感谢。回赞。
post_id | 86,647,870 |
---|---|
author | justyy |
permlink | qd99oq |
category | witness-category |
json_metadata | {"app":"steemit\/0.2"} |
created | 2020-07-10 13:34:03 |
last_update | 2020-07-10 13:34:03 |
depth | 2 |
children | 0 |
net_rshares | 287,684,776 |
last_payout | 2020-07-17 13:34:03 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 6 |
author_reputation | 2,052,211,997,492,585 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
curbot | 0 | 287,684,776 | 100% |
interesting that 20th and 21th are that much different. Thank you for your service, as usual.
post_id | 86,641,823 |
---|---|
author | glory7 |
permlink | qd8d4f |
category | witness-category |
json_metadata | {"app":"steemit\/0.2"} |
created | 2020-07-10 01:50:39 |
last_update | 2020-07-10 01:50:39 |
depth | 1 |
children | 1 |
net_rshares | 226,756,867,763 |
last_payout | 2020-07-17 01:50:39 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.044 SBD |
curator_payout_value | 0.043 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 95 |
author_reputation | 1,494,322,874,274,224 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
justyy | 0 | 218,601,378,383 | 1% | ||
happyukgo | 0 | 145,437,094 | 1% | ||
nokeh | 0 | 0 | 1% | ||
robinlee | 0 | 0 | 1% | ||
rainyapril | 0 | 0 | 1% | ||
kikima | 0 | 0 | 1% | ||
geass | 0 | 0 | 1% | ||
superbing | 0 | 0 | 1% | ||
dailyfortune | 0 | 0 | 1% | ||
dailystats | 0 | 3,006,562 | 1% | ||
mundharmonika | 0 | 6,994,497,134 | 12% | ||
jianan | 0 | 495,208,538 | 1% | ||
daxiang | 0 | 0 | 1% | ||
anxin | 0 | 0 | 1% | ||
nean | 0 | 0 | 1% | ||
foodielifestyle | 0 | 0 | 1% | ||
woolfe19861008 | 0 | 0 | 1% | ||
dailychina | 0 | 12,429,467 | 1% | ||
vincenthan | 0 | 0 | 1% | ||
yuxuan | 0 | 0 | 1% | ||
dongfengman | 0 | 64,000,271 | 1% | ||
serenazz | 0 | 0 | 1% | ||
yedda | 0 | 0 | 1% | ||
zasilla | 0 | 0 | 1% | ||
ayanamoon | 0 | 0 | 1% | ||
ethanlee | 0 | 0 | 1% | ||
twinsnicole | 0 | 0 | 1% | ||
deepthinking | 0 | 0 | 1% | ||
gogoabc | 0 | 0 | 1% | ||
fanso | 0 | 0 | 1% | ||
lilypang22 | 0 | 0 | 1% | ||
yuting | 0 | 0 | 1% | ||
zens | 0 | 0 | 1% | ||
steemitvip | 0 | 0 | 1% | ||
regals | 0 | 0 | 1% | ||
joelone | 0 | 0 | 1% | ||
sweet-jenny8 | 0 | 168,599,732 | 1% | ||
weicomenew | 0 | 0 | 1% | ||
laiyuehta | 0 | 0 | 1% | ||
turtlegraphics | 0 | 0 | 1% | ||
witnesstools | 0 | 21,895,960 | 1% | ||
ilovecoding | 0 | 16,691,011 | 1% | ||
steemfuckeos | 0 | 0 | 1% | ||
blockcleaner | 0 | 132,762,972 | 1% | ||
cplusplus | 0 | 16,038,285 | 1% | ||
justsoso | 0 | 0 | 1% | ||
longhash | 0 | 0 | 1% | ||
llfestyle | 0 | 0 | 1% | ||
steeemmonsters | 0 | 0 | 1% | ||
wilhb82 | 0 | 0 | 1% | ||
keivinzhang | 0 | 0 | 1% | ||
sexybeach | 0 | 15,971,132 | 1% | ||
suckmydick | 0 | 0 | 1% | ||
chromebook | 0 | 0 | 1% | ||
ericandryan | 0 | 68,951,222 | 1% | ||
justyy222 | 0 | 0 | 1% |
Thanks.. yes, the TOP 20 gets most slices of the cake. 😅
post_id | 86,647,865 |
---|---|
author | justyy |
permlink | qd99o0 |
category | witness-category |
json_metadata | {"app":"steemit\/0.2"} |
created | 2020-07-10 13:33:42 |
last_update | 2020-07-10 13:33:42 |
depth | 2 |
children | 0 |
net_rshares | 294,525,034 |
last_payout | 2020-07-17 13:33:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 56 |
author_reputation | 2,052,211,997,492,585 |
root_title | "How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
curbot | 0 | 294,525,034 | 100% |