PREVIEW / stock_30min / 2016-09-30

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-30.parquet
  size:    1.6 MB
  rows:    80,833
  symbols: 3,210

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-09-30 04:00:00	AAPL	Stock	27.9375	27.9375	27.8875	27.93	3540.0
2016-09-30 04:30:00	AAPL	Stock	27.93	27.9425	27.93	27.9425	2828.0
2016-09-30 05:00:00	AAPL	Stock	27.93	27.93	27.93	27.93	400.0
2016-09-30 05:30:00	AAPL	Stock	27.9625	27.9625	27.9625	27.9625	696.0
2016-09-30 06:00:00	AAPL	Stock	27.975	27.9975	27.975	27.9975	1308.0
2016-09-30 06:30:00	AAPL	Stock	27.9775	28.0	27.975	28.0	25624.0
2016-09-30 07:00:00	AAPL	Stock	28.0775	28.17	28.0625	28.155	81188.0
2016-09-30 07:30:00	AAPL	Stock	28.155	28.2125	28.1	28.1275	80988.0
2016-09-30 08:00:00	AAPL	Stock	28.1275	28.175	27.9825	28.1575	95164.0
2016-09-30 08:30:00	AAPL	Stock	28.1625	28.1975	28.155	28.185	132916.0
2016-09-30 09:00:00	AAPL	Stock	28.185	28.2425	28.1175	28.12	539972.0
2016-09-30 09:30:00	AAPL	Stock	28.12	28.3075	28.1125	28.2112	18793328.0
2016-09-30 10:00:00	AAPL	Stock	28.2112	28.23	27.95	28.0712	17719852.0
2016-09-30 10:30:00	AAPL	Stock	28.0702	28.145	28.0212	28.135	8615992.0
2016-09-30 11:00:00	AAPL	Stock	28.135	28.225	28.1325	28.1975	9664100.0
2016-09-30 11:30:00	AAPL	Stock	28.2	28.2275	28.18	28.195	7038556.0
2016-09-30 12:00:00	AAPL	Stock	28.195	28.2775	28.195	28.2675	5887460.0
2016-09-30 12:30:00	AAPL	Stock	28.2675	28.275	28.215	28.2452	4472112.0
2016-09-30 13:00:00	AAPL	Stock	28.245	28.2672	28.23	28.2425	3249288.0
2016-09-30 13:30:00	AAPL	Stock	28.245	28.305	28.235	28.3	4762820.0
2016-09-30 14:00:00	AAPL	Stock	28.3012	28.3175	28.2675	28.275	4327580.0
2016-09-30 14:30:00	AAPL	Stock	28.275	28.3175	28.265	28.3125	4266892.0
2016-09-30 15:00:00	AAPL	Stock	28.31	28.3425	28.2812	28.2875	6297092.0
2016-09-30 15:30:00	AAPL	Stock	28.286	28.305	28.225	28.2575	16919552.0
2016-09-30 16:00:00	AAPL	Stock	28.2525	28.2628	28.2232	28.2525	20999244.0
2016-09-30 16:30:00	AAPL	Stock	28.2525	28.2575	28.2125	28.25	257724.0
2016-09-30 17:00:00	AAPL	Stock	28.2425	28.26	28.2425	28.26	12048.0
2016-09-30 17:30:00	AAPL	Stock	28.2475	28.26	28.245	28.2525	14600.0
2016-09-30 18:00:00	AAPL	Stock	28.2525	28.2675	28.25	28.2625	58776.0
2016-09-30 18:30:00	AAPL	Stock	28.2625	28.2625	28.2575	28.2575	7400.0
2016-09-30 19:00:00	AAPL	Stock	28.2575	28.2575	28.2575	28.2575	14400.0
2016-09-30 19:30:00	AAPL	Stock	28.2625	28.2625	28.2575	28.2625	34468.0
2016-09-30 08:00:00	MSFT	Stock	57.3	57.45	57.3	57.45	285.0
2016-09-30 08:30:00	MSFT	Stock	57.57	57.68	57.55	57.68	3000.0
2016-09-30 09:00:00	MSFT	Stock	57.66	57.66	57.54	57.66	9921.0
2016-09-30 09:30:00	MSFT	Stock	57.57	57.68	57.34	57.35	3242427.0
2016-09-30 10:00:00	MSFT	Stock	57.35	57.51	57.35	57.38	1768476.0
2016-09-30 10:30:00	MSFT	Stock	57.39	57.52	57.35	57.49	1092996.0
2016-09-30 11:00:00	MSFT	Stock	57.49	57.67	57.48	57.62	1404508.0
2016-09-30 11:30:00	MSFT	Stock	57.63	57.65	57.51	57.52	778302.0
2016-09-30 12:00:00	MSFT	Stock	57.514	57.645	57.49	57.62	811896.0
2016-09-30 12:30:00	MSFT	Stock	57.62	57.63	57.49	57.49	857559.0
2016-09-30 13:00:00	MSFT	Stock	57.49	57.55	57.47	57.48	544033.0
2016-09-30 13:30:00	MSFT	Stock	57.48	57.61	57.455	57.55	772641.0
2016-09-30 14:00:00	MSFT	Stock	57.548	57.58	57.514	57.565	985068.0
2016-09-30 14:30:00	MSFT	Stock	57.56	57.63	57.54	57.576	935921.0
2016-09-30 15:00:00	MSFT	Stock	57.58	57.76	57.57	57.72	1433079.0
2016-09-30 15:30:00	MSFT	Stock	57.72	57.77	57.58	57.59	5018919.0
2016-09-30 16:00:00	MSFT	Stock	57.58	57.605	57.47	57.49	7468008.0
2016-09-30 16:30:00	MSFT	Stock	57.6	57.6	57.41	57.45	13044.0

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

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