PREVIEW / stock_1hour / 2016-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-17.parquet
  size:    1.1 MB
  rows:    48,844
  symbols: 3,189

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-17 04:00:00	AAPL	Stock	27.4975	27.4975	27.4975	27.4975	4032.0
2016-11-17 05:00:00	AAPL	Stock	27.46	27.46	27.46	27.46	3988.0
2016-11-17 06:00:00	AAPL	Stock	27.45	27.45	27.44	27.44	5068.0
2016-11-17 07:00:00	AAPL	Stock	27.465	27.5325	27.46	27.48	17456.0
2016-11-17 08:00:00	AAPL	Stock	27.475	27.5425	27.4425	27.45	227228.0
2016-11-17 09:00:00	AAPL	Stock	27.47	27.5875	27.3312	27.4175	17207684.0
2016-11-17 10:00:00	AAPL	Stock	27.4175	27.4275	27.2075	27.2328	19860684.0
2016-11-17 11:00:00	AAPL	Stock	27.2325	27.38	27.2125	27.375	13901856.0
2016-11-17 12:00:00	AAPL	Stock	27.375	27.445	27.365	27.42	11073864.0
2016-11-17 13:00:00	AAPL	Stock	27.42	27.4725	27.4075	27.42	8720924.0
2016-11-17 14:00:00	AAPL	Stock	27.42	27.4325	27.351	27.415	9145920.0
2016-11-17 15:00:00	AAPL	Stock	27.415	27.49	27.3975	27.485	14591796.0
2016-11-17 16:00:00	AAPL	Stock	27.485	27.4975	27.3025	27.46	11303576.0
2016-11-17 17:00:00	AAPL	Stock	27.48	27.51	27.475	27.5025	38292.0
2016-11-17 18:00:00	AAPL	Stock	27.5025	27.51	27.5	27.5025	7560.0
2016-11-17 19:00:00	AAPL	Stock	27.5	27.5	27.4575	27.4625	15832.0
2016-11-17 04:00:00	MSFT	Stock	60.04	60.07	60.0	60.0	21505.0
2016-11-17 05:00:00	MSFT	Stock	60.18	60.35	60.18	60.21	1780.0
2016-11-17 06:00:00	MSFT	Stock	60.3	60.4	60.3	60.35	4505.0
2016-11-17 07:00:00	MSFT	Stock	60.3	60.61	60.3	60.59	41285.0
2016-11-17 08:00:00	MSFT	Stock	60.51	60.6	60.33	60.33	57104.0
2016-11-17 09:00:00	MSFT	Stock	60.33	60.45	59.965	60.329	4768314.0
2016-11-17 10:00:00	MSFT	Stock	60.34	60.41	60.25	60.3	3416861.0
2016-11-17 11:00:00	MSFT	Stock	60.3	60.57	60.28	60.55	3659341.0
2016-11-17 12:00:00	MSFT	Stock	60.555	60.75	60.46	60.705	3742927.0
2016-11-17 13:00:00	MSFT	Stock	60.7	60.95	60.7	60.83	2666880.0
2016-11-17 14:00:00	MSFT	Stock	60.83	60.855	60.54	60.67	3497066.0
2016-11-17 15:00:00	MSFT	Stock	60.66	60.73	60.64	60.64	5653278.0
2016-11-17 16:00:00	MSFT	Stock	60.64	60.85	60.64	60.64	2838603.0
2016-11-17 17:00:00	MSFT	Stock	60.7	60.82	60.64	60.82	46909.0
2016-11-17 18:00:00	MSFT	Stock	60.75	60.78	60.68	60.68	947.0
2016-11-17 19:00:00	MSFT	Stock	60.7	60.76	60.68	60.68	3301.0
2016-11-17 05:00:00	NVDA	Stock	2.3	2.3	2.295	2.295	16000.0
2016-11-17 06:00:00	NVDA	Stock	2.295	2.3005	2.295	2.3	48120.0
2016-11-17 07:00:00	NVDA	Stock	2.3	2.31	2.3	2.3075	350720.0
2016-11-17 08:00:00	NVDA	Stock	2.3098	2.3122	2.285	2.308	1738600.0
2016-11-17 09:00:00	NVDA	Stock	2.3062	2.315	2.2663	2.309	117016880.0
2016-11-17 10:00:00	NVDA	Stock	2.3092	2.355	2.3088	2.3475	155956840.0
2016-11-17 11:00:00	NVDA	Stock	2.3462	2.3698	2.3382	2.3605	98402280.0
2016-11-17 12:00:00	NVDA	Stock	2.3602	2.3675	2.3352	2.3404	90834560.0
2016-11-17 13:00:00	NVDA	Stock	2.3402	2.3545	2.3398	2.3465	55901600.0
2016-11-17 14:00:00	NVDA	Stock	2.3467	2.353	2.308	2.3148	93227480.0
2016-11-17 15:00:00	NVDA	Stock	2.3146	2.316	2.271	2.3098	179107640.0
2016-11-17 16:00:00	NVDA	Stock	2.3098	2.315	2.302	2.315	8888440.0
2016-11-17 17:00:00	NVDA	Stock	2.3098	2.3125	2.3098	2.3125	76440.0
2016-11-17 18:00:00	NVDA	Stock	2.315	2.316	2.31	2.3122	231000.0
2016-11-17 19:00:00	NVDA	Stock	2.3118	2.3158	2.3113	2.3122	257200.0
2016-11-17 04:00:00	AMZN	Stock	37.35	37.35	37.3495	37.3495	6960.0
2016-11-17 05:00:00	AMZN	Stock	37.345	37.387	37.345	37.363	6220.0
2016-11-17 07:00:00	AMZN	Stock	37.395	37.4375	37.321	37.3315	34060.0

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

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