beneficiaries from DHF- begünstigte vom DHF

in Programming & Dev • 12 days ago

EN

A few days ago, okay, almost two weeks ago, @hive-124221 (Dogmingo) wanted to know who received the most from the DHF.

So who received HBD from hive.fund?
First, I searched for it in HiveQL in the TXTransfer table, but there were no transfers to be found there. So I looked to see which table might still contain this data and found the VOProposalPays table.

The query is very simple: just the sum of payments grouped by recipient and sorted by total:

SELECT 
   receiver, 
   SUM(payment) AS total_payment
FROM VOProposalPays
GROUP BY receiver
ORDER BY total_payment DESC;
RecipientTotal payment
steem.dao170113750.956
hbdstabilizer107005695.165
valueplan3456746.872
keychain801688.376
howo620679.469
ecency607306.734
peak.open588499.69
splinterlands415507.62
vsc.network400,586.474
spkproposal377,152.279
disregardfiat251,051.894
hiveauth235,492.477
leofinance231,166.698
hivewatchers225,880.205
fund.dbuzz212,693.899
blocktrades204,230.00
hivechain.app193,676.008
peak.proposals177,384.182
hivesql174,687.863
hive.multisig162,594.929
lordbutterfly155,977.295
imwatsi152,388.462
v4vapp.dhf138,762.314
actifit.funds126,744.878
hdev.fund105007.617
engrave.cold90000.104
hashkings70113.946
netuoso65911.883
fullalt.dhf61554.486
good-karma59544.478
deathwing50825.493
martibis34736.306
blockanarchist134539.53
mahdiyari31726.991
hivedebitfund31452.552
detlev30516.368
justineh29910.70
vimm.dhf27202.856
fridaybot25456.746
ilysarazom24989.934
inertia23240.502
sbdpotato21132.95
hivefest18985.623
hivecreators17640.66
steem-keychain16619.32
zyptoapp15158.972
amgr10999.824
worldmappin7946.274
fundacoven7149.413
pettycash6984.592
podping6615.90
superhive5998.383
steemonboarding5861.46
latino.romano4999.92
themarkymark4353.914
hivesearcher4056.451
openseed3956.20
anyx3790.831
steemchiller3635.412
brofund2999.952
hive.loans1872.792
spaminator1214.096
vimm1164.534
haveyoubeenhere1107.614
dapplr982,182
esteemapp969,674
hive-woodpeckers530,40
fabien466,962
stemsocial-dev329,472
poshbot269.36
smooth139,992
emrebeyler43,413
steem-plus18,729
steemitworldmap5,414

Important

These are only the payments from hive.fund to the corresponding accounts. Regardless of what happens to the HBD and whether there were any repayments! steem.dao is the return proposal, if I'm not mistaken.

This is for the entire term, here is another query for 2025, i.e. ~7 months:

SELECT 
    receiver, 
    SUM(payment) AS total_payment
FROM VOProposalPays
where year(timestamp)=2025
GROUP BY receiver
ORDER BY total_payment DESC;
RecipientTotal payment
steem.dao46099840.871
hbdstabilizer2398502.912
valueplan617789.161
vsc.network183218.987
keychain127400.16
hdev.fund82810.104
ecency82153.604
howo71,958.504
peak.open67,429.552
disregardfiat48,051.033
splinterlands47,208.864
hivedebitfund31,618.812
vimm.dhf23992.00
hivewatchers20169.992
zyptoapp15158.972
detlev13926.765
worldmappin8084.399
mahdiyari5106.643
actifit.funds3219.888
leofinance1940.21
hive-woodpeckers530.40
hivesql135.00

Translated with DeepL.com (free version)

DE

Vor paar Tagen, Ok sind schon fast 2 Wochen, wollte @hive-124221 (Dogmingo) gerne wissen, wer am meisten aus dem DHF erhalten hat.

Wer hat also HBD von hive.fund erhalten?
Zunächst habe ich danach in HiveQL in der TXTransfer Tabelle gesucht, aber dort waren keine Transfers zu finden. Daher habe ich geschaut, welche Tabelle diese Daten noch beinhalten könnte und habe die Tabelle VOProposalPays gefunden.

Die Abfrage ist damit sehr simpel, einfach die Summe der Zahlungen gruppiert nach Empfänger und sortiert nach der Summe:

SELECT 
   receiver, 
   SUM(payment) AS total_payment
FROM VOProposalPays
GROUP BY receiver
ORDER BY total_payment DESC;
EmpfängerGesamtzahlung
steem.dao170113750,956
hbdstabilizer107005695,165
valueplan3456746,872
keychain801688,376
howo620679,469
ecency607306,734
peak.open588499,69
splinterlands415507,62
vsc.network400586,474
spkproposal377152,279
disregardfiat251051,894
hiveauth235492,477
leofinance231166,698
hivewatchers225880,205
fund.dbuzz212693,899
blocktrades204230,00
hivechain.app193676,008
peak.proposals177384,182
hivesql174687,863
hive.multisig162594,929
lordbutterfly155977,295
imwatsi152388,462
v4vapp.dhf138762,314
actifit.funds126744,878
hdev.fund105007,617
engrave.cold90000,104
hashkings70113,946
netuoso65911,883
fullalt.dhf61554,486
good-karma59544,478
deathwing50825,493
martibis34736,306
blockanarchist134539,53
mahdiyari31726,991
hivedebitfund31452,552
detlev30516,368
justineh29910,70
vimm.dhf27202,856
fridaybot25456,746
ilysarazom24989,934
inertia23240,502
sbdpotato21132,95
hivefest18985,623
hivecreators17640,66
steem-keychain16619,32
zyptoapp15158,972
amgr10999,824
worldmappin7946,274
fundacoven7149,413
pettycash6984,592
podping6615,90
superhive5998,383
steemonboarding5861,46
latino.romano4999,92
themarkymark4353,914
hivesearcher4056,451
openseed3956,20
anyx3790,831
steemchiller3635,412
brofund2999,952
hive.loans1872,792
spaminator1214,096
vimm1164,534
haveyoubeenhere1107,614
dapplr982,182
esteemapp969,674
hive-woodpeckers530,40
fabien466,962
stemsocial-dev329,472
poshbot269,36
smooth139,992
emrebeyler43,413
steem-plus18,729
steemitworldmap5,414

Wichtig

Dies sind nur die Zahlungen aus dem hive.fund an die entsprechenden Accounts. Unabhängig, was mit den HBD dann passiert und ob es ggf. auch Rückzahlungen gab! steem.dao ist das Return Proposal wenn ich mich nicht täusche.

Das ist über die gesamte Laufzeit, hier noch eine Abfrage für 2025, also ~7 Monate:

SELECT 
   receiver, 
   SUM(payment) AS total_payment
FROM VOProposalPays
where year(timestamp)=2025
GROUP BY receiver
ORDER BY total_payment DESC;
EmpfängerGesamtzahlung
steem.dao46099840,871
hbdstabilizer2398502,912
valueplan617789,161
vsc.network183218,987
keychain127400,16
hdev.fund82810,104
ecency82153,604
howo71958,504
peak.open67429,552
disregardfiat48051,033
splinterlands47208,864
hivedebitfund31618,812
vimm.dhf23992,00
hivewatchers20169,992
zyptoapp15158,972
detlev13926,765
worldmappin8084,399
mahdiyari5106,643
actifit.funds3219,888
leofinance1940,21
hive-woodpeckers530,40
hivesql135,00

Posted Using INLEO

#hive #coding #deutsch #hive-engine #alive #hive-coding #pob #dev
12 days ago in Programming & Dev by
100%
    -100%

      Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

      • Disagreement on rewards
      • Fraud or plagiarism
      • Hate speech or trolling
      • Miscategorized content or spam

      Submit
      0.00 ALIVE
        70 votes
        Reply 1
        Sort:  
      • Trending
        • [-]
         9 days ago 

        Congratulations @hive-coding! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s)

        You distributed more than 9000 upvotes.
        Your next target is to reach 10000 upvotes.

        You can view your badges on your board and compare yourself to others in the Ranking
        If you no longer want to receive notifications, reply to this comment with the word STOP

        Check out our last posts:

        Our Hive Power Delegations to the July PUM Winners
        Feedback from the August Hive Power Up Day
        Hive Power Up Month Challenge - July 2025 Winners List
        100%
          -100%

            Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

            • Disagreement on rewards
            • Fraud or plagiarism
            • Hate speech or trolling
            • Miscategorized content or spam

            Submit
            0.00 ALIVE
              Reply