PREVIEW / stock_1hour / 2016-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-05.parquet
  size:    1.1 MB
  rows:    49,083
  symbols: 3,172

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-12-05 04:00:00	AAPL	Stock	27.5025	27.58	27.5	27.58	8780.0
2016-12-05 05:00:00	AAPL	Stock	27.6375	27.6375	27.635	27.635	900.0
2016-12-05 06:00:00	AAPL	Stock	27.6	27.6125	27.6	27.6125	6500.0
2016-12-05 07:00:00	AAPL	Stock	27.6	27.61	27.475	27.525	53876.0
2016-12-05 08:00:00	AAPL	Stock	27.5375	27.64	27.5125	27.5525	111052.0
2016-12-05 09:00:00	AAPL	Stock	27.5525	27.5525	27.0625	27.255	26830020.0
2016-12-05 10:00:00	AAPL	Stock	27.255	27.4462	27.2375	27.3425	18979564.0
2016-12-05 11:00:00	AAPL	Stock	27.345	27.3675	27.2112	27.2418	13601240.0
2016-12-05 12:00:00	AAPL	Stock	27.2412	27.315	27.2075	27.294	10732496.0
2016-12-05 13:00:00	AAPL	Stock	27.295	27.34	27.2725	27.2775	8478820.0
2016-12-05 14:00:00	AAPL	Stock	27.28	27.3388	27.2575	27.325	8812964.0
2016-12-05 15:00:00	AAPL	Stock	27.3225	27.3575	27.2425	27.275	20291496.0
2016-12-05 16:00:00	AAPL	Stock	27.28	27.29	27.2625	27.2875	14099752.0
2016-12-05 17:00:00	AAPL	Stock	27.2875	27.2925	27.2775	27.2775	10988.0
2016-12-05 18:00:00	AAPL	Stock	27.2875	27.3	27.2775	27.295	16200.0
2016-12-05 19:00:00	AAPL	Stock	27.305	27.3125	27.2775	27.2775	19920.0
2016-12-05 04:00:00	MSFT	Stock	59.53	59.53	59.53	59.53	272.0
2016-12-05 07:00:00	MSFT	Stock	59.58	59.58	59.58	59.58	1100.0
2016-12-05 08:00:00	MSFT	Stock	59.36	59.36	59.36	59.36	600.0
2016-12-05 09:00:00	MSFT	Stock	59.54	60.13	59.54	59.989	2803949.0
2016-12-05 10:00:00	MSFT	Stock	59.985	60.585	59.985	60.515	3635858.0
2016-12-05 11:00:00	MSFT	Stock	60.52	60.54	60.15	60.175	2470816.0
2016-12-05 12:00:00	MSFT	Stock	60.17	60.226	59.93	60.18	2284029.0
2016-12-05 13:00:00	MSFT	Stock	60.18	60.2	60.08	60.1	1592813.0
2016-12-05 14:00:00	MSFT	Stock	60.1	60.115	59.995	60.06	1751636.0
2016-12-05 15:00:00	MSFT	Stock	60.06	60.28	60.01	60.21	3490244.0
2016-12-05 16:00:00	MSFT	Stock	60.22	60.3	60.2	60.2	3959063.0
2016-12-05 17:00:00	MSFT	Stock	60.2	60.27	60.2	60.27	366787.0
2016-12-05 18:00:00	MSFT	Stock	60.27	60.27	60.27	60.27	500.0
2016-12-05 04:00:00	NVDA	Stock	2.2275	2.235	2.2275	2.235	32000.0
2016-12-05 05:00:00	NVDA	Stock	2.235	2.235	2.235	2.235	4000.0
2016-12-05 06:00:00	NVDA	Stock	2.2475	2.2685	2.2475	2.2665	100480.0
2016-12-05 07:00:00	NVDA	Stock	2.2575	2.2615	2.2535	2.2535	325880.0
2016-12-05 08:00:00	NVDA	Stock	2.2588	2.26	2.2468	2.2488	1664560.0
2016-12-05 09:00:00	NVDA	Stock	2.2465	2.2675	2.225	2.2638	81013440.0
2016-12-05 10:00:00	NVDA	Stock	2.264	2.3153	2.2638	2.3092	128796720.0
2016-12-05 11:00:00	NVDA	Stock	2.3095	2.3102	2.2852	2.2898	63631520.0
2016-12-05 12:00:00	NVDA	Stock	2.2895	2.3042	2.2768	2.301	54978200.0
2016-12-05 13:00:00	NVDA	Stock	2.3008	2.3008	2.2848	2.2863	31458800.0
2016-12-05 14:00:00	NVDA	Stock	2.286	2.298	2.2818	2.2935	43236400.0
2016-12-05 15:00:00	NVDA	Stock	2.2931	2.299	2.2925	2.297	68950560.0
2016-12-05 16:00:00	NVDA	Stock	2.297	2.2995	2.2922	2.2988	19660720.0
2016-12-05 17:00:00	NVDA	Stock	2.2988	2.2995	2.2978	2.2988	99000.0
2016-12-05 18:00:00	NVDA	Stock	2.3	2.305	2.3	2.3035	396160.0
2016-12-05 19:00:00	NVDA	Stock	2.3038	2.3045	2.3025	2.3025	99680.0
2016-12-05 04:00:00	AMZN	Stock	37.428	37.428	37.428	37.428	2000.0
2016-12-05 06:00:00	AMZN	Stock	37.3505	37.3505	37.3505	37.3505	2000.0
2016-12-05 07:00:00	AMZN	Stock	37.325	37.325	37.285	37.285	16680.0
2016-12-05 08:00:00	AMZN	Stock	37.258	37.3	37.2	37.2965	226460.0
2016-12-05 09:00:00	AMZN	Stock	37.26	37.638	37.1	37.5812	15594960.0

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

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