PREVIEW / stock_5min / 2017-08-09

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-09.parquet
  size:    5.4 MB
  rows:    354,123
  symbols: 2,991

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-08-09 04:00:00	AAPL	Stock	39.845	39.845	39.845	39.845	4400.0
2017-08-09 04:05:00	AAPL	Stock	39.8	39.8	39.7525	39.7525	3880.0
2017-08-09 04:20:00	AAPL	Stock	39.8	39.8	39.785	39.8	5948.0
2017-08-09 05:15:00	AAPL	Stock	39.8625	39.8625	39.8625	39.8625	624.0
2017-08-09 05:45:00	AAPL	Stock	39.8375	39.8375	39.8375	39.8375	1600.0
2017-08-09 05:50:00	AAPL	Stock	39.7875	39.7875	39.7875	39.7875	2400.0
2017-08-09 06:00:00	AAPL	Stock	39.775	39.775	39.775	39.775	3976.0
2017-08-09 06:10:00	AAPL	Stock	39.755	39.755	39.755	39.755	800.0
2017-08-09 06:20:00	AAPL	Stock	39.7525	39.7625	39.75	39.75	9440.0
2017-08-09 06:25:00	AAPL	Stock	39.82	39.82	39.82	39.82	1220.0
2017-08-09 06:40:00	AAPL	Stock	39.7875	39.8	39.7875	39.8	1600.0
2017-08-09 06:45:00	AAPL	Stock	39.8	39.8125	39.8	39.8125	2400.0
2017-08-09 06:50:00	AAPL	Stock	39.8125	39.8125	39.7975	39.8	6400.0
2017-08-09 06:55:00	AAPL	Stock	39.82	39.82	39.8	39.8	1972.0
2017-08-09 07:00:00	AAPL	Stock	39.79	39.845	39.7875	39.825	10188.0
2017-08-09 07:05:00	AAPL	Stock	39.8425	39.85	39.8425	39.85	6088.0
2017-08-09 07:10:00	AAPL	Stock	39.825	39.8475	39.8	39.8125	33920.0
2017-08-09 07:15:00	AAPL	Stock	39.8125	39.8125	39.7875	39.8	10032.0
2017-08-09 07:20:00	AAPL	Stock	39.8	39.8225	39.8	39.8225	10880.0
2017-08-09 07:25:00	AAPL	Stock	39.825	39.85	39.8225	39.8225	11952.0
2017-08-09 07:30:00	AAPL	Stock	39.825	39.825	39.815	39.815	3920.0
2017-08-09 07:35:00	AAPL	Stock	39.825	39.8475	39.805	39.8475	7668.0
2017-08-09 07:40:00	AAPL	Stock	39.825	39.825	39.7875	39.7875	11132.0
2017-08-09 07:45:00	AAPL	Stock	39.79	39.79	39.75	39.7525	15804.0
2017-08-09 07:50:00	AAPL	Stock	39.705	39.725	39.6875	39.6875	33772.0
2017-08-09 07:55:00	AAPL	Stock	39.7125	39.735	39.69	39.7275	23964.0
2017-08-09 08:00:00	AAPL	Stock	39.825	39.85	39.6825	39.725	153236.0
2017-08-09 08:05:00	AAPL	Stock	39.7475	39.755	39.725	39.7325	37344.0
2017-08-09 08:10:00	AAPL	Stock	39.7325	39.78	39.7325	39.775	25444.0
2017-08-09 08:15:00	AAPL	Stock	39.775	39.7975	39.755	39.7675	30708.0
2017-08-09 08:20:00	AAPL	Stock	39.775	39.775	39.7525	39.7525	8964.0
2017-08-09 08:25:00	AAPL	Stock	39.755	39.7675	39.75	39.75	30816.0
2017-08-09 08:30:00	AAPL	Stock	39.75	39.75	39.7225	39.7225	46792.0
2017-08-09 08:35:00	AAPL	Stock	39.7425	39.7875	39.73	39.7875	33136.0
2017-08-09 08:40:00	AAPL	Stock	39.7925	39.8375	39.775	39.825	53700.0
2017-08-09 08:45:00	AAPL	Stock	39.825	39.8625	39.825	39.83	33936.0
2017-08-09 08:50:00	AAPL	Stock	39.8375	39.845	39.75	39.8025	44716.0
2017-08-09 08:55:00	AAPL	Stock	39.82	39.825	39.8025	39.8225	15644.0
2017-08-09 09:00:00	AAPL	Stock	39.8225	39.825	39.7925	39.825	14064.0
2017-08-09 09:05:00	AAPL	Stock	39.8	39.8225	39.775	39.775	31252.0
2017-08-09 09:10:00	AAPL	Stock	39.8	39.8175	39.775	39.8	28660.0
2017-08-09 09:15:00	AAPL	Stock	39.79	39.8125	39.7775	39.8075	20512.0
2017-08-09 09:20:00	AAPL	Stock	39.7825	39.8	39.7775	39.8	26628.0
2017-08-09 09:25:00	AAPL	Stock	39.8	39.8075	39.7625	39.7725	83364.0
2017-08-09 09:30:00	AAPL	Stock	39.815	39.99	39.7775	39.9688	4800400.0
2017-08-09 09:35:00	AAPL	Stock	39.9685	40.0625	39.9275	39.9925	3143676.0
2017-08-09 09:40:00	AAPL	Stock	40.0	40.0445	39.805	39.91	2721616.0
2017-08-09 09:45:00	AAPL	Stock	39.905	39.9818	39.8325	39.9475	1852204.0
2017-08-09 09:50:00	AAPL	Stock	39.9425	39.975	39.87	39.9682	1623968.0
2017-08-09 09:55:00	AAPL	Stock	39.97	40.142	39.97	40.0925	3086428.0

> showing 50 of 354,123 rows — these rows as CSV

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