PREVIEW / stock_5min / 2017-09-28

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-28.parquet
  size:    5.4 MB
  rows:    358,147
  symbols: 2,948

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
2017-09-28 04:00:00	AAPL	Stock	38.5575	38.5725	38.5575	38.5725	2280.0
2017-09-28 04:15:00	AAPL	Stock	38.5525	38.5525	38.5525	38.5525	800.0
2017-09-28 05:25:00	AAPL	Stock	38.5875	38.5875	38.5875	38.5875	400.0
2017-09-28 06:05:00	AAPL	Stock	38.575	38.595	38.575	38.595	3192.0
2017-09-28 06:25:00	AAPL	Stock	38.61	38.61	38.61	38.61	1736.0
2017-09-28 06:35:00	AAPL	Stock	38.6	38.6	38.6	38.6	400.0
2017-09-28 06:40:00	AAPL	Stock	38.6125	38.6125	38.6125	38.6125	3600.0
2017-09-28 06:50:00	AAPL	Stock	38.61	38.61	38.61	38.61	1200.0
2017-09-28 06:55:00	AAPL	Stock	38.6	38.6	38.595	38.595	1200.0
2017-09-28 07:00:00	AAPL	Stock	38.5775	38.585	38.5625	38.585	6772.0
2017-09-28 07:05:00	AAPL	Stock	38.5625	38.5625	38.5625	38.5625	5604.0
2017-09-28 07:10:00	AAPL	Stock	38.585	38.585	38.585	38.585	1600.0
2017-09-28 07:15:00	AAPL	Stock	38.5725	38.575	38.5625	38.575	5020.0
2017-09-28 07:20:00	AAPL	Stock	38.5925	38.5925	38.5925	38.5925	400.0
2017-09-28 07:25:00	AAPL	Stock	38.575	38.575	38.5575	38.5575	2056.0
2017-09-28 07:30:00	AAPL	Stock	38.56	38.56	38.5575	38.5575	1820.0
2017-09-28 07:35:00	AAPL	Stock	38.5575	38.5575	38.5475	38.5475	2200.0
2017-09-28 07:40:00	AAPL	Stock	38.5275	38.5275	38.5275	38.5275	400.0
2017-09-28 07:45:00	AAPL	Stock	38.5275	38.5275	38.5	38.505	14008.0
2017-09-28 07:50:00	AAPL	Stock	38.5125	38.5125	38.5	38.5	3200.0
2017-09-28 07:55:00	AAPL	Stock	38.5	38.5	38.465	38.465	3424.0
2017-09-28 08:00:00	AAPL	Stock	38.5862	38.595	38.4675	38.4675	36080.0
2017-09-28 08:05:00	AAPL	Stock	38.475	38.475	38.46	38.465	11160.0
2017-09-28 08:10:00	AAPL	Stock	38.48	38.485	38.4525	38.4525	17308.0
2017-09-28 08:15:00	AAPL	Stock	38.44	38.4525	38.44	38.45	11576.0
2017-09-28 08:20:00	AAPL	Stock	38.45	38.47	38.4425	38.4475	23528.0
2017-09-28 08:25:00	AAPL	Stock	38.4425	38.4625	38.4375	38.4625	13128.0
2017-09-28 08:30:00	AAPL	Stock	38.4375	38.5	38.4375	38.4875	40736.0
2017-09-28 08:35:00	AAPL	Stock	38.4975	38.4975	38.485	38.485	7208.0
2017-09-28 08:40:00	AAPL	Stock	38.4875	38.5	38.4875	38.5	16000.0
2017-09-28 08:45:00	AAPL	Stock	38.4975	38.4975	38.475	38.475	30976.0
2017-09-28 08:50:00	AAPL	Stock	38.47	38.475	38.47	38.475	6000.0
2017-09-28 08:55:00	AAPL	Stock	38.475	38.49	38.475	38.49	11984.0
2017-09-28 09:00:00	AAPL	Stock	38.475	38.475	38.46	38.46	29732.0
2017-09-28 09:05:00	AAPL	Stock	38.4525	38.4625	38.4375	38.4625	7816.0
2017-09-28 09:10:00	AAPL	Stock	38.4525	38.4625	38.4375	38.4375	6440.0
2017-09-28 09:15:00	AAPL	Stock	38.4475	38.475	38.4425	38.4425	11480.0
2017-09-28 09:20:00	AAPL	Stock	38.4475	38.4625	38.425	38.425	33924.0
2017-09-28 09:25:00	AAPL	Stock	38.4475	38.5125	38.4475	38.455	91924.0
2017-09-28 09:30:00	AAPL	Stock	38.4575	38.57	38.4375	38.495	3875552.0
2017-09-28 09:35:00	AAPL	Stock	38.5	38.5575	38.4025	38.4105	2565076.0
2017-09-28 09:40:00	AAPL	Stock	38.4125	38.46	38.3875	38.4425	2210356.0
2017-09-28 09:45:00	AAPL	Stock	38.4425	38.4425	38.355	38.3575	2215408.0
2017-09-28 09:50:00	AAPL	Stock	38.3575	38.3975	38.3225	38.3812	1808540.0
2017-09-28 09:55:00	AAPL	Stock	38.3812	38.3972	38.335	38.34	1307004.0
2017-09-28 10:00:00	AAPL	Stock	38.3375	38.3625	38.27	38.2925	1689308.0
2017-09-28 10:05:00	AAPL	Stock	38.2938	38.3225	38.26	38.3	1595220.0
2017-09-28 10:10:00	AAPL	Stock	38.3	38.3	38.195	38.247	2508028.0
2017-09-28 10:15:00	AAPL	Stock	38.2448	38.27	38.175	38.2125	1875572.0
2017-09-28 10:20:00	AAPL	Stock	38.21	38.275	38.2	38.27	1405192.0

> showing 50 of 358,147 rows — these rows as CSV

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