PREVIEW / stock_1hour / 2011-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-24.parquet
  size:    935 KB
  rows:    44,352
  symbols: 3,549

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-05-24 05:00:00	AAPL	Stock	11.9643	11.9643	11.9439	11.9579	21644.0
2011-05-24 06:00:00	AAPL	Stock	11.9475	11.9475	11.9475	11.9475	2800.0
2011-05-24 07:00:00	AAPL	Stock	11.9679	11.9711	11.9482	11.9643	214060.0
2011-05-24 08:00:00	AAPL	Stock	11.9696	12.0089	11.9696	12.0	1260728.0
2011-05-24 09:00:00	AAPL	Stock	12.0014	12.0075	11.8336	11.8571	69870164.0
2011-05-24 10:00:00	AAPL	Stock	11.8575	11.9216	11.8371	11.8929	80753204.0
2011-05-24 11:00:00	AAPL	Stock	11.8929	11.9636	11.8923	11.9157	50922676.0
2011-05-24 12:00:00	AAPL	Stock	11.9157	11.9179	11.8882	11.8982	17337488.0
2011-05-24 13:00:00	AAPL	Stock	11.8961	11.9175	11.8786	11.8968	18765040.0
2011-05-24 14:00:00	AAPL	Stock	11.8964	11.9261	11.89	11.9041	19369336.0
2011-05-24 15:00:00	AAPL	Stock	11.905	11.9278	11.8554	11.8696	47262320.0
2011-05-24 16:00:00	AAPL	Stock	11.8693	11.9125	11.8518	11.8539	9149756.0
2011-05-24 17:00:00	AAPL	Stock	11.8971	11.9066	11.8546	11.8614	314216.0
2011-05-24 18:00:00	AAPL	Stock	11.8589	11.8639	11.8568	11.8589	179032.0
2011-05-24 19:00:00	AAPL	Stock	11.8614	11.8614	11.85	11.85	103572.0
2011-05-24 05:00:00	MSFT	Stock	24.35	24.35	24.35	24.35	100.0
2011-05-24 06:00:00	MSFT	Stock	24.35	24.35	24.35	24.35	100.0
2011-05-24 07:00:00	MSFT	Stock	24.24	24.24	24.22	24.22	708.0
2011-05-24 08:00:00	MSFT	Stock	24.24	24.28	24.22	24.28	10442.0
2011-05-24 09:00:00	MSFT	Stock	24.28	24.28	24.04	24.115	5668006.0
2011-05-24 10:00:00	MSFT	Stock	24.115	24.23	24.1	24.145	6964953.0
2011-05-24 11:00:00	MSFT	Stock	24.14	24.21	24.1	24.12	5548554.0
2011-05-24 12:00:00	MSFT	Stock	24.125	24.23	24.095	24.15	6600987.0
2011-05-24 13:00:00	MSFT	Stock	24.15	24.23	24.14	24.23	3266344.0
2011-05-24 14:00:00	MSFT	Stock	24.22	24.29	24.21	24.256	5240411.0
2011-05-24 15:00:00	MSFT	Stock	24.25	24.27	24.15	24.15	10275288.0
2011-05-24 16:00:00	MSFT	Stock	24.15	24.242	24.14	24.15	2707057.0
2011-05-24 17:00:00	MSFT	Stock	24.124	24.17	24.11	24.12	35434.0
2011-05-24 18:00:00	MSFT	Stock	24.15	24.15	24.14	24.15	41947.0
2011-05-24 19:00:00	MSFT	Stock	24.12	24.12	24.11	24.12	617.0
2011-05-24 08:00:00	NVDA	Stock	0.4538	0.4538	0.4535	0.4538	359600.0
2011-05-24 09:00:00	NVDA	Stock	0.4555	0.4718	0.4538	0.4687	168408560.0
2011-05-24 10:00:00	NVDA	Stock	0.4688	0.4688	0.4603	0.4628	144922760.0
2011-05-24 11:00:00	NVDA	Stock	0.4628	0.465	0.4568	0.458	103879120.0
2011-05-24 12:00:00	NVDA	Stock	0.458	0.471	0.456	0.457	47504760.0
2011-05-24 13:00:00	NVDA	Stock	0.4568	0.4585	0.4542	0.4565	48053240.0
2011-05-24 14:00:00	NVDA	Stock	0.4568	0.4582	0.4558	0.4575	48756680.0
2011-05-24 15:00:00	NVDA	Stock	0.4575	0.4578	0.4528	0.4538	127121280.0
2011-05-24 16:00:00	NVDA	Stock	0.4535	0.4606	0.45	0.451	25265160.0
2011-05-24 17:00:00	NVDA	Stock	0.4505	0.4515	0.4505	0.4515	132000.0
2011-05-24 18:00:00	NVDA	Stock	0.451	0.4538	0.4508	0.4535	300000.0
2011-05-24 19:00:00	NVDA	Stock	0.4538	0.4538	0.451	0.4532	95520.0
2011-05-24 08:00:00	AMZN	Stock	9.847	9.875	9.8305	9.8305	66000.0
2011-05-24 09:00:00	AMZN	Stock	9.8345	9.8695	9.72	9.7373	9451200.0
2011-05-24 10:00:00	AMZN	Stock	9.7395	9.779	9.689	9.748	13395240.0
2011-05-24 11:00:00	AMZN	Stock	9.748	9.775	9.717	9.7225	3546800.0
2011-05-24 12:00:00	AMZN	Stock	9.7222	9.846	9.6965	9.721	4752000.0
2011-05-24 13:00:00	AMZN	Stock	9.7233	9.7395	9.675	9.7102	5131440.0
2011-05-24 14:00:00	AMZN	Stock	9.71	9.7285	9.6775	9.6871	6022740.0
2011-05-24 15:00:00	AMZN	Stock	9.69	9.7195	9.65	9.6715	14345100.0

> showing 50 of 44,352 rows — these rows as CSV

> unlock the full archive -- $79 one-time