PREVIEW / stock_5min / 2016-07-19

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-07-19.parquet
  size:    5.2 MB
  rows:    345,030
  symbols: 3,272

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-07-19 04:10:00	AAPL	Stock	24.8625	24.8625	24.8125	24.825	9600.0
2016-07-19 04:15:00	AAPL	Stock	24.815	24.815	24.8075	24.8075	3576.0
2016-07-19 05:05:00	AAPL	Stock	24.8	24.8	24.8	24.8	400.0
2016-07-19 05:50:00	AAPL	Stock	24.8475	24.8475	24.8475	24.8475	1120.0
2016-07-19 06:00:00	AAPL	Stock	24.8475	24.8475	24.8475	24.8475	2720.0
2016-07-19 06:10:00	AAPL	Stock	24.8275	24.8275	24.8275	24.8275	2000.0
2016-07-19 06:20:00	AAPL	Stock	24.8275	24.8275	24.8275	24.8275	2400.0
2016-07-19 07:05:00	AAPL	Stock	24.8625	24.8625	24.8625	24.8625	6300.0
2016-07-19 07:15:00	AAPL	Stock	24.875	24.875	24.875	24.875	2000.0
2016-07-19 07:20:00	AAPL	Stock	24.8775	24.8775	24.8625	24.8625	4400.0
2016-07-19 07:25:00	AAPL	Stock	24.8625	24.8625	24.8625	24.8625	5600.0
2016-07-19 07:35:00	AAPL	Stock	24.88	24.88	24.88	24.88	800.0
2016-07-19 07:40:00	AAPL	Stock	24.8625	24.8625	24.8625	24.8625	1360.0
2016-07-19 07:50:00	AAPL	Stock	24.8575	24.8575	24.8575	24.8575	2900.0
2016-07-19 07:55:00	AAPL	Stock	24.855	24.8575	24.8525	24.8525	7916.0
2016-07-19 08:00:00	AAPL	Stock	24.8525	24.8575	24.85	24.855	48820.0
2016-07-19 08:05:00	AAPL	Stock	24.8575	24.875	24.8575	24.875	12364.0
2016-07-19 08:10:00	AAPL	Stock	24.885	24.8875	24.885	24.8875	800.0
2016-07-19 08:15:00	AAPL	Stock	24.8825	24.8825	24.8775	24.8825	17624.0
2016-07-19 08:20:00	AAPL	Stock	24.8825	24.8825	24.8625	24.88	29140.0
2016-07-19 08:25:00	AAPL	Stock	24.875	24.875	24.875	24.875	800.0
2016-07-19 08:30:00	AAPL	Stock	24.87	24.87	24.87	24.87	6800.0
2016-07-19 08:35:00	AAPL	Stock	24.87	24.87	24.87	24.87	440.0
2016-07-19 08:40:00	AAPL	Stock	24.865	24.875	24.865	24.87	12360.0
2016-07-19 08:45:00	AAPL	Stock	24.87	24.8825	24.87	24.8825	11300.0
2016-07-19 08:50:00	AAPL	Stock	24.88	24.8825	24.88	24.88	5964.0
2016-07-19 08:55:00	AAPL	Stock	24.8825	24.8825	24.8825	24.8825	3960.0
2016-07-19 09:00:00	AAPL	Stock	24.88	24.8875	24.88	24.8875	42312.0
2016-07-19 09:05:00	AAPL	Stock	24.885	24.8875	24.885	24.8875	8760.0
2016-07-19 09:10:00	AAPL	Stock	24.8775	24.8775	24.875	24.875	9648.0
2016-07-19 09:15:00	AAPL	Stock	24.875	24.8875	24.875	24.8875	8360.0
2016-07-19 09:20:00	AAPL	Stock	24.89	24.89	24.8875	24.8875	8400.0
2016-07-19 09:25:00	AAPL	Stock	24.875	24.885	24.875	24.875	18720.0
2016-07-19 09:30:00	AAPL	Stock	24.89	24.96	24.835	24.94	4223312.0
2016-07-19 09:35:00	AAPL	Stock	24.9375	24.9925	24.9325	24.9475	2399336.0
2016-07-19 09:40:00	AAPL	Stock	24.95	24.974	24.94	24.945	2179292.0
2016-07-19 09:45:00	AAPL	Stock	24.945	24.9475	24.885	24.8875	2212984.0
2016-07-19 09:50:00	AAPL	Stock	24.8878	24.9275	24.86	24.9188	1845492.0
2016-07-19 09:55:00	AAPL	Stock	24.9185	24.945	24.915	24.93	1281380.0
2016-07-19 10:00:00	AAPL	Stock	24.9275	24.935	24.9	24.9138	1002640.0
2016-07-19 10:05:00	AAPL	Stock	24.9125	24.9425	24.9025	24.9412	1202568.0
2016-07-19 10:10:00	AAPL	Stock	24.9412	24.9712	24.9375	24.9602	1624244.0
2016-07-19 10:15:00	AAPL	Stock	24.96	24.9875	24.9575	24.9712	1672628.0
2016-07-19 10:20:00	AAPL	Stock	24.9725	25.0	24.9675	25.0	2021656.0
2016-07-19 10:25:00	AAPL	Stock	25.0	25.0	24.97	24.98	1559056.0
2016-07-19 10:30:00	AAPL	Stock	24.9798	24.9988	24.9775	24.9825	1192692.0
2016-07-19 10:35:00	AAPL	Stock	24.98	24.9875	24.935	24.9375	1294296.0
2016-07-19 10:40:00	AAPL	Stock	24.94	24.9575	24.935	24.94	1108788.0
2016-07-19 10:45:00	AAPL	Stock	24.9375	24.9475	24.935	24.94	890588.0
2016-07-19 10:50:00	AAPL	Stock	24.9425	24.98	24.9388	24.975	1217916.0

> showing 50 of 345,030 rows — these rows as CSV

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