PREVIEW / stock_1hour / 2017-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-27.parquet
  size:    1.0 MB
  rows:    47,708
  symbols: 3,105

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-01-27 04:00:00	AAPL	Stock	30.4675	30.4675	30.4675	30.4675	400.0
2017-01-27 07:00:00	AAPL	Stock	30.5	30.5125	30.4625	30.4775	15800.0
2017-01-27 08:00:00	AAPL	Stock	30.4775	30.5375	30.4775	30.525	54656.0
2017-01-27 09:00:00	AAPL	Stock	30.5175	30.5875	30.4675	30.546	11603156.0
2017-01-27 10:00:00	AAPL	Stock	30.545	30.5675	30.4875	30.495	10060624.0
2017-01-27 11:00:00	AAPL	Stock	30.495	30.515	30.485	30.495	6822900.0
2017-01-27 12:00:00	AAPL	Stock	30.495	30.525	30.4675	30.4925	5571716.0
2017-01-27 13:00:00	AAPL	Stock	30.49	30.5015	30.4425	30.445	6668688.0
2017-01-27 14:00:00	AAPL	Stock	30.4458	30.4545	30.4	30.4375	8987500.0
2017-01-27 15:00:00	AAPL	Stock	30.435	30.4925	30.4225	30.43	16464040.0
2017-01-27 16:00:00	AAPL	Stock	30.43	30.4925	30.4275	30.4825	7188064.0
2017-01-27 17:00:00	AAPL	Stock	30.4825	30.4925	30.475	30.4925	38112.0
2017-01-27 18:00:00	AAPL	Stock	30.475	30.475	30.425	30.425	103044.0
2017-01-27 19:00:00	AAPL	Stock	30.425	30.425	30.255	30.3875	128148.0
2017-01-27 04:00:00	MSFT	Stock	65.18	65.18	64.86	64.93	400.0
2017-01-27 06:00:00	MSFT	Stock	65.17	65.2	65.1	65.2	14448.0
2017-01-27 07:00:00	MSFT	Stock	65.2	65.68	65.12	65.56	141428.0
2017-01-27 08:00:00	MSFT	Stock	65.55	65.6	65.07	65.19	496492.0
2017-01-27 09:00:00	MSFT	Stock	65.17	65.64	64.89	65.43	11214612.0
2017-01-27 10:00:00	MSFT	Stock	65.425	65.66	65.25	65.541	6687755.0
2017-01-27 11:00:00	MSFT	Stock	65.545	65.91	65.501	65.73	5860765.0
2017-01-27 12:00:00	MSFT	Stock	65.73	65.81	65.61	65.705	2812827.0
2017-01-27 13:00:00	MSFT	Stock	65.705	65.74	65.58	65.585	2827371.0
2017-01-27 14:00:00	MSFT	Stock	65.59	65.77	65.54	65.71	3542433.0
2017-01-27 15:00:00	MSFT	Stock	65.71	65.8	65.46	65.78	6270721.0
2017-01-27 16:00:00	MSFT	Stock	65.78	65.881	65.77	65.79	2021512.0
2017-01-27 17:00:00	MSFT	Stock	65.79	65.86	65.78	65.84	415861.0
2017-01-27 18:00:00	MSFT	Stock	65.78	65.8	65.77	65.8	3779.0
2017-01-27 19:00:00	MSFT	Stock	65.75	65.82	65.75	65.81	5641.0
2017-01-27 04:00:00	NVDA	Stock	2.74	2.74	2.74	2.74	6560.0
2017-01-27 06:00:00	NVDA	Stock	2.7413	2.7413	2.7388	2.7388	8000.0
2017-01-27 07:00:00	NVDA	Stock	2.74	2.7438	2.7393	2.7438	260320.0
2017-01-27 08:00:00	NVDA	Stock	2.7438	2.7458	2.729	2.74	1066720.0
2017-01-27 09:00:00	NVDA	Stock	2.74	2.7625	2.7375	2.7423	70424640.0
2017-01-27 10:00:00	NVDA	Stock	2.7447	2.7453	2.7212	2.7408	76006840.0
2017-01-27 11:00:00	NVDA	Stock	2.7413	2.7615	2.7402	2.7598	56233760.0
2017-01-27 12:00:00	NVDA	Stock	2.7595	2.775	2.7505	2.7646	37468600.0
2017-01-27 13:00:00	NVDA	Stock	2.764	2.7818	2.758	2.7782	44140880.0
2017-01-27 14:00:00	NVDA	Stock	2.7782	2.7972	2.7725	2.796	53780480.0
2017-01-27 15:00:00	NVDA	Stock	2.796	2.796	2.7753	2.7942	82830200.0
2017-01-27 16:00:00	NVDA	Stock	2.7942	2.7985	2.7613	2.798	22604320.0
2017-01-27 17:00:00	NVDA	Stock	2.7955	2.7985	2.7953	2.7985	218160.0
2017-01-27 18:00:00	NVDA	Stock	2.797	2.8	2.797	2.7975	239040.0
2017-01-27 19:00:00	NVDA	Stock	2.8	2.8	2.7975	2.7995	239280.0
2017-01-27 06:00:00	AMZN	Stock	41.8085	41.9145	41.8085	41.895	32480.0
2017-01-27 07:00:00	AMZN	Stock	41.8935	41.9	41.8825	41.9	14400.0
2017-01-27 08:00:00	AMZN	Stock	41.9	41.925	41.84	41.9	94300.0
2017-01-27 09:00:00	AMZN	Stock	41.923	41.985	41.512	41.523	11276780.0
2017-01-27 10:00:00	AMZN	Stock	41.525	41.799	41.472	41.7665	10979200.0
2017-01-27 11:00:00	AMZN	Stock	41.7795	41.83	41.712	41.7695	5600680.0

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

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