PREVIEW / stock_30min / 2016-09-01

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-01.parquet
  size:    1.6 MB
  rows:    80,400
  symbols: 3,228

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-01 04:30:00	AAPL	Stock	26.5675	26.5825	26.5675	26.5825	3556.0
2016-09-01 05:00:00	AAPL	Stock	26.615	26.615	26.615	26.615	2044.0
2016-09-01 05:30:00	AAPL	Stock	26.5675	26.5675	26.5275	26.565	5600.0
2016-09-01 06:00:00	AAPL	Stock	26.565	26.61	26.56	26.61	22696.0
2016-09-01 06:30:00	AAPL	Stock	26.5975	26.5975	26.5775	26.5775	5596.0
2016-09-01 07:00:00	AAPL	Stock	26.6075	26.6075	26.575	26.575	23008.0
2016-09-01 07:30:00	AAPL	Stock	26.5775	26.62	26.5775	26.6125	65472.0
2016-09-01 08:00:00	AAPL	Stock	26.61	26.61	26.5775	26.5775	53960.0
2016-09-01 08:30:00	AAPL	Stock	26.585	26.585	26.5425	26.55	96424.0
2016-09-01 09:00:00	AAPL	Stock	26.55	26.5625	26.4875	26.5375	130076.0
2016-09-01 09:30:00	AAPL	Stock	26.535	26.6175	26.515	26.5512	12835896.0
2016-09-01 10:00:00	AAPL	Stock	26.55	26.5862	26.44	26.444	9927108.0
2016-09-01 10:30:00	AAPL	Stock	26.4425	26.5075	26.405	26.4865	7841204.0
2016-09-01 11:00:00	AAPL	Stock	26.485	26.5125	26.4375	26.5068	5234540.0
2016-09-01 11:30:00	AAPL	Stock	26.505	26.5525	26.4925	26.5475	4637404.0
2016-09-01 12:00:00	AAPL	Stock	26.5472	26.63	26.53	26.5975	6241488.0
2016-09-01 12:30:00	AAPL	Stock	26.5975	26.6475	26.59	26.635	4558832.0
2016-09-01 13:00:00	AAPL	Stock	26.6362	26.7	26.6325	26.644	4267936.0
2016-09-01 13:30:00	AAPL	Stock	26.645	26.6782	26.6225	26.6625	4234788.0
2016-09-01 14:00:00	AAPL	Stock	26.66	26.665	26.6175	26.6525	3993468.0
2016-09-01 14:30:00	AAPL	Stock	26.6512	26.6725	26.64	26.655	3944648.0
2016-09-01 15:00:00	AAPL	Stock	26.6575	26.6638	26.5825	26.59	5019568.0
2016-09-01 15:30:00	AAPL	Stock	26.59	26.6825	26.5775	26.6825	9053784.0
2016-09-01 16:00:00	AAPL	Stock	26.6775	26.6875	26.56	26.6875	5330676.0
2016-09-01 16:30:00	AAPL	Stock	26.68	26.68	26.65	26.655	23356.0
2016-09-01 17:00:00	AAPL	Stock	26.6775	26.685	26.66	26.685	23460.0
2016-09-01 17:30:00	AAPL	Stock	26.685	26.685	26.625	26.625	10560.0
2016-09-01 18:00:00	AAPL	Stock	26.6775	26.6825	26.675	26.6775	5400.0
2016-09-01 19:00:00	AAPL	Stock	26.6625	26.6625	26.6625	26.6625	1080.0
2016-09-01 19:30:00	AAPL	Stock	26.68	26.685	26.675	26.685	19796.0
2016-09-01 05:00:00	MSFT	Stock	57.6	57.6	57.42	57.49	2584.0
2016-09-01 05:30:00	MSFT	Stock	57.47	57.48	57.47	57.48	1869.0
2016-09-01 06:00:00	MSFT	Stock	57.5	57.55	57.5	57.55	1100.0
2016-09-01 06:30:00	MSFT	Stock	57.65	57.76	57.54	57.54	15136.0
2016-09-01 07:00:00	MSFT	Stock	57.68	57.68	57.5	57.52	6267.0
2016-09-01 08:00:00	MSFT	Stock	57.52	57.52	57.31	57.44	12018.0
2016-09-01 08:30:00	MSFT	Stock	57.44	57.46	57.28	57.39	5519.0
2016-09-01 09:00:00	MSFT	Stock	57.35	57.36	57.02	57.02	102675.0
2016-09-01 09:30:00	MSFT	Stock	57.02	57.71	57.01	57.51	3495602.0
2016-09-01 10:00:00	MSFT	Stock	57.505	57.58	57.33	57.33	1862092.0
2016-09-01 10:30:00	MSFT	Stock	57.33	57.33	57.152	57.24	1691874.0
2016-09-01 11:00:00	MSFT	Stock	57.245	57.42	57.14	57.405	1281734.0
2016-09-01 11:30:00	MSFT	Stock	57.4	57.5	57.33	57.43	1270009.0
2016-09-01 12:00:00	MSFT	Stock	57.43	57.71	57.405	57.68	1452542.0
2016-09-01 12:30:00	MSFT	Stock	57.69	57.78	57.67	57.704	1137072.0
2016-09-01 13:00:00	MSFT	Stock	57.7	57.82	57.69	57.77	1155576.0
2016-09-01 13:30:00	MSFT	Stock	57.78	57.79	57.63	57.64	1083519.0
2016-09-01 14:00:00	MSFT	Stock	57.645	57.65	57.51	57.53	1480438.0
2016-09-01 14:30:00	MSFT	Stock	57.53	57.57	57.46	57.52	1376810.0
2016-09-01 15:00:00	MSFT	Stock	57.52	57.535	57.33	57.43	1914336.0

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

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