>And I also know many people who says that mtgox absolutely incorrect shows trading info.
bitcoinex: What trading info is incorrect?
Click on "Last 48 hours". Click again and again and again. You see little changes on the chart?
Your code do something like:
SELECT time, price FROM trades_history ORDER BY time;
But there is almost always a few trades have occurred simultaneously. More precisely, it is the same trade but with a lot of orders. That's why changing the chart. As a minimum, you need to add sort by another field.
But it says more about the problem really is. It is impossible charts with lots of points corresponding to one value of x, unless it's not trigonometry. People see total volume at every x point. And when traded offers contain one with too large or too small price, while showing a large amount of the transaction, they think that the rate has changed a lot, though in fact it is "sticking" the offer was met by ~0.01 bitcoins. I know at least 2 people who trying use it to rate manipulations.
For each x point (each trade) is necessary to calculate the real value of the price (weighted price, for example).
This also suggests (to me) about that 99.99% of bitcoin users is monkey-profiteers and the next six months bitcoin had no prospects. That's why the last few days I write these evil messages.