PREVIEW / stock_5min / 2016-10-19

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-10-19.parquet
  size:    5.2 MB
  rows:    342,061
  symbols: 3,200

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-19 04:25:00	AAPL	Stock	29.27	29.27	29.27	29.27	400.0
2016-10-19 04:30:00	AAPL	Stock	29.2675	29.2675	29.25	29.25	800.0
2016-10-19 04:50:00	AAPL	Stock	29.315	29.315	29.315	29.315	400.0
2016-10-19 05:05:00	AAPL	Stock	29.315	29.315	29.315	29.315	2800.0
2016-10-19 06:00:00	AAPL	Stock	29.3575	29.3575	29.3575	29.3575	1200.0
2016-10-19 06:10:00	AAPL	Stock	29.3575	29.3575	29.3425	29.3425	5844.0
2016-10-19 06:20:00	AAPL	Stock	29.3575	29.3575	29.3575	29.3575	408.0
2016-10-19 06:35:00	AAPL	Stock	29.3675	29.3675	29.3675	29.3675	400.0
2016-10-19 06:40:00	AAPL	Stock	29.3675	29.3675	29.3675	29.3675	400.0
2016-10-19 06:50:00	AAPL	Stock	29.3675	29.3675	29.3675	29.3675	800.0
2016-10-19 07:05:00	AAPL	Stock	29.3775	29.3775	29.3775	29.3775	400.0
2016-10-19 07:20:00	AAPL	Stock	29.3875	29.3875	29.375	29.375	2728.0
2016-10-19 07:25:00	AAPL	Stock	29.3875	29.4125	29.3875	29.4125	2000.0
2016-10-19 07:30:00	AAPL	Stock	29.3875	29.3875	29.3775	29.3875	4492.0
2016-10-19 07:35:00	AAPL	Stock	29.3875	29.3875	29.3875	29.3875	400.0
2016-10-19 07:45:00	AAPL	Stock	29.4	29.4125	29.4	29.4125	3600.0
2016-10-19 07:50:00	AAPL	Stock	29.4125	29.4275	29.4	29.4275	14952.0
2016-10-19 07:55:00	AAPL	Stock	29.4275	29.4375	29.415	29.4375	6880.0
2016-10-19 08:00:00	AAPL	Stock	29.425	29.4362	29.3	29.4175	66772.0
2016-10-19 08:05:00	AAPL	Stock	29.4025	29.4025	29.355	29.3625	78952.0
2016-10-19 08:10:00	AAPL	Stock	29.375	29.3975	29.375	29.3975	12800.0
2016-10-19 08:15:00	AAPL	Stock	29.3975	29.4025	29.3875	29.3875	8940.0
2016-10-19 08:20:00	AAPL	Stock	29.3875	29.4	29.3875	29.4	13200.0
2016-10-19 08:25:00	AAPL	Stock	29.4	29.4	29.395	29.4	25200.0
2016-10-19 08:30:00	AAPL	Stock	29.4075	29.415	29.375	29.375	48732.0
2016-10-19 08:35:00	AAPL	Stock	29.375	29.375	29.3425	29.345	65912.0
2016-10-19 08:40:00	AAPL	Stock	29.345	29.355	29.33	29.335	100300.0
2016-10-19 08:45:00	AAPL	Stock	29.335	29.3525	29.335	29.3425	29080.0
2016-10-19 08:50:00	AAPL	Stock	29.35	29.355	29.3425	29.35	21700.0
2016-10-19 08:55:00	AAPL	Stock	29.35	29.355	29.35	29.355	53664.0
2016-10-19 09:00:00	AAPL	Stock	29.3425	29.35	29.3	29.3	71124.0
2016-10-19 09:05:00	AAPL	Stock	29.31	29.3375	29.3075	29.3375	17600.0
2016-10-19 09:10:00	AAPL	Stock	29.325	29.3375	29.325	29.325	44356.0
2016-10-19 09:15:00	AAPL	Stock	29.335	29.3425	29.335	29.3425	10172.0
2016-10-19 09:20:00	AAPL	Stock	29.3425	29.3525	29.32	29.33	11392.0
2016-10-19 09:25:00	AAPL	Stock	29.325	29.335	29.3175	29.335	30056.0
2016-10-19 09:30:00	AAPL	Stock	29.3125	29.3675	29.285	29.32	3687944.0
2016-10-19 09:35:00	AAPL	Stock	29.3175	29.4	29.3175	29.3925	1914708.0
2016-10-19 09:40:00	AAPL	Stock	29.3942	29.42	29.3875	29.407	1800196.0
2016-10-19 09:45:00	AAPL	Stock	29.406	29.44	29.4025	29.4225	1663608.0
2016-10-19 09:50:00	AAPL	Stock	29.42	29.4392	29.405	29.4075	1177616.0
2016-10-19 09:55:00	AAPL	Stock	29.4088	29.415	29.3425	29.4112	1593736.0
2016-10-19 10:00:00	AAPL	Stock	29.41	29.4125	29.37	29.3838	1397448.0
2016-10-19 10:05:00	AAPL	Stock	29.3838	29.3925	29.3625	29.374	868304.0
2016-10-19 10:10:00	AAPL	Stock	29.3725	29.405	29.3625	29.4025	890320.0
2016-10-19 10:15:00	AAPL	Stock	29.4025	29.4025	29.36	29.361	883316.0
2016-10-19 10:20:00	AAPL	Stock	29.361	29.3675	29.3362	29.345	1062520.0
2016-10-19 10:25:00	AAPL	Stock	29.345	29.3875	29.345	29.3725	1178032.0
2016-10-19 10:30:00	AAPL	Stock	29.3725	29.39	29.3225	29.3228	1244716.0
2016-10-19 10:35:00	AAPL	Stock	29.3225	29.34	29.3145	29.3372	978244.0

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

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