PREVIEW / stock_5min / 2016-09-01

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-09-01.parquet
  size:    5.2 MB
  rows:    345,160
  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:40:00	AAPL	Stock	26.5675	26.5675	26.5675	26.5675	400.0
2016-09-01 04:45:00	AAPL	Stock	26.5775	26.5775	26.5775	26.5775	800.0
2016-09-01 04:55:00	AAPL	Stock	26.5825	26.5825	26.5825	26.5825	2356.0
2016-09-01 05:05:00	AAPL	Stock	26.615	26.615	26.615	26.615	2044.0
2016-09-01 05:35:00	AAPL	Stock	26.5675	26.5675	26.5675	26.5675	1600.0
2016-09-01 05:40:00	AAPL	Stock	26.565	26.565	26.565	26.565	2400.0
2016-09-01 05:45:00	AAPL	Stock	26.5275	26.5275	26.5275	26.5275	800.0
2016-09-01 05:55:00	AAPL	Stock	26.565	26.565	26.565	26.565	800.0
2016-09-01 06:05:00	AAPL	Stock	26.565	26.565	26.565	26.565	2800.0
2016-09-01 06:10:00	AAPL	Stock	26.565	26.5675	26.56	26.56	10428.0
2016-09-01 06:20:00	AAPL	Stock	26.5725	26.61	26.5725	26.61	9468.0
2016-09-01 06:45:00	AAPL	Stock	26.5975	26.5975	26.595	26.595	4000.0
2016-09-01 06:55:00	AAPL	Stock	26.5775	26.5775	26.5775	26.5775	1596.0
2016-09-01 07:05:00	AAPL	Stock	26.6075	26.6075	26.6075	26.6075	1968.0
2016-09-01 07:10:00	AAPL	Stock	26.6075	26.6075	26.5875	26.5875	2100.0
2016-09-01 07:15:00	AAPL	Stock	26.59	26.5925	26.575	26.5925	17280.0
2016-09-01 07:20:00	AAPL	Stock	26.575	26.575	26.575	26.575	1660.0
2016-09-01 07:30:00	AAPL	Stock	26.5775	26.5875	26.5775	26.5875	1600.0
2016-09-01 07:35:00	AAPL	Stock	26.5775	26.5875	26.5775	26.5875	6800.0
2016-09-01 07:40:00	AAPL	Stock	26.5875	26.5875	26.5775	26.5775	2400.0
2016-09-01 07:45:00	AAPL	Stock	26.5825	26.5825	26.5825	26.5825	4000.0
2016-09-01 07:50:00	AAPL	Stock	26.585	26.62	26.585	26.6125	43788.0
2016-09-01 07:55:00	AAPL	Stock	26.6025	26.6125	26.6	26.6125	6884.0
2016-09-01 08:00:00	AAPL	Stock	26.61	26.61	26.5925	26.5975	10680.0
2016-09-01 08:05:00	AAPL	Stock	26.5975	26.5975	26.5875	26.595	7600.0
2016-09-01 08:10:00	AAPL	Stock	26.5875	26.5875	26.5825	26.5825	3400.0
2016-09-01 08:15:00	AAPL	Stock	26.5825	26.5875	26.58	26.58	10440.0
2016-09-01 08:20:00	AAPL	Stock	26.58	26.5875	26.5775	26.5775	12440.0
2016-09-01 08:25:00	AAPL	Stock	26.5775	26.585	26.5775	26.5775	9400.0
2016-09-01 08:30:00	AAPL	Stock	26.585	26.585	26.575	26.575	39804.0
2016-09-01 08:35:00	AAPL	Stock	26.5625	26.5625	26.55	26.56	6288.0
2016-09-01 08:40:00	AAPL	Stock	26.5625	26.5675	26.555	26.5675	23244.0
2016-09-01 08:45:00	AAPL	Stock	26.5675	26.5675	26.555	26.555	7888.0
2016-09-01 08:50:00	AAPL	Stock	26.555	26.555	26.5425	26.5425	4400.0
2016-09-01 08:55:00	AAPL	Stock	26.5425	26.5575	26.5425	26.55	14800.0
2016-09-01 09:00:00	AAPL	Stock	26.55	26.5625	26.55	26.55	1700.0
2016-09-01 09:05:00	AAPL	Stock	26.545	26.5475	26.5375	26.5475	14044.0
2016-09-01 09:10:00	AAPL	Stock	26.55	26.55	26.53	26.53	19624.0
2016-09-01 09:15:00	AAPL	Stock	26.54	26.54	26.53	26.53	6200.0
2016-09-01 09:20:00	AAPL	Stock	26.5375	26.5375	26.49	26.5	48484.0
2016-09-01 09:25:00	AAPL	Stock	26.5	26.54	26.4875	26.5375	40024.0
2016-09-01 09:30:00	AAPL	Stock	26.535	26.575	26.515	26.5508	3822040.0
2016-09-01 09:35:00	AAPL	Stock	26.5512	26.5875	26.535	26.5675	1813216.0
2016-09-01 09:40:00	AAPL	Stock	26.5675	26.615	26.5675	26.5825	1504880.0
2016-09-01 09:45:00	AAPL	Stock	26.585	26.6088	26.565	26.5962	1278288.0
2016-09-01 09:50:00	AAPL	Stock	26.5962	26.6175	26.515	26.54	2675484.0
2016-09-01 09:55:00	AAPL	Stock	26.54	26.5675	26.5225	26.5512	1741988.0
2016-09-01 10:00:00	AAPL	Stock	26.55	26.5862	26.5325	26.5475	1896404.0
2016-09-01 10:05:00	AAPL	Stock	26.5475	26.555	26.52	26.5425	1010504.0
2016-09-01 10:10:00	AAPL	Stock	26.5438	26.57	26.5225	26.5388	1034076.0

> showing 50 of 345,160 rows — these rows as CSV

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