PREVIEW / stock_1hour / 2011-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-17.parquet
  size:    947 KB
  rows:    44,881
  symbols: 3,566

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-17 04:00:00	AAPL	Stock	11.9243	11.9243	11.9243	11.9243	2800.0
2011-05-17 05:00:00	AAPL	Stock	11.9286	11.9286	11.9286	11.9286	25816.0
2011-05-17 06:00:00	AAPL	Stock	11.9286	11.9518	11.9286	11.9464	105784.0
2011-05-17 07:00:00	AAPL	Stock	11.9396	11.9589	11.9089	11.9107	413644.0
2011-05-17 08:00:00	AAPL	Stock	11.9196	11.9196	11.8439	11.8679	2707068.0
2011-05-17 09:00:00	AAPL	Stock	11.8696	11.9018	11.8118	11.8524	64712844.0
2011-05-17 10:00:00	AAPL	Stock	11.8521	11.9565	11.8179	11.8682	91743512.0
2011-05-17 11:00:00	AAPL	Stock	11.8686	11.8718	11.8125	11.8575	55964748.0
2011-05-17 12:00:00	AAPL	Stock	11.8579	11.9229	11.8486	11.8696	44449860.0
2011-05-17 13:00:00	AAPL	Stock	11.8711	11.9018	11.8621	11.882	34167280.0
2011-05-17 14:00:00	AAPL	Stock	11.8818	11.9386	11.8468	11.9321	41731816.0
2011-05-17 15:00:00	AAPL	Stock	11.9321	12.005	11.92	12.0039	86734200.0
2011-05-17 16:00:00	AAPL	Stock	12.0039	12.0429	11.8649	12.0329	21562604.0
2011-05-17 17:00:00	AAPL	Stock	12.0307	12.0321	12.025	12.0286	314300.0
2011-05-17 18:00:00	AAPL	Stock	12.0286	12.0357	12.005	12.035	203980.0
2011-05-17 19:00:00	AAPL	Stock	12.0343	12.0357	12.0321	12.0321	294448.0
2011-05-17 05:00:00	MSFT	Stock	24.55	24.55	24.55	24.55	2600.0
2011-05-17 06:00:00	MSFT	Stock	24.54	24.55	24.51	24.53	3500.0
2011-05-17 07:00:00	MSFT	Stock	24.49	24.51	24.42	24.47	13800.0
2011-05-17 08:00:00	MSFT	Stock	24.48	24.51	24.44	24.44	48210.0
2011-05-17 09:00:00	MSFT	Stock	24.44	24.5	24.27	24.325	8362661.0
2011-05-17 10:00:00	MSFT	Stock	24.325	24.42	24.29	24.311	10005445.0
2011-05-17 11:00:00	MSFT	Stock	24.32	24.44	24.3	24.35	10913754.0
2011-05-17 12:00:00	MSFT	Stock	24.35	24.56	24.35	24.46	7949688.0
2011-05-17 13:00:00	MSFT	Stock	24.465	24.65	24.46	24.62	8491998.0
2011-05-17 14:00:00	MSFT	Stock	24.618	24.7	24.58	24.66	9461173.0
2011-05-17 15:00:00	MSFT	Stock	24.66	24.66	24.49	24.52	10817037.0
2011-05-17 16:00:00	MSFT	Stock	24.52	24.65	24.47	24.55	3431876.0
2011-05-17 17:00:00	MSFT	Stock	24.41	24.6	24.41	24.57	12100.0
2011-05-17 18:00:00	MSFT	Stock	24.52	24.56	24.52	24.56	12007432.0
2011-05-17 19:00:00	MSFT	Stock	24.57	24.59	24.57	24.59	4975.0
2011-05-17 08:00:00	NVDA	Stock	0.4448	0.445	0.4405	0.4405	241000.0
2011-05-17 09:00:00	NVDA	Stock	0.4425	0.443	0.428	0.429	224784320.0
2011-05-17 10:00:00	NVDA	Stock	0.4288	0.4398	0.428	0.4303	345230240.0
2011-05-17 11:00:00	NVDA	Stock	0.4304	0.4312	0.428	0.4296	194615440.0
2011-05-17 12:00:00	NVDA	Stock	0.4298	0.4332	0.4285	0.4322	130490360.0
2011-05-17 13:00:00	NVDA	Stock	0.4322	0.4345	0.432	0.433	86494480.0
2011-05-17 14:00:00	NVDA	Stock	0.433	0.4374	0.4318	0.4372	143145600.0
2011-05-17 15:00:00	NVDA	Stock	0.437	0.4412	0.436	0.4405	247360920.0
2011-05-17 16:00:00	NVDA	Stock	0.4408	0.446	0.4335	0.4428	11248280.0
2011-05-17 17:00:00	NVDA	Stock	0.4428	0.4428	0.4418	0.442	420000.0
2011-05-17 18:00:00	NVDA	Stock	0.442	0.443	0.442	0.443	124000.0
2011-05-17 19:00:00	NVDA	Stock	0.4448	0.4448	0.4408	0.4425	106600.0
2011-05-17 07:00:00	AMZN	Stock	9.6675	9.6675	9.6085	9.6275	76000.0
2011-05-17 08:00:00	AMZN	Stock	9.6325	9.6595	9.564	9.587	385900.0
2011-05-17 09:00:00	AMZN	Stock	9.585	9.741	9.573	9.675	25378100.0
2011-05-17 10:00:00	AMZN	Stock	9.675	9.799	9.635	9.696	29057000.0
2011-05-17 11:00:00	AMZN	Stock	9.699	9.72	9.625	9.715	18094780.0
2011-05-17 12:00:00	AMZN	Stock	9.7158	9.7265	9.6535	9.675	10530040.0
2011-05-17 13:00:00	AMZN	Stock	9.6755	9.6825	9.615	9.635	11940320.0

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

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