PREVIEW / stock_1hour / 2015-05-28

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-28.parquet
  size:    1.0 MB
  rows:    48,313
  symbols: 3,507

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
2015-05-28 04:00:00	AAPL	Stock	33.25	33.25	32.925	32.975	3600.0
2015-05-28 05:00:00	AAPL	Stock	32.9725	32.9725	32.9375	32.9375	2384.0
2015-05-28 06:00:00	AAPL	Stock	32.985	32.9875	32.95	32.955	16184.0
2015-05-28 07:00:00	AAPL	Stock	32.99	33.0025	32.875	32.905	142908.0
2015-05-28 08:00:00	AAPL	Stock	32.925	32.9875	32.77	32.8775	1103008.0
2015-05-28 09:00:00	AAPL	Stock	32.8675	32.9725	32.775	32.8098	25203620.0
2015-05-28 10:00:00	AAPL	Stock	32.81	32.92	32.8025	32.8452	18254096.0
2015-05-28 11:00:00	AAPL	Stock	32.8475	32.95	32.8325	32.86	15469680.0
2015-05-28 12:00:00	AAPL	Stock	32.8625	32.915	32.84	32.8662	9775516.0
2015-05-28 13:00:00	AAPL	Stock	32.8662	32.9	32.8475	32.8698	8022844.0
2015-05-28 14:00:00	AAPL	Stock	32.87	32.946	32.8525	32.935	9334836.0
2015-05-28 15:00:00	AAPL	Stock	32.935	32.9875	32.91	32.9425	16301732.0
2015-05-28 16:00:00	AAPL	Stock	32.945	32.975	32.8702	32.975	10277312.0
2015-05-28 17:00:00	AAPL	Stock	32.98	32.9875	32.945	32.96	115912.0
2015-05-28 18:00:00	AAPL	Stock	32.9525	32.965	32.9525	32.9525	24636.0
2015-05-28 19:00:00	AAPL	Stock	32.9625	32.97	32.955	32.97	39364.0
2015-05-28 04:00:00	MSFT	Stock	47.49	47.5	47.49	47.49	892.0
2015-05-28 07:00:00	MSFT	Stock	47.33	47.45	47.33	47.45	2200.0
2015-05-28 08:00:00	MSFT	Stock	47.25	47.54	47.25	47.53	14810.0
2015-05-28 09:00:00	MSFT	Stock	47.55	48.02	47.43	47.855	3505451.0
2015-05-28 10:00:00	MSFT	Stock	47.84	47.86	47.435	47.49	2928302.0
2015-05-28 11:00:00	MSFT	Stock	47.5	47.72	47.44	47.505	2456143.0
2015-05-28 12:00:00	MSFT	Stock	47.505	47.57	47.39	47.4	1695012.0
2015-05-28 13:00:00	MSFT	Stock	47.4	47.57	47.39	47.5	1639108.0
2015-05-28 14:00:00	MSFT	Stock	47.495	47.64	47.47	47.565	1162111.0
2015-05-28 15:00:00	MSFT	Stock	47.565	47.575	47.43	47.45	3158019.0
2015-05-28 16:00:00	MSFT	Stock	47.45	47.5	47.42	47.42	1723421.0
2015-05-28 17:00:00	MSFT	Stock	47.5	47.5	47.45	47.499	1700.0
2015-05-28 18:00:00	MSFT	Stock	47.45	47.45	47.45	47.45	100.0
2015-05-28 08:00:00	NVDA	Stock	0.546	0.546	0.546	0.546	8000.0
2015-05-28 09:00:00	NVDA	Stock	0.545	0.5531	0.5448	0.5505	53677280.0
2015-05-28 10:00:00	NVDA	Stock	0.5505	0.5552	0.5472	0.5535	65886160.0
2015-05-28 11:00:00	NVDA	Stock	0.5535	0.5554	0.5502	0.5504	32668920.0
2015-05-28 12:00:00	NVDA	Stock	0.5505	0.5522	0.55	0.55	21374600.0
2015-05-28 13:00:00	NVDA	Stock	0.55	0.5528	0.55	0.552	21360680.0
2015-05-28 14:00:00	NVDA	Stock	0.552	0.5545	0.5515	0.553	30226120.0
2015-05-28 15:00:00	NVDA	Stock	0.5529	0.555	0.5525	0.5538	70761160.0
2015-05-28 16:00:00	NVDA	Stock	0.5535	0.5535	0.5535	0.5535	12722600.0
2015-05-28 18:00:00	NVDA	Stock	0.5535	0.5535	0.5535	0.5535	40000.0
2015-05-28 07:00:00	AMZN	Stock	21.51	21.51	21.51	21.51	2000.0
2015-05-28 08:00:00	AMZN	Stock	21.525	21.525	21.496	21.51	37840.0
2015-05-28 09:00:00	AMZN	Stock	21.5176	21.5675	21.3112	21.3265	6425400.0
2015-05-28 10:00:00	AMZN	Stock	21.3245	21.3925	21.2735	21.367	6171620.0
2015-05-28 11:00:00	AMZN	Stock	21.368	21.4185	21.2985	21.3225	3548600.0
2015-05-28 12:00:00	AMZN	Stock	21.3225	21.3765	21.303	21.341	3260920.0
2015-05-28 13:00:00	AMZN	Stock	21.343	21.3975	21.293	21.3755	4114800.0
2015-05-28 14:00:00	AMZN	Stock	21.3655	21.41	21.363	21.3865	2777800.0
2015-05-28 15:00:00	AMZN	Stock	21.3803	21.4015	21.3185	21.3275	6846940.0
2015-05-28 16:00:00	AMZN	Stock	21.3285	21.3758	21.3	21.3747	1338280.0
2015-05-28 17:00:00	AMZN	Stock	21.35	21.35	21.34	21.34	19000.0

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

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