In this study I revisit the financial breakdown of the Steem blockchain that I first derived back at the end of November 2017.
The breakdown considers:
- How much of the Steem currency is held as Steem Power and thus eligible for voting on reward allocation and how much is held as Liquid Steem or Steem in Savings.
- What proportion of the powered up Steem is actually used for voting and how much is sitting idle or not fully utilised.
- How the above measures vary by user level (minnow, dolphin, orca, whale etc).
- How this position compares to the breakdown derived at the end of November.
The aims of the study are:
- To aid Steem account holders, potential investors and developers in understanding where the Steem currency is held and the extent to which it is being utilised for reward allocation.
- To look at the change of this position over time to give an indication of whether the rise in SBD and Steem prices has impacted the choice of holding Steem Power, or its use in voting.
The snapshot of the currency breakdown has been taken at the end of the 18th January 2018. The analysis of voting use covers the past week; 12th - 18th January 2018. The previous analysis was also for one week; from 22nd - 29th November 2017.
There are two parts to the analysis:
How much Steem is held as Steem Power:
A breakdown of the Steem currency between Steem Power, Liquid Steem and Steem in Savings with a further categorisation by user level.
This breakdown is then compared to the position at the end of November.What proportion of Steem Power is used for voting:
An analysis of voting over one week to determine what proportion of Steem Power is used for voting, separated by upvotes and downvotes, and again categorised by user level.
The position is also compared to the equivalent figures at the end of November.
Outline
- Scope of Analysis
- Tools Used
- How much Steem is held as Steem Power
- What proportion of Steem Power is used for voting
- Scripts
1 Scope of Analysis
The data has been obtained through SQL queries of SteemSQL, a publicly available Microsoft SQL database containing all the Steem blockchain data.
The amounts of Steem held as Steem Power, Liquid Steem and Steem in Savings can be seen in each user’s wallet. This is even the case for the overall amounts of Liquid Steem held on the currency exchanges. This first part of the analysis requires the data for all Steem accounts. A grouped summary has been extracted from the Accounts table.
The voting behaviour has been determined using data from the TxVotes table. Only data for accounts voting over the last week has been extracted. The data has been filtered by date using the timestamps for each vote in the TxVotes table.
2 Tools Used
Valentina Studio, a free data management tool, was used to run the SQL queries. The raw data was then verified and analysed in the spreadsheet application of the LibreOffice office suite.
Illustrations were produced manually using GIMP, the open source image editor.
SQL scripts are included at the end of this analysis.
3 How much Steem is held as Steem Power
Most users will be aware that not all Steem is Powered Up into Steem Power. There are large allocations of Steem that are thus not eligible for voting. These amounts can be seen in each user’s wallet, either held as immediately transferable tokens (often called Liquid Steem) or more securely in Steem Savings.
The table below shows the breakdown of the Steem currency between Steem Power, Liquid Steem and Steem in Savings with a further categorisation by user level.
Breakdown of Steem Currency
Figures derived as at end of 18-01-2018
| Steem Power | Liquid Steem | Steem in Savings | Total Steem | |
|---|---|---|---|---|
| Redfish | 11,233,821 | 10,730,016 | 776,185 | 22,740,022 |
| Minnows | 9,420,311 | 45,046,370 | 223,936 | 54,690,617 |
| Dolphins | 20,710,394 | 1,167,670 | 33,206 | 21,911,271 |
| Orcas | 37,611,837 | 2,475,628 | 4,748 | 40,092,212 |
| Whales | 46,971,371 | 2,468,937 | 150,251 | 49,590,559 |
| Steemit Account | 65,963,193 | 0 | 0 | 65,963,193 |
| TOTAL | 191,910,927 | 61,888,621 | 1,188,325 | 254,987,873 |
| 75.3% | 24.3% | 0.5% | 100.0% |
A few points to note:
The user classification is based on Steem Power, which means that investor accounts that hold Liquid Steem but no Steem Power, as well as the exchange accounts such as Bittrex and Poloniex, get classified as minnows, or redfish despite their huge holdings of Liquid Steem.
As can be seen, almost a quarter of the Steem currency is held as Liquid Steem. This is mainly on cryptocurrency exchanges: 27m is held by Bittrex and 15m by Poloniex. The remainder is most likely in the accounts of investors who are not otherwise participating in the Steem environment but do not want their Steem held on an exchange. The amount of Steem held in Savings is now small.
How does this compare to the position of the previous analysis carried out at end November?
Breakdown of Steem Currency
Figures derived as at end of 29-11-2017
| Steem Power | Liquid Steem | Steem in Savings | Total Steem | |
|---|---|---|---|---|
| Redfish | 9,811,648 | 10,817,879 | 720,103 | 21,349,631 |
| Minnows | 8,301,197 | 40,848,354 | 225,575 | 49,375,126 |
| Dolphins | 19,104,950 | 1,469,060 | 54,766 | 20,628,776 |
| Orcas | 36,236,079 | 5,280,349 | 71,651 | 41,588,080 |
| Whales | 43,969,481 | 1,969,959 | 180,014 | 46,119,454 |
| Steemit Account | 71,296,692 | 4 | 3,372,916 | 74,669,612 |
| TOTAL | 188,720,047 | 60,385,607 | 4,625,025 | 253,730,679 |
| 74.4% | 23.8% | 1.8% | 100.0% |
- Overall the position is broadly similar. The amount of Steem held as Steem Power has increased from 74.4% to 75.3%, an amount of just over 3m Steem but not a huge movement overall.
- There has been an increase in Steem Power at all user levels (except for the
account which has begun to power down). This could be due to an increase in new accounts at lower levels, a gradual accumulation of power by smaller accounts, or increased delegation from larger accounts. A separate study would be required to fully investigate this topic.
- A brief examination of the flow of currency in the
, the account used to support various Steem blockchain projects.
- The amount of Liquid Steem on the two main exchanges has increased with a shift towards Bittrex. The previous figures were Bittrex 20m and Poloniex 19m.
- The amount of Steem in Savings has reduced substantially due to the Steemit account liquidation of their holding.
4 What proportion of Steem Power is used for voting
Whilst the overall pattern of Steem Power and Liquid Steem held has not changed significantly, has there been a change in the amount of Steem Power used to vote?
Figures derived for week of 12th - 18th January 2018
| Steem Power | SP-up vote % | SP-down vote % | |
|---|---|---|---|
| Redfish | 11,233,821 | 12% | -0% |
| Minnows | 9,420,311 | 49% | -0% |
| Dolphins | 20,710,394 | 67% | -1% |
| Orcas | 37,611,837 | 65% | -5% |
| Whales | 46,971,371 | 42% | -2% |
| Steemit Account | 65,963,193 | 0% | 0% |
| TOTAL | 191,910,927 | 33% | -1.5% |
The table below shows that only around 33% of available Steem Power was actually used for upvoting in the week analysed. This equates to approximately 25% of total circulating Steem. Around 1.5% of available Steem Power was used to return rewards to the reward pool through downvoting.
Figures derived for week of 23rd - 29th November 2017
| Steem Power | SP-up vote % | SP-down vote % | |
|---|---|---|---|
| Redfish | 9,811,648 | 13% | -0% |
| Minnows | 8,301,197 | 54% | -2% |
| Dolphins | 19,104,950 | 73% | -2% |
| Orcas | 36,236,079 | 78% | -3% |
| Whales | 43,969,481 | 43% | -3% |
| Steemit Account | 71,296,692 | 0% | 0% |
| TOTAL | 188,720,047 | 35% | -1.5% |
The figures show that, despite the very significant increases in rewards available in January with the higher SBD and Steem prices, the amount of Steem Power used for voting has actually decreased slightly, from 35% (26% overall) to 33% (25% overall). This is really quite surprising.
It is also noticeable that, despite the current spate of downvoting on the platform, the overall level of power used to return rewards to the reward pool is broadly unchanged.
Based on the above we can update the visualisation of the breakdown as follows:
Conclusions:
- Despite the significant changes in the Steem environment with the increased level of rewards available, the overall financial breakdown of the Steem currency and level of voting are both broadly unchanged.
- Whilst the increase in the percentage of Steem currency Powered-Up was slight, the overall percentage - 75% - remains at a high level, illustrating significant commitment to the blockchain from users.
As in the November study, it remains true that approximately 25% of circulating Steem determines the allocation of rewards. Each vote is therefore worth around 4 times its potential theoretical value if all Steem participated in reward allocation.
5 Scripts
This was the SQL query used to generate the Accounts data per user from the Accounts table:
SELECT
Accounts.name AS [AccountName],
max(convert(decimal(20,0), left(Accounts.vesting_shares, len(Accounts.vesting_shares)-5))) as [VestingShares],
max(convert(decimal(20,0), left(Accounts.received_vesting_shares, len(Accounts.received_vesting_shares)-5))) as [ReceivedShares],
min(-convert(decimal(20,0), left(Accounts.delegated_vesting_shares, len(Accounts.delegated_vesting_shares)-5))) as [DelegatedShares],
max(convert(decimal(20,0), left(Accounts.vesting_shares, len(Accounts.vesting_shares)-5)) + convert(decimal(20,4), left(Accounts.received_vesting_shares, len(Accounts.received_vesting_shares)-5)) - convert(decimal(20,4), left(Accounts.delegated_vesting_shares, len(Accounts.delegated_vesting_shares)-5))) as [Vests],
max(convert(integer,Accounts.voting_power)) as [VotingPower]
FROM
Accounts (NOLOCK)
INNER join TxVotes (NOLOCK)
ON TxVotes.voter = Accounts.name
WHERE
convert(date, TxVotes.timestamp) >= ‘2018-01-12’ AND
convert(date, TxVotes.timestamp) <= ‘2018-01-18’
GROUP BY
Accounts.name
The TxVotes SQL query was similar to the above (same WHERE and GROUP BY clauses) but extracted data from the TxVotes table. It did not require the join to the Accounts table.
This was the SQL query used to generate the grouped summary from the Accounts table:
SELECT
Round(log10(IIF(convert(decimal(20,4), left(Accounts.vesting_shares, len(Accounts.vesting_shares)-5)) - convert(decimal(20,4), left(Accounts.delegated_vesting_shares, len(Accounts.delegated_vesting_shares)-5)) + convert(decimal(20,4), left(Accounts.received_vesting_shares, len(Accounts.received_vesting_shares)-5)) < 1, 1, convert(decimal(20,4), left(Accounts.vesting_shares, len(Accounts.vesting_shares)-5)) - convert(decimal(20,4), left(Accounts.delegated_vesting_shares, len(Accounts.delegated_vesting_shares)-5)) + convert(decimal(20,4), left(Accounts.received_vesting_shares, len(Accounts.received_vesting_shares)-5)))),0,1) AS [FISH],
Count(Accounts.name) AS [NumberOFAccounts],
Sum(convert(decimal(20,4), left(Accounts.balance, len(Accounts.balance)-5))) AS [Steem],
Sum(convert(decimal(20,4), left(Accounts.savings_balance, len(Accounts.savings_balance)-5))) AS [SteemBalance],
Sum(convert(decimal(20,4), left(Accounts.sbd_balance, len(Accounts.sbd_balance)-3))) AS [SBDBalance],
Sum(convert(decimal(20,4), left(Accounts.savings_balance, len(Accounts.savings_balance)-5))) AS [SavingsBalance],
Sum(convert(decimal(20,4), left(Accounts.savings_sbd_balance, len(Accounts.savings_sbd_balance)-3))) AS [SavingsSBDBalance],
Sum(convert(decimal(20,4), left(Accounts.vesting_shares, len(Accounts.vesting_shares)-5))) AS [vesting_shares],
Sum(convert(decimal(20,4), left(Accounts.delegated_vesting_shares, len(delegated_vesting_shares)-5))) AS [delegated_vesting_shares],
Sum(convert(decimal(20,4), left(Accounts.received_vesting_shares, len(received_vesting_shares)-5))) AS [received_vesting_shares],
Sum(convert(decimal(20,4), left(Accounts.vesting_shares, len(Accounts.vesting_shares)-5)) - convert(decimal(20,4), left(Accounts.delegated_vesting_shares, len(Accounts.delegated_vesting_shares)-5)) + convert(decimal(20,4), left(Accounts.received_vesting_shares, len(Accounts.received_vesting_shares)-5))) AS [VESTS]
FROM
Accounts (NOLOCK)
GROUP BY
Round(log10(IIF(convert(decimal(20,4), left(Accounts.vesting_shares, len(Accounts.vesting_shares)-5)) - convert(decimal(20,4), left(Accounts.delegated_vesting_shares, len(Accounts.delegated_vesting_shares)-5)) + convert(decimal(20,4), left(Accounts.received_vesting_shares, len(Accounts.received_vesting_shares)-5)) < 1, 1, convert(decimal(20,4), left(Accounts.vesting_shares, len(Accounts.vesting_shares)-5)) - convert(decimal(20,4), left(Accounts.delegated_vesting_shares, len(Accounts.delegated_vesting_shares)-5)) + convert(decimal(20,4), left(Accounts.received_vesting_shares, len(Accounts.received_vesting_shares)-5)))),0,1)
ORDER by
Round(log10(IIF(convert(decimal(20,4), left(Accounts.vesting_shares, len(Accounts.vesting_shares)-5)) - convert(decimal(20,4), left(Accounts.delegated_vesting_shares, len(Accounts.delegated_vesting_shares)-5)) + convert(decimal(20,4), left(Accounts.received_vesting_shares, len(Accounts.received_vesting_shares)-5)) < 1, 1, convert(decimal(20,4), left(Accounts.vesting_shares, len(Accounts.vesting_shares)-5)) - convert(decimal(20,4), left(Accounts.delegated_vesting_shares, len(Accounts.delegated_vesting_shares)-5)) + convert(decimal(20,4), left(Accounts.received_vesting_shares, len(Accounts.received_vesting_shares)-5)))),0,1)
That's all for today. Thanks for reading!
Posted on Utopian.io - Rewarding Open Source Contributors