PREVIEW / stock_30min / 2017-04-21

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-21.parquet
  size:    1.6 MB
  rows:    80,847
  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.5775	35.5775	35.5775	400.0
2017-04-21 05:30:00	AAPL	Stock	35.625	35.625	35.58	35.58	2000.0
2017-04-21 06:00:00	AAPL	Stock	35.625	35.625	35.62	35.6225	3840.0
2017-04-21 06:30:00	AAPL	Stock	35.62	35.62	35.62	35.62	400.0
2017-04-21 07:00:00	AAPL	Stock	35.62	35.675	35.62	35.65	24848.0
2017-04-21 07:30:00	AAPL	Stock	35.6375	35.6375	35.6325	35.6325	2800.0
2017-04-21 08:00:00	AAPL	Stock	35.6575	35.67	35.61	35.625	47852.0
2017-04-21 08:30:00	AAPL	Stock	35.635	35.635	35.615	35.625	24892.0
2017-04-21 09:00:00	AAPL	Stock	35.625	35.6425	35.615	35.625	161296.0
2017-04-21 09:30:00	AAPL	Stock	35.61	35.67	35.5275	35.54	14620452.0
2017-04-21 10:00:00	AAPL	Stock	35.54	35.6275	35.54	35.594	4384432.0
2017-04-21 10:30:00	AAPL	Stock	35.5945	35.6225	35.5675	35.59	3129296.0
2017-04-21 11:00:00	AAPL	Stock	35.5875	35.6325	35.53	35.6012	3982672.0
2017-04-21 11:30:00	AAPL	Stock	35.6025	35.6462	35.5975	35.6075	2744532.0
2017-04-21 12:00:00	AAPL	Stock	35.61	35.6125	35.5472	35.5725	2366212.0
2017-04-21 12:30:00	AAPL	Stock	35.57	35.61	35.5585	35.59	1958180.0
2017-04-21 13:00:00	AAPL	Stock	35.5912	35.6075	35.5125	35.555	3801428.0
2017-04-21 13:30:00	AAPL	Stock	35.555	35.5562	35.505	35.5302	2628400.0
2017-04-21 14:00:00	AAPL	Stock	35.53	35.5375	35.4825	35.52	3155632.0
2017-04-21 14:30:00	AAPL	Stock	35.52	35.5275	35.4775	35.5062	2232600.0
2017-04-21 15:00:00	AAPL	Stock	35.5062	35.5138	35.4625	35.4975	3013132.0
2017-04-21 15:30:00	AAPL	Stock	35.5	35.5825	35.4838	35.5675	8094412.0
2017-04-21 16:00:00	AAPL	Stock	35.5675	35.59	35.55	35.5625	5940424.0
2017-04-21 16:30:00	AAPL	Stock	35.5675	35.57	35.5425	35.5425	42228.0
2017-04-21 17:00:00	AAPL	Stock	35.555	35.5675	35.55	35.5675	16680.0
2017-04-21 17:30:00	AAPL	Stock	35.5675	35.5675	35.515	35.5575	27564.0
2017-04-21 18:00:00	AAPL	Stock	35.55	35.555	35.55	35.555	8000.0
2017-04-21 18:30:00	AAPL	Stock	35.5525	35.56	35.55	35.55	7240.0
2017-04-21 19:00:00	AAPL	Stock	35.56	35.56	35.54	35.54	17200.0
2017-04-21 19:30:00	AAPL	Stock	35.56	35.5625	35.53	35.56	19624.0
2017-04-21 07:00:00	MSFT	Stock	65.86	65.86	65.86	65.86	200.0
2017-04-21 07:30:00	MSFT	Stock	65.55	65.55	65.55	65.55	100.0
2017-04-21 09:00:00	MSFT	Stock	65.72	65.72	65.38	65.53	19970.0
2017-04-21 09:30:00	MSFT	Stock	65.56	65.779	65.45	65.65	4486198.0
2017-04-21 10:00:00	MSFT	Stock	65.66	66.04	65.61	66.01	1844354.0
2017-04-21 10:30:00	MSFT	Stock	66.02	66.28	65.99	66.28	2230770.0
2017-04-21 11:00:00	MSFT	Stock	66.28	66.5	66.24	66.49	2118872.0
2017-04-21 11:30:00	MSFT	Stock	66.499	66.686	66.48	66.63	2196048.0
2017-04-21 12:00:00	MSFT	Stock	66.635	66.7	66.33	66.405	1747291.0
2017-04-21 12:30:00	MSFT	Stock	66.4	66.5	66.36	66.385	808127.0
2017-04-21 13:00:00	MSFT	Stock	66.39	66.41	66.15	66.29	1080584.0
2017-04-21 13:30:00	MSFT	Stock	66.28	66.47	66.24	66.45	859086.0
2017-04-21 14:00:00	MSFT	Stock	66.45	66.56	66.38	66.47	1541881.0
2017-04-21 14:30:00	MSFT	Stock	66.46	66.51	66.41	66.5	1492195.0
2017-04-21 15:00:00	MSFT	Stock	66.5	66.52	66.38	66.42	1441065.0
2017-04-21 15:30:00	MSFT	Stock	66.43	66.545	66.38	66.41	5638857.0
2017-04-21 16:00:00	MSFT	Stock	66.41	66.51	66.36	66.45	2787866.0
2017-04-21 16:30:00	MSFT	Stock	66.57	66.57	66.4	66.45	66300.0
2017-04-21 17:00:00	MSFT	Stock	66.48	66.5	66.47	66.49	6417.0
2017-04-21 17:30:00	MSFT	Stock	66.49	66.5	66.45	66.45	5688.0

> showing 50 of 80,847 rows — these rows as CSV

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