PREVIEW / stock_5min / 2018-07-03

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-03.parquet
  size:    3.5 MB
  rows:    211,530
  symbols: 2,763

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
2018-07-03 04:50:00	AAPL	Stock	46.8175	46.8175	46.8175	46.8175	3884.0
2018-07-03 05:10:00	AAPL	Stock	46.8225	46.8225	46.8225	46.8225	7200.0
2018-07-03 05:40:00	AAPL	Stock	46.925	46.925	46.8275	46.8275	4104.0
2018-07-03 05:45:00	AAPL	Stock	46.83	46.83	46.825	46.825	3720.0
2018-07-03 06:05:00	AAPL	Stock	46.925	46.925	46.925	46.925	808.0
2018-07-03 06:15:00	AAPL	Stock	46.9475	46.9725	46.9475	46.9725	6380.0
2018-07-03 06:35:00	AAPL	Stock	46.9425	46.9425	46.9425	46.9425	400.0
2018-07-03 06:40:00	AAPL	Stock	46.9625	46.975	46.9175	46.9175	8172.0
2018-07-03 07:00:00	AAPL	Stock	46.925	46.95	46.92	46.95	10544.0
2018-07-03 07:05:00	AAPL	Stock	46.9375	46.9475	46.93	46.93	13788.0
2018-07-03 07:10:00	AAPL	Stock	46.945	46.945	46.8925	46.9375	22236.0
2018-07-03 07:15:00	AAPL	Stock	46.9375	46.9375	46.935	46.9375	9952.0
2018-07-03 07:20:00	AAPL	Stock	46.9375	46.9375	46.9125	46.93	4132.0
2018-07-03 07:25:00	AAPL	Stock	46.92	46.965	46.92	46.965	15124.0
2018-07-03 07:30:00	AAPL	Stock	46.9525	46.9525	46.9375	46.945	4800.0
2018-07-03 07:35:00	AAPL	Stock	46.9575	46.9725	46.9575	46.9725	39412.0
2018-07-03 07:40:00	AAPL	Stock	46.9725	46.9775	46.97	46.9775	24600.0
2018-07-03 07:45:00	AAPL	Stock	46.9875	46.9975	46.975	46.975	15560.0
2018-07-03 07:50:00	AAPL	Stock	46.9725	46.9725	46.9375	46.95	26220.0
2018-07-03 07:55:00	AAPL	Stock	46.95	46.965	46.95	46.965	7460.0
2018-07-03 08:00:00	AAPL	Stock	46.975	46.9975	46.92	46.975	72340.0
2018-07-03 08:05:00	AAPL	Stock	46.9825	46.9825	46.9575	46.9575	8756.0
2018-07-03 08:10:00	AAPL	Stock	46.9625	46.9625	46.95	46.95	25220.0
2018-07-03 08:15:00	AAPL	Stock	46.94	46.94	46.9325	46.935	5360.0
2018-07-03 08:20:00	AAPL	Stock	46.9475	46.95	46.925	46.9475	14328.0
2018-07-03 08:25:00	AAPL	Stock	46.925	46.9475	46.925	46.9275	6940.0
2018-07-03 08:30:00	AAPL	Stock	46.9475	46.9625	46.925	46.9375	9728.0
2018-07-03 08:35:00	AAPL	Stock	46.93	46.96	46.9275	46.9575	15608.0
2018-07-03 08:40:00	AAPL	Stock	46.95	46.95	46.9375	46.95	4280.0
2018-07-03 08:45:00	AAPL	Stock	46.9275	46.9275	46.9	46.9	17268.0
2018-07-03 08:50:00	AAPL	Stock	46.9	46.9	46.8875	46.8875	2860.0
2018-07-03 08:55:00	AAPL	Stock	46.91	46.9125	46.91	46.9125	7704.0
2018-07-03 09:00:00	AAPL	Stock	46.9075	46.9375	46.9	46.9125	24084.0
2018-07-03 09:05:00	AAPL	Stock	46.905	46.905	46.8875	46.89	8160.0
2018-07-03 09:10:00	AAPL	Stock	46.8875	46.89	46.8875	46.8875	22092.0
2018-07-03 09:15:00	AAPL	Stock	46.8875	46.9	46.875	46.875	18852.0
2018-07-03 09:20:00	AAPL	Stock	46.8625	46.895	46.85	46.885	14280.0
2018-07-03 09:25:00	AAPL	Stock	46.885	46.9575	46.8375	46.92	29068.0
2018-07-03 09:30:00	AAPL	Stock	46.92	46.9875	46.7955	46.815	3211080.0
2018-07-03 09:35:00	AAPL	Stock	46.8125	46.925	46.65	46.6588	1849596.0
2018-07-03 09:40:00	AAPL	Stock	46.6538	46.7225	46.59	46.625	1974608.0
2018-07-03 09:45:00	AAPL	Stock	46.6325	46.7175	46.62	46.6825	1396972.0
2018-07-03 09:50:00	AAPL	Stock	46.6825	46.7425	46.63	46.665	971588.0
2018-07-03 09:55:00	AAPL	Stock	46.66	46.6825	46.5775	46.675	1037672.0
2018-07-03 10:00:00	AAPL	Stock	46.675	46.738	46.6125	46.685	1301024.0
2018-07-03 10:05:00	AAPL	Stock	46.685	46.6925	46.585	46.65	1008248.0
2018-07-03 10:10:00	AAPL	Stock	46.65	46.6875	46.6325	46.6725	758316.0
2018-07-03 10:15:00	AAPL	Stock	46.6725	46.7625	46.65	46.75	1308372.0
2018-07-03 10:20:00	AAPL	Stock	46.75	46.81	46.715	46.795	825396.0
2018-07-03 10:25:00	AAPL	Stock	46.795	46.7975	46.7275	46.7475	797896.0

> showing 50 of 211,530 rows — these rows as CSV

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