PREVIEW / stock_30min / 2016-10-18

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-18.parquet
  size:    1.6 MB
  rows:    80,707
  symbols: 3,205

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-10-18 04:00:00	AAPL	Stock	29.475	29.575	29.475	29.5675	14112.0
2016-10-18 04:30:00	AAPL	Stock	29.57	29.57	29.57	29.57	1352.0
2016-10-18 05:00:00	AAPL	Stock	29.57	29.57	29.5675	29.5675	1600.0
2016-10-18 05:30:00	AAPL	Stock	29.5775	29.5775	29.5625	29.5625	11164.0
2016-10-18 06:00:00	AAPL	Stock	29.5475	29.575	29.5475	29.5625	9720.0
2016-10-18 06:30:00	AAPL	Stock	29.565	29.5725	29.5625	29.5625	6064.0
2016-10-18 07:00:00	AAPL	Stock	29.5625	29.57	29.5375	29.55	59964.0
2016-10-18 07:30:00	AAPL	Stock	29.55	29.575	29.5425	29.5525	46440.0
2016-10-18 08:00:00	AAPL	Stock	29.55	29.5725	29.325	29.555	273272.0
2016-10-18 08:30:00	AAPL	Stock	29.555	29.6	29.545	29.6	435368.0
2016-10-18 09:00:00	AAPL	Stock	29.59	29.625	29.5025	29.5025	763100.0
2016-10-18 09:30:00	AAPL	Stock	29.545	29.5525	29.3988	29.505	18596428.0
2016-10-18 10:00:00	AAPL	Stock	29.505	29.5225	29.4275	29.4862	9342748.0
2016-10-18 10:30:00	AAPL	Stock	29.4875	29.535	29.4835	29.5025	6269344.0
2016-10-18 11:00:00	AAPL	Stock	29.501	29.5225	29.47	29.48	3880620.0
2016-10-18 11:30:00	AAPL	Stock	29.4775	29.52	29.4575	29.5088	4062116.0
2016-10-18 12:00:00	AAPL	Stock	29.51	29.5475	29.5075	29.54	3896120.0
2016-10-18 12:30:00	AAPL	Stock	29.5425	29.5475	29.4675	29.4955	3795412.0
2016-10-18 13:00:00	AAPL	Stock	29.4975	29.5338	29.4875	29.5225	2273216.0
2016-10-18 13:30:00	AAPL	Stock	29.5225	29.5225	29.4862	29.5	2725096.0
2016-10-18 14:00:00	AAPL	Stock	29.5	29.51	29.465	29.48	2744784.0
2016-10-18 14:30:00	AAPL	Stock	29.4825	29.495	29.4542	29.4675	3249780.0
2016-10-18 15:00:00	AAPL	Stock	29.4675	29.47	29.365	29.3825	7431788.0
2016-10-18 15:30:00	AAPL	Stock	29.383	29.42	29.3625	29.3625	9601092.0
2016-10-18 16:00:00	AAPL	Stock	29.3675	29.3675	29.305	29.325	8003520.0
2016-10-18 16:30:00	AAPL	Stock	29.3375	29.3625	29.3125	29.33	22768.0
2016-10-18 17:00:00	AAPL	Stock	29.3225	29.3375	29.3125	29.325	16912.0
2016-10-18 17:30:00	AAPL	Stock	29.325	29.3675	29.32	29.325	72232.0
2016-10-18 18:00:00	AAPL	Stock	29.3275	29.3525	29.3275	29.3375	9736.0
2016-10-18 18:30:00	AAPL	Stock	29.33	29.3375	29.33	29.3325	52900.0
2016-10-18 19:00:00	AAPL	Stock	29.3375	29.35	29.3175	29.35	45812.0
2016-10-18 19:30:00	AAPL	Stock	29.3475	29.3525	29.325	29.3525	28768.0
2016-10-18 07:00:00	MSFT	Stock	57.55	57.55	57.55	57.55	3000.0
2016-10-18 07:30:00	MSFT	Stock	57.55	57.6	57.4	57.6	17817.0
2016-10-18 08:00:00	MSFT	Stock	57.55	57.63	57.22	57.59	59088.0
2016-10-18 08:30:00	MSFT	Stock	57.53	57.64	57.53	57.61	35495.0
2016-10-18 09:00:00	MSFT	Stock	57.61	57.69	57.54	57.54	50171.0
2016-10-18 09:30:00	MSFT	Stock	57.53	57.945	57.519	57.605	2648625.0
2016-10-18 10:00:00	MSFT	Stock	57.61	57.63	57.41	57.446	1299254.0
2016-10-18 10:30:00	MSFT	Stock	57.44	57.66	57.435	57.62	1241091.0
2016-10-18 11:00:00	MSFT	Stock	57.625	57.72	57.6	57.65	973258.0
2016-10-18 11:30:00	MSFT	Stock	57.66	57.74	57.59	57.735	708113.0
2016-10-18 12:00:00	MSFT	Stock	57.74	57.785	57.73	57.764	668596.0
2016-10-18 12:30:00	MSFT	Stock	57.77	57.78	57.71	57.75	614503.0
2016-10-18 13:00:00	MSFT	Stock	57.745	57.84	57.72	57.78	801813.0
2016-10-18 13:30:00	MSFT	Stock	57.78	57.81	57.71	57.74	796450.0
2016-10-18 14:00:00	MSFT	Stock	57.75	57.81	57.71	57.805	955054.0
2016-10-18 14:30:00	MSFT	Stock	57.81	57.82	57.725	57.8	1088547.0
2016-10-18 15:00:00	MSFT	Stock	57.8	57.81	57.67	57.685	1240178.0
2016-10-18 15:30:00	MSFT	Stock	57.685	57.75	57.65	57.65	2915038.0

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

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