PREVIEW / stock_5min / 2016-10-27

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-10-27.parquet
  size:    5.2 MB
  rows:    342,190
  symbols: 3,182

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-10-27 04:00:00	AAPL	Stock	28.925	28.935	28.925	28.935	2880.0
2016-10-27 04:25:00	AAPL	Stock	28.935	28.935	28.935	28.935	1600.0
2016-10-27 04:45:00	AAPL	Stock	28.9125	28.9125	28.9125	28.9125	400.0
2016-10-27 05:15:00	AAPL	Stock	28.925	28.925	28.925	28.925	400.0
2016-10-27 05:40:00	AAPL	Stock	28.9325	28.9425	28.9325	28.9425	2156.0
2016-10-27 05:45:00	AAPL	Stock	28.93	28.93	28.93	28.93	400.0
2016-10-27 05:55:00	AAPL	Stock	28.94	28.94	28.9375	28.9375	2400.0
2016-10-27 06:15:00	AAPL	Stock	28.9425	28.9425	28.9325	28.9325	1600.0
2016-10-27 06:20:00	AAPL	Stock	28.94	28.95	28.94	28.95	8800.0
2016-10-27 06:25:00	AAPL	Stock	28.935	28.97	28.935	28.95	6520.0
2016-10-27 06:30:00	AAPL	Stock	28.9575	28.9575	28.9575	28.9575	820.0
2016-10-27 06:35:00	AAPL	Stock	28.9875	28.9875	28.95	28.9875	5400.0
2016-10-27 06:40:00	AAPL	Stock	28.9525	28.9525	28.9525	28.9525	400.0
2016-10-27 06:45:00	AAPL	Stock	28.955	28.955	28.9375	28.9375	2000.0
2016-10-27 07:00:00	AAPL	Stock	28.945	28.9725	28.945	28.97	4512.0
2016-10-27 07:05:00	AAPL	Stock	28.9625	28.9625	28.9625	28.9625	2272.0
2016-10-27 07:10:00	AAPL	Stock	28.96	28.9625	28.955	28.955	2728.0
2016-10-27 07:20:00	AAPL	Stock	28.9525	28.9625	28.9525	28.9625	2400.0
2016-10-27 07:25:00	AAPL	Stock	28.9475	28.9625	28.9475	28.9625	4200.0
2016-10-27 07:30:00	AAPL	Stock	28.96	28.96	28.9425	28.9425	9000.0
2016-10-27 07:40:00	AAPL	Stock	28.9425	28.9425	28.9325	28.9325	13600.0
2016-10-27 07:45:00	AAPL	Stock	28.9275	28.9275	28.9125	28.9125	3600.0
2016-10-27 07:50:00	AAPL	Stock	28.91	28.91	28.905	28.905	4580.0
2016-10-27 07:55:00	AAPL	Stock	28.925	28.925	28.9175	28.9175	9200.0
2016-10-27 08:00:00	AAPL	Stock	28.92	28.95	28.9075	28.9125	38060.0
2016-10-27 08:05:00	AAPL	Stock	28.9075	28.93	28.9	28.93	40596.0
2016-10-27 08:10:00	AAPL	Stock	28.9125	28.9225	28.9025	28.9125	38184.0
2016-10-27 08:15:00	AAPL	Stock	28.915	28.93	28.9125	28.925	30480.0
2016-10-27 08:20:00	AAPL	Stock	28.9275	28.935	28.9075	28.9125	15668.0
2016-10-27 08:25:00	AAPL	Stock	28.9125	28.9125	28.905	28.9125	23600.0
2016-10-27 08:30:00	AAPL	Stock	28.9075	28.9125	28.8725	28.8825	24792.0
2016-10-27 08:35:00	AAPL	Stock	28.8825	28.8888	28.8675	28.8675	24640.0
2016-10-27 08:40:00	AAPL	Stock	28.8925	28.8925	28.865	28.875	5600.0
2016-10-27 08:45:00	AAPL	Stock	28.8675	28.885	28.8675	28.875	15000.0
2016-10-27 08:50:00	AAPL	Stock	28.875	28.8775	28.875	28.8775	4920.0
2016-10-27 08:55:00	AAPL	Stock	28.875	28.895	28.875	28.895	11536.0
2016-10-27 09:00:00	AAPL	Stock	28.885	28.8875	28.885	28.8875	2080.0
2016-10-27 09:05:00	AAPL	Stock	28.895	28.905	28.895	28.8975	11236.0
2016-10-27 09:10:00	AAPL	Stock	28.9	28.905	28.8975	28.9	12600.0
2016-10-27 09:15:00	AAPL	Stock	28.905	28.915	28.8975	28.915	43472.0
2016-10-27 09:20:00	AAPL	Stock	28.91	28.9125	28.905	28.9125	41744.0
2016-10-27 09:25:00	AAPL	Stock	28.9025	28.9175	28.795	28.845	287612.0
2016-10-27 09:30:00	AAPL	Stock	28.8475	28.965	28.76	28.78	6086200.0
2016-10-27 09:35:00	AAPL	Stock	28.78	28.8875	28.75	28.8335	3098200.0
2016-10-27 09:40:00	AAPL	Stock	28.8338	28.86	28.7775	28.8525	2217716.0
2016-10-27 09:45:00	AAPL	Stock	28.855	28.885	28.8125	28.8125	2081592.0
2016-10-27 09:50:00	AAPL	Stock	28.8125	28.8875	28.81	28.86	1799732.0
2016-10-27 09:55:00	AAPL	Stock	28.8612	28.8698	28.835	28.855	1339748.0
2016-10-27 10:00:00	AAPL	Stock	28.855	28.865	28.8	28.8125	1950124.0
2016-10-27 10:05:00	AAPL	Stock	28.8112	28.844	28.7875	28.79	1622948.0

> showing 50 of 342,190 rows — these rows as CSV

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