PREVIEW / stock_5min / 2017-07-27

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-27.parquet
  size:    5.5 MB
  rows:    350,492
  symbols: 3,001

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-07-27 04:00:00	AAPL	Stock	38.4975	38.5025	38.4975	38.5025	2800.0
2017-07-27 04:35:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	3384.0
2017-07-27 04:40:00	AAPL	Stock	38.5025	38.5025	38.5025	38.5025	768.0
2017-07-27 04:45:00	AAPL	Stock	38.5025	38.5025	38.5025	38.5025	1956.0
2017-07-27 04:55:00	AAPL	Stock	38.5025	38.55	38.5025	38.55	8652.0
2017-07-27 05:15:00	AAPL	Stock	38.555	38.555	38.555	38.555	456.0
2017-07-27 05:40:00	AAPL	Stock	38.55	38.55	38.55	38.55	624.0
2017-07-27 05:55:00	AAPL	Stock	38.5375	38.5375	38.5375	38.5375	400.0
2017-07-27 06:00:00	AAPL	Stock	38.5125	38.5125	38.5	38.5	2396.0
2017-07-27 06:15:00	AAPL	Stock	38.5	38.5	38.5	38.5	400.0
2017-07-27 06:20:00	AAPL	Stock	38.53	38.53	38.53	38.53	552.0
2017-07-27 06:30:00	AAPL	Stock	38.5025	38.5025	38.5025	38.5025	400.0
2017-07-27 06:35:00	AAPL	Stock	38.525	38.525	38.525	38.525	5172.0
2017-07-27 06:40:00	AAPL	Stock	38.5325	38.535	38.5325	38.535	5680.0
2017-07-27 06:50:00	AAPL	Stock	38.535	38.535	38.535	38.535	1908.0
2017-07-27 07:00:00	AAPL	Stock	38.505	38.505	38.5	38.5	2524.0
2017-07-27 07:10:00	AAPL	Stock	38.5	38.5	38.485	38.485	16364.0
2017-07-27 07:15:00	AAPL	Stock	38.4975	38.5025	38.4975	38.5	8400.0
2017-07-27 07:20:00	AAPL	Stock	38.5	38.5125	38.5	38.5125	6516.0
2017-07-27 07:25:00	AAPL	Stock	38.5125	38.5125	38.5025	38.5025	3640.0
2017-07-27 07:30:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	1000.0
2017-07-27 07:35:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	800.0
2017-07-27 07:40:00	AAPL	Stock	38.5	38.5025	38.4975	38.4975	6252.0
2017-07-27 07:45:00	AAPL	Stock	38.4975	38.5	38.4975	38.5	8388.0
2017-07-27 07:50:00	AAPL	Stock	38.5125	38.5125	38.5025	38.5075	8268.0
2017-07-27 07:55:00	AAPL	Stock	38.515	38.53	38.5025	38.5025	5924.0
2017-07-27 08:00:00	AAPL	Stock	38.5125	38.53	38.5	38.51	61716.0
2017-07-27 08:05:00	AAPL	Stock	38.505	38.5175	38.5	38.505	17720.0
2017-07-27 08:10:00	AAPL	Stock	38.51	38.52	38.505	38.5075	18300.0
2017-07-27 08:15:00	AAPL	Stock	38.52	38.5275	38.5125	38.5275	15452.0
2017-07-27 08:20:00	AAPL	Stock	38.525	38.53	38.515	38.515	25692.0
2017-07-27 08:25:00	AAPL	Stock	38.515	38.515	38.5	38.5	47048.0
2017-07-27 08:30:00	AAPL	Stock	38.5125	38.5325	38.5125	38.5325	18624.0
2017-07-27 08:35:00	AAPL	Stock	38.5125	38.5325	38.51	38.51	19248.0
2017-07-27 08:40:00	AAPL	Stock	38.525	38.5525	38.525	38.55	15416.0
2017-07-27 08:45:00	AAPL	Stock	38.5425	38.5625	38.5425	38.56	14400.0
2017-07-27 08:50:00	AAPL	Stock	38.56	38.56	38.5525	38.56	7444.0
2017-07-27 08:55:00	AAPL	Stock	38.5575	38.57	38.555	38.555	10720.0
2017-07-27 09:00:00	AAPL	Stock	38.5575	38.5675	38.55	38.5625	13976.0
2017-07-27 09:05:00	AAPL	Stock	38.5625	38.5625	38.5575	38.5575	2796.0
2017-07-27 09:10:00	AAPL	Stock	38.5575	38.59	38.5575	38.59	25400.0
2017-07-27 09:15:00	AAPL	Stock	38.575	38.5975	38.56	38.5625	17600.0
2017-07-27 09:20:00	AAPL	Stock	38.56	38.57	38.56	38.565	4520.0
2017-07-27 09:25:00	AAPL	Stock	38.585	38.585	38.4425	38.4425	304460.0
2017-07-27 09:30:00	AAPL	Stock	38.445	38.4975	38.3572	38.4355	3985228.0
2017-07-27 09:35:00	AAPL	Stock	38.4375	38.47	38.3275	38.3302	1692632.0
2017-07-27 09:40:00	AAPL	Stock	38.3312	38.375	38.3025	38.325	1798756.0
2017-07-27 09:45:00	AAPL	Stock	38.325	38.365	38.295	38.305	1912776.0
2017-07-27 09:50:00	AAPL	Stock	38.305	38.3275	38.235	38.24	1852524.0
2017-07-27 09:55:00	AAPL	Stock	38.2375	38.2825	38.2275	38.2522	1096392.0

> showing 50 of 350,492 rows — these rows as CSV

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