Address Distribution

tiOfBaik

New Member
Mar 30, 2014
11
0
1
It strikes me VERY odd that this was not pre-tested to gauge the payout, and see how the launch would go. There's absolutely NO reason for this kind of error to have made it past even basic eyeball testing. Especially for someone with a financial advisor license.

I think it's worth putting a value on the launch for this "0.0000000% premine" currency, as it's advertized on the front page, i'll let the numbers speak for themselves.

The figures below are based on data from first 20000 blocks, (-11 blocks, because there were blocks where generation went to multiple addresses, and i was too lazy to parse that out)

so, here's the total coins generated in the first 20,000 blocks:

Code:
mysql> select sum(val) from generation;
+--------------------+
| sum(val)           |
+--------------------+
| 3381934.3863182700 |
+--------------------+
1 row in set (0.01 sec)
yup, that's 3.38 million coin already out there. there are 3,863,314 coins now (according to coinmarketcap) that's 87% within the first month.


1.5 million of that consists of 500 DRK payouts within the first 4000 or so blocks
block 4000 = 2014-01-19 18:46:28
block 0 = 2014-01-19 01:40:18

Code:
mysql> select sum(val) from generation where val = 500;
+--------------------+
| sum(val)           |
+--------------------+
| 1521000.0000000000 |
+--------------------+
1 row in set (0.01 sec)
so that's 1.5 mil in approx 17 hours.
~ 88k DRK / hour
at the current exchange rate based off cryptsy (.0014 BTC per DRK) that comes out to:
123 BTC per hour * 460 USD/BTC (wow, btc has fallen) = $56000-ish / hour

that's not a bad payout.


here is the top 20 addresses in the first 20 thousand blocks (full list here: http://pastebin.com/Ps0UgaZK ~3900 records)

Code:
mysql> select dest_addr, sum(val) from generation group by 1 order by 2 desc limit 20;
+------------------------------------+-------------------+
| dest_addr                          | sum(val)          |
+------------------------------------+-------------------+
| myJgUmRWzB4j6Xo3TVUpRiFMuUxsMkta1v | 459412.7335851400 |
| n1LC1QgLpP5X7zHhMBfCx8KdU28jCFTcJ5 | 413520.4917303200 |
| mhSWBQegXRWN3q8yF9hhzan2qwTZ5S4ZVj | 373359.2557711200 |
| mtNVC6a45hxqfiMhjkr3QPqB3ifNefF2i5 | 203265.5540000000 |
| mq6yo8y7ksw4TKACDgFZTh8wMhUoiZiwGM |  23349.6890100000 |
| mkwhvzbK13Jy5waigXxZuNLDoa3aKN27Qj |  14824.0210000000 |
| mmTKhD4MpHbVbTVgRwuqktdFesNqyi72fu |  12939.0070000000 |
| n4ff9gwYQ2KmTrKHn5ji7Fh9LMng4pUkSh |  12662.0220000000 |
| mwZyhcTq2QGF6zMezCNUhWQfvbNAo5JT56 |  12608.0070000000 |
| myNqFXYMyk1CBxRQSAFE7vMd8B2hJq4Wi8 |  12493.0130000000 |
| mkm8Re2VGeDiQEMfc1hKZn9mL2TxPFY2do |  12270.0170000000 |
| mwMgX7tAxRPJ1t9a5nbm6v2Z6RtwQqVtpa |  12108.0030000000 |
| mqHD6T45wMLZbEYzrvGNHB4WwV3V8AZLhy |  11993.0070000000 |
| mu1d3cQ4AcSm8wXpdicETbPWuuYRZGtfEP |  11493.0170000000 |
| n4Chf2WY8HMM1DiabPgsqcxWpx3WQdegDS |  11439.0150000000 |
| mvvpcv7tVTFFfBJpcvN5iecjtRe5U5gXsn |  11439.0040000000 |
| moenmWaXCqrYsKhLmFdfpF4NfW3JZhkPe1 |  11324.0120000000 |
| mxXNfFMEBtiZRqnJCAZ55wMu7cG5mFCtPk |  10939.0030000000 |
| n1pRG4hVfY79SEgZFytE7MAcw8cgWJVLZn |  10662.0050000000 |
| mpe9sctxt9XUAQ2dbYhp7ALHtTJq3yry4A |  10493.0100000000 |
+------------------------------------+-------------------+
20 rows in set (0.00 sec)

I will gladly make the MySQL dump of this available to anybody who is curious to do their own statistics on it, it's far from complete, but obviously enough to show me the data presented above.
 

Propulsion

The buck stops here.
Feb 26, 2014
1,008
467
183
Dash Address
XerHCGryyfZttUc6mnuRY3FNJzU1Jm9u5L
It strikes me VERY odd that this was not pre-tested to gauge the payout, and see how the launch would go. There's absolutely NO reason for this kind of error to have made it past even basic eyeball testing. Especially for someone with a financial advisor license.

I think it's worth putting a value on the launch for this "0.0000000% premine" currency, as it's advertized on the front page, i'll let the numbers speak for themselves.

The figures below are based on data from first 20000 blocks, (-11 blocks, because there were blocks where generation went to multiple addresses, and i was too lazy to parse that out)

so, here's the total coins generated in the first 20,000 blocks:

Code:
mysql> select sum(val) from generation;
+--------------------+
| sum(val)           |
+--------------------+
| 3381934.3863182700 |
+--------------------+
1 row in set (0.01 sec)
yup, that's 3.38 million coin already out there. there are 3,863,314 coins now (according to coinmarketcap) that's 87% within the first month.


1.5 million of that consists of 500 DRK payouts within the first 4000 or so blocks
block 4000 = 2014-01-19 18:46:28
block 0 = 2014-01-19 01:40:18

Code:
mysql> select sum(val) from generation where val = 500;
+--------------------+
| sum(val)           |
+--------------------+
| 1521000.0000000000 |
+--------------------+
1 row in set (0.01 sec)
so that's 1.5 mil in approx 17 hours.
~ 88k DRK / hour
at the current exchange rate based off cryptsy (.0014 BTC per DRK) that comes out to:
123 BTC per hour * 460 USD/BTC (wow, btc has fallen) = $56000-ish / hour

that's not a bad payout.


here is the top 20 addresses in the first 20 thousand blocks (full list here: http://pastebin.com/Ps0UgaZK ~3900 records)

Code:
mysql> select dest_addr, sum(val) from generation group by 1 order by 2 desc limit 20;
+------------------------------------+-------------------+
| dest_addr                          | sum(val)          |
+------------------------------------+-------------------+
| myJgUmRWzB4j6Xo3TVUpRiFMuUxsMkta1v | 459412.7335851400 |
| n1LC1QgLpP5X7zHhMBfCx8KdU28jCFTcJ5 | 413520.4917303200 |
| mhSWBQegXRWN3q8yF9hhzan2qwTZ5S4ZVj | 373359.2557711200 |
| mtNVC6a45hxqfiMhjkr3QPqB3ifNefF2i5 | 203265.5540000000 |
| mq6yo8y7ksw4TKACDgFZTh8wMhUoiZiwGM |  23349.6890100000 |
| mkwhvzbK13Jy5waigXxZuNLDoa3aKN27Qj |  14824.0210000000 |
| mmTKhD4MpHbVbTVgRwuqktdFesNqyi72fu |  12939.0070000000 |
| n4ff9gwYQ2KmTrKHn5ji7Fh9LMng4pUkSh |  12662.0220000000 |
| mwZyhcTq2QGF6zMezCNUhWQfvbNAo5JT56 |  12608.0070000000 |
| myNqFXYMyk1CBxRQSAFE7vMd8B2hJq4Wi8 |  12493.0130000000 |
| mkm8Re2VGeDiQEMfc1hKZn9mL2TxPFY2do |  12270.0170000000 |
| mwMgX7tAxRPJ1t9a5nbm6v2Z6RtwQqVtpa |  12108.0030000000 |
| mqHD6T45wMLZbEYzrvGNHB4WwV3V8AZLhy |  11993.0070000000 |
| mu1d3cQ4AcSm8wXpdicETbPWuuYRZGtfEP |  11493.0170000000 |
| n4Chf2WY8HMM1DiabPgsqcxWpx3WQdegDS |  11439.0150000000 |
| mvvpcv7tVTFFfBJpcvN5iecjtRe5U5gXsn |  11439.0040000000 |
| moenmWaXCqrYsKhLmFdfpF4NfW3JZhkPe1 |  11324.0120000000 |
| mxXNfFMEBtiZRqnJCAZ55wMu7cG5mFCtPk |  10939.0030000000 |
| n1pRG4hVfY79SEgZFytE7MAcw8cgWJVLZn |  10662.0050000000 |
| mpe9sctxt9XUAQ2dbYhp7ALHtTJq3yry4A |  10493.0100000000 |
+------------------------------------+-------------------+
20 rows in set (0.00 sec)

I will gladly make the MySQL dump of this available to anybody who is curious to do their own statistics on it, it's far from complete, but obviously enough to show me the data presented above.
LOL those are TESTNET ADDRESSES!

Edit: It seems http://explorer.darkcoin.io/ shows main net addresses starting with test net addresses prefix's.
 
Last edited by a moderator:

TanteStefana

Grizzled Member
Foundation Member
Mar 9, 2014
2,861
1,854
1,283
LOL those are TESTNET ADDRESSES!
LOL, I didn't even look at the data. Still there was a mistake in the beginning, but like I said, I think the coin has been spread out now better than a "fair launch" ever could have given it due to the low prices and many sales :)

But now the question, how did he get testnet addresses and not know it?
 

tiOfBaik

New Member
Mar 30, 2014
11
0
1
LOL, I didn't even look at the data. Still there was a mistake in the beginning, but like I said, I think the coin has been spread out now better than a "fair launch" ever could have given it due to the low prices and many sales :)

But now the question, how did he get testnet addresses and not know it?
pardon ?

this info is from darkcoin's explorer that puts the start of the data at 1:40 am Jan 19th:

Code:
mysql> select ts, id, reward from blocks order by id limit 15;
+---------------------+------+----------------+
| ts                  | id   | reward         |
+---------------------+------+----------------+
| 2014-01-19 01:40:18 |    0 |  50.0000000000 |
| 2014-01-19 03:54:41 |    1 | 500.0000000000 |
| 2014-01-19 03:54:46 |    2 | 500.0000000000 |
| 2014-01-19 03:55:01 |    3 | 500.0000000000 |
| 2014-01-19 03:55:10 |    4 | 500.0000000000 |
| 2014-01-19 03:55:13 |    5 | 500.0000000000 |
| 2014-01-19 03:55:22 |    6 | 500.0000000000 |
| 2014-01-19 03:55:23 |    7 | 500.0000000000 |
| 2014-01-19 03:55:24 |    8 | 500.0000000000 |
| 2014-01-19 03:55:24 |    9 | 500.0000000000 |
| 2014-01-19 03:55:25 |   10 | 500.0000000000 |
| 2014-01-19 03:55:34 |   11 | 500.0000000000 |
| 2014-01-19 03:55:38 |   12 | 500.0000000000 |
| 2014-01-19 03:55:40 |   13 | 500.0000000000 |
| 2014-01-19 03:56:31 |   14 | 500.0000000000 |
+---------------------+------+----------------+
15 rows in set (0.01 sec)
this >IS< the production block chain, and is part of reality.

what constitutes a testnet address ?
 

tiOfBaik

New Member
Mar 30, 2014
11
0
1
They're worthless. That is not the actual blockchain. The real addresses start with an X.

Here's a block explorer with the top 100 addresses.
http://chainz.cryptoid.info/drk/
this is false.

there appears to be two paths to the address:

for example, i'm part of a pool with payout going to:

XdjBEyPXHDnGd8XAM4ZVNdssc1TaYuToji (http://explorer.darkcoin.io/address/XdjBEyPXHDnGd8XAM4ZVNdssc1TaYuToji)
but if you take any of those amounts, and look at the block, the payout goes to miZHhmpc8XzwFJQCCkDeM2QQdfUbXw8D2U ( http://explorer.darkcoin.io/address/miZHhmpc8XzwFJQCCkDeM2QQdfUbXw8D2U )

so the address is slightly obfuscated.

please do compare those two links yourself, the history is identical, therefore two addresses are identical.
 

tiOfBaik

New Member
Mar 30, 2014
11
0
1
furthermore. an address from the "rich list" here (http://chainz.cryptoid.info/drk/), payments to top account can be traced back to block 3446, part of the production block chain. within about 4-5 steps.

simply because there's not a massive address at the top with tons of coin is not proof that a single person does not control 100 addresses where coins may be evenly divided, to hide in the long-ish tail.

I am curious, as to what this "testnet" address is, and why they can be found paying out to XgV8FpC6RhkLU1XAxG6yhwsypjvJVGTGez

just food for thought.
 

Propulsion

The buck stops here.
Feb 26, 2014
1,008
467
183
Dash Address
XerHCGryyfZttUc6mnuRY3FNJzU1Jm9u5L
You're correct with the initial payout of 500drk per block, but once again the addresses you listed are not main net addresses. Someone more technical will have to take it from here. I've reached my limit of intelligence about this.

Edit: I see what your saying, but I believe both you and I are wrong.
 

tiOfBaik

New Member
Mar 30, 2014
11
0
1
I believe what you are liking at, is the transactions, not the value of individual addresses. Individual addresses start with an X.
This address is the richest address currently.
http://chainz.cryptoid.info/drk/address.dws?77205.htm
indeed.

you are correct.

however.

you can see the same address on the "old" chain explorer here: http://explorer.darkcoin.io/address/XgV8FpC6RhkLU1XAxG6yhwsypjvJVGTGez

amount: 144327.085 from this transaction: http://explorer.darkcoin.io/tx/6ff52f0a2e3142749911b2ac31301d20f05147635c016eeba2711924101522fd#o0

which, if you look where that 144k is going is marked as : http://explorer.darkcoin.io/address/mmKEicdBH1y16BQCowm8gLQWrPwKPPLkGq

which is that "testnet" address format you were referring to.

now, the new explorer doesn't show this for the old style address: http://chainz.cryptoid.info/drk/search.dws?q=mmKEicdBH1y16BQCowm8gLQWrPwKPPLkGq but does for the new : http://chainz.cryptoid.info/drk/address.dws?XgV8FpC6RhkLU1XAxG6yhwsypjvJVGTGez.htm

this, however, is simple obfuscation, since unprivileged users can obviously get this information out of the old chain explorer with 100% matching amounts.

observe, i'll try to make this simple.

144k in http://explorer.darkcoin.io/address/XgV8FpC6RhkLU1XAxG6yhwsypjvJVGTGez account came from:
transaction http://explorer.darkcoin.io/tx/6ff52f0a2e3142749911b2ac31301d20f05147635c016eeba2711924101522fd#o0 from address http://explorer.darkcoin.io/address/mv4kPRyaxeaz7WTe8X1bK3wKtMonMMBssn

where 184214.658 was split into 144327.085 and 39887.568, the 184214.658 came from address http://explorer.darkcoin.io/address/mv4kPRyaxeaz7WTe8X1bK3wKtMonMMBssn at block http://explorer.darkcoin.io/block/0000000000f7a7cbf645f30cec1368d846ca52249c1607a8179eae2d4ec53d5f (24138), which, mind you, has a bunch of other HEFTY transactions, the entire block is half a million DRK !

anyway, the 184214.658 came from block 5695, tx: http://explorer.darkcoin.io/tx/069adae9a7b8a6d336cb1d7b769749ea08b7ff953fb0536c5b3b281c8d45aeca, in which 185214.658 was split into 1000.00 and 184214.658, with the 1000 drk going to address http://explorer.darkcoin.io/address/myt9g4yHTUpHGNTfqXy2uHD6tjnxChzqb9, but that's peanuts.
 

tiOfBaik

New Member
Mar 30, 2014
11
0
1
i forgot to mention, that if you keep following the money from that "mainnet address", eventually it leads you to this transaction: http://explorer.darkcoin.io/tx/634dcd5cc7f7a10f2a2216bd459e4e834bb9c60f478530461f27637e3eb61b0b#o0

where a bunch of the 500 DRK payouts converge from a single address to start the chain that eventually leads up to the "rich list" top.

this is the origination

eventually leading to generation of a 500 DRK payout:

via generation @ http://explorer.darkcoin.io/block/0000000de9e59ca3b8412323c576ef9fa4fad4e3cfe9cad52f5878839a213650 to http://explorer.darkcoin.io/address/mkjVR8MSReNRei6qLNHj54jir8UvMuSAoj
via http://explorer.darkcoin.io/tx/0c10a448f48ab84308908540889749cd1de75a256a982442920124f4ade76212#i0 to http://explorer.darkcoin.io/address/ms5edSDfQBkpULBsjUTZbNF2RYzByAi5Ai (180k received)

entire sum 186214.713 out via http://explorer.darkcoin.io/tx/634dcd5cc7f7a10f2a2216bd459e4e834bb9c60f478530461f27637e3eb61b0b#i0 to http://explorer.darkcoin.io/address/mfezrvAFS8mYspgvYCP7FPCstQ3soz2Wr3

186214.658 goes via http://explorer.darkcoin.io/tx/f18c3d547311f2aec9e649414bc0fe4156e20db8241d55b91f3fc9be5b23e3a8#i0
to mrSVschsHFsTH6B2TJbMdKUhcitpwJYFK2 (1000), and
http://explorer.darkcoin.io/address/n3eGmgSzJFmw1QhLCY2WpN3Ry3u95vJZhx ( 186214.658 )
100 blocks later (via http://explorer.darkcoin.io/tx/069adae9a7b8a6d336cb1d7b769749ea08b7ff953fb0536c5b3b281c8d45aeca#i0) , goes to myt9g4yHTUpHGNTfqXy2uHD6tjnxChzqb9 (1000), and
http://explorer.darkcoin.io/address/mv4kPRyaxeaz7WTe8X1bK3wKtMonMMBssn (184214.658)

that goes to (via http://explorer.darkcoin.io/tx/6ff52f0a2e3142749911b2ac31301d20f05147635c016eeba2711924101522fd#i0)

http://explorer.darkcoin.io/address/mmKEicdBH1y16BQCowm8gLQWrPwKPPLkGq which is the top address on rich list (not yet redeemed) (2-26)



49445.47029703 goes this way http://explorer.darkcoin.io/tx/f8fd201910ca03d356771d7cd8eef9eab12d174dbe5b44e7b9b146d53f32990b#i0 and branches off
 

DieCommieScum

Member
Mar 9, 2014
48
6
48
i forgot to mention, that if you keep following the money from that "mainnet address", eventually it leads you to this transaction: http://explorer.darkcoin.io/tx/634dcd5cc7f7a10f2a2216bd459e4e834bb9c60f478530461f27637e3eb61b0b#o0

where a bunch of the 500 DRK payouts converge from a single address to start the chain that eventually leads up to the "rich list" top.

this is the origination

eventually leading to generation of a 500 DRK payout:

via generation @ http://explorer.darkcoin.io/block/0000000de9e59ca3b8412323c576ef9fa4fad4e3cfe9cad52f5878839a213650 to http://explorer.darkcoin.io/address/mkjVR8MSReNRei6qLNHj54jir8UvMuSAoj
via http://explorer.darkcoin.io/tx/0c10a448f48ab84308908540889749cd1de75a256a982442920124f4ade76212#i0 to http://explorer.darkcoin.io/address/ms5edSDfQBkpULBsjUTZbNF2RYzByAi5Ai (180k received)

entire sum 186214.713 out via http://explorer.darkcoin.io/tx/634dcd5cc7f7a10f2a2216bd459e4e834bb9c60f478530461f27637e3eb61b0b#i0 to http://explorer.darkcoin.io/address/mfezrvAFS8mYspgvYCP7FPCstQ3soz2Wr3

186214.658 goes via http://explorer.darkcoin.io/tx/f18c3d547311f2aec9e649414bc0fe4156e20db8241d55b91f3fc9be5b23e3a8#i0
to mrSVschsHFsTH6B2TJbMdKUhcitpwJYFK2 (1000), and
http://explorer.darkcoin.io/address/n3eGmgSzJFmw1QhLCY2WpN3Ry3u95vJZhx ( 186214.658 )
100 blocks later (via http://explorer.darkcoin.io/tx/069adae9a7b8a6d336cb1d7b769749ea08b7ff953fb0536c5b3b281c8d45aeca#i0) , goes to myt9g4yHTUpHGNTfqXy2uHD6tjnxChzqb9 (1000), and
http://explorer.darkcoin.io/address/mv4kPRyaxeaz7WTe8X1bK3wKtMonMMBssn (184214.658)

that goes to (via http://explorer.darkcoin.io/tx/6ff52f0a2e3142749911b2ac31301d20f05147635c016eeba2711924101522fd#i0)

http://explorer.darkcoin.io/address/mmKEicdBH1y16BQCowm8gLQWrPwKPPLkGq which is the top address on rich list (not yet redeemed) (2-26)



49445.47029703 goes this way http://explorer.darkcoin.io/tx/f8fd201910ca03d356771d7cd8eef9eab12d174dbe5b44e7b9b146d53f32990b#i0 and branches off
You have absolutely zero clue what you are talking about, don't you?
 

LimLims

Member
Mar 13, 2014
103
21
68
here is the top 20 addresses in the first 20 thousand blocks (full list here: http://pastebin.com/Ps0UgaZK ~3900 records)

Code:
mysql> select dest_addr, sum(val) from generation group by 1 order by 2 desc limit 20;
+------------------------------------+-------------------+
| dest_addr                          | sum(val)          |
+------------------------------------+-------------------+
| myJgUmRWzB4j6Xo3TVUpRiFMuUxsMkta1v | 459412.7335851400 |
| n1LC1QgLpP5X7zHhMBfCx8KdU28jCFTcJ5 | 413520.4917303200 |
| mhSWBQegXRWN3q8yF9hhzan2qwTZ5S4ZVj | 373359.2557711200 |
| mtNVC6a45hxqfiMhjkr3QPqB3ifNefF2i5 | 203265.5540000000 |
| mq6yo8y7ksw4TKACDgFZTh8wMhUoiZiwGM |  23349.6890100000 |
| mkwhvzbK13Jy5waigXxZuNLDoa3aKN27Qj |  14824.0210000000 |
| mmTKhD4MpHbVbTVgRwuqktdFesNqyi72fu |  12939.0070000000 |
| n4ff9gwYQ2KmTrKHn5ji7Fh9LMng4pUkSh |  12662.0220000000 |
| mwZyhcTq2QGF6zMezCNUhWQfvbNAo5JT56 |  12608.0070000000 |
| myNqFXYMyk1CBxRQSAFE7vMd8B2hJq4Wi8 |  12493.0130000000 |
| mkm8Re2VGeDiQEMfc1hKZn9mL2TxPFY2do |  12270.0170000000 |
| mwMgX7tAxRPJ1t9a5nbm6v2Z6RtwQqVtpa |  12108.0030000000 |
| mqHD6T45wMLZbEYzrvGNHB4WwV3V8AZLhy |  11993.0070000000 |
| mu1d3cQ4AcSm8wXpdicETbPWuuYRZGtfEP |  11493.0170000000 |
| n4Chf2WY8HMM1DiabPgsqcxWpx3WQdegDS |  11439.0150000000 |
| mvvpcv7tVTFFfBJpcvN5iecjtRe5U5gXsn |  11439.0040000000 |
| moenmWaXCqrYsKhLmFdfpF4NfW3JZhkPe1 |  11324.0120000000 |
| mxXNfFMEBtiZRqnJCAZ55wMu7cG5mFCtPk |  10939.0030000000 |
| n1pRG4hVfY79SEgZFytE7MAcw8cgWJVLZn |  10662.0050000000 |
| mpe9sctxt9XUAQ2dbYhp7ALHtTJq3yry4A |  10493.0100000000 |
+------------------------------------+-------------------+
20 rows in set (0.00 sec)
I'd love to have a play with that mysql dump.

One thing you should probably change with your figures there is to restrict it to the period before the diff kicked in and block reward schedule changed (i.e. < block 4500).

I did a similar kind of analysis, but it was more of a manual effort clicking through each block payout from block 1 upwards, recording the big addresses that were mining from early on, until I got tired of clicking. I was aiming to reconstruct a timeline for when the earliest big addresses started mining. I did get somewhat different results to you, which may be an issue with my interpretation of the block explorer, or just a difference in our methodologies.

One thing I didn't understand were the crazy 10k+ "value out" entries from 4500 onwards: http://explorer.darkcoin.io/chain/DarkCoin?hi=4520&count=20

Anyway here's what I got:



raw text from the table:

DRK going into this addressaddressfirst block found by this addresstime first block found by this addressnote
---1/19/2014 3:50:00Darkcoin ANN OP posted
193,501mvXtXBaiK13LyJ2ipLNSSfFoNpAkpbxqTz11/19/2014 3:54:41
121,485mtGHbwq8yfqoSYFUTMRGrUdRe2EYA2T8Lh31/19/2014 3:55:01
157,500mrkKhxKQKZ82hKZQSRjAwoFePikAEYMXoe41/19/2014 3:55:10
157,500n1xNKMYNX4EqEwLeno1dSYhTBFy5tyGKj561/19/2014 3:55:22
8,610mpBjPcWRS5TP7nfsasVJjGnvnPsTAJsUdZ821/19/2014 3:58:38
----*NOTE* I stopped checking every block after block 200. I skipped ahead in intervals to check for any new big addresses, up to block 4000.
116,214miY6YcqrQrP7BMBCZEbNTC89MehkqDkuif9871/19/2014 4:32:53first block found may be inexact from here.
159,052mkrRSg1vsiTzfrZNK94dUhds8GKUCtm4t59881/19/2014 4:32:57
111,019mtYGCiKrz9pZb6W4LjczopwKrHrQnFnJaK18931/19/2014 6:15:03
109,972mpB3f5eikUT59x1eL3MTrTZ9rmQz2pDUjV23211/19/2014 7:14:08
117,513mzG8ECrTegLVJSnBsbPQT7i754Mhmq4mfR37781/19/2014 16:24:34
22,981miB7Bx1omsczJMfzzMrzuu3aVvedyWzU7124191/19/2014 7:55:28
 

tiOfBaik

New Member
Mar 30, 2014
11
0
1
You have absolutely zero clue what you are talking about, don't you?
Ahem ?

I think that demonstrating the ability to follow transactions through the block chain, ability to infer connections from facts in the chain, being able to present a rational argument without getting personal, and possessing the skills necessary to obtain this kind of data for the kind of analysis i've shown would puts me way above the zero clue line.
 

tiOfBaik

New Member
Mar 30, 2014
11
0
1
my figures only touch 20 thousand blocks, but it's easy enough to restrict stuff to whatever block you like, for example. this is the earliest addresses show up in the block chain:

here, for example, is a list of when the top addresses appear.

min(blocknum) column is when the address first appeared to have mined anything
max(blocknum) is the last time in my dataset the address mines anything.
count(1) is number of blocks found by the address.
mine, is the total amount mined in the 20000 blocks that i have.

Code:
mysql> select dest_addr, count(1), min(blocknum), max(blocknum), (select sum(val) from generation ig where ig.dest_addr = og.dest_addr) as mined from generation og group by dest_addr order by mined desc limit 15;
+------------------------------------+----------+---------------+---------------+-------------------+
| dest_addr                          | count(1) | min(blocknum) | max(blocknum) | mined             |
+------------------------------------+----------+---------------+---------------+-------------------+
| myJgUmRWzB4j6Xo3TVUpRiFMuUxsMkta1v |     4773 |          5342 |         20000 | 459412.7335851400 |
| n1LC1QgLpP5X7zHhMBfCx8KdU28jCFTcJ5 |     2946 |          3643 |         19558 | 413520.4917303200 |
| mhSWBQegXRWN3q8yF9hhzan2qwTZ5S4ZVj |     4978 |          8411 |         19999 | 373359.2557711200 |
| mtNVC6a45hxqfiMhjkr3QPqB3ifNefF2i5 |     1866 |          3951 |         19981 | 203265.5540000000 |
| mq6yo8y7ksw4TKACDgFZTh8wMhUoiZiwGM |      260 |          5315 |         19571 |  23349.6890100000 |
| mkwhvzbK13Jy5waigXxZuNLDoa3aKN27Qj |       35 |          2491 |          3954 |  14824.0210000000 |
| mmTKhD4MpHbVbTVgRwuqktdFesNqyi72fu |       29 |          2520 |          4161 |  12939.0070000000 |
| n4ff9gwYQ2KmTrKHn5ji7Fh9LMng4pUkSh |       28 |          2499 |          4205 |  12662.0220000000 |
| mwZyhcTq2QGF6zMezCNUhWQfvbNAo5JT56 |       27 |          2473 |          4288 |  12608.0070000000 |
| myNqFXYMyk1CBxRQSAFE7vMd8B2hJq4Wi8 |       29 |          2548 |          4376 |  12493.0130000000 |
| mkm8Re2VGeDiQEMfc1hKZn9mL2TxPFY2do |       29 |          2475 |          4492 |  12270.0170000000 |
| mwMgX7tAxRPJ1t9a5nbm6v2Z6RtwQqVtpa |       26 |          2516 |          4389 |  12108.0030000000 |
| mqHD6T45wMLZbEYzrvGNHB4WwV3V8AZLhy |       28 |          2468 |          4180 |  11993.0070000000 |
| mu1d3cQ4AcSm8wXpdicETbPWuuYRZGtfEP |       27 |          2519 |          4461 |  11493.0170000000 |
| n4Chf2WY8HMM1DiabPgsqcxWpx3WQdegDS |       26 |          2541 |          4356 |  11439.0150000000 |
+------------------------------------+----------+---------------+---------------+-------------------+

if you would like to see just stuff under the block number 4500, that is easily doable:

Code:
mysql> select dest_addr, count(1), min(blocknum), max(blocknum), (select sum(val) from generation ig where ig.dest_addr = og.dest_addr and ig.blocknum < 4500) as mined from generation og where og.blocknum < 4500 group by dest_addr order by mined desc limit 15;
+------------------------------------+----------+---------------+---------------+-------------------+
| dest_addr                          | count(1) | min(blocknum) | max(blocknum) | mined             |
+------------------------------------+----------+---------------+---------------+-------------------+
| n1LC1QgLpP5X7zHhMBfCx8KdU28jCFTcJ5 |      403 |          3643 |          4499 | 179200.3905000000 |
| mkwhvzbK13Jy5waigXxZuNLDoa3aKN27Qj |       35 |          2491 |          3954 |  14824.0210000000 |
| mmTKhD4MpHbVbTVgRwuqktdFesNqyi72fu |       29 |          2520 |          4161 |  12939.0070000000 |
| n4ff9gwYQ2KmTrKHn5ji7Fh9LMng4pUkSh |       28 |          2499 |          4205 |  12662.0220000000 |
| mwZyhcTq2QGF6zMezCNUhWQfvbNAo5JT56 |       27 |          2473 |          4288 |  12608.0070000000 |
| myNqFXYMyk1CBxRQSAFE7vMd8B2hJq4Wi8 |       29 |          2548 |          4376 |  12493.0130000000 |
| mkm8Re2VGeDiQEMfc1hKZn9mL2TxPFY2do |       29 |          2475 |          4492 |  12270.0170000000 |
| mwMgX7tAxRPJ1t9a5nbm6v2Z6RtwQqVtpa |       26 |          2516 |          4389 |  12108.0030000000 |
| mqHD6T45wMLZbEYzrvGNHB4WwV3V8AZLhy |       28 |          2468 |          4180 |  11993.0070000000 |
| mu1d3cQ4AcSm8wXpdicETbPWuuYRZGtfEP |       27 |          2519 |          4461 |  11493.0170000000 |
| n4Chf2WY8HMM1DiabPgsqcxWpx3WQdegDS |       26 |          2541 |          4356 |  11439.0150000000 |
| mvvpcv7tVTFFfBJpcvN5iecjtRe5U5gXsn |       26 |          2480 |          4293 |  11439.0040000000 |
| moenmWaXCqrYsKhLmFdfpF4NfW3JZhkPe1 |       28 |          2579 |          4401 |  11324.0120000000 |
| mxXNfFMEBtiZRqnJCAZ55wMu7cG5mFCtPk |       25 |          2493 |          4301 |  10939.0030000000 |
| n1pRG4hVfY79SEgZFytE7MAcw8cgWJVLZn |       24 |          2469 |          4280 |  10662.0050000000 |
+------------------------------------+----------+---------------+---------------+-------------------+
15 rows in set (0.06 sec)
can't look up these addresses in block explorer because of "too many records", but the blockchain does not lie.

n1LC1QgLpP5X7zHhMBfCx8KdU28jCFTcJ5 mined 403 blocks, between block 3643 and 4499 for a total of 179k DRK.

3643 | 2014-01-19 14:56:38
4499 | 2014-01-20 12:03:01

75983 seconds between those two blocks.

179200.3905000000 / (75983 / 3600) = 8490.33870506783207 DRK per hour.

at the current exchange rate, that's almost ~11 BTC an hour, which at a ~$460/btc is ~$5000 an hour.


the "crazy 10k+ value out from 4500 onward" is all the instamine stuff being transfered out and split into smaller chunks, and just transactions happening. 10k+ is not crazy, cause there was a LOT of coin spilled

and those aren't that crazy, take for example these transactions where the instamine stuff converges on a single address.

http://explorer.darkcoin.io/block/0000000006586ffdc84c36dd4f2c869d01da4fbd49a632ef0432118d885fe357
http://explorer.darkcoin.io/block/000000000456af07b3589a897ce3e6746d01eee5b639be3914f2d7db711ff0d6
http://explorer.darkcoin.io/block/000000000d6e5cdbe5538e7686b200c1507de2dd1e4bfdf2ebe7c1e88f0c175d


i'd be more than glad to email you the mysqldump of this, pm me your email address.

I'd love to have a play with that mysql dump.

One thing you should probably change with your figures there is to restrict it to the period before the diff kicked in and block reward schedule changed (i.e. < block 4500).

I did a similar kind of analysis, but it was more of a manual effort clicking through each block payout from block 1 upwards, recording the big addresses that were mining from early on, until I got tired of clicking. I was aiming to reconstruct a timeline for when the earliest big addresses started mining. I did get somewhat different results to you, which may be an issue with my interpretation of the block explorer, or just a difference in our methodologies.

One thing I didn't understand were the crazy 10k+ "value out" entries from 4500 onwards: http://explorer.darkcoin.io/chain/DarkCoin?hi=4520&count=20

Anyway here's what I got:



raw text from the table:

DRK going into this addressaddressfirst block found by this addresstime first block found by this addressnote
---1/19/2014 3:50:00Darkcoin ANN OP posted
193,501mvXtXBaiK13LyJ2ipLNSSfFoNpAkpbxqTz11/19/2014 3:54:41
121,485mtGHbwq8yfqoSYFUTMRGrUdRe2EYA2T8Lh31/19/2014 3:55:01
157,500mrkKhxKQKZ82hKZQSRjAwoFePikAEYMXoe41/19/2014 3:55:10
157,500n1xNKMYNX4EqEwLeno1dSYhTBFy5tyGKj561/19/2014 3:55:22
8,610mpBjPcWRS5TP7nfsasVJjGnvnPsTAJsUdZ821/19/2014 3:58:38
----*NOTE* I stopped checking every block after block 200. I skipped ahead in intervals to check for any new big addresses, up to block 4000.
116,214miY6YcqrQrP7BMBCZEbNTC89MehkqDkuif9871/19/2014 4:32:53first block found may be inexact from here.
159,052mkrRSg1vsiTzfrZNK94dUhds8GKUCtm4t59881/19/2014 4:32:57
111,019mtYGCiKrz9pZb6W4LjczopwKrHrQnFnJaK18931/19/2014 6:15:03
109,972mpB3f5eikUT59x1eL3MTrTZ9rmQz2pDUjV23211/19/2014 7:14:08
117,513mzG8ECrTegLVJSnBsbPQT7i754Mhmq4mfR37781/19/2014 16:24:34
22,981miB7Bx1omsczJMfzzMrzuu3aVvedyWzU7124191/19/2014 7:55:28
 

LimLims

Member
Mar 13, 2014
103
21
68
if you would like to see just stuff under the block number 4500, that is easily doable:

Code:
mysql> select dest_addr, count(1), min(blocknum), max(blocknum), (select sum(val) from generation ig where ig.dest_addr = og.dest_addr and ig.blocknum < 4500) as mined from generation og where og.blocknum < 4500 group by dest_addr order by mined desc limit 15;
+------------------------------------+----------+---------------+---------------+-------------------+
| dest_addr                          | count(1) | min(blocknum) | max(blocknum) | mined             |
+------------------------------------+----------+---------------+---------------+-------------------+
| n1LC1QgLpP5X7zHhMBfCx8KdU28jCFTcJ5 |      403 |          3643 |          4499 | 179200.3905000000 |
| mkwhvzbK13Jy5waigXxZuNLDoa3aKN27Qj |       35 |          2491 |          3954 |  14824.0210000000 |
| mmTKhD4MpHbVbTVgRwuqktdFesNqyi72fu |       29 |          2520 |          4161 |  12939.0070000000 |
| n4ff9gwYQ2KmTrKHn5ji7Fh9LMng4pUkSh |       28 |          2499 |          4205 |  12662.0220000000 |
| mwZyhcTq2QGF6zMezCNUhWQfvbNAo5JT56 |       27 |          2473 |          4288 |  12608.0070000000 |
| myNqFXYMyk1CBxRQSAFE7vMd8B2hJq4Wi8 |       29 |          2548 |          4376 |  12493.0130000000 |
| mkm8Re2VGeDiQEMfc1hKZn9mL2TxPFY2do |       29 |          2475 |          4492 |  12270.0170000000 |
| mwMgX7tAxRPJ1t9a5nbm6v2Z6RtwQqVtpa |       26 |          2516 |          4389 |  12108.0030000000 |
| mqHD6T45wMLZbEYzrvGNHB4WwV3V8AZLhy |       28 |          2468 |          4180 |  11993.0070000000 |
| mu1d3cQ4AcSm8wXpdicETbPWuuYRZGtfEP |       27 |          2519 |          4461 |  11493.0170000000 |
| n4Chf2WY8HMM1DiabPgsqcxWpx3WQdegDS |       26 |          2541 |          4356 |  11439.0150000000 |
| mvvpcv7tVTFFfBJpcvN5iecjtRe5U5gXsn |       26 |          2480 |          4293 |  11439.0040000000 |
| moenmWaXCqrYsKhLmFdfpF4NfW3JZhkPe1 |       28 |          2579 |          4401 |  11324.0120000000 |
| mxXNfFMEBtiZRqnJCAZ55wMu7cG5mFCtPk |       25 |          2493 |          4301 |  10939.0030000000 |
| n1pRG4hVfY79SEgZFytE7MAcw8cgWJVLZn |       24 |          2469 |          4280 |  10662.0050000000 |
+------------------------------------+----------+---------------+---------------+-------------------+
15 rows in set (0.06 sec)
Shouldn't the mined column add up to roughtly 2M? Or are there a ton of addresses beyond these 15 that were mining in this period?
 

tiOfBaik

New Member
Mar 30, 2014
11
0
1
Shouldn't the mined column add up to roughtly 2M? Or are there a ton of addresses beyond these 15 that were mining in this period?
not with the dataset quoted, because of the limit 15 there at the end, you are only seeing top 15.
Code:
mysql> 
select dest_addr
     , count(1)
     , min(blocknum)
     , max(blocknum)
     , (select sum(val) from generation ig where ig.dest_addr = og.dest_addr and ig.blocknum < 4500) as mined
  from generation og
 where og.blocknum < 4500
 group by dest_addr
 order by mined desc
 limit 15;

here's the full dataset without the limit: http://pastebin.com/7EcSdxK4
and the check, to make sure data is sane (and adds up to what you mentioned) ~1992655.0480
Code:
mysql> select sum(mined) from (
    ->         select dest_addr
    ->              , count(1)
    ->              , min(blocknum)
    ->              , max(blocknum)
    ->              , (select sum(val) from generation ig where ig.dest_addr = og.dest_addr and ig.blocknum < 4500) as mined
    ->           from generation og
    ->          where og.blocknum < 4500
    ->          group by dest_addr
    ->          order by mined desc
    ->         ) a;
+--------------------+
| sum(mined)         |
+--------------------+
| 1992655.0480000000 |
+--------------------+
1 row in set (0.00 sec)
 

chaeplin

Active Member
Core Developer
Mar 29, 2014
749
356
133
http://drk.poolhash.org/who/20000.log

You can use this file for analysis.

20,000 blocks

height: 1 time 01-19 12:54:41 difficulty 0.00024414 nbits 1e0ffff0 subsidy 500 sum 500 add XtuVUju4Baaj7YXShQu4QbLLR7X2aw9Gc8
height: 2 time 01-19 12:54:46 difficulty 0.00024414 nbits 1e0ffff0 subsidy 500 sum 1000 add XbmPwcZCdaRMa4m4JedspBPkUqY1FKRhsX
height: 3 time 01-19 12:55:01 difficulty 0.00024414 nbits 1e0ffff0 subsidy 500 sum 1500 add XgfLsphG9KDGmyBEwHmBjMRYa8Hr7Yode5
height: 4 time 01-19 12:55:10 difficulty 0.00024414 nbits 1e0ffff0 subsidy 500 sum 2000 add XxYTj1hgGMx6X6PgFmTsq4zcMkhrSMczTJ
height: 5 time 01-19 12:55:13 difficulty 0.00024414 nbits 1e0ffff0 subsidy 500 sum 2500 add Xo9UzA2B7yyEhsrQZyFPGCTuFbNGKgHkPU
height: 6 time 01-19 12:55:22 difficulty 0.00024414 nbits 1e0ffff0 subsidy 500 sum 3000 add XmaHVRvUXiZruPwXrbvGuxBiXnSXBzMtof
height: 7 time 01-19 12:55:23 difficulty 0.00024414 nbits 1e0ffff0 subsidy 500 sum 3500 add Xp22uVtFEEJqkcHtLjKifcKt8AUFjWRYmu
 

chaeplin

Active Member
Core Developer
Mar 29, 2014
749
356
133
This is pool address

if address == 'Xemt2zeYELCkddJHvsW4x9ytqTEnkiviaH':
address = 'mininghub'
if address == 'XccPicDbg7HhRfFwPU3Z2CFVpHSYAhuxtu':
address = 'coinmine'
if address == 'Xd4Jv9fAf8NmgkJmmkoWXMi5JJPZdf4uUa':
address = 'suchpool'
if address == 'XdgnL33mHN2byuauHqJQHAsa3s8sYakSrF':
address = 'official'
if address == 'XoYNjJ8yEPkB3YUft5BtS1Je24eMgnAQXg':
address = 'cpupool'
if address == 'XxvFVwx5hZBouVRPu2WgBkahxnojVRRgK8':
address = 'lottery'
if address == 'XkGsLLY2uZiPq9HAMzbQVJcQL3Tnr5ibuv':
address = 'lottery'
if address == 'XvW5YcFFy4rrVpQfVW13yjo6SN7iKFHdF5':
address = 'smalltimeminer'
if address == 'XtUa1xzS8rr4UMv1bopfTKipspwrUvaBMp':
address = 'officialold'
 
Last edited by a moderator:

LimLims

Member
Mar 13, 2014
103
21
68
Ok, so going by that data, one address mined a whole bunch (179k) before the block reward reduced to 50 at block 4500, and a whole bunch more addresses mined smaller amounts (< 15k each) to make up the 2M. Which, if we were to read between the lines, might suggest there were multiple individuals mining, or perhaps a ton of EC2 instances being fired up at some point. We might even be able to roughly answer that by doing an analysis of the timing of when those addresses started mining.

The interesting part of that data (pending a deeper analysis) is there's nothing to directly suggest that only a few individuals were mining during that period.
 

tiOfBaik

New Member
Mar 30, 2014
11
0
1
you have to look at the convergence of those small 500 reward blocks in on a few addresses.

look at these transactions:

http://explorer.darkcoin.io/block/0000000006586ffdc84c36dd4f2c869d01da4fbd49a632ef0432118d885fe357
http://explorer.darkcoin.io/block/000000000456af07b3589a897ce3e6746d01eee5b639be3914f2d7db711ff0d6
http://explorer.darkcoin.io/block/000000000d6e5cdbe5538e7686b200c1507de2dd1e4bfdf2ebe7c1e88f0c175d


then find the addresses sending 500 DRK in several massive transactions to a few addresses, effectively making all the tiny 500 DRK reward addresses that do not repeat in the few blocks one person, or a group of people controlling enough nodes.
 

TanteStefana

Grizzled Member
Foundation Member
Mar 9, 2014
2,861
1,854
1,283
Ok, so here we sit. Nothing can be done about this. I'm not sure Evan even took this seriously when he started, now people have invested lots of money into this coin. And we have a weird history. I don't know. It would be great if someone had the energy to give a clear as possible history, but at the same time, what can be done? We're all invested in the coin, it's a great coin otherwise with a great developer with great ideas.

Like we've all said before, it's a matter of whether or not the big holders will be dumping their coin, and we think that would be illogical. Hopefully they have been selling off, someone has! In fact you never hear anyone saying "I just sold a bunch of dark" but you constantly hear people saying "I'm buying up dark" this suggests to me that a big holder has indeed been selling off his shares. Maybe this could be verified by someone following the trail? If that is what is happening, I can't imagine a better way to distribute those coins to the population at large. It's kept the price down so more people can invest in dark, which spreads the user base, which in tern will eventually make Darkcoin more valuable. We may have a very intelligent person holding large chunks of Darkcoin who is actually following concept of the enlightened self interest?

I would love to see someone follow the money trail, I can't do it, it'd require programming I think, my head hurts when I look at those charts, LOL. We'll only be able to follow them until DarkSend kicked in, but it'd still be interesting :)
 

TanteStefana

Grizzled Member
Foundation Member
Mar 9, 2014
2,861
1,854
1,283
you have to look at the convergence of those small 500 reward blocks in on a few addresses.
then find the addresses sending 500 DRK in several massive transactions to a few addresses, effectively making all the tiny 500 DRK reward addresses that do not repeat in the few blocks one person, or a group of people controlling enough nodes.
I may not be understanding, but that sounds like a pool started up? or? oh no, excuse me, now I understand :)
 

TanteStefana

Grizzled Member
Foundation Member
Mar 9, 2014
2,861
1,854
1,283
Wow, I'm following one of the trails and boy that person went through a lot of trouble to break up the amounts and create trails! One line continuing on with the majority of the funds! Like a tree with branches starting at the trunk!
 

chaeplin

Active Member
Core Developer
Mar 29, 2014
749
356
133
I saw this one page before.

Code:
mysql> select dest_addr, count(1), min(blocknum), max(blocknum), (select sum(val) from generation ig where ig.dest_addr = og.dest_addr) as mined from generation og group by dest_addr order by mined desc limit 15;
+------------------------------------+----------+---------------+---------------+-------------------+
| dest_addr | count(1) | min(blocknum) | max(blocknum) | mined |
+------------------------------------+----------+---------------+---------------+-------------------+
| myJgUmRWzB4j6Xo3TVUpRiFMuUxsMkta1v | 4773 | 5342 | 20000 | 459412.7335851400 |   ---> officialold
| n1LC1QgLpP5X7zHhMBfCx8KdU28jCFTcJ5 | 2946 | 3643 | 19558 | 413520.4917303200 |  --> smalltimeminer
| mhSWBQegXRWN3q8yF9hhzan2qwTZ5S4ZVj | 4978 | 8411 | 19999 | 373359.2557711200 |  ---> coinmine
| mtNVC6a45hxqfiMhjkr3QPqB3ifNefF2i5 | 1866 | 3951 | 19981 | 203265.5540000000 |   -->  cpupool
| mq6yo8y7ksw4TKACDgFZTh8wMhUoiZiwGM | 260 | 5315 | 19571 | 23349.6890100000 |
Using min block, first 4 is pool address.

height: 5342 time 01-22 06:59:03 difficulty 6.10650391 nbits 1c29ec00 subsidy 21 add officialold
height: 3643 time 01-19 23:56:38 difficulty 1.0 nbits 1d00ffff subsidy 277 add smalltimeminer
height: 8411 time 02-01 03:06:37 difficulty 3.16947264 nbits 1c50c4f1 subsidy 136 add coinmine
height: 3951 time 01-20 03:12:58 difficulty 1.0 nbits 1d00ffff subsidy 277 add cpupool

if address == 'Xemt2zeYELCkddJHvsW4x9ytqTEnkiviaH':
address = 'mininghub'
if address == 'XccPicDbg7HhRfFwPU3Z2CFVpHSYAhuxtu':
address = 'coinmine'
if address == 'Xd4Jv9fAf8NmgkJmmkoWXMi5JJPZdf4uUa':
address = 'suchpool'
if address == 'XdgnL33mHN2byuauHqJQHAsa3s8sYakSrF':
address = 'official'
if address == 'XoYNjJ8yEPkB3YUft5BtS1Je24eMgnAQXg':
address = 'cpupool'
if address == 'XxvFVwx5hZBouVRPu2WgBkahxnojVRRgK8':
address = 'lottery'
if address == 'XkGsLLY2uZiPq9HAMzbQVJcQL3Tnr5ibuv':
address = 'lottery'
if address == 'XvW5YcFFy4rrVpQfVW13yjo6SN7iKFHdF5':
address = 'smalltimeminer'
if address == 'XtUa1xzS8rr4UMv1bopfTKipspwrUvaBMp':
address = 'officialold'