BTC Price History Chart/Table? | Bitcointalksearch.org

deepceleron

legendary

Activity: 1512

Merit: 1032

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

Stephen Gornick

legendary

Activity: 2506

Merit: 1010

Quote from: BitcoinScholar on February 15, 2013, 08:00:21 PM

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

yogi

legendary

Activity: 947

Merit: 1042

Hamster ate my bitcoin

bitcoincharts.com

BitcoinScholar

newbie

Activity: 32

Merit: 0

Thanks!

deepceleron

legendary

Activity: 1512

Merit: 1032

Price scale is logarithmic, look to the right to see the price.

BitcoinScholar

newbie

Activity: 32

Merit: 0

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.

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