PREVIEW / stock_1hour / 2017-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-27.parquet
  size:    1.1 MB
  rows:    49,368
  symbols: 2,942

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
2017-11-27 04:00:00	AAPL	Stock	43.715	43.75	43.715	43.725	2200.0
2017-11-27 05:00:00	AAPL	Stock	43.725	43.8	43.725	43.8	2428.0
2017-11-27 06:00:00	AAPL	Stock	43.81	43.845	43.75	43.775	15724.0
2017-11-27 07:00:00	AAPL	Stock	43.755	43.7875	43.61	43.645	111476.0
2017-11-27 08:00:00	AAPL	Stock	43.81	43.875	43.6125	43.6775	315112.0
2017-11-27 09:00:00	AAPL	Stock	43.675	43.775	43.335	43.6538	17230132.0
2017-11-27 10:00:00	AAPL	Stock	43.66	43.745	43.6125	43.63	9156796.0
2017-11-27 11:00:00	AAPL	Stock	43.63	43.6325	43.4	43.5125	10817148.0
2017-11-27 12:00:00	AAPL	Stock	43.5175	43.5875	43.465	43.52	8010372.0
2017-11-27 13:00:00	AAPL	Stock	43.5225	43.6225	43.515	43.6025	3879536.0
2017-11-27 14:00:00	AAPL	Stock	43.6012	43.6038	43.5125	43.5707	4971872.0
2017-11-27 15:00:00	AAPL	Stock	43.57	43.5775	43.5025	43.52	8319632.0
2017-11-27 16:00:00	AAPL	Stock	43.5225	43.5475	43.515	43.5225	10540788.0
2017-11-27 17:00:00	AAPL	Stock	43.5225	43.54	43.5025	43.5225	405620.0
2017-11-27 18:00:00	AAPL	Stock	43.505	43.505	43.4875	43.4875	49904.0
2017-11-27 19:00:00	AAPL	Stock	43.49	43.49	43.4	43.4525	41232.0
2017-11-27 06:00:00	MSFT	Stock	83.47	83.47	83.47	83.47	100.0
2017-11-27 07:00:00	MSFT	Stock	83.4	83.4	83.24	83.25	4836.0
2017-11-27 08:00:00	MSFT	Stock	83.3	83.47	83.18	83.25	12813.0
2017-11-27 09:00:00	MSFT	Stock	83.27	83.965	83.27	83.855	2218302.0
2017-11-27 10:00:00	MSFT	Stock	83.86	83.965	83.74	83.865	2367413.0
2017-11-27 11:00:00	MSFT	Stock	83.865	83.98	83.67	83.91	2128893.0
2017-11-27 12:00:00	MSFT	Stock	83.91	83.96	83.7	83.71	1348289.0
2017-11-27 13:00:00	MSFT	Stock	83.71	83.85	83.56	83.61	1082413.0
2017-11-27 14:00:00	MSFT	Stock	83.61	83.86	83.54	83.86	1227561.0
2017-11-27 15:00:00	MSFT	Stock	83.85	83.9	83.75	83.86	2966756.0
2017-11-27 16:00:00	MSFT	Stock	83.87	83.88	83.84	83.87	2594900.0
2017-11-27 17:00:00	MSFT	Stock	83.88	83.88	83.87	83.88	541831.0
2017-11-27 18:00:00	MSFT	Stock	83.87	83.87	83.85	83.85	712.0
2017-11-27 19:00:00	MSFT	Stock	83.85	83.86	83.78	83.78	2585.0
2017-11-27 04:00:00	NVDA	Stock	5.4298	5.4298	5.4238	5.4243	152640.0
2017-11-27 05:00:00	NVDA	Stock	5.425	5.425	5.4238	5.4238	11640.0
2017-11-27 06:00:00	NVDA	Stock	5.4225	5.4238	5.4175	5.42	226640.0
2017-11-27 07:00:00	NVDA	Stock	5.4232	5.4232	5.4038	5.407	681360.0
2017-11-27 08:00:00	NVDA	Stock	5.41	5.4362	5.4035	5.4225	2458520.0
2017-11-27 09:00:00	NVDA	Stock	5.4205	5.4438	5.3752	5.388	75938840.0
2017-11-27 10:00:00	NVDA	Stock	5.3882	5.4048	5.3863	5.396	47055040.0
2017-11-27 11:00:00	NVDA	Stock	5.3965	5.4045	5.351	5.3612	67624480.0
2017-11-27 12:00:00	NVDA	Stock	5.3615	5.3725	5.3583	5.36	29855320.0
2017-11-27 13:00:00	NVDA	Stock	5.361	5.3688	5.3594	5.365	20120880.0
2017-11-27 14:00:00	NVDA	Stock	5.3649	5.3688	5.3578	5.3674	21407520.0
2017-11-27 15:00:00	NVDA	Stock	5.3672	5.3695	5.3502	5.3532	51439080.0
2017-11-27 16:00:00	NVDA	Stock	5.3535	5.355	5.3508	5.3535	39193880.0
2017-11-27 17:00:00	NVDA	Stock	5.3532	5.355	5.3525	5.3535	606920.0
2017-11-27 18:00:00	NVDA	Stock	5.3535	5.3612	5.3535	5.3545	143320.0
2017-11-27 19:00:00	NVDA	Stock	5.3565	5.3565	5.35	5.35	225760.0
2017-11-27 05:00:00	AMZN	Stock	59.65	59.65	59.65	59.65	4420.0
2017-11-27 06:00:00	AMZN	Stock	59.6485	59.7	59.6	59.627	63180.0
2017-11-27 07:00:00	AMZN	Stock	59.637	59.6435	59.458	59.599	443600.0
2017-11-27 08:00:00	AMZN	Stock	59.6	60.1895	59.5	59.9175	2419340.0

> showing 50 of 49,368 rows — these rows as CSV

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