PREVIEW / stock_5min / 2017-03-21

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-21.parquet
  size:    5.5 MB
  rows:    359,520
  symbols: 3,073

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-03-21 04:00:00	AAPL	Stock	35.3975	35.4575	35.3975	35.4575	4604.0
2017-03-21 04:05:00	AAPL	Stock	35.4575	35.4575	35.4575	35.4575	3396.0
2017-03-21 04:10:00	AAPL	Stock	35.4575	35.4575	35.4575	35.4575	800.0
2017-03-21 04:45:00	AAPL	Stock	35.455	35.455	35.455	35.455	596.0
2017-03-21 05:05:00	AAPL	Stock	35.465	35.465	35.465	35.465	868.0
2017-03-21 05:15:00	AAPL	Stock	35.46	35.4675	35.46	35.4675	4000.0
2017-03-21 06:00:00	AAPL	Stock	35.465	35.4675	35.465	35.4675	3068.0
2017-03-21 06:10:00	AAPL	Stock	35.455	35.4675	35.455	35.4675	2380.0
2017-03-21 06:15:00	AAPL	Stock	35.4575	35.4575	35.4575	35.4575	1976.0
2017-03-21 06:20:00	AAPL	Stock	35.465	35.465	35.465	35.465	800.0
2017-03-21 06:25:00	AAPL	Stock	35.465	35.465	35.465	35.465	400.0
2017-03-21 06:35:00	AAPL	Stock	35.4625	35.4625	35.45	35.45	3668.0
2017-03-21 06:40:00	AAPL	Stock	35.4625	35.4625	35.4625	35.4625	1628.0
2017-03-21 06:45:00	AAPL	Stock	35.45	35.45	35.45	35.45	2000.0
2017-03-21 06:50:00	AAPL	Stock	35.45	35.45	35.45	35.45	400.0
2017-03-21 06:55:00	AAPL	Stock	35.46	35.46	35.46	35.46	400.0
2017-03-21 07:00:00	AAPL	Stock	35.46	35.46	35.46	35.46	592.0
2017-03-21 07:05:00	AAPL	Stock	35.46	35.46	35.45	35.45	3420.0
2017-03-21 07:10:00	AAPL	Stock	35.45	35.45	35.4375	35.4475	4848.0
2017-03-21 07:15:00	AAPL	Stock	35.435	35.4375	35.435	35.435	1200.0
2017-03-21 07:20:00	AAPL	Stock	35.4375	35.4375	35.435	35.435	1600.0
2017-03-21 07:25:00	AAPL	Stock	35.4375	35.4375	35.4375	35.4375	12892.0
2017-03-21 07:30:00	AAPL	Stock	35.4375	35.4375	35.4325	35.435	5000.0
2017-03-21 07:35:00	AAPL	Stock	35.435	35.4375	35.435	35.4375	18556.0
2017-03-21 07:40:00	AAPL	Stock	35.45	35.4625	35.4475	35.4625	27332.0
2017-03-21 07:45:00	AAPL	Stock	35.4625	35.4625	35.44	35.44	5600.0
2017-03-21 07:50:00	AAPL	Stock	35.4575	35.4575	35.4375	35.4425	6460.0
2017-03-21 07:55:00	AAPL	Stock	35.45	35.4625	35.45	35.4625	2928.0
2017-03-21 08:00:00	AAPL	Stock	35.4525	35.51	35.4275	35.5	82516.0
2017-03-21 08:05:00	AAPL	Stock	35.51	35.5125	35.4875	35.4875	41744.0
2017-03-21 08:10:00	AAPL	Stock	35.4775	35.4975	35.4775	35.4975	22268.0
2017-03-21 08:15:00	AAPL	Stock	35.4875	35.525	35.4875	35.5125	60648.0
2017-03-21 08:20:00	AAPL	Stock	35.5225	35.525	35.4925	35.4925	19680.0
2017-03-21 08:25:00	AAPL	Stock	35.5025	35.5025	35.4925	35.5	55132.0
2017-03-21 08:30:00	AAPL	Stock	35.5	35.515	35.455	35.505	135776.0
2017-03-21 08:35:00	AAPL	Stock	35.5125	35.5375	35.5125	35.5225	123904.0
2017-03-21 08:40:00	AAPL	Stock	35.5225	35.54	35.5225	35.53	114476.0
2017-03-21 08:45:00	AAPL	Stock	35.525	35.5325	35.52	35.5275	21372.0
2017-03-21 08:50:00	AAPL	Stock	35.525	35.525	35.525	35.525	8076.0
2017-03-21 08:55:00	AAPL	Stock	35.53	35.55	35.525	35.53	47652.0
2017-03-21 09:00:00	AAPL	Stock	35.5225	35.5375	35.52	35.52	43852.0
2017-03-21 09:05:00	AAPL	Stock	35.525	35.5375	35.52	35.5275	33928.0
2017-03-21 09:10:00	AAPL	Stock	35.53	35.5375	35.525	35.525	25424.0
2017-03-21 09:15:00	AAPL	Stock	35.525	35.53	35.525	35.53	56628.0
2017-03-21 09:20:00	AAPL	Stock	35.5275	35.5425	35.4775	35.535	131952.0
2017-03-21 09:25:00	AAPL	Stock	35.5375	35.54	35.5275	35.54	39616.0
2017-03-21 09:30:00	AAPL	Stock	35.5275	35.6275	35.5275	35.62	8142264.0
2017-03-21 09:35:00	AAPL	Stock	35.615	35.685	35.6075	35.6183	4942260.0
2017-03-21 09:40:00	AAPL	Stock	35.6175	35.675	35.6125	35.6725	2397256.0
2017-03-21 09:45:00	AAPL	Stock	35.675	35.7	35.655	35.6738	2444792.0

> showing 50 of 359,520 rows — these rows as CSV

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