PREVIEW / stock_5min / 2016-05-27

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-05-27.parquet
  size:    5.1 MB
  rows:    340,995
  symbols: 3,286

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
2016-05-27 04:15:00	AAPL	Stock	25.1	25.1	25.1	25.1	800.0
2016-05-27 04:20:00	AAPL	Stock	25.115	25.115	25.115	25.115	428.0
2016-05-27 04:25:00	AAPL	Stock	25.115	25.115	25.115	25.115	736.0
2016-05-27 05:25:00	AAPL	Stock	25.0875	25.0875	25.0875	25.0875	400.0
2016-05-27 05:40:00	AAPL	Stock	25.1125	25.1125	25.1125	25.1125	700.0
2016-05-27 05:50:00	AAPL	Stock	25.1125	25.1125	25.1125	25.1125	800.0
2016-05-27 05:55:00	AAPL	Stock	25.0875	25.0875	25.075	25.075	800.0
2016-05-27 06:00:00	AAPL	Stock	25.09	25.09	25.0875	25.0875	1560.0
2016-05-27 06:10:00	AAPL	Stock	25.075	25.075	25.075	25.075	800.0
2016-05-27 06:15:00	AAPL	Stock	25.0875	25.0875	25.0875	25.0875	3956.0
2016-05-27 06:25:00	AAPL	Stock	25.075	25.075	25.075	25.075	2440.0
2016-05-27 06:30:00	AAPL	Stock	25.08	25.08	25.08	25.08	1200.0
2016-05-27 06:50:00	AAPL	Stock	25.075	25.0875	25.075	25.0875	3180.0
2016-05-27 06:55:00	AAPL	Stock	25.0875	25.0875	25.08	25.08	1400.0
2016-05-27 07:00:00	AAPL	Stock	25.075	25.075	25.0625	25.0625	3520.0
2016-05-27 07:05:00	AAPL	Stock	25.0725	25.0725	24.98	24.98	22488.0
2016-05-27 07:10:00	AAPL	Stock	24.9725	24.975	24.9725	24.975	3200.0
2016-05-27 07:15:00	AAPL	Stock	24.995	25.0	24.995	24.995	14248.0
2016-05-27 07:20:00	AAPL	Stock	25.0	25.0125	24.995	25.0075	27784.0
2016-05-27 07:25:00	AAPL	Stock	25.0	25.0	24.965	24.98	35384.0
2016-05-27 07:30:00	AAPL	Stock	24.965	24.98	24.95	24.95	76100.0
2016-05-27 07:35:00	AAPL	Stock	24.945	24.955	24.9375	24.95	28996.0
2016-05-27 07:40:00	AAPL	Stock	24.95	24.955	24.9	24.925	36572.0
2016-05-27 07:45:00	AAPL	Stock	24.925	24.925	24.9075	24.9175	4664.0
2016-05-27 07:50:00	AAPL	Stock	24.925	24.925	24.9225	24.925	12580.0
2016-05-27 07:55:00	AAPL	Stock	24.925	24.925	24.9075	24.92	18000.0
2016-05-27 08:00:00	AAPL	Stock	24.9725	25.0875	24.91	24.915	166112.0
2016-05-27 08:05:00	AAPL	Stock	24.925	24.93	24.9	24.9175	103440.0
2016-05-27 08:10:00	AAPL	Stock	24.9175	24.9375	24.9175	24.9325	42628.0
2016-05-27 08:15:00	AAPL	Stock	24.9325	24.9375	24.9175	24.925	40520.0
2016-05-27 08:20:00	AAPL	Stock	24.9175	24.9375	24.9175	24.9325	34048.0
2016-05-27 08:25:00	AAPL	Stock	24.9325	24.9375	24.9325	24.9375	16644.0
2016-05-27 08:30:00	AAPL	Stock	24.9375	24.94	24.9175	24.9175	56940.0
2016-05-27 08:35:00	AAPL	Stock	24.925	24.925	24.8875	24.8875	65112.0
2016-05-27 08:40:00	AAPL	Stock	24.8875	24.8975	24.87	24.8775	114584.0
2016-05-27 08:45:00	AAPL	Stock	24.885	24.8875	24.8375	24.8375	105996.0
2016-05-27 08:50:00	AAPL	Stock	24.8375	24.8625	24.81	24.81	107184.0
2016-05-27 08:55:00	AAPL	Stock	24.8075	24.8525	24.8	24.8125	130344.0
2016-05-27 09:00:00	AAPL	Stock	24.8225	24.8375	24.815	24.83	90592.0
2016-05-27 09:05:00	AAPL	Stock	24.8175	24.8325	24.8125	24.82	25248.0
2016-05-27 09:10:00	AAPL	Stock	24.8125	24.8675	24.8125	24.865	113500.0
2016-05-27 09:15:00	AAPL	Stock	24.8675	24.875	24.865	24.8725	224548.0
2016-05-27 09:20:00	AAPL	Stock	24.875	24.8825	24.8525	24.865	91220.0
2016-05-27 09:25:00	AAPL	Stock	24.865	24.885	24.8475	24.8475	151968.0
2016-05-27 09:30:00	AAPL	Stock	24.86	24.925	24.8112	24.89	9420580.0
2016-05-27 09:35:00	AAPL	Stock	24.895	24.9475	24.8575	24.858	5511108.0
2016-05-27 09:40:00	AAPL	Stock	24.8575	24.9225	24.8425	24.92	3589380.0
2016-05-27 09:45:00	AAPL	Stock	24.918	24.95	24.9025	24.9315	3222440.0
2016-05-27 09:50:00	AAPL	Stock	24.9308	24.9975	24.9302	24.96	2959580.0
2016-05-27 09:55:00	AAPL	Stock	24.961	25.015	24.9375	25.0123	2814744.0

> showing 50 of 340,995 rows — these rows as CSV

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