Author

Topic: BTC Price History Chart/Table? (Read 3946 times)

legendary
Activity: 1512
Merit: 1036
February 15, 2013, 09:56:47 PM
#6
I don't think he really wants raw data, but just in case, I exported the trade data for the entire history of mtgox to a csv file, 3.5M trades (that's 3.5 million lines of text file), 221MB (12.7MB with 7-zip and some ultra compression)

format:
Code:
Date Time Open High Low Last Volume Number of Trades Bid Volume Ask Volume
7/17/2010 16:09:17 0.05 0.05 0.05 0.05 2000 2000 0 0
7/17/2010 20:43:06 0.059 0.059 0.059 0.059 5001 5001 0 0
7/18/2010 10:48:56 0.081 0.081 0.081 0.081 500 500 0 0
7/18/2010 14:44:11 0.086 0.086 0.086 0.086 1000 1000 0 0
7/18/2010 15:00:26 0.086 0.086 0.086 0.086 500 500 0 0
7/18/2010 15:00:36 0.086 0.086 0.086 0.086 500 500 0 0
7/18/2010 20:53:04 0.091 0.091 0.091 0.091 500 500 0 0
7/19/2010 09:24:13 0.093 0.093 0.093 0.093 8000 8000 0 0
7/19/2010 10:03:33 0.089 0.089 0.089 0.089 10000 10000 0 0
7/19/2010 10:07:58 0.088 0.088 0.088 0.088 10000 10000 0 0
7/19/2010 10:12:27 0.091 0.091 0.091 0.091 9000 9000 0 0
7/19/2010 13:44:16 0.084 0.084 0.084 0.084 2000 2000 0 0
7/19/2010 13:55:25 0.079 0.079 0.079 0.079 10000 10000 0 0
7/19/2010 13:56:29 0.079 0.079 0.079 0.079 1000 1000 0 0
7/19/2010 13:57:00 0.077 0.077 0.077 0.077 2000 2000 0 0
7/19/2010 14:02:17 0.081 0.081 0.081 0.081 4900 4900 0 0
7/19/2010 19:36:22 0.082 0.082 0.082 0.082 10000 10000 0 0
7/19/2010 20:54:28 0.082 0.082 0.082 0.082 1200 1200 0 0
7/20/2010 05:48:55 0.081 0.081 0.081 0.081 400 400 0 0
7/20/2010 05:50:34 0.079 0.079 0.079 0.079 1000 1000 0 0
7/20/2010 07:37:28 0.078 0.078 0.078 0.078 1000 1000 0 0
7/20/2010 07:39:09 0.077 0.077 0.077 0.077 1000 1000 0 0
7/20/2010 08:01:54 0.076 0.076 0.076 0.076 1000 1000 0 0
7/20/2010 10:08:05 0.077 0.077 0.077 0.077 1000 1000 0 0
7/20/2010 10:09:38 0.077 0.077 0.077 0.077 1000 1000 0 0
7/20/2010 10:09:48 0.077 0.077 0.077 0.077 2000 2000 0 0
7/20/2010 13:09:44 0.074 0.074 0.074 0.074 450 450 0 0
7/20/2010 13:38:13 0.074 0.074 0.074 0.074 550 550 0 0
7/20/2010 13:38:13 0.074 0.074 0.074 0.074 450 450 0 0
7/20/2010 13:41:49 0.074 0.074 0.074 0.074 4550 4550 0 0
7/20/2010 14:24:20 0.075 0.075 0.075 0.075 300 300 0 0
7/20/2010 14:28:39 0.075 0.075 0.075 0.075 100 100 0 0
7/20/2010 14:29:15 0.075 0.075 0.075 0.075 100 100 0 0
7/20/2010 14:29:58 0.075 0.075 0.075 0.075 100 100 0 0
7/20/2010 19:27:48 0.074 0.074 0.074 0.074 6000 6000 0 0
7/20/2010 19:30:30 0.073 0.073 0.073 0.073 1000 1000 0 0
7/20/2010 19:41:25 0.072 0.072 0.072 0.072 1000 1000 0 0
7/20/2010 19:41:43 0.071 0.071 0.071 0.071 1000 1000 0 0
7/21/2010 07:11:25 0.07 0.07 0.07 0.07 1000 1000 0 0
7/21/2010 07:45:07 0.069 0.069 0.069 0.069 1000 1000 0 0
7/21/2010 07:56:53 0.068 0.068 0.068 0.068 1000 1000 0 0
7/21/2010 11:58:28 0.067 0.067 0.067 0.067 1000 1000 0 0
legendary
Activity: 2506
Merit: 1010
February 15, 2013, 09:16:19 PM
#5
Hey everyone. I'm looking for a chart or table illustrating the change in BTC price compared to dollars. I have been looking because I'm attempting to create my own chart in excel for a project of mine. Can anyone help me out? I've looked for a quite awhile but I cannot find a good resource.

The "load raw data" link in bitcoincharts gives the underlying data.   I plug the historical data once a month into a spreadsheet on Google docs.  I'm using a mobile at the moment so don't have the link handy.  Search for bitcoin historical data and the link is probably a minute or less away.

 - https://docs.google.com/spreadsheet/ccc?key=0AmcTCtjBoRWUdHJuUE1mUkFxa3A0eHBDQkxZLVVFZmc
legendary
Activity: 947
Merit: 1042
Hamster ate my bitcoin
newbie
Activity: 32
Merit: 0
February 15, 2013, 07:05:24 PM
#3
Thanks!
legendary
Activity: 1512
Merit: 1036
February 15, 2013, 07:03:29 PM
#2


Price scale is logarithmic, look to the right to see the price.
newbie
Activity: 32
Merit: 0
February 15, 2013, 07:00:21 PM
#1
Hey everyone. I'm looking for a chart or table illustrating the change in BTC price compared to dollars. I have been looking because I'm attempting to create my own chart in excel for a project of mine. Can anyone help me out? I've looked for a quite awhile but I cannot find a good resource.
Jump to: