TOP 10 HP Delegators

in #delegations • 2 years ago

hpd.png

Hi guys!

In a DPOS Blockchain, delegations assume a relevant and essential role and Hive is no exception to the rule.
Two main types of delegation in Hive are

  • HP delegation (Hive Power)
  • Governance votes delegation (witnesses and proposals)
Today I will share with you the Top 10 HP delegators and the accounts receiving their delegations

For data collection I've used HiveSQL database and the follow queries

Query Top 10 Delegators
SELECT TOP 10 delegator, SUM (vests)
FROM Delegations  (NOLOCK)
GROUP BY delegator
ORDER BY SUM (vests) DESC
Query Vests to HP
SELECT hive_per_vest
    FROM DynamicGlobalProperties
Query Accounts receiving delegations
SELECT delegatee, vests
FROM Delegations  (NOLOCK)
WHERE delegator = 'delegator name'
GROUP BY delegatee, vests
ORDER BY vests DESC

I could made just one query to get delegators and accounts receiving delegation but I preferred to separate them to show both queries

1588511876842.png

Top 10 Delegators

DELEGATORVESTSHP
freedom23 100 000 000.0012 993 574.44
darthknight8 869 143 047.084 988 825.56
blocktrades6 998 610 390.743 936 665.16
mika3 967 699 030.142 231 800.55
jamesc3 210 623 858.811 805 951.52
elmerlin2 210 764 862.541 243 538.43
roadscape1 922 244 137.571 081 247.72
adm1 900 000 000.001 068 735.56
pharesim1 789 246 467.931 006 437.54
theycallmedan1 734 398 597.46975 586.03

1588511876842.png

Accounts receiving HP delegation from freedom
ACCOUNTVESTSHP
appreciator15 000 000 000.008 437 386.00
rocky15 000 000 000.002 812 462.00
bdvoter3 000 000 000.001 687 477.20
actifit100 000 000.0056 249.24
Accounts receiving HP delegation from darthknight
ACCOUNTVESTSHP
ocdb8 869 143 047.084 988 825.56
Accounts receiving HP delegation from blocktrades
ACCOUNTVESTSHP
buildawhale3 942 369 739.002 217 553.02
ocdb2 000 040 171.901 125 007.40
usainvote966 930 961.00543 891.32
janetedita44 543 870.7625 055.59
queen-silvia17 817 547.6710 022.24
agreste8 908 773.625 011.12
ahmadmangazap8 908 773.445 011.12
nftfrappe8 908 773.275 011.12
blocktrades.spk181 780.07102.25
Accounts receiving HP delegation from mika
ACCOUNTVESTSHP
ocdb8 869 143 047.084 988 825.56
Accounts receiving HP delegation from jamesc
ACCOUNTVESTSHP
resonator1 610 623 858.81905 963.68
v4vapid800 000 000.00449 993.92
canadian-coconut800 000 000.00449 993.92
Accounts receiving HP delegation from elmerlin
ACCOUNTVESTSHP
liketu2 210 764 862.541 243 538.43
Accounts receiving HP delegation from roadscape
ACCOUNTVESTSHP
ocd450 000 000.00253 121.58
ecency283 585 930.58159 514.93
s4s237 124 158.21133 380.54
acidyo207 306 733.12116 608.46
kommienezuspadt206 120 543.42115 941.24
hivegc193 105 093.84108 620.15
mbp174 283 559.6898 033.18
mustard133 976 144.0075 360.56
tarotbyfergus36 741 974.7320 667.08
Accounts receiving HP delegation from adm
ACCOUNTVESTSHP
abit1 200 000 000.00674 990.88
ocdb300 000 000.00168 747.72
oflyhigh100 000 000.0056 249.24
rivalhw100 000 000.0056 249.24
ace108100 000 000.0056 249.24
deanliu100 000 000.0056 249.24
Accounts receiving HP delegation from pharesim
ACCOUNTVESTSHP
curangel1 789 246 467.931 006 437.54
Accounts receiving HP delegation from theycallmedan
ACCOUNTVESTSHP
threespeak444 865 955.72250 233.72
poshtoken184 663 860.65103 872.02
trostparadox184 441 608.57103 747.00
eddiespino167 936 618.2194 463.07
aliento.love166 143 562.2293 454.49
ocd94 277 514.4053 030.39
swc-curation88 944 323.0550 030.51
votovzla51 643 650.4029 049.16
hivecuba50 169 388.1328 219.90
hivepakistan50 160 900.1328 215.13
mcsamm50 155 043.5128 211.83
hivemx45 622 690.9925 662.42
guurry12344 550 174.4925 059.13
traciyork28 492 105.6416 026.59
rubencress19 190 258.2210 794.37
romeskie18 590 768.6310 457.17
rosmiapure17 820 069.8010 023.65
hopestylist17 820 069.8010 023.65
codingdefined8 910 034.905 011.83

1588511876842.png

Thank for following me!

#hp #hive #dpos #hivesql #sql #blockchain
2 years ago in #delegations by
$5.46
  • Past Payouts $5.46
  • - Author $2.73
  • - Curators $2.72
76 votes
Reply 8
Sort:  
  • Trending
    • [-]
     2 years ago  

    https://leofinance.io/threads/view/doze/re-leothreads-upvafqcx
    The rewards earned on this comment will go directly to the people ( doze ) sharing the post on LeoThreads,LikeTu,dBuzz.

    $0.00
      Reply
      [-]
       2 years ago  

      Thanks for sharing this info!

      $0.00
        Reply
        [-]
         2 years ago (edited) 

        You're most welcome! Cheers buddy!
        !PIZZA

        $0.00
          Reply
          [-]
           2 years ago  

          PIZZA!

          $PIZZA slices delivered:
          @doze(1/5) tipped @mypathtofire

          $0.00
            Reply
            [-]
             2 years ago  

            Aha intresting thanks for sharing good day 🙏😊.have a great week ahead.
            One question, the image you provided is free to use 😁?

            $0.00
              Reply
              [-]
               2 years ago  

              Thanks!
              Yes you can take it ;)

              $0.00
                Reply
                [-]
                 2 years ago  

                Aha thanks it looks beautiful ❤️

                $0.00
                  Reply
                  [-]
                   2 years ago  

                  You're most welcome :)

                  $0.00
                    Reply