PREVIEW / stock_5min / 2017-11-15

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-11-15.parquet
  size:    5.6 MB
  rows:    363,477
  symbols: 2,934

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-11-15 04:00:00	AAPL	Stock	42.61	42.61	42.5	42.5	16904.0
2017-11-15 04:05:00	AAPL	Stock	42.54	42.55	42.54	42.55	4988.0
2017-11-15 04:10:00	AAPL	Stock	42.54	42.54	42.5375	42.5375	7808.0
2017-11-15 04:15:00	AAPL	Stock	42.52	42.52	42.52	42.52	7624.0
2017-11-15 04:20:00	AAPL	Stock	42.52	42.52	42.5	42.5	6800.0
2017-11-15 04:35:00	AAPL	Stock	42.475	42.475	42.455	42.455	17960.0
2017-11-15 04:40:00	AAPL	Stock	42.46	42.46	42.455	42.455	4400.0
2017-11-15 04:45:00	AAPL	Stock	42.46	42.46	42.455	42.46	13400.0
2017-11-15 04:55:00	AAPL	Stock	42.49	42.49	42.46	42.46	2156.0
2017-11-15 05:00:00	AAPL	Stock	42.5	42.5225	42.5	42.5225	5596.0
2017-11-15 05:05:00	AAPL	Stock	42.5225	42.5225	42.5225	42.5225	1372.0
2017-11-15 05:10:00	AAPL	Stock	42.475	42.475	42.475	42.475	5200.0
2017-11-15 05:15:00	AAPL	Stock	42.5	42.5025	42.5	42.5	5600.0
2017-11-15 05:20:00	AAPL	Stock	42.485	42.485	42.485	42.485	5604.0
2017-11-15 05:25:00	AAPL	Stock	42.4825	42.485	42.4825	42.485	6400.0
2017-11-15 05:35:00	AAPL	Stock	42.47	42.4775	42.47	42.4775	800.0
2017-11-15 05:40:00	AAPL	Stock	42.515	42.515	42.515	42.515	1472.0
2017-11-15 05:50:00	AAPL	Stock	42.5025	42.5025	42.485	42.49	3480.0
2017-11-15 05:55:00	AAPL	Stock	42.485	42.4975	42.485	42.4875	1200.0
2017-11-15 06:00:00	AAPL	Stock	42.4975	42.5225	42.4975	42.5225	15916.0
2017-11-15 06:05:00	AAPL	Stock	42.4875	42.4875	42.4875	42.4875	400.0
2017-11-15 06:10:00	AAPL	Stock	42.5	42.5	42.4825	42.4825	1864.0
2017-11-15 06:15:00	AAPL	Stock	42.5	42.5475	42.5	42.5475	8396.0
2017-11-15 06:25:00	AAPL	Stock	42.5475	42.55	42.5475	42.55	6764.0
2017-11-15 06:30:00	AAPL	Stock	42.56	42.56	42.55	42.55	2644.0
2017-11-15 06:35:00	AAPL	Stock	42.575	42.575	42.5525	42.5525	7456.0
2017-11-15 06:45:00	AAPL	Stock	42.54	42.54	42.54	42.54	400.0
2017-11-15 06:50:00	AAPL	Stock	42.54	42.545	42.5	42.545	8548.0
2017-11-15 06:55:00	AAPL	Stock	42.5125	42.5125	42.5125	42.5125	400.0
2017-11-15 07:00:00	AAPL	Stock	42.51	42.575	42.505	42.555	26756.0
2017-11-15 07:05:00	AAPL	Stock	42.57	42.575	42.555	42.575	5368.0
2017-11-15 07:10:00	AAPL	Stock	42.585	42.585	42.55	42.575	12700.0
2017-11-15 07:15:00	AAPL	Stock	42.565	42.565	42.535	42.5375	11116.0
2017-11-15 07:20:00	AAPL	Stock	42.5425	42.585	42.5375	42.5625	16452.0
2017-11-15 07:25:00	AAPL	Stock	42.58	42.6125	42.5625	42.575	26948.0
2017-11-15 07:30:00	AAPL	Stock	42.6075	42.6375	42.5875	42.6375	40496.0
2017-11-15 07:35:00	AAPL	Stock	42.605	42.625	42.6	42.625	16940.0
2017-11-15 07:40:00	AAPL	Stock	42.6225	42.625	42.6025	42.6225	6716.0
2017-11-15 07:45:00	AAPL	Stock	42.6175	42.6175	42.6	42.6	3072.0
2017-11-15 07:50:00	AAPL	Stock	42.5925	42.63	42.5925	42.625	30304.0
2017-11-15 07:55:00	AAPL	Stock	42.625	42.6475	42.625	42.6475	12040.0
2017-11-15 08:00:00	AAPL	Stock	42.575	42.665	42.5	42.665	103096.0
2017-11-15 08:05:00	AAPL	Stock	42.6475	42.67	42.6375	42.6375	28500.0
2017-11-15 08:10:00	AAPL	Stock	42.6275	42.6375	42.6125	42.6125	22008.0
2017-11-15 08:15:00	AAPL	Stock	42.62	42.6275	42.59	42.625	49784.0
2017-11-15 08:20:00	AAPL	Stock	42.6275	42.6375	42.6125	42.6375	79212.0
2017-11-15 08:25:00	AAPL	Stock	42.6125	42.6325	42.6125	42.6325	24992.0
2017-11-15 08:30:00	AAPL	Stock	42.6125	42.64	42.5775	42.5775	23352.0
2017-11-15 08:35:00	AAPL	Stock	42.58	42.5875	42.54	42.54	55076.0
2017-11-15 08:40:00	AAPL	Stock	42.565	42.5675	42.535	42.55	48260.0

> showing 50 of 363,477 rows — these rows as CSV

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