PREVIEW / stock_1hour / 2017-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-21.parquet
  size:    1.0 MB
  rows:    47,908
  symbols: 3,048

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-04-21 05:00:00	AAPL	Stock	35.5775	35.625	35.5775	35.58	2400.0
2017-04-21 06:00:00	AAPL	Stock	35.625	35.625	35.62	35.62	4240.0
2017-04-21 07:00:00	AAPL	Stock	35.62	35.675	35.62	35.6325	27648.0
2017-04-21 08:00:00	AAPL	Stock	35.6575	35.67	35.61	35.625	72744.0
2017-04-21 09:00:00	AAPL	Stock	35.625	35.67	35.5275	35.54	14781748.0
2017-04-21 10:00:00	AAPL	Stock	35.54	35.6275	35.54	35.59	7513728.0
2017-04-21 11:00:00	AAPL	Stock	35.5875	35.6462	35.53	35.6075	6727204.0
2017-04-21 12:00:00	AAPL	Stock	35.61	35.6125	35.5472	35.59	4324392.0
2017-04-21 13:00:00	AAPL	Stock	35.5912	35.6075	35.505	35.5302	6429828.0
2017-04-21 14:00:00	AAPL	Stock	35.53	35.5375	35.4775	35.5062	5388232.0
2017-04-21 15:00:00	AAPL	Stock	35.5062	35.5825	35.4625	35.5675	11107544.0
2017-04-21 16:00:00	AAPL	Stock	35.5675	35.59	35.5425	35.5425	5982652.0
2017-04-21 17:00:00	AAPL	Stock	35.555	35.5675	35.515	35.5575	44244.0
2017-04-21 18:00:00	AAPL	Stock	35.55	35.56	35.55	35.55	15240.0
2017-04-21 19:00:00	AAPL	Stock	35.56	35.5625	35.53	35.56	36824.0
2017-04-21 07:00:00	MSFT	Stock	65.86	65.86	65.55	65.55	300.0
2017-04-21 09:00:00	MSFT	Stock	65.72	65.779	65.38	65.65	4506168.0
2017-04-21 10:00:00	MSFT	Stock	65.66	66.28	65.61	66.28	4075124.0
2017-04-21 11:00:00	MSFT	Stock	66.28	66.686	66.24	66.63	4314920.0
2017-04-21 12:00:00	MSFT	Stock	66.635	66.7	66.33	66.385	2555418.0
2017-04-21 13:00:00	MSFT	Stock	66.39	66.47	66.15	66.45	1939670.0
2017-04-21 14:00:00	MSFT	Stock	66.45	66.56	66.38	66.5	3034076.0
2017-04-21 15:00:00	MSFT	Stock	66.5	66.545	66.38	66.41	7079922.0
2017-04-21 16:00:00	MSFT	Stock	66.41	66.57	66.36	66.45	2854166.0
2017-04-21 17:00:00	MSFT	Stock	66.48	66.5	66.45	66.45	12105.0
2017-04-21 18:00:00	MSFT	Stock	66.41	66.57	66.41	66.45	5128.0
2017-04-21 19:00:00	MSFT	Stock	66.54	66.54	66.43	66.48	3210.0
2017-04-21 04:00:00	NVDA	Stock	2.5363	2.5363	2.5363	2.5363	4000.0
2017-04-21 05:00:00	NVDA	Stock	2.5288	2.5288	2.5288	2.5288	7160.0
2017-04-21 06:00:00	NVDA	Stock	2.52	2.52	2.5175	2.5175	20000.0
2017-04-21 07:00:00	NVDA	Stock	2.5208	2.5208	2.5145	2.5188	72680.0
2017-04-21 08:00:00	NVDA	Stock	2.5235	2.5312	2.5148	2.525	652640.0
2017-04-21 09:00:00	NVDA	Stock	2.5255	2.5305	2.509	2.5265	53796680.0
2017-04-21 10:00:00	NVDA	Stock	2.527	2.5448	2.5245	2.5254	63742200.0
2017-04-21 11:00:00	NVDA	Stock	2.5253	2.5408	2.521	2.5338	38720760.0
2017-04-21 12:00:00	NVDA	Stock	2.5338	2.541	2.5302	2.5382	25087640.0
2017-04-21 13:00:00	NVDA	Stock	2.5382	2.5387	2.5295	2.5355	30733520.0
2017-04-21 14:00:00	NVDA	Stock	2.5358	2.5418	2.5318	2.5408	27830440.0
2017-04-21 15:00:00	NVDA	Stock	2.5408	2.5438	2.5345	2.542	61718760.0
2017-04-21 16:00:00	NVDA	Stock	2.542	2.5438	2.5375	2.5428	10976280.0
2017-04-21 17:00:00	NVDA	Stock	2.5425	2.5425	2.5425	2.5425	8000.0
2017-04-21 18:00:00	NVDA	Stock	2.539	2.54	2.539	2.54	225120.0
2017-04-21 19:00:00	NVDA	Stock	2.5398	2.542	2.5392	2.542	39480.0
2017-04-21 07:00:00	AMZN	Stock	45.23	45.2375	45.1895	45.195	29380.0
2017-04-21 08:00:00	AMZN	Stock	45.23	45.23	45.173	45.22	19300.0
2017-04-21 09:00:00	AMZN	Stock	45.22	45.23	44.9275	44.975	8898420.0
2017-04-21 10:00:00	AMZN	Stock	44.9685	45.002	44.8955	44.9408	6624660.0
2017-04-21 11:00:00	AMZN	Stock	44.9375	44.993	44.9185	44.9488	3764180.0
2017-04-21 12:00:00	AMZN	Stock	44.9475	45.0255	44.9355	44.949	3768660.0
2017-04-21 13:00:00	AMZN	Stock	44.945	44.9625	44.8385	44.9239	4644340.0

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

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