PREVIEW / stock_1hour / 2014-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-28.parquet
  size:    1.0 MB
  rows:    48,255
  symbols: 3,583

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
2014-08-28 04:00:00	AAPL	Stock	25.5875	25.5875	25.48	25.5	8316.0
2014-08-28 05:00:00	AAPL	Stock	25.5	25.5075	25.4375	25.45	11140.0
2014-08-28 06:00:00	AAPL	Stock	25.45	25.45	25.375	25.415	89564.0
2014-08-28 07:00:00	AAPL	Stock	25.41	25.4725	25.41	25.4375	161788.0
2014-08-28 08:00:00	AAPL	Stock	25.4375	25.5325	25.375	25.425	834308.0
2014-08-28 09:00:00	AAPL	Stock	25.4225	25.635	25.33	25.603	41633260.0
2014-08-28 10:00:00	AAPL	Stock	25.6075	25.625	25.51	25.5912	33132736.0
2014-08-28 11:00:00	AAPL	Stock	25.5925	25.64	25.5625	25.605	21291840.0
2014-08-28 12:00:00	AAPL	Stock	25.6048	25.695	25.5925	25.6072	23678192.0
2014-08-28 13:00:00	AAPL	Stock	25.6075	25.6338	25.5675	25.6053	12798252.0
2014-08-28 14:00:00	AAPL	Stock	25.605	25.6275	25.565	25.57	11036772.0
2014-08-28 15:00:00	AAPL	Stock	25.57	25.63	25.54	25.5625	25448940.0
2014-08-28 16:00:00	AAPL	Stock	25.5625	25.603	25.5225	25.603	27311768.0
2014-08-28 17:00:00	AAPL	Stock	25.575	25.5925	25.5625	25.575	1897288.0
2014-08-28 18:00:00	AAPL	Stock	25.5775	25.6075	25.5625	25.6075	110764.0
2014-08-28 19:00:00	AAPL	Stock	25.6075	25.6175	25.595	25.595	201536.0
2014-08-28 05:00:00	MSFT	Stock	44.7	44.7	44.62	44.62	400.0
2014-08-28 06:00:00	MSFT	Stock	44.6	44.6	44.6	44.6	1150.0
2014-08-28 07:00:00	MSFT	Stock	44.79	44.79	44.79	44.79	100.0
2014-08-28 08:00:00	MSFT	Stock	44.73	44.73	44.67	44.7	4809.0
2014-08-28 09:00:00	MSFT	Stock	44.71	44.85	44.64	44.69	2707960.0
2014-08-28 10:00:00	MSFT	Stock	44.69	44.76	44.61	44.715	2590158.0
2014-08-28 11:00:00	MSFT	Stock	44.72	44.8	44.66	44.735	1494225.0
2014-08-28 12:00:00	MSFT	Stock	44.74	44.91	44.73	44.875	1501026.0
2014-08-28 13:00:00	MSFT	Stock	44.87	44.88	44.81	44.87	1014881.0
2014-08-28 14:00:00	MSFT	Stock	44.865	44.87	44.78	44.805	1541673.0
2014-08-28 15:00:00	MSFT	Stock	44.81	44.98	44.79	44.88	4349551.0
2014-08-28 16:00:00	MSFT	Stock	44.88	45.0	44.794	44.872	1558347.0
2014-08-28 17:00:00	MSFT	Stock	44.89	44.89	44.87	44.87	33745.0
2014-08-28 18:00:00	MSFT	Stock	44.87	44.87	44.84	44.84	1056.0
2014-08-28 08:00:00	NVDA	Stock	0.48	0.4808	0.4775	0.4793	1404000.0
2014-08-28 09:00:00	NVDA	Stock	0.4808	0.481	0.4785	0.4803	31575080.0
2014-08-28 10:00:00	NVDA	Stock	0.4803	0.4825	0.4782	0.4812	30013480.0
2014-08-28 11:00:00	NVDA	Stock	0.4812	0.4839	0.4808	0.4838	27914320.0
2014-08-28 12:00:00	NVDA	Stock	0.4836	0.4845	0.4828	0.4832	11689840.0
2014-08-28 13:00:00	NVDA	Stock	0.4832	0.4839	0.483	0.4832	9973600.0
2014-08-28 14:00:00	NVDA	Stock	0.4835	0.4855	0.4832	0.4848	15348320.0
2014-08-28 15:00:00	NVDA	Stock	0.4848	0.4858	0.4845	0.4848	38304160.0
2014-08-28 16:00:00	NVDA	Stock	0.4848	0.4848	0.4847	0.4848	7272720.0
2014-08-28 06:00:00	AMZN	Stock	17.1145	17.1145	17.0495	17.0495	6000.0
2014-08-28 07:00:00	AMZN	Stock	17.015	17.061	17.015	17.04	24000.0
2014-08-28 08:00:00	AMZN	Stock	17.0125	17.068	17.0125	17.0585	83440.0
2014-08-28 09:00:00	AMZN	Stock	17.05	17.0895	17.0	17.022	9000120.0
2014-08-28 10:00:00	AMZN	Stock	17.0225	17.0395	16.94	16.9865	10941140.0
2014-08-28 11:00:00	AMZN	Stock	16.986	17.0435	16.9695	16.98	3845640.0
2014-08-28 12:00:00	AMZN	Stock	16.9833	17.025	16.956	17.015	2358420.0
2014-08-28 13:00:00	AMZN	Stock	17.015	17.017	16.9695	16.9945	2669240.0
2014-08-28 14:00:00	AMZN	Stock	16.9893	17.0	16.9425	16.9855	2934480.0
2014-08-28 15:00:00	AMZN	Stock	16.987	17.0425	16.963	17.001	8803880.0
2014-08-28 16:00:00	AMZN	Stock	17.001	17.0025	16.9995	17.0025	172000.0

> showing 50 of 48,255 rows — these rows as CSV

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