New to Nutbox?

SP distribution by account sizes

8 comments

2 months ago3 min read

Yesterday, I posted A more granular look at Steem's account classifications with a breakdown of accounts by the amount of staked STEEM.

Today, I was curious about how much actual SP is held by each class of accounts, so I downloaded the actual balances of all accounts and slapped together a PowerBI report. Here's what I found:

The top row is the number of accounts by account type, and it basically matches what I got from SDS yesterday.
- I broke it into two charts since minnows and above are invisible if they're all in the same chart.
- "redfish" are repeated in both charts to try to anchor the perspective a little bit.
The second row is the amount of STEEM, SP, and SBD held by account type.
- I didn't see a need to split this into two charts.
- I used estimated SP instead of VESTS so that it could be visually compared against the liquid STEEM values.

And here's the script I used to do the download

#!/bin/bash
STEEM_API="https://api.steemit.com"

DATE=$(date)
echo "account,STEEM,SBD,VESTS" > /tmp/allBalances.csv
curl -s --data \
   '{"jsonrpc":"2.0", "method":"database_api.list_accounts", "params": {"start":"", "limit":1000, "order":"by_name"}, "id":1}' ${STEEM_API} \
   | jq -Src ".result[][] | [.name, .balance.amount, .sbd_balance.amount,  .vesting_shares.amount] | @csv" | sed 's/\"//g' | tee -a /tmp/allBalances.csv

saveLastAccount="xyzzy"
count=1
while :
do
   DATE=$(date)
   lastAccount=$(tail -1 /tmp/allBalances.csv | sed 's/,.*//g')
   echo ${DATE}/${count}: ${saveLastAccount} ${lastAccount}
   if [ "${saveLastAccount}x" == "${lastAccount}x" ]
   then
      break
   fi
   curl -s --data \
      '{"jsonrpc":"2.0", "method":"database_api.list_accounts", "params": {"start":"'${lastAccount}'", "limit":1000, "order":"by_name"}, "id":1}' ${STEEM_API} \
      | jq -Src ".result[][] | [.name, .balance.amount, .sbd_balance.amount,  .vesting_shares.amount] | @csv" | sed 's/\"//g' | tee -a /tmp/allBalances.csv
   saveLastAccount=${lastAccount}
   count=$(( ${count} + 1 ))
done

Some not-very-surprising observations

4 blue whales have more combined SP/VESTS than 29 whales
So do 291 Orcas
I divided nanoplankton into sub-classes based on holdings, but I don't know whether there's any point in establishing new names for those subclasses.
Converting from the blockchain's numbers to human readable numbers is a real chore^😉.
Almost all SBDs are probably held by the SPS and by the exchanges.
Dolphins and above hold very little liquid STEEM or SBDs.

Just for fun, here's another visual with the overall distribution of STEEM vs. SP. These numbers are broadly consistent with what I'm seeing in other reports.