PREVIEW / stock_5min / 2017-06-08

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-08.parquet
  size:    5.4 MB
  rows:    353,299
  symbols: 3,027

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-08 04:30:00	AAPL	Stock	38.9175	38.9175	38.9175	38.9175	436.0
2017-06-08 05:25:00	AAPL	Stock	38.92	38.92	38.92	38.92	3028.0
2017-06-08 05:45:00	AAPL	Stock	38.9375	38.94	38.9375	38.94	7268.0
2017-06-08 06:05:00	AAPL	Stock	38.9125	38.9125	38.9125	38.9125	596.0
2017-06-08 06:20:00	AAPL	Stock	38.95	38.95	38.95	38.95	3832.0
2017-06-08 06:25:00	AAPL	Stock	38.925	38.925	38.925	38.925	4000.0
2017-06-08 06:30:00	AAPL	Stock	38.94	38.94	38.9125	38.9125	5200.0
2017-06-08 06:35:00	AAPL	Stock	38.94	38.94	38.94	38.94	3700.0
2017-06-08 06:40:00	AAPL	Stock	38.965	38.965	38.95	38.95	1124.0
2017-06-08 06:45:00	AAPL	Stock	38.95	38.95	38.95	38.95	1112.0
2017-06-08 06:50:00	AAPL	Stock	38.95	38.95	38.95	38.95	4096.0
2017-06-08 06:55:00	AAPL	Stock	38.935	38.95	38.935	38.95	4304.0
2017-06-08 07:00:00	AAPL	Stock	38.9575	38.9575	38.955	38.955	5908.0
2017-06-08 07:25:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	400.0
2017-06-08 07:30:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	400.0
2017-06-08 07:40:00	AAPL	Stock	38.94	38.94	38.9375	38.9375	1276.0
2017-06-08 07:45:00	AAPL	Stock	38.94	38.9575	38.9375	38.9375	2764.0
2017-06-08 07:50:00	AAPL	Stock	38.9475	38.9475	38.9475	38.9475	2000.0
2017-06-08 08:00:00	AAPL	Stock	38.925	38.97	38.9125	38.9125	27640.0
2017-06-08 08:05:00	AAPL	Stock	38.9275	38.9275	38.9125	38.9125	20484.0
2017-06-08 08:10:00	AAPL	Stock	38.9125	38.9375	38.9125	38.9375	8400.0
2017-06-08 08:15:00	AAPL	Stock	38.915	38.9375	38.915	38.9375	18300.0
2017-06-08 08:20:00	AAPL	Stock	38.915	38.9475	38.915	38.925	16604.0
2017-06-08 08:25:00	AAPL	Stock	38.9475	38.9475	38.925	38.9425	2800.0
2017-06-08 08:30:00	AAPL	Stock	38.94	38.94	38.925	38.9325	10556.0
2017-06-08 08:35:00	AAPL	Stock	38.935	38.935	38.9125	38.9125	4800.0
2017-06-08 08:40:00	AAPL	Stock	38.915	38.94	38.915	38.93	23968.0
2017-06-08 08:45:00	AAPL	Stock	38.9325	38.9325	38.9175	38.925	25896.0
2017-06-08 08:50:00	AAPL	Stock	38.925	38.925	38.9125	38.915	10380.0
2017-06-08 08:55:00	AAPL	Stock	38.915	38.915	38.8875	38.9	15996.0
2017-06-08 09:00:00	AAPL	Stock	38.9	38.9125	38.8925	38.9125	17284.0
2017-06-08 09:05:00	AAPL	Stock	38.915	38.9175	38.9	38.9025	53820.0
2017-06-08 09:10:00	AAPL	Stock	38.9075	38.915	38.8975	38.9075	28324.0
2017-06-08 09:20:00	AAPL	Stock	38.9	38.9	38.8875	38.8875	16556.0
2017-06-08 09:25:00	AAPL	Stock	38.88	38.88	38.8025	38.8125	68288.0
2017-06-08 09:30:00	AAPL	Stock	38.8125	38.885	38.7225	38.7725	3617580.0
2017-06-08 09:35:00	AAPL	Stock	38.7775	38.87	38.7635	38.8125	1975976.0
2017-06-08 09:40:00	AAPL	Stock	38.815	38.8295	38.7275	38.75	1438128.0
2017-06-08 09:45:00	AAPL	Stock	38.7475	38.7675	38.64	38.6675	1963988.0
2017-06-08 09:50:00	AAPL	Stock	38.6725	38.701	38.6125	38.699	1885528.0
2017-06-08 09:55:00	AAPL	Stock	38.6975	38.7025	38.6625	38.6875	1119324.0
2017-06-08 10:00:00	AAPL	Stock	38.6875	38.7475	38.685	38.735	1242432.0
2017-06-08 10:05:00	AAPL	Stock	38.7335	38.7575	38.6825	38.6825	1429044.0
2017-06-08 10:10:00	AAPL	Stock	38.685	38.7125	38.6275	38.6325	1207780.0
2017-06-08 10:15:00	AAPL	Stock	38.6328	38.7175	38.615	38.6675	1468088.0
2017-06-08 10:20:00	AAPL	Stock	38.67	38.685	38.6	38.66	1314720.0
2017-06-08 10:25:00	AAPL	Stock	38.66	38.665	38.6075	38.6525	901392.0
2017-06-08 10:30:00	AAPL	Stock	38.65	38.6875	38.6375	38.686	1182432.0
2017-06-08 10:35:00	AAPL	Stock	38.6875	38.7175	38.6675	38.6825	952040.0
2017-06-08 10:40:00	AAPL	Stock	38.6825	38.6912	38.65	38.65	943396.0

> showing 50 of 353,299 rows — these rows as CSV

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