PREVIEW / stock_5min / 2017-05-05

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-05-05.parquet
  size:    5.3 MB
  rows:    348,876
  symbols: 3,045

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-05-05 04:25:00	AAPL	Stock	36.6325	36.6325	36.6325	36.6325	1648.0
2017-05-05 05:20:00	AAPL	Stock	36.68	36.7	36.68	36.7	4328.0
2017-05-05 06:55:00	AAPL	Stock	36.72	36.72	36.72	36.72	800.0
2017-05-05 07:00:00	AAPL	Stock	36.725	36.725	36.725	36.725	716.0
2017-05-05 07:05:00	AAPL	Stock	36.7	36.7025	36.7	36.7025	4400.0
2017-05-05 07:20:00	AAPL	Stock	36.6875	36.6875	36.6875	36.6875	1004.0
2017-05-05 07:30:00	AAPL	Stock	36.6825	36.7	36.6825	36.7	3496.0
2017-05-05 07:35:00	AAPL	Stock	36.695	36.695	36.695	36.695	800.0
2017-05-05 07:40:00	AAPL	Stock	36.6875	36.6875	36.6875	36.6875	520.0
2017-05-05 07:50:00	AAPL	Stock	36.7	36.7	36.6625	36.665	5008.0
2017-05-05 08:00:00	AAPL	Stock	36.675	36.675	36.6625	36.675	7000.0
2017-05-05 08:10:00	AAPL	Stock	36.6725	36.6725	36.6725	36.6725	924.0
2017-05-05 08:15:00	AAPL	Stock	36.675	36.675	36.675	36.675	404.0
2017-05-05 08:20:00	AAPL	Stock	36.6825	36.6875	36.675	36.6875	4688.0
2017-05-05 08:25:00	AAPL	Stock	36.6925	36.6925	36.6925	36.6925	924.0
2017-05-05 08:30:00	AAPL	Stock	36.695	36.725	36.695	36.725	41300.0
2017-05-05 08:35:00	AAPL	Stock	36.7275	36.7325	36.7	36.7025	39540.0
2017-05-05 08:40:00	AAPL	Stock	36.7175	36.75	36.7175	36.75	23464.0
2017-05-05 08:45:00	AAPL	Stock	36.75	36.75	36.735	36.735	14640.0
2017-05-05 08:50:00	AAPL	Stock	36.7275	36.735	36.725	36.7325	19920.0
2017-05-05 08:55:00	AAPL	Stock	36.7275	36.7275	36.7125	36.7125	10000.0
2017-05-05 09:00:00	AAPL	Stock	36.7225	36.7225	36.7225	36.7225	6768.0
2017-05-05 09:05:00	AAPL	Stock	36.725	36.725	36.72	36.725	17624.0
2017-05-05 09:10:00	AAPL	Stock	36.73	36.73	36.725	36.7275	7908.0
2017-05-05 09:15:00	AAPL	Stock	36.7275	36.7325	36.725	36.725	6340.0
2017-05-05 09:20:00	AAPL	Stock	36.725	36.7325	36.725	36.7275	4836.0
2017-05-05 09:25:00	AAPL	Stock	36.73	36.7325	36.6875	36.7025	36124.0
2017-05-05 09:30:00	AAPL	Stock	36.69	36.76	36.69	36.755	3917516.0
2017-05-05 09:35:00	AAPL	Stock	36.755	36.8125	36.7475	36.81	2182560.0
2017-05-05 09:40:00	AAPL	Stock	36.81	36.8625	36.7875	36.8625	2405004.0
2017-05-05 09:45:00	AAPL	Stock	36.86	36.875	36.825	36.8525	2499920.0
2017-05-05 09:50:00	AAPL	Stock	36.8525	36.955	36.85	36.9475	3055832.0
2017-05-05 09:55:00	AAPL	Stock	36.9472	36.95	36.88	36.91	2050060.0
2017-05-05 10:00:00	AAPL	Stock	36.9118	36.935	36.8975	36.9225	1412852.0
2017-05-05 10:05:00	AAPL	Stock	36.924	37.0	36.9225	36.9725	2568796.0
2017-05-05 10:10:00	AAPL	Stock	36.9725	36.995	36.945	36.98	1556864.0
2017-05-05 10:15:00	AAPL	Stock	36.9825	36.9925	36.9375	36.9675	1523996.0
2017-05-05 10:20:00	AAPL	Stock	36.965	36.975	36.9325	36.9525	1114640.0
2017-05-05 10:25:00	AAPL	Stock	36.9548	36.9575	36.91	36.9502	1469092.0
2017-05-05 10:30:00	AAPL	Stock	36.9522	36.975	36.9375	36.95	1019276.0
2017-05-05 10:35:00	AAPL	Stock	36.9525	36.9575	36.92	36.92	1173072.0
2017-05-05 10:40:00	AAPL	Stock	36.9225	36.93	36.88	36.93	1230568.0
2017-05-05 10:45:00	AAPL	Stock	36.9275	36.965	36.9228	36.955	1002628.0
2017-05-05 10:50:00	AAPL	Stock	36.955	36.9725	36.94	36.9475	770244.0
2017-05-05 10:55:00	AAPL	Stock	36.945	36.9575	36.9338	36.949	711804.0
2017-05-05 11:00:00	AAPL	Stock	36.9487	36.9725	36.9425	36.965	880484.0
2017-05-05 11:05:00	AAPL	Stock	36.965	37.015	36.9625	37.005	2342352.0
2017-05-05 11:10:00	AAPL	Stock	37.005	37.0225	36.9988	37.0112	1931532.0
2017-05-05 11:15:00	AAPL	Stock	37.0112	37.05	37.0025	37.0375	1408996.0
2017-05-05 11:20:00	AAPL	Stock	37.04	37.0462	37.005	37.0145	1226136.0

> showing 50 of 348,876 rows — these rows as CSV

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