BitShares Forum

Main => General Discussion => Topic started by: bytemaster on November 11, 2014, 05:14:39 pm

Title: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: bytemaster on November 11, 2014, 05:14:39 pm
I would like to see a script + output that will identify the raw number of PTS that were donated and how much was given using the first input address as the source of the donation.

Note:  this is not an AGS allocation or daily amounts all amounts should be denominated in PTS.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: arhag on November 11, 2014, 05:45:56 pm
I don't get it. Isn't this (https://github.com/donSchoe/ags-parser) already what you are asking for?

Apparently it has already been used for agsexplorer.com.

The example output csv on the GitHub page seems to only run up to Feb 4, 2014 however. So, it requires running the pts_chain.rb script on a computer with a synchronized PTS daemon running.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: bytemaster on November 11, 2014, 05:48:27 pm
I don't get it. Isn't this (https://github.com/donSchoe/ags-parser) already what you are asking for?

Apparently it has already been used for agsexplorer.com.

The example output csv on the GitHub page seems to only run up to Feb 4, 2014 however. So, it requires running the pts_chain.rb script on a computer with a synchronized PTS daemon running.

This calculates AGS balances... I want to know how much total PTS each address gave without consideration for AGS daily accounting.   
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: arhag on November 11, 2014, 05:51:20 pm
I don't get it. Isn't this (https://github.com/donSchoe/ags-parser) already what you are asking for?

Apparently it has already been used for agsexplorer.com.

The example output csv on the GitHub page seems to only run up to Feb 4, 2014 however. So, it requires running the pts_chain.rb script on a computer with a synchronized PTS daemon running.

This calculates AGS balances... I want to know how much total PTS each address gave without consideration for AGS daily accounting.   

If you look at http://q39.qhor.net/ags/4/pts.csv.txt, you can see it also calculates the raw PTS donated.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: bytemaster on November 11, 2014, 05:52:33 pm
I don't get it. Isn't this (https://github.com/donSchoe/ags-parser) already what you are asking for?

Apparently it has already been used for agsexplorer.com.

The example output csv on the GitHub page seems to only run up to Feb 4, 2014 however. So, it requires running the pts_chain.rb script on a computer with a synchronized PTS daemon running.


This calculates AGS balances... I want to know how much total PTS each address gave without consideration for AGS daily accounting.   

If you look at http://q39.qhor.net/ags/4/pts.csv.txt, you can see it also calculates the raw PTS donated.

Great, can someone run that on the latest PTS blockchain for a full history?
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: Riverhead on November 11, 2014, 05:57:46 pm
I'll take a shot at it. My PTS wallet is up to date.

Sent from my SM-G900T using Tapatalk

Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: boombastic on November 11, 2014, 06:21:31 pm
I have all the donation records in db.  I can populate the list for you, tomorrow though.  It's 2:30am here and really getting sleepy.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: boombastic on November 11, 2014, 06:28:21 pm
Well, here you go

http://www1.agsexplorer.com/data/pts_donator_amount.txt (http://www1.agsexplorer.com/data/pts_donator_amount.txt)
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: Riverhead on November 11, 2014, 06:30:01 pm
Well, here you go

http://www1.agsexplorer.com/data/pts_donator_amount.txt (http://www1.agsexplorer.com/data/pts_donator_amount.txt)

Nice! If this is what you're looking for BM I'll stop my effort.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: boombastic on November 11, 2014, 06:32:20 pm
$100 BitUSD is way too much for this job.  It took literally seconds to accomplish it.  @Riverhead, you may help verify this data and share the bounty.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: Riverhead on November 11, 2014, 06:33:37 pm
$100 BitUSD is way too much for this job.  It took literally seconds to accomplish it.  @Riverhead, you may help verify this data and share the bounty.

It took seconds for someone who knew were to find it. I say he gets the bounty :).

I'll try and run the script against the updated blockchain and run a diff on the outputs.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: nomoreheroes7 on November 11, 2014, 06:44:26 pm
Yea, and if you ctrl+f, you can find your PTS address in the list!

Can I get a share of the bounty too?


 :D
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: bytemaster on November 11, 2014, 08:28:33 pm
$100 BitUSD is way too much for this job.  It took literally seconds to accomplish it.  @Riverhead, you may help verify this data and share the bounty.

I am sending $100 BitUSD to boombastic and you can share with Riverhead how you feel appropriate.   

I didn't realize this data was available at ags explorer.... good work.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: Stan on November 11, 2014, 08:31:40 pm
Looks like the total in this list is  415,218.03087392, for what it's worth.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: testz on November 11, 2014, 10:19:47 pm
Looks like the total in this list is  415,218.03087392, for what it's worth.

To be precise  :) total donation is 415,387.548021225 PTS:
http://cryptoseed.cloudapp.net:81/pts-genesis-to-81603.csv.txt

In the file you can find all donations to address PaNGELmZgzRQCKeEKM6ifgTqNkC4ceiAWw from genesis up to latest block (81603).

Scrypt https://github.com/testzcrypto/ags-parser fork of https://github.com/donSchoe/ags-parser with changes which was merged to donSchoe repo.

Update: This amount also confirmed by my block explorer http://ptsexplorer.cloudapp.net/
I cache this page because it's tooo slow to get from blockexplorer, cached version can be accessed here: http://cryptoseed.cloudapp.net:81/PaNGELmZgzRQCKeEKM6ifgTqNkC4ceiAWw-81603.html
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: arhag on November 11, 2014, 10:44:00 pm
Looks like the total in this list is  415,218.03087392, for what it's worth.

To be precise  :) total donation is 415,387.548021225 PTS:
http://cryptoseed.cloudapp.net:81/pts-genesis-to-81603.csv.txt

Well, to be even more precise, I'm not sure if you should be counting the small amounts donated for some reason after the AGS crowdfunding ended (after midnight UTC on July 20, 2014). In which case the total PTS donated to the AGS campaign would be 415,385.036921225 PTS. Then again, I'm not sure what exactly bytemaster wants to use this for, so perhaps including that extra 2.5111 PTS is appropriate. Or perhaps following the precedent here (https://bitsharestalk.org/index.php?topic=11084.msg145899#msg145899), we should actually subtract another 52.40579432 PTS that was donated by nasty scammers with PaNGEL lookalike addresses (giving a total of 415,332.631127 PTS).
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: boombastic on November 12, 2014, 08:16:52 am
Looks like the total in this list is  415,218.03087392, for what it's worth.

To be precise  :) total donation is 415,387.548021225 PTS:
http://cryptoseed.cloudapp.net:81/pts-genesis-to-81603.csv.txt

In the file you can find all donations to address PaNGELmZgzRQCKeEKM6ifgTqNkC4ceiAWw from genesis up to latest block (81603).

Scrypt https://github.com/testzcrypto/ags-parser fork of https://github.com/donSchoe/ags-parser with changes which was merged to donSchoe repo.

Update: This amount also confirmed by my block explorer http://ptsexplorer.cloudapp.net/
I cache this page because it's tooo slow to get from blockexplorer, cached version can be accessed here: http://cryptoseed.cloudapp.net:81/PaNGELmZgzRQCKeEKM6ifgTqNkC4ceiAWw-81603.html

Good work.  I am sharing $50 with you.  Fund sent.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: testz on November 12, 2014, 08:25:05 am
Looks like the total in this list is  415,218.03087392, for what it's worth.

To be precise  :) total donation is 415,387.548021225 PTS:
http://cryptoseed.cloudapp.net:81/pts-genesis-to-81603.csv.txt
...

Good work.  I am sharing $50 with you.  Fund sent.

Thanks, received.  :) Can you look what cause the difference between agsexplorer and my calculations?
415,387.548021225 PTS - 415,218.03087392 PTS = more than 150 PTS but out of AGS donation was only about 2.5 PTS:

Code: [Select]
"67357";"2014-07-20 10:20:23 UTC";"6ba92a936";"PuFq2aBz6pYCvYuQEWjeYBr3xpTJDTcWSB";"0.25";"0.25";"20000.0"
"67377";"2014-07-21 06:18:53 UTC";"775a1a7c0";"PojvGgfSmaxNis8FRSsNY9CqfEQJ5uuL9U";"0.25";"0.25";"20000.0"
"67402";"2014-07-22 06:51:16 UTC";"03b247db6";"PdMxt5D1o34eMMnuwmMJy4GpuCVbzcgbBQ";"0.25";"0.25";"20000.0"
"67427";"2014-07-23 06:45:21 UTC";"f3b00603e";"Pn943e8Avhrd3Sft4kaVfoiCyrY8wEeEgH";"0.25";"0.25";"20000.0"
"67427";"2014-07-23 06:45:21 UTC";"14c906c6d";"PbNx6V9Tr4D3Vt9jEeSkp2q9kpKRZxB1ot";"0.0001";"0.2501";"19992.00319872"
"67455";"2014-07-24 08:08:37 UTC";"caecc9da5";"Pcg2fvxT9DGriaibtWC8eBD8nzsnoCcuDG";"0.25";"0.25";"20000.0"
"67482";"2014-07-25 06:26:26 UTC";"95e9ed5dd";"Pss6Nbpbi4thZbTmQhctDb1ujeZEBRfFr3";"0.25";"0.25";"20000.0"
"67504";"2014-07-26 08:13:03 UTC";"7c3b7ccc8";"PiYK6BHXj6i7SeoD3oTZhTN9YxHvgexF36";"0.25";"0.25";"20000.0"
"67538";"2014-07-27 09:21:59 UTC";"ffb52a85e";"Po57rtseEF7fWJVFjwkXGEik2SebDAbzxB";"0.25";"0.25";"20000.0"
"67562";"2014-07-28 06:55:05 UTC";"6786a9b3c";"PsXBTGyD9cgJhoaawe31ynYibJEPpMtnAD";"0.25";"0.25";"20000.0"
"67579";"2014-07-29 06:44:42 UTC";"b0b133ef8";"PeQJcyvL4CdAFcEXNq6s6XE26n5e3jzvEt";"0.25";"0.25";"20000.0"
"72700";"2014-08-22 00:21:15 UTC";"a7e3d5184";"PYaYDXcTmbdnCCxYTYpN92sAEaLAsBG6ce";"0.01";"0.01";"500000.0"
"81492";"2014-10-30 16:24:49 UTC";"74c509a3a";"PmqFeWYHtGD6dcCj3RQ4zqbduz5kUEr821";"0.001";"0.001";"5000000.0"
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: boombastic on November 12, 2014, 08:36:31 am
The difference is 169.51714730501408 = 415_387.548021225 - 415_218.03087392

AGS donation stops at 2014-07-19 00:00:00 UTC, so your out of ags donation should include those on 07-19

Code: [Select]
48caa1bd49... 67317 2014-07-19 00:14:01 14.9599 273053.52706963 PTS
a0d6349b3b... 67317 2014-07-19 00:14:01 14.9599 273068.48696963 PTS
a6fba3183f... 67317 2014-07-19 00:14:01 0.33333333 273068.82030296 PTS
c8166300f2... 67317 2014-07-19 00:14:01 33 273101.82030296 PTS
fe37b3393f... 67317 2014-07-19 00:14:01 3.50291398 273105.32321694 PTS
9dea6bcc20... 67327 2014-07-19 06:46:53 0.25 273105.57321694 PTS
de51097d05... 67344 2014-07-19 22:57:48 100 273205.57321694 PTS
6ba92a9366... 67357 2014-07-20 10:20:23 0.25 273205.82321694 PTS
775a1a7c0f... 67377 2014-07-21 06:18:53 0.25 273206.07321694 PTS
03b247db62... 67402 2014-07-22 06:51:16 0.25 273206.32321694 PTS
14c906c6d0... 67427 2014-07-23 06:45:21 0.0001 273206.32331694 PTS
f3b00603e2... 67427 2014-07-23 06:45:21 0.25 273206.57331694 PTS
caecc9da5a... 67455 2014-07-24 08:08:37 0.25 273206.82331694 PTS
95e9ed5dd1... 67482 2014-07-25 06:26:26 0.25 273207.07331694 PTS
7c3b7ccc8b... 67504 2014-07-26 08:13:03 0.25 273207.32331694 PTS
ffb52a85e7... 67538 2014-07-27 09:21:59 0.25 273207.57331694 PTS
6786a9b3ca... 67562 2014-07-28 06:55:05 0.25 273207.82331694 PTS
b0b133ef8e... 67579 2014-07-29 06:44:42 0.25 273208.07331694 PTS
a7e3d5184e... 72700 2014-08-22 00:21:15 0.01 232208.08121694 PTS
74c509a3ab... 81492 2014-10-30 16:24:49 0.001 232208.08221694 PTS

Code: [Select]
14.9599+14.9599+0.33333333+33+3.50291398+0.25+100+0.25+0.25+0.25+0.0001+0.25+0.25+0.25+0.25+0.25+0.25+0.25+0.01+0.001 = 169.51714730999998
It's a match.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: testz on November 12, 2014, 08:52:42 am
...
It's a match.

Thanks!
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: bytemaster on November 12, 2014, 01:14:18 pm
I want all donations regardless of date. 
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: Riverhead on November 12, 2014, 01:23:47 pm

I see three possibilities here:

1) I3 wants to return PTS donations
2) They are preparing for an audit
3) They received a letter from the SEC.

While they can't say #3 if it's true they can say it's not #3 if it isn't that. So....here's hoping we don't hear <crickets>.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: Stan on November 12, 2014, 01:29:00 pm

I see three possibilities here:

1) I3 wants to return PTS donations
2) They are preparing for an audit
3) They received a letter from the SEC.

While they can't say #3 if it's true they can say it's not #3 if it isn't that. So....here's hoping we don't hear <crickets>.

No letter received.
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: Riverhead on November 12, 2014, 01:30:07 pm

No letter received.

 +5%
Title: Re: $100 BitUSD - Produce a list of all PTS donors and the amount they donated
Post by: testz on November 12, 2014, 02:34:56 pm
I want all donations regardless of date.

Here http://cryptoseed.cloudapp.net:81/pts-genesis-to-81603-sum.csv.txt
Summary: 10061 unique addresses, total: 415387.548021225 PTS