PREVIEW / stock_1hour / 2016-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-18.parquet
  size:    1.0 MB
  rows:    47,806
  symbols: 3,205

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
2016-10-18 04:00:00	AAPL	Stock	29.475	29.575	29.475	29.57	15464.0
2016-10-18 05:00:00	AAPL	Stock	29.57	29.5775	29.5625	29.5625	12764.0
2016-10-18 06:00:00	AAPL	Stock	29.5475	29.575	29.5475	29.5625	15784.0
2016-10-18 07:00:00	AAPL	Stock	29.5625	29.575	29.5375	29.5525	106404.0
2016-10-18 08:00:00	AAPL	Stock	29.55	29.6	29.325	29.6	708640.0
2016-10-18 09:00:00	AAPL	Stock	29.59	29.625	29.3988	29.505	19359528.0
2016-10-18 10:00:00	AAPL	Stock	29.505	29.535	29.4275	29.5025	15612092.0
2016-10-18 11:00:00	AAPL	Stock	29.501	29.5225	29.4575	29.5088	7942736.0
2016-10-18 12:00:00	AAPL	Stock	29.51	29.5475	29.4675	29.4955	7691532.0
2016-10-18 13:00:00	AAPL	Stock	29.4975	29.5338	29.4862	29.5	4998312.0
2016-10-18 14:00:00	AAPL	Stock	29.5	29.51	29.4542	29.4675	5994564.0
2016-10-18 15:00:00	AAPL	Stock	29.4675	29.47	29.3625	29.3625	17032880.0
2016-10-18 16:00:00	AAPL	Stock	29.3675	29.3675	29.305	29.33	8026288.0
2016-10-18 17:00:00	AAPL	Stock	29.3225	29.3675	29.3125	29.325	89144.0
2016-10-18 18:00:00	AAPL	Stock	29.3275	29.3525	29.3275	29.3325	62636.0
2016-10-18 19:00:00	AAPL	Stock	29.3375	29.3525	29.3175	29.3525	74580.0
2016-10-18 07:00:00	MSFT	Stock	57.55	57.6	57.4	57.6	20817.0
2016-10-18 08:00:00	MSFT	Stock	57.55	57.64	57.22	57.61	94583.0
2016-10-18 09:00:00	MSFT	Stock	57.61	57.945	57.519	57.605	2698796.0
2016-10-18 10:00:00	MSFT	Stock	57.61	57.66	57.41	57.62	2540345.0
2016-10-18 11:00:00	MSFT	Stock	57.625	57.74	57.59	57.735	1681371.0
2016-10-18 12:00:00	MSFT	Stock	57.74	57.785	57.71	57.75	1283099.0
2016-10-18 13:00:00	MSFT	Stock	57.745	57.84	57.71	57.74	1598263.0
2016-10-18 14:00:00	MSFT	Stock	57.75	57.82	57.71	57.8	2043601.0
2016-10-18 15:00:00	MSFT	Stock	57.8	57.81	57.65	57.65	4155216.0
2016-10-18 16:00:00	MSFT	Stock	57.65	57.66	57.35	57.66	1748530.0
2016-10-18 17:00:00	MSFT	Stock	57.44	57.66	57.25	57.42	43325.0
2016-10-18 18:00:00	MSFT	Stock	57.42	57.5	57.35	57.35	6910.0
2016-10-18 19:00:00	MSFT	Stock	57.4	57.44	57.3	57.4	4352.0
2016-10-18 07:00:00	NVDA	Stock	1.6558	1.6558	1.655	1.655	20000.0
2016-10-18 08:00:00	NVDA	Stock	1.66	1.661	1.6555	1.661	280440.0
2016-10-18 09:00:00	NVDA	Stock	1.6575	1.6712	1.6523	1.6642	28695480.0
2016-10-18 10:00:00	NVDA	Stock	1.6642	1.6666	1.6573	1.6645	36907480.0
2016-10-18 11:00:00	NVDA	Stock	1.6644	1.6698	1.6632	1.6698	23028600.0
2016-10-18 12:00:00	NVDA	Stock	1.6695	1.674	1.6684	1.6721	21851640.0
2016-10-18 13:00:00	NVDA	Stock	1.672	1.6748	1.6703	1.672	17295000.0
2016-10-18 14:00:00	NVDA	Stock	1.6718	1.6738	1.6699	1.6728	21951000.0
2016-10-18 15:00:00	NVDA	Stock	1.6728	1.673	1.6635	1.665	43728000.0
2016-10-18 16:00:00	NVDA	Stock	1.6652	1.667	1.6462	1.6555	52311680.0
2016-10-18 17:00:00	NVDA	Stock	1.6562	1.6562	1.65	1.6512	244880.0
2016-10-18 18:00:00	NVDA	Stock	1.6545	1.6575	1.6545	1.6562	254840.0
2016-10-18 19:00:00	NVDA	Stock	1.6575	1.6575	1.6575	1.6575	20000.0
2016-10-18 04:00:00	AMZN	Stock	41.05	41.05	41.05	41.05	2000.0
2016-10-18 06:00:00	AMZN	Stock	41.0775	41.0775	41.015	41.015	19380.0
2016-10-18 07:00:00	AMZN	Stock	41.0445	41.1385	41.0225	41.125	201480.0
2016-10-18 08:00:00	AMZN	Stock	41.0225	41.1475	41.0225	41.1	297980.0
2016-10-18 09:00:00	AMZN	Stock	41.1	41.15	40.8	40.8423	10370040.0
2016-10-18 10:00:00	AMZN	Stock	40.8345	40.9478	40.751	40.891	7910120.0
2016-10-18 11:00:00	AMZN	Stock	40.8975	41.1125	40.8928	41.1055	5239480.0
2016-10-18 12:00:00	AMZN	Stock	41.1055	41.15	41.0155	41.1415	4616440.0

> showing 50 of 47,806 rows — these rows as CSV

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