PREVIEW / stock_5min / 2017-06-05

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-05.parquet
  size:    5.3 MB
  rows:    347,960
  symbols: 3,050

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-06-05 04:00:00	AAPL	Stock	38.6	38.6	38.5075	38.525	28400.0
2017-06-05 04:05:00	AAPL	Stock	38.515	38.5175	38.4875	38.495	16900.0
2017-06-05 04:10:00	AAPL	Stock	38.5	38.5	38.5	38.5	5604.0
2017-06-05 04:20:00	AAPL	Stock	38.55	38.55	38.55	38.55	1600.0
2017-06-05 04:25:00	AAPL	Stock	38.5875	38.6	38.5	38.5	11128.0
2017-06-05 04:30:00	AAPL	Stock	38.575	38.575	38.575	38.575	920.0
2017-06-05 04:45:00	AAPL	Stock	38.5	38.5025	38.465	38.465	6168.0
2017-06-05 05:35:00	AAPL	Stock	38.5675	38.5675	38.5675	38.5675	1124.0
2017-06-05 05:50:00	AAPL	Stock	38.545	38.545	38.545	38.545	1600.0
2017-06-05 06:10:00	AAPL	Stock	38.5275	38.5275	38.525	38.525	1600.0
2017-06-05 06:15:00	AAPL	Stock	38.5075	38.5075	38.465	38.465	12752.0
2017-06-05 06:20:00	AAPL	Stock	38.4675	38.475	38.4675	38.47	4800.0
2017-06-05 06:25:00	AAPL	Stock	38.4975	38.5	38.4875	38.5	9236.0
2017-06-05 06:40:00	AAPL	Stock	38.525	38.525	38.525	38.525	800.0
2017-06-05 06:45:00	AAPL	Stock	38.54	38.54	38.535	38.535	2416.0
2017-06-05 06:50:00	AAPL	Stock	38.525	38.535	38.525	38.535	800.0
2017-06-05 06:55:00	AAPL	Stock	38.525	38.525	38.5125	38.525	3192.0
2017-06-05 07:00:00	AAPL	Stock	38.535	38.545	38.53	38.535	19064.0
2017-06-05 07:05:00	AAPL	Stock	38.5375	38.575	38.525	38.575	18508.0
2017-06-05 07:10:00	AAPL	Stock	38.5725	38.575	38.525	38.525	30632.0
2017-06-05 07:15:00	AAPL	Stock	38.5275	38.5275	38.51	38.525	37672.0
2017-06-05 07:20:00	AAPL	Stock	38.5325	38.55	38.5325	38.55	6136.0
2017-06-05 07:25:00	AAPL	Stock	38.5375	38.5425	38.5375	38.5425	3600.0
2017-06-05 07:30:00	AAPL	Stock	38.545	38.5475	38.545	38.5475	3880.0
2017-06-05 07:35:00	AAPL	Stock	38.555	38.5725	38.555	38.5725	6400.0
2017-06-05 07:40:00	AAPL	Stock	38.575	38.575	38.5625	38.5675	6812.0
2017-06-05 07:45:00	AAPL	Stock	38.5725	38.575	38.55	38.56	78740.0
2017-06-05 07:50:00	AAPL	Stock	38.56	38.56	38.5375	38.545	16536.0
2017-06-05 07:55:00	AAPL	Stock	38.565	38.57	38.545	38.55	9968.0
2017-06-05 08:00:00	AAPL	Stock	38.57	38.8625	38.515	38.565	534280.0
2017-06-05 08:05:00	AAPL	Stock	38.5725	38.575	38.54	38.55	90928.0
2017-06-05 08:10:00	AAPL	Stock	38.55	38.5625	38.5125	38.5125	72072.0
2017-06-05 08:15:00	AAPL	Stock	38.52	38.52	38.4925	38.5	47472.0
2017-06-05 08:20:00	AAPL	Stock	38.495	38.5325	38.49	38.53	35560.0
2017-06-05 08:25:00	AAPL	Stock	38.53	38.5725	38.525	38.57	76144.0
2017-06-05 08:30:00	AAPL	Stock	38.5625	38.575	38.5625	38.5625	21000.0
2017-06-05 08:35:00	AAPL	Stock	38.5625	38.5725	38.55	38.5525	10248.0
2017-06-05 08:40:00	AAPL	Stock	38.56	38.5675	38.56	38.5675	14044.0
2017-06-05 08:45:00	AAPL	Stock	38.57	38.6	38.57	38.5875	74256.0
2017-06-05 08:50:00	AAPL	Stock	38.5925	38.6	38.5725	38.5775	83504.0
2017-06-05 08:55:00	AAPL	Stock	38.58	38.59	38.57	38.59	10928.0
2017-06-05 09:00:00	AAPL	Stock	38.58	38.585	38.575	38.585	25504.0
2017-06-05 09:05:00	AAPL	Stock	38.585	38.6225	38.585	38.62	78980.0
2017-06-05 09:10:00	AAPL	Stock	38.62	38.62	38.575	38.575	36636.0
2017-06-05 09:15:00	AAPL	Stock	38.585	38.5875	38.5725	38.585	13700.0
2017-06-05 09:20:00	AAPL	Stock	38.585	38.5875	38.5625	38.5725	46584.0
2017-06-05 09:25:00	AAPL	Stock	38.5725	38.6075	38.5625	38.5975	137512.0
2017-06-05 09:30:00	AAPL	Stock	38.585	38.6125	38.3975	38.4052	5942388.0
2017-06-05 09:35:00	AAPL	Stock	38.405	38.5075	38.4	38.455	2916624.0
2017-06-05 09:40:00	AAPL	Stock	38.455	38.485	38.4425	38.4475	2392956.0

> showing 50 of 347,960 rows — these rows as CSV

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