PREVIEW / stock_30min / 2016-01-28

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-28.parquet
  size:    1.6 MB
  rows:    81,728
  symbols: 3,361

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-01-28 04:00:00	AAPL	Stock	23.5	23.6975	23.5	23.645	57116.0
2016-01-28 04:30:00	AAPL	Stock	23.6025	23.75	23.6025	23.75	20192.0
2016-01-28 05:00:00	AAPL	Stock	23.7125	23.7125	23.655	23.6625	6384.0
2016-01-28 05:30:00	AAPL	Stock	23.6575	23.6575	23.625	23.625	3800.0
2016-01-28 06:00:00	AAPL	Stock	23.575	23.625	23.5725	23.6225	35388.0
2016-01-28 06:30:00	AAPL	Stock	23.6225	23.6375	23.5275	23.5375	48728.0
2016-01-28 07:00:00	AAPL	Stock	23.535	23.5375	23.475	23.5375	102756.0
2016-01-28 07:30:00	AAPL	Stock	23.5175	23.5175	23.425	23.475	103724.0
2016-01-28 08:00:00	AAPL	Stock	23.4925	23.5625	23.4075	23.475	392696.0
2016-01-28 08:30:00	AAPL	Stock	23.465	23.49	23.375	23.47	436076.0
2016-01-28 09:00:00	AAPL	Stock	23.4725	23.5375	23.4475	23.45	977728.0
2016-01-28 09:30:00	AAPL	Stock	23.4475	23.5875	23.3025	23.4075	36967420.0
2016-01-28 10:00:00	AAPL	Stock	23.4062	23.4557	23.1425	23.2	28737792.0
2016-01-28 10:30:00	AAPL	Stock	23.197	23.4075	23.0975	23.36	19211972.0
2016-01-28 11:00:00	AAPL	Stock	23.36	23.47	23.3438	23.355	12481848.0
2016-01-28 11:30:00	AAPL	Stock	23.36	23.3712	23.2425	23.2525	10872460.0
2016-01-28 12:00:00	AAPL	Stock	23.2525	23.4125	23.25	23.3975	10400300.0
2016-01-28 12:30:00	AAPL	Stock	23.4	23.4875	23.335	23.355	11140172.0
2016-01-28 13:00:00	AAPL	Stock	23.3525	23.4475	23.31	23.38	8913936.0
2016-01-28 13:30:00	AAPL	Stock	23.3798	23.4688	23.3575	23.37	8097228.0
2016-01-28 14:00:00	AAPL	Stock	23.3675	23.585	23.36	23.584	10419096.0
2016-01-28 14:30:00	AAPL	Stock	23.5837	23.63	23.4425	23.4738	11590772.0
2016-01-28 15:00:00	AAPL	Stock	23.4725	23.5675	23.415	23.545	13325556.0
2016-01-28 15:30:00	AAPL	Stock	23.5425	23.6	23.4675	23.52	15301140.0
2016-01-28 16:00:00	AAPL	Stock	23.5225	23.5375	23.42	23.425	4148420.0
2016-01-28 16:30:00	AAPL	Stock	23.425	23.4575	23.4	23.4175	149580.0
2016-01-28 17:00:00	AAPL	Stock	23.4075	23.4475	23.3875	23.4275	99868.0
2016-01-28 17:30:00	AAPL	Stock	23.4275	23.445	23.425	23.425	26348.0
2016-01-28 18:00:00	AAPL	Stock	23.425	23.5225	23.4125	23.425	27032.0
2016-01-28 18:30:00	AAPL	Stock	23.425	23.455	23.42	23.455	47860.0
2016-01-28 19:00:00	AAPL	Stock	23.45	23.45	23.425	23.4425	10564.0
2016-01-28 19:30:00	AAPL	Stock	23.415	23.44	23.4125	23.4125	29752.0
2016-01-28 04:00:00	MSFT	Stock	51.85	51.85	51.85	51.85	1249.0
2016-01-28 06:00:00	MSFT	Stock	51.7	51.7	51.6	51.6	3731.0
2016-01-28 06:30:00	MSFT	Stock	51.67	51.69	51.52	51.52	2100.0
2016-01-28 07:00:00	MSFT	Stock	51.4	51.59	51.4	51.59	3050.0
2016-01-28 07:30:00	MSFT	Stock	51.6	51.68	51.59	51.65	2946.0
2016-01-28 08:00:00	MSFT	Stock	51.66	51.67	51.55	51.6	20672.0
2016-01-28 08:30:00	MSFT	Stock	51.5	51.57	51.43	51.57	22990.0
2016-01-28 09:00:00	MSFT	Stock	51.57	51.86	51.55	51.85	109294.0
2016-01-28 09:30:00	MSFT	Stock	51.84	52.15	51.465	52.075	5529164.0
2016-01-28 10:00:00	MSFT	Stock	52.07	52.07	51.29	51.5	4289944.0
2016-01-28 10:30:00	MSFT	Stock	51.49	51.59	51.25	51.49	2683192.0
2016-01-28 11:00:00	MSFT	Stock	51.485	51.89	51.43	51.68	2429408.0
2016-01-28 11:30:00	MSFT	Stock	51.695	51.72	51.28	51.365	2682742.0
2016-01-28 12:00:00	MSFT	Stock	51.36	52.03	51.34	51.954	2377350.0
2016-01-28 12:30:00	MSFT	Stock	51.95	52.21	51.831	51.89	2881118.0
2016-01-28 13:00:00	MSFT	Stock	51.885	52.02	51.45	51.72	3538769.0
2016-01-28 13:30:00	MSFT	Stock	51.71	51.87	51.55	51.57	2552615.0
2016-01-28 14:00:00	MSFT	Stock	51.56	52.02	51.514	52.0	2783480.0

> showing 50 of 81,728 rows — these rows as CSV

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