PREVIEW / stock_1hour / 2016-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-16.parquet
  size:    1.1 MB
  rows:    48,822
  symbols: 3,184

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-16 04:00:00	AAPL	Stock	26.7775	26.8525	26.73	26.73	7808.0
2016-11-16 05:00:00	AAPL	Stock	26.715	26.715	26.7125	26.7125	2428.0
2016-11-16 06:00:00	AAPL	Stock	26.7125	26.7375	26.7125	26.7125	15560.0
2016-11-16 07:00:00	AAPL	Stock	26.7025	26.7025	26.625	26.64	26708.0
2016-11-16 08:00:00	AAPL	Stock	26.665	26.7125	26.575	26.585	136104.0
2016-11-16 09:00:00	AAPL	Stock	26.575	27.0725	26.575	26.9362	23146228.0
2016-11-16 10:00:00	AAPL	Stock	26.9362	27.3025	26.9275	27.2838	26453736.0
2016-11-16 11:00:00	AAPL	Stock	27.2812	27.435	27.191	27.3688	21070488.0
2016-11-16 12:00:00	AAPL	Stock	27.3688	27.5225	27.33	27.4385	19002940.0
2016-11-16 13:00:00	AAPL	Stock	27.4378	27.4875	27.3375	27.4525	12179420.0
2016-11-16 14:00:00	AAPL	Stock	27.45	27.4938	27.4112	27.4675	10588968.0
2016-11-16 15:00:00	AAPL	Stock	27.4662	27.5575	27.44	27.5025	24215936.0
2016-11-16 16:00:00	AAPL	Stock	27.5025	27.525	27.1658	27.4625	6946828.0
2016-11-16 17:00:00	AAPL	Stock	27.4675	27.49	27.4675	27.49	16848.0
2016-11-16 18:00:00	AAPL	Stock	27.4875	27.495	27.4775	27.48	38636.0
2016-11-16 19:00:00	AAPL	Stock	27.48	27.5	27.48	27.4975	63016.0
2016-11-16 04:00:00	MSFT	Stock	58.87	58.87	58.87	58.87	100.0
2016-11-16 07:00:00	MSFT	Stock	58.9	58.9	58.71	58.71	4066.0
2016-11-16 08:00:00	MSFT	Stock	58.76	58.9	58.71	58.71	10983.0
2016-11-16 09:00:00	MSFT	Stock	58.72	59.56	58.7	59.085	3905823.0
2016-11-16 10:00:00	MSFT	Stock	59.09	59.37	59.02	59.18	3551215.0
2016-11-16 11:00:00	MSFT	Stock	59.18	59.44	58.995	59.31	3014066.0
2016-11-16 12:00:00	MSFT	Stock	59.31	59.39	59.18	59.34	2044068.0
2016-11-16 13:00:00	MSFT	Stock	59.33	59.378	59.14	59.293	1188747.0
2016-11-16 14:00:00	MSFT	Stock	59.295	59.53	59.24	59.515	1858610.0
2016-11-16 15:00:00	MSFT	Stock	59.515	59.66	59.51	59.64	5592441.0
2016-11-16 16:00:00	MSFT	Stock	59.64	59.65	59.45	59.5	3752112.0
2016-11-16 17:00:00	MSFT	Stock	59.59	59.59	59.46	59.59	955.0
2016-11-16 18:00:00	MSFT	Stock	59.6	59.6	59.59	59.59	250.0
2016-11-16 19:00:00	MSFT	Stock	59.5	59.5	59.5	59.5	500.0
2016-11-16 06:00:00	NVDA	Stock	2.185	2.185	2.175	2.175	16000.0
2016-11-16 07:00:00	NVDA	Stock	2.1752	2.1752	2.1625	2.1625	234680.0
2016-11-16 08:00:00	NVDA	Stock	2.1775	2.1875	2.16	2.1738	1040720.0
2016-11-16 09:00:00	NVDA	Stock	2.1688	2.22	2.1586	2.2093	116592120.0
2016-11-16 10:00:00	NVDA	Stock	2.2085	2.2612	2.1926	2.2588	147910480.0
2016-11-16 11:00:00	NVDA	Stock	2.259	2.2985	2.2402	2.292	173350960.0
2016-11-16 12:00:00	NVDA	Stock	2.2915	2.2948	2.2698	2.279	97448440.0
2016-11-16 13:00:00	NVDA	Stock	2.2798	2.3139	2.2798	2.309	104122800.0
2016-11-16 14:00:00	NVDA	Stock	2.309	2.3113	2.2815	2.2919	120327560.0
2016-11-16 15:00:00	NVDA	Stock	2.292	2.2978	2.2838	2.291	131087320.0
2016-11-16 16:00:00	NVDA	Stock	2.2908	2.2922	2.2852	2.29	8837880.0
2016-11-16 17:00:00	NVDA	Stock	2.29	2.2938	2.2892	2.2925	324040.0
2016-11-16 18:00:00	NVDA	Stock	2.291	2.296	2.2908	2.2948	271840.0
2016-11-16 19:00:00	NVDA	Stock	2.2945	2.2945	2.291	2.2938	102760.0
2016-11-16 07:00:00	AMZN	Stock	37.0605	37.1	36.95	37.1	65440.0
2016-11-16 08:00:00	AMZN	Stock	37.0605	37.0605	36.9	36.9	249340.0
2016-11-16 09:00:00	AMZN	Stock	36.9	37.46	36.7805	37.1288	15569200.0
2016-11-16 10:00:00	AMZN	Stock	37.128	37.4935	37.108	37.4145	9899720.0
2016-11-16 11:00:00	AMZN	Stock	37.415	37.4705	37.2765	37.415	6660280.0
2016-11-16 12:00:00	AMZN	Stock	37.3955	37.4235	37.203	37.272	5888880.0

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

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