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;
| Recipient | Total payment |
|---|---|
| steem.dao | 170113750.956 |
| hbdstabilizer | 107005695.165 |
| valueplan | 3456746.872 |
| keychain | 801688.376 |
| howo | 620679.469 |
| ecency | 607306.734 |
| peak.open | 588499.69 |
| splinterlands | 415507.62 |
| vsc.network | 400,586.474 |
| spkproposal | 377,152.279 |
| disregardfiat | 251,051.894 |
| hiveauth | 235,492.477 |
| leofinance | 231,166.698 |
| hivewatchers | 225,880.205 |
| fund.dbuzz | 212,693.899 |
| blocktrades | 204,230.00 |
| hivechain.app | 193,676.008 |
| peak.proposals | 177,384.182 |
| hivesql | 174,687.863 |
| hive.multisig | 162,594.929 |
| lordbutterfly | 155,977.295 |
| imwatsi | 152,388.462 |
| v4vapp.dhf | 138,762.314 |
| actifit.funds | 126,744.878 |
| hdev.fund | 105007.617 |
| engrave.cold | 90000.104 |
| hashkings | 70113.946 |
| netuoso | 65911.883 |
| fullalt.dhf | 61554.486 |
| good-karma | 59544.478 |
| deathwing | 50825.493 |
| martibis | 34736.306 |
| blockanarchist1 | 34539.53 |
| mahdiyari | 31726.991 |
| hivedebitfund | 31452.552 |
| detlev | 30516.368 |
| justineh | 29910.70 |
| vimm.dhf | 27202.856 |
| fridaybot | 25456.746 |
| ilysarazom | 24989.934 |
| inertia | 23240.502 |
| sbdpotato | 21132.95 |
| hivefest | 18985.623 |
| hivecreators | 17640.66 |
| steem-keychain | 16619.32 |
| zyptoapp | 15158.972 |
| amgr | 10999.824 |
| worldmappin | 7946.274 |
| fundacoven | 7149.413 |
| pettycash | 6984.592 |
| podping | 6615.90 |
| superhive | 5998.383 |
| steemonboarding | 5861.46 |
| latino.romano | 4999.92 |
| themarkymark | 4353.914 |
| hivesearcher | 4056.451 |
| openseed | 3956.20 |
| anyx | 3790.831 |
| steemchiller | 3635.412 |
| brofund | 2999.952 |
| hive.loans | 1872.792 |
| spaminator | 1214.096 |
| vimm | 1164.534 |
| haveyoubeenhere | 1107.614 |
| dapplr | 982,182 |
| esteemapp | 969,674 |
| hive-woodpeckers | 530,40 |
| fabien | 466,962 |
| stemsocial-dev | 329,472 |
| poshbot | 269.36 |
| smooth | 139,992 |
| emrebeyler | 43,413 |
| steem-plus | 18,729 |
| steemitworldmap | 5,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;
| Recipient | Total payment |
|---|---|
| steem.dao | 46099840.871 |
| hbdstabilizer | 2398502.912 |
| valueplan | 617789.161 |
| vsc.network | 183218.987 |
| keychain | 127400.16 |
| hdev.fund | 82810.104 |
| ecency | 82153.604 |
| howo | 71,958.504 |
| peak.open | 67,429.552 |
| disregardfiat | 48,051.033 |
| splinterlands | 47,208.864 |
| hivedebitfund | 31,618.812 |
| vimm.dhf | 23992.00 |
| hivewatchers | 20169.992 |
| zyptoapp | 15158.972 |
| detlev | 13926.765 |
| worldmappin | 8084.399 |
| mahdiyari | 5106.643 |
| actifit.funds | 3219.888 |
| leofinance | 1940.21 |
| hive-woodpeckers | 530.40 |
| hivesql | 135.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änger | Gesamtzahlung |
|---|---|
| steem.dao | 170113750,956 |
| hbdstabilizer | 107005695,165 |
| valueplan | 3456746,872 |
| keychain | 801688,376 |
| howo | 620679,469 |
| ecency | 607306,734 |
| peak.open | 588499,69 |
| splinterlands | 415507,62 |
| vsc.network | 400586,474 |
| spkproposal | 377152,279 |
| disregardfiat | 251051,894 |
| hiveauth | 235492,477 |
| leofinance | 231166,698 |
| hivewatchers | 225880,205 |
| fund.dbuzz | 212693,899 |
| blocktrades | 204230,00 |
| hivechain.app | 193676,008 |
| peak.proposals | 177384,182 |
| hivesql | 174687,863 |
| hive.multisig | 162594,929 |
| lordbutterfly | 155977,295 |
| imwatsi | 152388,462 |
| v4vapp.dhf | 138762,314 |
| actifit.funds | 126744,878 |
| hdev.fund | 105007,617 |
| engrave.cold | 90000,104 |
| hashkings | 70113,946 |
| netuoso | 65911,883 |
| fullalt.dhf | 61554,486 |
| good-karma | 59544,478 |
| deathwing | 50825,493 |
| martibis | 34736,306 |
| blockanarchist1 | 34539,53 |
| mahdiyari | 31726,991 |
| hivedebitfund | 31452,552 |
| detlev | 30516,368 |
| justineh | 29910,70 |
| vimm.dhf | 27202,856 |
| fridaybot | 25456,746 |
| ilysarazom | 24989,934 |
| inertia | 23240,502 |
| sbdpotato | 21132,95 |
| hivefest | 18985,623 |
| hivecreators | 17640,66 |
| steem-keychain | 16619,32 |
| zyptoapp | 15158,972 |
| amgr | 10999,824 |
| worldmappin | 7946,274 |
| fundacoven | 7149,413 |
| pettycash | 6984,592 |
| podping | 6615,90 |
| superhive | 5998,383 |
| steemonboarding | 5861,46 |
| latino.romano | 4999,92 |
| themarkymark | 4353,914 |
| hivesearcher | 4056,451 |
| openseed | 3956,20 |
| anyx | 3790,831 |
| steemchiller | 3635,412 |
| brofund | 2999,952 |
| hive.loans | 1872,792 |
| spaminator | 1214,096 |
| vimm | 1164,534 |
| haveyoubeenhere | 1107,614 |
| dapplr | 982,182 |
| esteemapp | 969,674 |
| hive-woodpeckers | 530,40 |
| fabien | 466,962 |
| stemsocial-dev | 329,472 |
| poshbot | 269,36 |
| smooth | 139,992 |
| emrebeyler | 43,413 |
| steem-plus | 18,729 |
| steemitworldmap | 5,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änger | Gesamtzahlung |
|---|---|
| steem.dao | 46099840,871 |
| hbdstabilizer | 2398502,912 |
| valueplan | 617789,161 |
| vsc.network | 183218,987 |
| keychain | 127400,16 |
| hdev.fund | 82810,104 |
| ecency | 82153,604 |
| howo | 71958,504 |
| peak.open | 67429,552 |
| disregardfiat | 48051,033 |
| splinterlands | 47208,864 |
| hivedebitfund | 31618,812 |
| vimm.dhf | 23992,00 |
| hivewatchers | 20169,992 |
| zyptoapp | 15158,972 |
| detlev | 13926,765 |
| worldmappin | 8084,399 |
| mahdiyari | 5106,643 |
| actifit.funds | 3219,888 |
| leofinance | 1940,21 |
| hive-woodpeckers | 530,40 |
| hivesql | 135,00 |
Posted Using INLEO