PREVIEW / stock_5min / 2017-09-26

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-26.parquet
  size:    5.3 MB
  rows:    347,686
  symbols: 2,951

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-09-26 04:00:00	AAPL	Stock	37.6475	37.6625	37.6475	37.6625	2040.0
2017-09-26 04:15:00	AAPL	Stock	37.6625	37.675	37.6625	37.675	7204.0
2017-09-26 04:20:00	AAPL	Stock	37.72	37.72	37.72	37.72	800.0
2017-09-26 04:35:00	AAPL	Stock	37.735	37.735	37.735	37.735	400.0
2017-09-26 04:45:00	AAPL	Stock	37.745	37.745	37.745	37.745	800.0
2017-09-26 04:55:00	AAPL	Stock	37.7925	37.8	37.7925	37.7925	7136.0
2017-09-26 05:05:00	AAPL	Stock	37.795	37.795	37.795	37.795	800.0
2017-09-26 05:10:00	AAPL	Stock	37.775	37.775	37.775	37.775	1800.0
2017-09-26 05:15:00	AAPL	Stock	37.8025	37.8025	37.8025	37.8025	400.0
2017-09-26 05:20:00	AAPL	Stock	37.8075	37.8375	37.8075	37.8375	19060.0
2017-09-26 05:30:00	AAPL	Stock	37.8375	37.8375	37.8375	37.8375	400.0
2017-09-26 05:45:00	AAPL	Stock	37.8325	37.875	37.8325	37.85	26428.0
2017-09-26 05:50:00	AAPL	Stock	37.8675	37.885	37.8675	37.885	2400.0
2017-09-26 05:55:00	AAPL	Stock	37.8625	37.8625	37.8625	37.8625	5600.0
2017-09-26 06:00:00	AAPL	Stock	37.86	37.86	37.845	37.845	2400.0
2017-09-26 06:10:00	AAPL	Stock	37.8175	37.8175	37.8175	37.8175	400.0
2017-09-26 06:15:00	AAPL	Stock	37.825	37.8325	37.825	37.8325	2000.0
2017-09-26 06:20:00	AAPL	Stock	37.8325	37.8475	37.8325	37.8475	6640.0
2017-09-26 06:25:00	AAPL	Stock	37.8475	37.8475	37.8475	37.8475	4108.0
2017-09-26 06:30:00	AAPL	Stock	37.8475	37.8475	37.8475	37.8475	800.0
2017-09-26 06:35:00	AAPL	Stock	37.8725	37.88	37.8725	37.88	9180.0
2017-09-26 06:40:00	AAPL	Stock	37.8875	37.8875	37.875	37.875	19840.0
2017-09-26 06:45:00	AAPL	Stock	37.8775	37.8925	37.875	37.8875	11200.0
2017-09-26 06:50:00	AAPL	Stock	37.895	37.895	37.88	37.8875	4800.0
2017-09-26 06:55:00	AAPL	Stock	37.895	37.895	37.875	37.875	17072.0
2017-09-26 07:00:00	AAPL	Stock	37.88	37.8875	37.8275	37.83	26292.0
2017-09-26 07:05:00	AAPL	Stock	37.85	37.8875	37.8375	37.85	37180.0
2017-09-26 07:10:00	AAPL	Stock	37.8625	37.9	37.8625	37.9	21884.0
2017-09-26 07:15:00	AAPL	Stock	37.92	37.925	37.895	37.9	11844.0
2017-09-26 07:20:00	AAPL	Stock	37.925	37.9475	37.895	37.9375	18880.0
2017-09-26 07:25:00	AAPL	Stock	37.9225	37.9275	37.9125	37.9275	16524.0
2017-09-26 07:30:00	AAPL	Stock	37.9275	37.9825	37.9275	37.9825	58808.0
2017-09-26 07:35:00	AAPL	Stock	37.9375	37.95	37.935	37.95	6400.0
2017-09-26 07:40:00	AAPL	Stock	37.95	38.0	37.9425	37.9625	89492.0
2017-09-26 07:45:00	AAPL	Stock	37.9625	37.9625	37.9425	37.9425	57004.0
2017-09-26 07:50:00	AAPL	Stock	37.9425	38.0	37.9375	37.9425	55740.0
2017-09-26 07:55:00	AAPL	Stock	37.9425	37.9425	37.9	37.9	56432.0
2017-09-26 08:00:00	AAPL	Stock	37.9475	37.9625	37.8275	37.9425	79980.0
2017-09-26 08:05:00	AAPL	Stock	37.9525	37.975	37.9525	37.975	51700.0
2017-09-26 08:10:00	AAPL	Stock	37.9775	37.9975	37.9625	37.9875	96708.0
2017-09-26 08:15:00	AAPL	Stock	37.9525	37.9575	37.95	37.9575	40216.0
2017-09-26 08:20:00	AAPL	Stock	37.9575	37.975	37.94	37.975	57472.0
2017-09-26 08:25:00	AAPL	Stock	37.9875	37.9875	37.9175	37.9275	89928.0
2017-09-26 08:30:00	AAPL	Stock	37.9575	37.9625	37.9575	37.9625	14780.0
2017-09-26 08:35:00	AAPL	Stock	37.975	37.9875	37.9625	37.9675	33708.0
2017-09-26 08:40:00	AAPL	Stock	37.9875	37.9875	37.95	37.9625	57956.0
2017-09-26 08:45:00	AAPL	Stock	37.9625	38.0	37.9625	37.9825	71324.0
2017-09-26 08:50:00	AAPL	Stock	37.9825	37.9825	37.94	37.95	79132.0
2017-09-26 08:55:00	AAPL	Stock	37.95	37.9775	37.94	37.975	50864.0
2017-09-26 09:00:00	AAPL	Stock	37.9625	37.9675	37.9375	37.95	52648.0

> showing 50 of 347,686 rows — these rows as CSV

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