PREVIEW / stock_1hour / 2017-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-28.parquet
  size:    1.1 MB
  rows:    49,876
  symbols: 2,958

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-28 05:00:00	AAPL	Stock	43.4875	43.495	43.4875	43.495	1200.0
2017-11-28 06:00:00	AAPL	Stock	43.4875	43.5725	43.4875	43.5725	5200.0
2017-11-28 07:00:00	AAPL	Stock	43.525	43.625	43.525	43.6125	77448.0
2017-11-28 08:00:00	AAPL	Stock	43.5225	43.6875	43.5225	43.605	1909368.0
2017-11-28 09:00:00	AAPL	Stock	43.585	43.7175	43.45	43.4725	12317900.0
2017-11-28 10:00:00	AAPL	Stock	43.47	43.55	43.27	43.3275	11851264.0
2017-11-28 11:00:00	AAPL	Stock	43.3288	43.365	43.175	43.2438	12099724.0
2017-11-28 12:00:00	AAPL	Stock	43.2425	43.345	43.1375	43.22	8549544.0
2017-11-28 13:00:00	AAPL	Stock	43.2225	43.3	43.095	43.1158	9796684.0
2017-11-28 14:00:00	AAPL	Stock	43.1175	43.275	42.965	43.21	11334608.0
2017-11-28 15:00:00	AAPL	Stock	43.2125	43.2975	43.1825	43.25	14936312.0
2017-11-28 16:00:00	AAPL	Stock	43.2675	43.2925	43.225	43.265	5391520.0
2017-11-28 17:00:00	AAPL	Stock	43.265	43.2675	43.1525	43.1575	136908.0
2017-11-28 18:00:00	AAPL	Stock	43.2375	43.25	43.2	43.24	32292.0
2017-11-28 19:00:00	AAPL	Stock	43.25	43.265	43.245	43.265	18752.0
2017-11-28 07:00:00	MSFT	Stock	83.87	84.01	83.87	83.95	4480.0
2017-11-28 08:00:00	MSFT	Stock	83.87	84.09	83.87	84.09	614198.0
2017-11-28 09:00:00	MSFT	Stock	84.09	84.87	83.97	84.745	2172981.0
2017-11-28 10:00:00	MSFT	Stock	84.75	85.06	84.46	84.535	3688513.0
2017-11-28 11:00:00	MSFT	Stock	84.54	84.815	84.535	84.665	1796761.0
2017-11-28 12:00:00	MSFT	Stock	84.67	84.83	84.665	84.774	1560399.0
2017-11-28 13:00:00	MSFT	Stock	84.775	84.92	84.44	84.5	1655607.0
2017-11-28 14:00:00	MSFT	Stock	84.51	84.95	84.38	84.815	1533515.0
2017-11-28 15:00:00	MSFT	Stock	84.81	84.92	84.67	84.88	3538861.0
2017-11-28 16:00:00	MSFT	Stock	84.88	84.88	84.76	84.78	1760847.0
2017-11-28 17:00:00	MSFT	Stock	84.88	84.9	84.88	84.9	26483.0
2017-11-28 18:00:00	MSFT	Stock	84.78	84.88	84.78	84.88	750.0
2017-11-28 19:00:00	MSFT	Stock	84.88	84.88	84.85	84.85	720.0
2017-11-28 04:00:00	NVDA	Stock	5.3612	5.3612	5.3612	5.3612	18000.0
2017-11-28 06:00:00	NVDA	Stock	5.369	5.369	5.369	5.369	12000.0
2017-11-28 07:00:00	NVDA	Stock	5.3742	5.3755	5.3625	5.3742	597480.0
2017-11-28 08:00:00	NVDA	Stock	5.3535	5.375	5.3535	5.3688	11970120.0
2017-11-28 09:00:00	NVDA	Stock	5.37	5.3722	5.297	5.3093	72729000.0
2017-11-28 10:00:00	NVDA	Stock	5.3088	5.3192	5.2725	5.2733	65504600.0
2017-11-28 11:00:00	NVDA	Stock	5.2738	5.3	5.2665	5.269	54905480.0
2017-11-28 12:00:00	NVDA	Stock	5.2695	5.277	5.2625	5.2703	46374120.0
2017-11-28 13:00:00	NVDA	Stock	5.2703	5.29	5.2178	5.2185	63619600.0
2017-11-28 14:00:00	NVDA	Stock	5.2195	5.285	5.206	5.272	74512360.0
2017-11-28 15:00:00	NVDA	Stock	5.2722	5.29	5.2545	5.2678	63459320.0
2017-11-28 16:00:00	NVDA	Stock	5.2673	5.2738	5.2625	5.267	19211840.0
2017-11-28 17:00:00	NVDA	Stock	5.2668	5.2722	5.2668	5.2675	383040.0
2017-11-28 18:00:00	NVDA	Stock	5.2673	5.2673	5.264	5.2658	214440.0
2017-11-28 19:00:00	NVDA	Stock	5.2628	5.2722	5.2575	5.2722	347960.0
2017-11-28 05:00:00	AMZN	Stock	59.85	59.921	59.85	59.921	7080.0
2017-11-28 06:00:00	AMZN	Stock	59.9985	60.1145	59.9985	60.1145	34420.0
2017-11-28 07:00:00	AMZN	Stock	60.1195	60.26	60.0815	60.167	287680.0
2017-11-28 08:00:00	AMZN	Stock	60.089	60.274	60.089	60.175	798180.0
2017-11-28 09:00:00	AMZN	Stock	60.185	60.3125	59.75	60.0205	16848240.0
2017-11-28 10:00:00	AMZN	Stock	59.9978	60.0903	59.751	59.807	9753940.0
2017-11-28 11:00:00	AMZN	Stock	59.8171	60.0375	59.805	59.9775	4931600.0

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

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