Hacker News new | ask | show | jobs
by jimrandomh 4481 days ago
Users 1 and 15's charts make no sense - they have to be special system accounts of some sort. My guess is that #15 is the account that receives trading fees, and #1 represents MtGox itself (or some specific aspect of MtGox, such as its cold-storage).

There're still a lot of points on these plots that don't make sense, though; generally they look like vertical stripes labelled as sets of small sell orders, both far below and far above the market price. User 30 has what looks like a large sell (in Mar 2013) far above the highest-ever price. So either MtGox's order-matching is way more broken than anyone ever knew (unlikely), or these actually represent fees, withdraws, or something similar, and the y-axis position is meaningless.

Also worthy of note is that massive sell order by user 1 in Nov 2013. That's hard to interpret without knowing what the dots on that graph really mean (I doubt they're trades), but it's likely significant.

3 comments

Each dot is a trade. I pulled the columns from the db we generated with the raw info of that one big trade, so you can see what the structure of the source data looks like. Removed the user id of the buyer, but it's trivial to find if you have the dataset.

File|Trade_Id|Date|User_Id|Type|Currency|Bitcoins|Money|Money_JPY|Money_Fee|Bitcoin_Fee

2013-11_mtgox_japan.csv|1384974682548514|2013-11-20 19:11:22|*|buy|USD|1000|610000|60941267.96|0|3

2013-11_mtgox_japan.csv|1384974682548514|2013-11-20 19:11:22|THK|sell|USD|1000|610000|60941267.96|0|0

So the size of the dots are the Money_JPY "volume" - that is, Yen, and not Bitcoins? Isn't that a bit redundant, because it contains information from the y-axis, which encodes the Yen value of a BC? Wouldn't it have been more interesting to see if the number of BCs traded actually went down with the increase of value of BCs? Right now, it only shows how the volume of trades has increased, but that seems to be obvious given BC's value hike. Actually, to make the graphs distinct, shouldn't the number of BCs traded be on the Y-axis (maybe on log scale, too, as I suspect a huge drop over time) and the dots remain as they are?
May I ask, where'd you get the dataset?
A torrent found on Reddit the day it was leaked. It looks like mods may have removed that thread:

http://www.reddit.com/r/Bitcoin/comments/1zz9rw/a_message_fr...

If you find a copy, don't run the .exe file contained within. It contains malware.

From "About":

>The special user TIBANNE_LIMITED_HK is not represented in the MtGox 500 since its trades are not in JPY. You can read a conjecture on the role of this user[1]. The other special user, THK, shows up as #1 in the MtGox 500.

[1] http://7u83.cauwersin.com/?p=12

They look like bid/ask offers.