PREVIEW / stock_1hour / 2016-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-28.parquet
  size:    1.0 MB
  rows:    48,560
  symbols: 3,161

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-11-28 04:00:00	AAPL	Stock	27.9125	27.9125	27.8325	27.8325	2256.0
2016-11-28 05:00:00	AAPL	Stock	27.875	27.875	27.8625	27.8625	16376.0
2016-11-28 06:00:00	AAPL	Stock	27.855	27.855	27.795	27.8	15040.0
2016-11-28 07:00:00	AAPL	Stock	27.8375	27.91	27.835	27.865	34108.0
2016-11-28 08:00:00	AAPL	Stock	27.8975	27.915	27.8625	27.8875	62896.0
2016-11-28 09:00:00	AAPL	Stock	27.8875	28.0475	27.8475	28.045	16233172.0
2016-11-28 10:00:00	AAPL	Stock	28.0435	28.1162	27.9575	27.9625	15395932.0
2016-11-28 11:00:00	AAPL	Stock	27.9625	27.98	27.925	27.9772	10206280.0
2016-11-28 12:00:00	AAPL	Stock	27.9775	28.0	27.935	27.9525	7452296.0
2016-11-28 13:00:00	AAPL	Stock	27.9538	27.99	27.935	27.965	5924220.0
2016-11-28 14:00:00	AAPL	Stock	27.965	27.9875	27.9325	27.9575	7357480.0
2016-11-28 15:00:00	AAPL	Stock	27.9575	27.9625	27.8625	27.895	14775820.0
2016-11-28 16:00:00	AAPL	Stock	27.8925	27.8975	27.875	27.8925	20625116.0
2016-11-28 17:00:00	AAPL	Stock	27.875	27.8925	27.875	27.875	4700.0
2016-11-28 18:00:00	AAPL	Stock	27.875	27.8875	27.875	27.875	6552.0
2016-11-28 19:00:00	AAPL	Stock	27.8875	27.8875	27.875	27.875	9536.0
2016-11-28 06:00:00	MSFT	Stock	60.4	60.43	60.4	60.43	500.0
2016-11-28 08:00:00	MSFT	Stock	60.25	60.41	60.25	60.38	2699.0
2016-11-28 09:00:00	MSFT	Stock	60.35	60.5	60.21	60.425	1860287.0
2016-11-28 10:00:00	MSFT	Stock	60.425	60.72	60.355	60.62	2499207.0
2016-11-28 11:00:00	MSFT	Stock	60.615	60.9	60.6	60.885	2412560.0
2016-11-28 12:00:00	MSFT	Stock	60.89	61.02	60.83	60.935	1667881.0
2016-11-28 13:00:00	MSFT	Stock	60.93	60.935	60.74	60.79	1419970.0
2016-11-28 14:00:00	MSFT	Stock	60.785	60.81	60.6	60.66	1400029.0
2016-11-28 15:00:00	MSFT	Stock	60.66	60.68	60.5	60.63	3248686.0
2016-11-28 16:00:00	MSFT	Stock	60.61	60.61	60.61	60.61	4960844.0
2016-11-28 17:00:00	MSFT	Stock	60.61	60.62	60.61	60.62	10007.0
2016-11-28 19:00:00	MSFT	Stock	60.62	60.62	60.55	60.57	640.0
2016-11-28 06:00:00	NVDA	Stock	2.3348	2.3348	2.3325	2.3325	11840.0
2016-11-28 07:00:00	NVDA	Stock	2.3337	2.3485	2.3337	2.3485	22320.0
2016-11-28 08:00:00	NVDA	Stock	2.3538	2.3538	2.334	2.3438	151120.0
2016-11-28 09:00:00	NVDA	Stock	2.3425	2.3612	2.34	2.3604	35101600.0
2016-11-28 10:00:00	NVDA	Stock	2.36	2.3685	2.3433	2.349	50273560.0
2016-11-28 11:00:00	NVDA	Stock	2.349	2.3635	2.349	2.357	34711560.0
2016-11-28 12:00:00	NVDA	Stock	2.3572	2.3593	2.3503	2.3561	18434040.0
2016-11-28 13:00:00	NVDA	Stock	2.356	2.3595	2.3518	2.3519	18521960.0
2016-11-28 14:00:00	NVDA	Stock	2.3515	2.3545	2.3422	2.3485	27414640.0
2016-11-28 15:00:00	NVDA	Stock	2.3485	2.354	2.346	2.3528	37721480.0
2016-11-28 16:00:00	NVDA	Stock	2.3528	2.3545	2.3473	2.3528	23900440.0
2016-11-28 17:00:00	NVDA	Stock	2.3528	2.355	2.3528	2.3545	140400.0
2016-11-28 18:00:00	NVDA	Stock	2.3505	2.3508	2.35	2.35	51800.0
2016-11-28 19:00:00	NVDA	Stock	2.3528	2.3528	2.3528	2.3528	16000.0
2016-11-28 04:00:00	AMZN	Stock	38.921	38.921	38.9	38.9	12080.0
2016-11-28 07:00:00	AMZN	Stock	38.91	38.91	38.75	38.8935	70280.0
2016-11-28 08:00:00	AMZN	Stock	38.8975	38.9	38.8125	38.85	372720.0
2016-11-28 09:00:00	AMZN	Stock	38.8495	38.85	38.269	38.5015	15749180.0
2016-11-28 10:00:00	AMZN	Stock	38.5	38.523	38.3005	38.369	13655140.0
2016-11-28 11:00:00	AMZN	Stock	38.3705	38.389	38.289	38.3392	8392780.0
2016-11-28 12:00:00	AMZN	Stock	38.346	38.4645	38.29	38.4554	8003240.0
2016-11-28 13:00:00	AMZN	Stock	38.4525	38.4995	38.4125	38.4396	5901440.0

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

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