Bitcoin Forum

Bitcoin => Bitcoin Discussion => Topic started by: QA on February 03, 2013, 02:14:00 AM



Title: 10/90 - how rich/poor are the forum users
Post by: QA on February 03, 2013, 02:14:00 AM
INVALID BBCODE: loop, probably unclosed tags


Title: Re: 10/90 - how rich/poor are the forum users
Post by: bg002h on February 03, 2013, 02:37:28 AM
That's very interesting. I guess I'm not super surprised at the distribution. Could you plot registration date on the forum against #btc received? I'd be curious.

Also, plot the cumulative % of the total btc own by forum members by rank (ie, the richest dude owns 12%, the top 2 own 20%, the top 3 own 26%, etc...


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Liquid on February 03, 2013, 02:52:45 AM
Nice work  :)


Title: Re: 10/90 - how rich/poor are the forum users
Post by: dust on February 03, 2013, 02:55:01 AM
This data isn't very useful.  Most users use donation addresses in their signature that are separate from their savings in order to preserve some anonymity.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: John (John K.) on February 03, 2013, 02:58:53 AM
I have a name!   :'(

Quote
Moderator   1NB1KFnFqnP3WSDZQrWV3pfmph5fWRyadz 


Title: Re: 10/90 - how rich/poor are the forum users
Post by: bg002h on February 03, 2013, 05:04:47 AM
This data isn't very useful.  Most users use donation addresses in their signature that are separate from their savings in order to preserve some anonymity.

I think everyone realizes this...but, no other analysis is possible using publicly available data. 


Title: Re: 10/90 - how rich/poor are the forum users
Post by: QA on February 03, 2013, 06:24:56 AM
I added a revised version in google spreadsheet:
https://docs.google.com/spreadsheet/ccc?key=0At9fbytjeQvCdFY4a1hiVHJqNkNoemFMQmlabnEwamc&usp=sharing (https://docs.google.com/spreadsheet/ccc?key=0At9fbytjeQvCdFY4a1hiVHJqNkNoemFMQmlabnEwamc&usp=sharing)

I have a name!   :'(

Quote
Moderator   1NB1KFnFqnP3WSDZQrWV3pfmph5fWRyadz 

Fixed.
That's very interesting. I guess I'm not super surprised at the distribution. Could you plot registration date on the forum against #btc received? I'd be curious.

Also, plot the cumulative % of the total btc own by forum members by rank (ie, the richest dude owns 12%, the top 2 own 20%, the top 3 own 26%, etc...
If you could add Total time they spend on the forum that would be cool, and maybe make a google spreadsheet so more sorting can be applied.

How I wish to access the forum database!  :P


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Phinnaeus Gage on February 03, 2013, 09:19:55 AM
Quote
Gage   1BTC1oo1J3MEt5SFj74ZBcF2Mk97Aah4ac   291.1208181   3095.376144

I'm rich! Now I is goin' get me one of them fancy coffee tables.

Plus, I made another Top 10 list. Life's been good to me so far.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: hardcore-fs on February 03, 2013, 09:25:45 AM
Yep well I can tell you that the  hardcore-fs is complete bollox........


Which is good because it shows my mixing tree is working.....

Now see if you can follow the paper trail.....




Title: Re: 10/90 - how rich/poor are the forum users
Post by: TraderTimm on February 03, 2013, 09:32:39 AM
This is fucking hilarious.

I assure you, I have more than 5 BTC.

How much? None of your fucking business, thanks :)


Title: Re: 10/90 - how rich/poor are the forum users
Post by: the joint on February 03, 2013, 09:37:14 AM
This is fucking hilarious.

I assure you, I have more than 5 BTC.

How much? None of your fucking business, thanks :)


I have 5 BTC in dog years.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: phatsphere on February 03, 2013, 09:48:54 AM
my "0" balance is also completely wrong. lol.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: hazek on February 03, 2013, 11:00:43 AM
If anything this thread confirms beyond the first address that someone publicly proclaims is theirs it's pretty much impossible to know for a fact who owns what.

For example, I'm shown to own an address (and I do own it), that's empty. But I'm not shown to own another address that I used to advertise nor any of my other addresses with bitcoins..


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Lethn on February 03, 2013, 12:51:36 PM
I love how many people want to try and spy on their fellow Bitcoin users, I suppose this is just a great way of testing whether Bitcoins anonymity is working correctly.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: deepceleron on February 03, 2013, 02:07:41 PM
Below is a (very incomplete) list of users on this forum with their balance and received BTC.
....
deepceleron   12ViYXgordxUkmPhN5PAU9vJRHwc8jftfQ   8.4   8.4

It appears that this is harvested from posts, like below. Obviously not my address, so the methodology is flawed:

The odd thing is the coins are not being sent in the way a normal Bitcoin client would send them, the address balances are being nibbled at and combined with other small payments from other address to new addresses, like here: http://blockexplorer.com/address/12ViYXgordxUkmPhN5PAU9vJRHwc8jftfQ.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Tomatocage on February 03, 2013, 05:12:46 PM
I have 0 BTC.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: evoorhees on February 03, 2013, 06:37:02 PM
According to the data I have 1 bitcoin. That's about right.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: cypherdoc on February 03, 2013, 07:44:18 PM
According to the data I have 1 bitcoin. That's about right.

lol!


Title: Re: 10/90 - how rich/poor are the forum users
Post by: k on February 03, 2013, 08:02:28 PM
Wonder what happened to gkelly?

over 7900 BTC remaining at 15Z5YJaaNSxeynvr6uW6jQZLwq3n1Hu6RX

Last active on the forum around April 2010, last activity at the address Oct 2010. Hope they still have the private key, would suck to have lost it because you didn't think they were worth much.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: foo on February 03, 2013, 08:33:11 PM
Wonder what happened to gkelly?

over 7900 BTC remaining at 15Z5YJaaNSxeynvr6uW6jQZLwq3n1Hu6RX

Last active on the forum around April 2010, last activity at the address Oct 2010. Hope they still have the private key, would suck to have lost it because you didn't think they were worth much.
Wow, good catch. $160k worth of bitcoins...

EDIT: Looks like he has a twitter that's active: https://twitter.com/gkelly


Title: Re: 10/90 - how rich/poor are the forum users
Post by: k on February 03, 2013, 08:51:29 PM
Wonder what happened to gkelly?

over 7900 BTC remaining at 15Z5YJaaNSxeynvr6uW6jQZLwq3n1Hu6RX

Last active on the forum around April 2010, last activity at the address Oct 2010. Hope they still have the private key, would suck to have lost it because you didn't think they were worth much.
Wow, good catch. $160k worth of bitcoins...

EDIT: Looks like he has a twitter that's active: https://twitter.com/gkelly

Looks like it's the right gkelly
https://twitter.com/gkelly/status/57333924417900544 (https://twitter.com/gkelly/status/57333924417900544)
https://i.imgur.com/xzocxZy.png




Title: Re: 10/90 - how rich/poor are the forum users
Post by: mb300sd on February 03, 2013, 10:35:29 PM
I definitely have significantly more than 0.025 ;D


Title: Re: 10/90 - how rich/poor are the forum users
Post by: 420 on February 03, 2013, 11:32:56 PM
am I the richest with 1btc? LOL


Title: Re: 10/90 - how rich/poor are the forum users
Post by: bg002h on February 04, 2013, 02:13:48 AM
my "0" balance is also completely wrong. lol.

Uhhh....no it's not.

http://blockchain.info/address/1HB9mgo3cdqBoC3jPemDpD8TPHFxcuQ8AD

The OP isn't foolishly claiming the numbers he is listing are the total amounts owned by each user. That's just silly. Everyone knows that.

You could also look at this as a "who in bitcoin land chose to make their balances known" exercise. My estimate is roughly correct and since it's never gonna make me ridiculously wealthy, I'm not all that concerned about who knows. If it does make me crazy wealthy...well...I guess people will know that.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Rassah on February 04, 2013, 03:01:17 AM
Quote
Rassah   1kenyaDrbe2W9KfC7djWAZbAKzSR2aXdX   0   108.191

Fail. That's not my address, that's the address of one of the charities Bitcoin100 sent money to. I have 1 bitcoin.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: DoomDumas on February 04, 2013, 04:07:08 AM
Eh, I own at least 20x what you listed, and mining !


Title: Re: 10/90 - how rich/poor are the forum users
Post by: 01BTC10 on February 04, 2013, 04:26:15 AM
Look like I'm good at hiding my game! Maybe I never publicly published a Bitcoin address. I can't remember doing so.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Rassah on February 04, 2013, 05:20:45 AM
Quote
Rassah   1kenyaDrbe2W9KfC7djWAZbAKzSR2aXdX   0   108.191

Fail. That's not my address, that's the address of one of the charities Bitcoin100 sent money to. I have 1 bitcoin.

Shucks, I was hoping to purchase $1000 worth from you!  ;D

https://localbitcoins.com/accounts/profile/rassah/

SHHHHHHHHHHHhhhhhhhhhhhhh!  :P


Title: Re: 10/90 - how rich/poor are the forum users
Post by: QA on February 04, 2013, 08:54:35 AM
Now a revised version (users registered by Jun 26, 2011), only use the address in signature. Register date included.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Luno on February 04, 2013, 09:06:02 AM
Nice with a list for directing begging, lending, business offer type PM's to members with coins to spare.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: QA on February 04, 2013, 09:10:55 AM
Below is a (very incomplete) list of users on this forum with their balance and received BTC.
....
deepceleron   12ViYXgordxUkmPhN5PAU9vJRHwc8jftfQ   8.4   8.4

It appears that this is harvested from posts, like below. Obviously not my address, so the methodology is flawed:

The odd thing is the coins are not being sent in the way a normal Bitcoin client would send them, the address balances are being nibbled at and combined with other small payments from other address to new addresses, like here: http://blockexplorer.com/address/12ViYXgordxUkmPhN5PAU9vJRHwc8jftfQ.

Indeed. Fixed now.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Vladimir on February 04, 2013, 09:21:31 AM
Unfortunately, the dataset collected is not representative of "how rich/poor are the forum users". Hence whatever conclusion you would make based on this data in context of the thread title, would be a big steaming pile of nonsense.



Title: Re: 10/90 - how rich/poor are the forum users
Post by: QA on February 04, 2013, 09:38:26 AM
Unfortunately, the dataset collected is not representative of "how rich/poor are the forum users". Hence whatever conclusion you would make based on this data in context of the thread title, would be a big steaming pile of nonsense.



Now it is, mostly. Anyways that's my best answer to the question for now.
I wonder how anonymous bitcoin can be.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: zvs on February 04, 2013, 11:11:11 AM
Nice with a list for directing begging, lending, business offer type PM's to members with coins to spare.


what's up w/ people asking for donations when they have 20,000 bitcoins, anyway?



Title: Re: 10/90 - how rich/poor are the forum users
Post by: anonymous_acc on February 04, 2013, 11:14:56 AM
Do you know such html tag: < table > ?


Title: Re: 10/90 - how rich/poor are the forum users
Post by: giszmo on February 04, 2013, 01:15:16 PM
According to the data I have 1 bitcoin. That's about right.
Really?
I assumed you had at least some Satoshi Dice shares but if you say so, 100% are owned by anonymous investors ;)


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Rassah on February 04, 2013, 03:57:45 PM
Quote
20203   Rassah   June 08, 2011, 07:12:12 PM   1BTC1oo1J3MEt5SFj74ZBcF2Mk97Aah4ac   291.1208181   3095.376144

Also not mine. I may manage the finances for Bitcoin100 charity thing, but it's not my money, and the private key for that address is shared by a few different people.
I may allegedly own a few thousand bitcoin, but there's really nothing out there to link it to me  :P


Title: Re: 10/90 - how rich/poor are the forum users
Post by: QA on February 04, 2013, 07:32:25 PM
Do you know such html tag: < table > ?

Good point. Formatted. Had to cut the list even shorter to fit in a message.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: QA on February 04, 2013, 10:07:26 PM
Users registered by Feb 4, 2013 included.
'Loaded' sounds true, with 40k in balance.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Tomatocage on February 04, 2013, 10:33:43 PM
ArtForz has 0 BTC my ass  :D


Title: Re: 10/90 - how rich/poor are the forum users
Post by: k on February 04, 2013, 10:47:42 PM
Even though AaronBarr   (HBGarry) has 1KPTdMb6p7H3YCwsyFqrEmKGmsHqe1Q3jg listed as his donation address I'm pretty sure he doesn't control it.
It's the first destination of the stolen bitcoins from the allinvain theft https://bitcointalk.org/index.php?topic=16457.0 (https://bitcointalk.org/index.php?topic=16457.0)

Aaron Barr was claiming on twitter than Lulzsec were responsible (very unlikely in my opinion, just the thief sending coins to the Lulzsec public address to muddy the waters) - https://twitter.com/aaronbarr/status/81030436058439681 (https://twitter.com/aaronbarr/status/81030436058439681)

Wonder if someone hacked his bitcointalk forum account and put that address as his donation address for a joke or if he did it himself as a joke.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: giszmo on February 04, 2013, 10:54:06 PM
Even though AaronBarr   (HBGarry) has 1KPTdMb6p7H3YCwsyFqrEmKGmsHqe1Q3jg listed as his donation address I'm pretty sure he doesn't control it.
It's the first destination of the stolen bitcoins from the allinvain theft https://bitcointalk.org/index.php?topic=16457.0 (https://bitcointalk.org/index.php?topic=16457.0)

Aaron Barr was claiming on twitter than Lulzsec were responsible (very unlikely in my opinion, just the thief sending coins to the Lulzsec public address to muddy the waters) - https://twitter.com/aaronbarr/status/81030436058439681 (https://twitter.com/aaronbarr/status/81030436058439681)

Wonder if someone hacked his bitcointalk forum account and put that address as his donation address for a joke or if he did it himself as a joke.

Nice finding :)

These donation addresses are a joke, aren't they? If people like what I'm writing, nobody would tip me, right? I mean I could pick some top 100 address and not regret missing out on all the donations flowing in, right? I guess I will go with this one: 1A1zP1eP5QGefi2DMPTfTL5SLmv7DivfNa.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Vladimir on February 04, 2013, 10:55:55 PM
ArtForz has 0 BTC my ass  :D

poor sod, lol


Title: Re: 10/90 - how rich/poor are the forum users
Post by: 001sonkit on February 05, 2013, 03:32:55 PM
Include me!

1CasperDEhyGD81WNPo9qkaFnWxUSWmrqk


Title: Re: 10/90 - how rich/poor are the forum users
Post by: QA on February 05, 2013, 06:00:49 PM
Include me!

1CasperDEhyGD81WNPo9qkaFnWxUSWmrqk

Added.

All the accounts listed here are at most 'related' to the users. Their relationship, including contribute to/can spend/both/brag about, can't be verified without confirmation from enough users who have dealt business with them.



Title: Re: 10/90 - how rich/poor are the forum users
Post by: mokahless on February 08, 2013, 06:41:02 AM
OMG please please doubleclick on the spaces between the column headers (A,B,C etc) so that all the rows automatically fit and so that we can read all the contents of the cells without clicking on them and each row only takes up one line.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: QA on February 09, 2013, 09:10:41 AM
OMG please please doubleclick on the spaces between the column headers (A,B,C etc) so that all the rows automatically fit and so that we can read all the contents of the cells without clicking on them and each row only takes up one line.

Suppose you mean the gg speadsheet. Thanks. Fixed.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: mokahless on March 17, 2013, 05:41:20 AM
OMG please please doubleclick on the spaces between the column headers (A,B,C etc) so that all the rows automatically fit and so that we can read all the contents of the cells without clicking on them and each row only takes up one line.

Suppose you mean the gg speadsheet. Thanks. Fixed.
So much better thanks :)

FYI, you can fetch the balance for the addresses with =ImportData("http://blockexplorer.com/q/addressbalance/"&D3) but unfortunately, it isn't practical as google limits the number of external references per spreadsheet to 50 :(

You can also drag down the striped line just above the "1" label to prevent the headers from scrolling when you scroll down the list.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: ralree on March 17, 2013, 05:45:55 AM
Remember, this doesn't include offline coins - just the addresses these folks have published.  I have quite a few offline coins (some I made, some from Casascius).


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Raoul Duke on March 17, 2013, 05:55:16 AM
You missed mine. Look in sig and follow link :P


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Wekkel on March 17, 2013, 08:25:18 AM
I foresee a lot of hard drive failures in the future....


Title: Re: 10/90 - how rich/poor are the forum users
Post by: viboracecata on March 17, 2013, 08:40:32 AM
Millionares are those bond share operators.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: QA on March 18, 2013, 08:51:42 AM

FYI, you can fetch the balance for the addresses with =ImportData("http://blockexplorer.com/q/addressbalance/"&D3) but unfortunately, it isn't practical as google limits the number of external references per spreadsheet to 50 :(

You can also drag down the striped line just above the "1" label to prevent the headers from scrolling when you scroll down the list.

Great tips. Thanks again.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: Gyrsur on March 14, 2014, 06:47:30 AM
found my Bitcoin address via Google! incredible! Bitcoin is not anonymous!! going to think about to leave Bitcoin!  ;D (not really)


Title: Re: 10/90 - how rich/poor are the forum users
Post by: smoothie on March 14, 2014, 11:22:42 AM
Look like I'm good at hiding my game! Maybe I never publicly published a Bitcoin address. I can't remember doing so.

Same here unless it was a bet address after winning a bet.


Title: Re: 10/90 - how rich/poor are the forum users
Post by: el_Tico on March 14, 2014, 02:11:01 PM
May I ask how you accumulated the data?  ;D


Title: Re: 10/90 - how rich/poor are the forum users
Post by: ns12123 on March 14, 2014, 03:27:27 PM
Here are super crazy bitcoin owners.

Nice work !


Title: Re: 10/90 - how rich/poor are the forum users
Post by: E.exchanger on March 14, 2014, 05:04:17 PM
Quite cool how you showing the balance available with their user name listed quite informational for blackhats  :D . Also the address people use in their signatures are not their primary/ main wallets they are only donation address. Anyways good to know users are holding that amount of btc.  :)