Analysis of the evolution of the delegated VESTS

in utopian-io •  6 years ago 

Link to the github repository
https://github.com/steemit/steem

1. INTRODUCTION

The delegation of VESTS represents the support (altruistic or interested ) to other accounts (personal or projects) so that they have more Steem Power which, as we know, provides more influence and the possibility of generating more rewards.

Depending on the activities and results of those accounts to which the VESTS have been delegated and also taking into account the circumstances of the kryptos-Steem ecosystem in the subsequent months, the received support can be maintained, withdrawn or increased.

This process of (1) support, (2) waiting for results and (3) evaluation of the results is repeated over time in periods of different lengths .

Previous analyzes made by other users

As these previous contributions focus on the Top Delegators and Delegatees accounts and on the undelegations from @steem, my objective is to show an overview of the evolution of delegations and undelegations with special interest in showing which is the state of the delegations in the present moment.

2. TABLES

I used Steem SQL to obtain the data presented in this analysis. There are two tables that I used to make the queries.

TxDelegateVestingShares

SELECT
delegator, delegatee, vesting_shares, timestamp
FROM
TxDelegateVestingShares

The contents of this table represent the updates of the delegated VESTS (delegations and delegations) indicating the updated amount, the delegator and the delegatee involved in the update.

Example using:
delegatee = "utopian-io"

Captura de pantalla 2018-11-06 a las 10.18.54.png

To know the total value of delegated VESTS for a certain delegatee/delegator (at a certain moment) , we must add the last update (at that certain moment) for all its delegators/delegatee.

Example using :
delegatee = "utopian-io"
timestamp: 05-Oct-2018

Captura de pantalla 2018-11-06 a las 10.40.35.png

Captura de pantalla 2018-11-06 a las 10.43.35.png

VOReturnVestingDelegations

This virtual operation occurs when the vesting_shares (or Steem Power) that has been previously delegated by an account to another account comes back the the original owner.

SELECT
account, amount, timestamp
FROM 
VOReturnVestingDelegations

Captura de pantalla 2018-11-06 a las 10.55.29.png

In this example @utopian-io has a delegator roll and therefore represent the withdrawals that the @utopian-io account has recovered from previous delegations.

3. ANALYSIS

What has been the evolution of the number of updates in the delegation?

Unique count (ID)

uniqueid.jpg

  • In recent months the trend in the number of updates has been decreasing since a "strange" maximum occurred in 2018-05.

What has been the evolution of the accumulated amount of delegated VESTS?

The following graph represents the amount of VESTS that was effectively delegated at the end of each month. VESTS are in Steem Power(k)

acumulado.jpg

  • Observing the evolution of the amount of delegated VESTS we see that it has been growing month by month throughout all the period. The highest growth occurred in the recent month of 2018-09 reaching an approximate value of 86 M VESTS (SP)

  • Regarding the strange peak in the number of updates in 2018-05 we see that it is not accompanied by a change in the number of accumulated VESTS in that month compared with the near months.

What monthly amounts of VESTS were Delegated and Undelegated ?

Resulting = Delegated- Undelegates R= D - U

By calculating the 'derivative' (difference between consecutive values) of the data in the previous graph we can know the Resulting (R) amount of VESTS involved in the monthly delegations/undelegations.

R - Resulting

flow.jpg

  • In this graph we can see more clearly the abnormally high value in the resulting amount of delegated VESTS in 2018-09.

Evolution of the Undelegated VESTS

retornada.jpg

  • Taking advantage of the information in the table *VOReturnVestingDelegations of the (U) Undelegated VESTS we can also know the amount of (D) Delegated VESTS .

D= R + U

Evolution of the Delegated / Undelegated VESTS

compuesta.jpg

  • In this chart I have represented the amounts of delegated VESTS in yellow and positive and the amounts of undelegated VESTS in red and negative.

  • So, the last increase in the cumulative amount of delegated VESTS in 2018-09 is therefore due to a comparatively LARGE amount of DELEGATED VESTS and a comparatively SMALL amount of UNDELEGATED VESTS in 2018-09.

All the trends simultaneously

simultaneas.jpg

Observing all the trends simultaneously we could say that:

  • In 2018-09 the accumulated amount of delegated VESTS has grown substantially due to the fact that the number of delegated VESTS has increased and the amount of undelegated VESTS has decreased.

  • However, this increase compensates for a certain growth relaxation in the previous months to reach a number of accumulated delegated VESTS that have been growing in a very stable way throughout the history of Steem.

  • I was surprised to find such stability in the growth of the accumulated delegated VESTS. I interpret it as a sign of constancy in action.

Analysis of users: DELEGATORS and DELEGATEES

Throughout all the period, the number of unique delegators and delegatees have been:

  • 22,021 delegators
  • 984,730 delegatees

TOP accounts

The accounts that currently handle the largest amounts of VESTS, such as delegators and delegatees, are summarized in the following table.

topdelegusers.jpg

Monthly evolution of the number of delegators who made updates

delegator.jpg

The highest peaks occurred in 2018-02 and 2018-04 with around 7k delegators.In the last months it has stabilized in a value of medium magnitude around 3.8k.

Monthly evolution of the number of affected delegatees

delegatee.jpg

  • It shows a great variability with values between 1 k and 597 k. This last maximum value occurred in 2018-05 from which it has decreased to the value of 100k in 2018-09.

  • Here seems to be the cause of the strange peak in the number of updates of the delegations in 2018-05. That is, in that period updates of delegated VESTS were made to an abnormally high amount of delegatee-accounts.

N. Delegatee / N.Delegator RATIO

ratio.jpg

  • Here you can clearly see the variability of the evolution of the ratio between delegatees/delegators that has had several of those high peaks reaching (130: 1) in 2018-05 currently standing at an approximate value of (30: 1).

  • This would indicate different phases in the behavior of the delegators as I indicated at the beginning as (1) Update support, (2) waiting for results and (3) evaluation of the results, Go to (1).

Average amounts of delegated VESTS (SP (k)) per user

dosradios.jpg

The average amounts of VESTS delegated by delegators and those received by delegates can give an idea of the type of relation between accounts.

  • When both ratios are high (delegators are delegating large amounts of VESTS and delegates are also receiving great averages) can be interpreted as moments of support/investment in project-accounts and we see that there were three major waves of this trend but all of them before 2017-12.

  • After this date the delegatees have received much smaller average quantities that can be interpreted as support/investment more in personal-accounts

  • Therefore, in the peaks of 2018-06 and 2018-09 there seems to be a trend in the form of waves of support/investment in personal-accounts in the form of delegated VESTS.

4. DATA SOURCE, DATES and TOOLS

DATA SOURCE

I have used SteemSQL, a publicly available Microsoft SQL database containing all the Steem blockchain data held and managed by @arcange.

DATES

  • Data extraction 2018-08-5
  • Submitting date 2018-11-10

ANALYSIS TOOL

I have used KNIME, a free and open-source data analytics, reporting and integration platform, to get, filter and manipulated data

KNIME WORKFLOW

Captura de pantalla 2018-11-06 a las 13.35.16.png

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Hey @sintoniz, great work! I'm wondering, are the delegations from the (pre-HF20) create_account_with_delegation operations included in the TxDelegateVestingShares table? If these are not, this could bias the results esp. for the @steem account creations. Now, with HF20, the first delegation operation to an account is really a "new" delegation while it was in most cases an update before.
Did you consider to treat account creators separately? @steem updates the delegation to accounts they created periodically whenever those earn own SP. I would expect that this practice could make a good share of the number of delegation updates?

Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.

To view those questions and the relevant answers related to your post, click here.


Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.
[utopian-moderator]

  ·  6 years ago (edited)

Thanks @crokkon! ,

Well, it seems that they were not included before the HF20!
I had assumed, wrongly, that the first update was this account-creation delegation.

I have tried to obtain that component of delegated VESTS to see how they would influence the previous results using the information in Account Creation and HF20 Changes by @paulag where these delegations are included for 2018 (Jan- Sep)

I have processed and represented this delegation component to compare it with the main component.
DELE1.jpg

The rectified graph for the Monthly Delegated VESTS shows a certain "offset" that decreases until both graphs converge in 2018-09 when the HF20 is activated.

rect.jpg

In the rectified graph for the accumulated delegated VESTS the "displacement" is more clearly perceived.

akum.jpg

So, the create_account_with_delegation component affect the figures but due it is relatively smaller values with the main component, its flatter appearance and its trend to zero, would not affect in essence the trends and their variations.

Thank you for your review, @crokkon! Keep up the good work!

Congratulations @sintoniz! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You received more than 500 upvotes. Your next target is to reach 1000 upvotes.

Click here to view your Board of Honor
If you no longer want to receive notifications, reply to this comment with the word STOP

Do not miss the last post from @steemitboard:

SteemFest3 and SteemitBoard - Meet the Steemians Contest

Support SteemitBoard's project! Vote for its witness and get one more award!

Hi @sintoniz!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your post is eligible for our upvote, thanks to our collaboration with @utopian-io!
Feel free to join our @steem-ua Discord server

Hey, @sintoniz!

Thanks for contributing on Utopian.
We’re already looking forward to your next contribution!

Get higher incentives and support Utopian.io!
Simply set @utopian.pay as a 5% (or higher) payout beneficiary on your contribution post (via SteemPlus or Steeditor).

Want to chat? Join us on Discord https://discord.gg/h52nFrV.

Vote for Utopian Witness!

Congratulations @sintoniz! You received a personal award!

1 Year on Steemit

Click here to view your Board of Honor

Support SteemitBoard's project! Vote for its witness and get one more award!

Congratulations @sintoniz! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 2 years!

You can view your badges on your Steem Board and compare to others on the Steem Ranking

Vote for @Steemitboard as a witness to get one more award and increased upvotes!