PREVIEW / stock_5min / 2016-09-23

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-09-23.parquet
  size:    5.2 MB
  rows:    342,857
  symbols: 3,222

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-23 04:25:00	AAPL	Stock	28.6125	28.6125	28.6125	28.6125	644.0
2016-09-23 05:25:00	AAPL	Stock	28.6125	28.6125	28.6125	28.6125	400.0
2016-09-23 06:10:00	AAPL	Stock	28.5675	28.5675	28.5675	28.5675	800.0
2016-09-23 06:15:00	AAPL	Stock	28.6125	28.62	28.6125	28.62	1160.0
2016-09-23 06:20:00	AAPL	Stock	28.62	28.62	28.6	28.6	2564.0
2016-09-23 06:25:00	AAPL	Stock	28.5825	28.5825	28.5825	28.5825	400.0
2016-09-23 06:40:00	AAPL	Stock	28.59	28.59	28.59	28.59	400.0
2016-09-23 06:50:00	AAPL	Stock	28.59	28.59	28.5875	28.5875	1600.0
2016-09-23 06:55:00	AAPL	Stock	28.5825	28.5825	28.5825	28.5825	400.0
2016-09-23 07:00:00	AAPL	Stock	28.5875	28.5875	28.5875	28.5875	400.0
2016-09-23 07:20:00	AAPL	Stock	28.6	28.6	28.6	28.6	460.0
2016-09-23 07:25:00	AAPL	Stock	28.61	28.61	28.605	28.605	4400.0
2016-09-23 07:30:00	AAPL	Stock	28.605	28.605	28.6	28.6	4800.0
2016-09-23 07:35:00	AAPL	Stock	28.5975	28.6125	28.595	28.6125	2996.0
2016-09-23 07:40:00	AAPL	Stock	28.6	28.62	28.6	28.62	3000.0
2016-09-23 07:45:00	AAPL	Stock	28.6025	28.6125	28.6	28.6125	4124.0
2016-09-23 07:50:00	AAPL	Stock	28.6125	28.6125	28.6125	28.6125	2000.0
2016-09-23 08:00:00	AAPL	Stock	28.6	28.6125	28.585	28.5975	59968.0
2016-09-23 08:05:00	AAPL	Stock	28.59	28.6175	28.59	28.6	19000.0
2016-09-23 08:10:00	AAPL	Stock	28.605	28.615	28.605	28.6125	14436.0
2016-09-23 08:15:00	AAPL	Stock	28.6075	28.6125	28.6075	28.6125	4000.0
2016-09-23 08:20:00	AAPL	Stock	28.6075	28.6125	28.5975	28.6125	19000.0
2016-09-23 08:25:00	AAPL	Stock	28.6025	28.6225	28.6025	28.6075	22640.0
2016-09-23 08:30:00	AAPL	Stock	28.605	28.6225	28.605	28.6125	36004.0
2016-09-23 08:35:00	AAPL	Stock	28.6175	28.655	28.61	28.655	34256.0
2016-09-23 08:40:00	AAPL	Stock	28.625	28.625	28.6225	28.625	3560.0
2016-09-23 08:45:00	AAPL	Stock	28.625	28.625	28.62	28.625	8600.0
2016-09-23 08:50:00	AAPL	Stock	28.6175	28.625	28.6175	28.6175	32240.0
2016-09-23 08:55:00	AAPL	Stock	28.625	28.625	28.6225	28.6225	7960.0
2016-09-23 09:00:00	AAPL	Stock	28.6175	28.6325	28.61	28.6325	28644.0
2016-09-23 09:05:00	AAPL	Stock	28.635	28.7275	28.63	28.655	198956.0
2016-09-23 09:10:00	AAPL	Stock	28.6675	28.6675	28.6375	28.655	51680.0
2016-09-23 09:15:00	AAPL	Stock	28.65	28.65	28.65	28.65	800.0
2016-09-23 09:20:00	AAPL	Stock	28.645	28.655	28.615	28.615	65992.0
2016-09-23 09:25:00	AAPL	Stock	28.615	28.64	28.605	28.64	85200.0
2016-09-23 09:30:00	AAPL	Stock	28.605	28.6975	28.5875	28.6475	5726604.0
2016-09-23 09:35:00	AAPL	Stock	28.65	28.6525	28.5675	28.5975	2758796.0
2016-09-23 09:40:00	AAPL	Stock	28.5948	28.6225	28.5375	28.56	2658840.0
2016-09-23 09:45:00	AAPL	Stock	28.5575	28.625	28.5375	28.625	1881576.0
2016-09-23 09:50:00	AAPL	Stock	28.625	28.625	28.5775	28.6025	1289060.0
2016-09-23 09:55:00	AAPL	Stock	28.6025	28.605	28.535	28.5355	1459608.0
2016-09-23 10:00:00	AAPL	Stock	28.5375	28.5725	28.5325	28.5725	1333952.0
2016-09-23 10:05:00	AAPL	Stock	28.573	28.573	28.541	28.5575	1039508.0
2016-09-23 10:10:00	AAPL	Stock	28.556	28.56	28.5275	28.5442	2078468.0
2016-09-23 10:15:00	AAPL	Stock	28.5475	28.5925	28.525	28.5835	1579564.0
2016-09-23 10:20:00	AAPL	Stock	28.5825	28.6138	28.56	28.605	1262128.0
2016-09-23 10:25:00	AAPL	Stock	28.6075	28.6075	28.5775	28.595	964308.0
2016-09-23 10:30:00	AAPL	Stock	28.5962	28.6	28.5775	28.5775	795804.0
2016-09-23 10:35:00	AAPL	Stock	28.58	28.585	28.5625	28.58	742404.0
2016-09-23 10:40:00	AAPL	Stock	28.58	28.6175	28.5725	28.6162	1181900.0

> showing 50 of 342,857 rows — these rows as CSV

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