PREVIEW / stock_5min / 2018-06-11

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-06-11.parquet
  size:    5.7 MB
  rows:    366,869
  symbols: 2,833

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
2018-06-11 04:00:00	AAPL	Stock	47.9	47.9	47.9	47.9	1200.0
2018-06-11 04:05:00	AAPL	Stock	47.9	47.9	47.9	47.9	760.0
2018-06-11 04:30:00	AAPL	Stock	47.8675	47.8675	47.8675	47.8675	1148.0
2018-06-11 05:10:00	AAPL	Stock	47.875	47.875	47.875	47.875	2000.0
2018-06-11 05:15:00	AAPL	Stock	47.875	47.875	47.875	47.875	1140.0
2018-06-11 05:35:00	AAPL	Stock	47.875	47.875	47.875	47.875	764.0
2018-06-11 06:35:00	AAPL	Stock	47.8075	47.8075	47.8075	47.8075	1424.0
2018-06-11 06:50:00	AAPL	Stock	47.825	47.825	47.825	47.825	400.0
2018-06-11 07:00:00	AAPL	Stock	47.8125	47.875	47.8125	47.875	58728.0
2018-06-11 07:05:00	AAPL	Stock	47.8625	47.87	47.8425	47.8425	15980.0
2018-06-11 07:10:00	AAPL	Stock	47.875	47.875	47.875	47.875	3496.0
2018-06-11 07:15:00	AAPL	Stock	47.85	47.85	47.85	47.85	400.0
2018-06-11 07:20:00	AAPL	Stock	47.8825	47.8875	47.8825	47.8875	12800.0
2018-06-11 07:25:00	AAPL	Stock	47.8925	47.915	47.8925	47.915	17400.0
2018-06-11 07:30:00	AAPL	Stock	47.915	47.9675	47.915	47.9525	48716.0
2018-06-11 07:35:00	AAPL	Stock	47.95	47.95	47.9275	47.9275	16644.0
2018-06-11 07:40:00	AAPL	Stock	47.9375	47.95	47.9375	47.9475	3200.0
2018-06-11 07:45:00	AAPL	Stock	47.94	47.94	47.9275	47.9375	4236.0
2018-06-11 07:50:00	AAPL	Stock	47.9375	47.9375	47.9275	47.9325	12760.0
2018-06-11 07:55:00	AAPL	Stock	47.93	47.9375	47.925	47.9375	6000.0
2018-06-11 08:00:00	AAPL	Stock	47.8402	47.9675	47.8175	47.9125	66244.0
2018-06-11 08:05:00	AAPL	Stock	47.92	47.9325	47.88	47.88	18596.0
2018-06-11 08:10:00	AAPL	Stock	47.8825	47.8875	47.8825	47.8875	6000.0
2018-06-11 08:15:00	AAPL	Stock	47.8875	47.8875	47.8875	47.8875	2700.0
2018-06-11 08:20:00	AAPL	Stock	47.89	47.895	47.88	47.88	8364.0
2018-06-11 08:25:00	AAPL	Stock	47.875	47.9125	47.875	47.9	7848.0
2018-06-11 08:30:00	AAPL	Stock	47.9025	47.9025	47.885	47.885	7488.0
2018-06-11 08:35:00	AAPL	Stock	47.885	47.9	47.885	47.9	3600.0
2018-06-11 08:40:00	AAPL	Stock	47.8875	47.8975	47.88	47.8825	12384.0
2018-06-11 08:45:00	AAPL	Stock	47.88	47.8975	47.8775	47.8975	15404.0
2018-06-11 08:50:00	AAPL	Stock	47.8875	47.895	47.8875	47.8925	2800.0
2018-06-11 08:55:00	AAPL	Stock	47.8925	47.8925	47.8925	47.8925	400.0
2018-06-11 09:00:00	AAPL	Stock	47.89	47.89	47.88	47.88	5528.0
2018-06-11 09:05:00	AAPL	Stock	47.8875	47.9	47.8875	47.895	2256.0
2018-06-11 09:10:00	AAPL	Stock	47.9	47.9225	47.895	47.92	20592.0
2018-06-11 09:15:00	AAPL	Stock	47.9175	47.9175	47.915	47.915	5504.0
2018-06-11 09:20:00	AAPL	Stock	47.9225	47.9375	47.9225	47.9275	14984.0
2018-06-11 09:25:00	AAPL	Stock	47.945	47.9725	47.8375	47.8375	66620.0
2018-06-11 09:30:00	AAPL	Stock	47.835	47.9925	47.835	47.9625	3259076.0
2018-06-11 09:35:00	AAPL	Stock	47.9625	47.9925	47.8825	47.9175	1495572.0
2018-06-11 09:40:00	AAPL	Stock	47.92	47.9425	47.8925	47.895	1110688.0
2018-06-11 09:45:00	AAPL	Stock	47.895	47.91	47.79	47.85	1762088.0
2018-06-11 09:50:00	AAPL	Stock	47.8525	47.855	47.8075	47.8075	1457228.0
2018-06-11 09:55:00	AAPL	Stock	47.8075	47.84	47.725	47.78	1496280.0
2018-06-11 10:00:00	AAPL	Stock	47.7775	47.7975	47.7445	47.7475	1227220.0
2018-06-11 10:05:00	AAPL	Stock	47.7455	47.75	47.69	47.7062	1376792.0
2018-06-11 10:10:00	AAPL	Stock	47.705	47.745	47.6875	47.6875	917008.0
2018-06-11 10:15:00	AAPL	Stock	47.6888	47.705	47.6425	47.6725	1111936.0
2018-06-11 10:20:00	AAPL	Stock	47.67	47.6975	47.61	47.6975	1470384.0
2018-06-11 10:25:00	AAPL	Stock	47.6975	47.7225	47.655	47.6575	992596.0

> showing 50 of 366,869 rows — these rows as CSV

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