PREVIEW / stock_5min / 2017-06-07

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-07.parquet
  size:    5.4 MB
  rows:    350,730
  symbols: 3,042

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-07 05:25:00	AAPL	Stock	38.6675	38.6875	38.6675	38.685	5000.0
2017-06-07 05:30:00	AAPL	Stock	38.685	38.685	38.685	38.685	820.0
2017-06-07 06:35:00	AAPL	Stock	38.67	38.67	38.67	38.67	800.0
2017-06-07 07:05:00	AAPL	Stock	38.655	38.655	38.655	38.655	800.0
2017-06-07 07:10:00	AAPL	Stock	38.6725	38.6725	38.655	38.655	800.0
2017-06-07 07:15:00	AAPL	Stock	38.65	38.65	38.6375	38.6375	2800.0
2017-06-07 07:20:00	AAPL	Stock	38.65	38.6625	38.65	38.6625	4388.0
2017-06-07 07:25:00	AAPL	Stock	38.685	38.6975	38.675	38.6975	9888.0
2017-06-07 07:30:00	AAPL	Stock	38.7	38.7125	38.7	38.7125	7032.0
2017-06-07 07:35:00	AAPL	Stock	38.71	38.71	38.71	38.71	2000.0
2017-06-07 07:40:00	AAPL	Stock	38.685	38.685	38.685	38.685	400.0
2017-06-07 07:50:00	AAPL	Stock	38.6975	38.7025	38.6975	38.7025	4484.0
2017-06-07 07:55:00	AAPL	Stock	38.7125	38.7175	38.7125	38.7175	4088.0
2017-06-07 08:00:00	AAPL	Stock	38.6875	38.7175	38.6875	38.6925	13856.0
2017-06-07 08:05:00	AAPL	Stock	38.6875	38.7	38.6875	38.7	6988.0
2017-06-07 08:10:00	AAPL	Stock	38.7	38.715	38.6975	38.715	15624.0
2017-06-07 08:15:00	AAPL	Stock	38.7125	38.725	38.705	38.7175	35404.0
2017-06-07 08:20:00	AAPL	Stock	38.7125	38.7125	38.7125	38.7125	1200.0
2017-06-07 08:25:00	AAPL	Stock	38.7125	38.72	38.7125	38.72	7200.0
2017-06-07 08:30:00	AAPL	Stock	38.72	38.72	38.715	38.715	3944.0
2017-06-07 08:35:00	AAPL	Stock	38.72	38.72	38.715	38.7175	5092.0
2017-06-07 08:40:00	AAPL	Stock	38.7175	38.73	38.71	38.73	17176.0
2017-06-07 08:45:00	AAPL	Stock	38.735	38.7375	38.7325	38.7375	14504.0
2017-06-07 08:50:00	AAPL	Stock	38.725	38.7375	38.725	38.725	8596.0
2017-06-07 08:55:00	AAPL	Stock	38.7275	38.735	38.7275	38.735	25772.0
2017-06-07 09:00:00	AAPL	Stock	38.735	38.745	38.7325	38.7375	11048.0
2017-06-07 09:05:00	AAPL	Stock	38.7375	38.7425	38.73	38.74	10720.0
2017-06-07 09:10:00	AAPL	Stock	38.7325	38.7325	38.7325	38.7325	800.0
2017-06-07 09:15:00	AAPL	Stock	38.7325	38.7325	38.7075	38.7075	18132.0
2017-06-07 09:20:00	AAPL	Stock	38.7125	38.715	38.71	38.7125	20392.0
2017-06-07 09:25:00	AAPL	Stock	38.7125	38.7525	38.7125	38.75	109244.0
2017-06-07 09:30:00	AAPL	Stock	38.7525	38.845	38.73	38.8425	4171064.0
2017-06-07 09:35:00	AAPL	Stock	38.825	38.9175	38.82	38.8787	3167804.0
2017-06-07 09:40:00	AAPL	Stock	38.8775	38.95	38.875	38.9175	2279188.0
2017-06-07 09:45:00	AAPL	Stock	38.9225	38.945	38.8875	38.8985	1989500.0
2017-06-07 09:50:00	AAPL	Stock	38.8988	38.9075	38.79	38.8425	2287996.0
2017-06-07 09:55:00	AAPL	Stock	38.8425	38.93	38.8275	38.9212	1578916.0
2017-06-07 10:00:00	AAPL	Stock	38.92	38.995	38.9125	38.9725	2837644.0
2017-06-07 10:05:00	AAPL	Stock	38.975	38.9875	38.8825	38.925	1532976.0
2017-06-07 10:10:00	AAPL	Stock	38.9228	38.9508	38.9	38.9375	927900.0
2017-06-07 10:15:00	AAPL	Stock	38.935	38.96	38.915	38.9575	798480.0
2017-06-07 10:20:00	AAPL	Stock	38.9562	38.97	38.915	38.926	1117976.0
2017-06-07 10:25:00	AAPL	Stock	38.925	38.9275	38.86	38.8912	1133844.0
2017-06-07 10:30:00	AAPL	Stock	38.89	38.9125	38.86	38.885	1131696.0
2017-06-07 10:35:00	AAPL	Stock	38.8825	38.8825	38.8088	38.8088	1447156.0
2017-06-07 10:40:00	AAPL	Stock	38.8088	38.8225	38.735	38.8	1435784.0
2017-06-07 10:45:00	AAPL	Stock	38.8025	38.8425	38.78	38.8172	835988.0
2017-06-07 10:50:00	AAPL	Stock	38.8172	38.8475	38.81	38.8425	745712.0
2017-06-07 10:55:00	AAPL	Stock	38.84	38.85	38.8048	38.8125	536284.0
2017-06-07 11:00:00	AAPL	Stock	38.8125	38.8623	38.81	38.85	660892.0

> showing 50 of 350,730 rows — these rows as CSV

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