PREVIEW / stock_5min / 2017-08-08

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-08.parquet
  size:    5.4 MB
  rows:    350,742
  symbols: 2,999

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-08-08 06:00:00	AAPL	Stock	39.6875	39.6875	39.65	39.65	6128.0
2017-08-08 06:25:00	AAPL	Stock	39.63	39.63	39.63	39.63	800.0
2017-08-08 06:35:00	AAPL	Stock	39.695	39.695	39.695	39.695	400.0
2017-08-08 06:40:00	AAPL	Stock	39.65	39.65	39.65	39.65	400.0
2017-08-08 07:05:00	AAPL	Stock	39.675	39.675	39.675	39.675	1000.0
2017-08-08 07:20:00	AAPL	Stock	39.65	39.65	39.625	39.625	18884.0
2017-08-08 07:30:00	AAPL	Stock	39.625	39.625	39.5875	39.5875	13572.0
2017-08-08 07:35:00	AAPL	Stock	39.625	39.625	39.61	39.6125	5996.0
2017-08-08 07:40:00	AAPL	Stock	39.625	39.625	39.625	39.625	400.0
2017-08-08 07:50:00	AAPL	Stock	39.625	39.625	39.615	39.615	1444.0
2017-08-08 07:55:00	AAPL	Stock	39.625	39.625	39.625	39.625	2856.0
2017-08-08 08:00:00	AAPL	Stock	39.65	39.6625	39.6125	39.65	20520.0
2017-08-08 08:05:00	AAPL	Stock	39.655	39.6625	39.65	39.6625	5516.0
2017-08-08 08:10:00	AAPL	Stock	39.6625	39.6825	39.6625	39.68	11568.0
2017-08-08 08:15:00	AAPL	Stock	39.675	39.6825	39.665	39.675	13984.0
2017-08-08 08:20:00	AAPL	Stock	39.675	39.6825	39.655	39.6675	23656.0
2017-08-08 08:25:00	AAPL	Stock	39.6675	39.6675	39.6375	39.6575	22684.0
2017-08-08 08:30:00	AAPL	Stock	39.6575	39.6575	39.625	39.635	13868.0
2017-08-08 08:35:00	AAPL	Stock	39.635	39.6375	39.6275	39.6275	13724.0
2017-08-08 08:40:00	AAPL	Stock	39.64	39.65	39.6325	39.6325	3400.0
2017-08-08 08:45:00	AAPL	Stock	39.6325	39.645	39.6175	39.6375	22376.0
2017-08-08 08:50:00	AAPL	Stock	39.645	39.6475	39.6375	39.6375	7000.0
2017-08-08 08:55:00	AAPL	Stock	39.6425	39.6425	39.6425	39.6425	400.0
2017-08-08 09:00:00	AAPL	Stock	39.65	39.6525	39.64	39.6525	5220.0
2017-08-08 09:05:00	AAPL	Stock	39.64	39.6425	39.6375	39.6425	2916.0
2017-08-08 09:10:00	AAPL	Stock	39.65	39.65	39.6375	39.6375	4260.0
2017-08-08 09:15:00	AAPL	Stock	39.64	39.65	39.64	39.645	2680.0
2017-08-08 09:20:00	AAPL	Stock	39.6375	39.6675	39.6375	39.6675	11796.0
2017-08-08 09:25:00	AAPL	Stock	39.6675	39.675	39.6325	39.6425	67448.0
2017-08-08 09:30:00	AAPL	Stock	39.6525	39.775	39.6125	39.6938	3791036.0
2017-08-08 09:35:00	AAPL	Stock	39.695	39.7125	39.6175	39.6525	2684940.0
2017-08-08 09:40:00	AAPL	Stock	39.655	39.68	39.5675	39.655	1472316.0
2017-08-08 09:45:00	AAPL	Stock	39.65	39.7325	39.62	39.7125	1366832.0
2017-08-08 09:50:00	AAPL	Stock	39.7125	39.855	39.7085	39.8262	2525900.0
2017-08-08 09:55:00	AAPL	Stock	39.8308	39.8888	39.815	39.8575	2106620.0
2017-08-08 10:00:00	AAPL	Stock	39.86	39.9075	39.8475	39.8862	2018028.0
2017-08-08 10:05:00	AAPL	Stock	39.885	39.938	39.875	39.9162	1969956.0
2017-08-08 10:10:00	AAPL	Stock	39.9175	39.9838	39.915	39.9775	2443204.0
2017-08-08 10:15:00	AAPL	Stock	39.98	39.99	39.9375	39.985	1911408.0
2017-08-08 10:20:00	AAPL	Stock	39.9845	40.0775	39.9675	40.06	5342568.0
2017-08-08 10:25:00	AAPL	Stock	40.0612	40.0825	40.0225	40.05	1891456.0
2017-08-08 10:30:00	AAPL	Stock	40.0375	40.07	40.005	40.07	1866384.0
2017-08-08 10:35:00	AAPL	Stock	40.07	40.15	40.07	40.14	2693168.0
2017-08-08 10:40:00	AAPL	Stock	40.14	40.22	40.1225	40.2175	3026160.0
2017-08-08 10:45:00	AAPL	Stock	40.2175	40.25	40.1728	40.1825	3335964.0
2017-08-08 10:50:00	AAPL	Stock	40.182	40.2475	40.165	40.2325	2258392.0
2017-08-08 10:55:00	AAPL	Stock	40.2275	40.295	40.2175	40.2912	2657604.0
2017-08-08 11:00:00	AAPL	Stock	40.2875	40.33	40.26	40.3	2584596.0
2017-08-08 11:05:00	AAPL	Stock	40.3022	40.35	40.2952	40.325	2195384.0
2017-08-08 11:10:00	AAPL	Stock	40.325	40.3475	40.2925	40.3075	1891816.0

> showing 50 of 350,742 rows — these rows as CSV

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