PREVIEW / stock_5min / 2016-10-14

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-10-14.parquet
  size:    5.2 MB
  rows:    341,023
  symbols: 3,188

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-14 05:40:00	AAPL	Stock	29.3125	29.325	29.3125	29.325	6500.0
2016-10-14 06:00:00	AAPL	Stock	29.3225	29.33	29.3225	29.33	3220.0
2016-10-14 06:05:00	AAPL	Stock	29.33	29.3725	29.33	29.3725	2668.0
2016-10-14 06:15:00	AAPL	Stock	29.37	29.37	29.3675	29.3675	3692.0
2016-10-14 06:20:00	AAPL	Stock	29.345	29.36	29.345	29.36	4240.0
2016-10-14 06:30:00	AAPL	Stock	29.36	29.37	29.36	29.37	2120.0
2016-10-14 06:35:00	AAPL	Stock	29.38	29.385	29.38	29.385	2400.0
2016-10-14 06:40:00	AAPL	Stock	29.4	29.415	29.4	29.405	3200.0
2016-10-14 06:50:00	AAPL	Stock	29.4225	29.425	29.42	29.4225	4296.0
2016-10-14 06:55:00	AAPL	Stock	29.4225	29.4225	29.4	29.4	12740.0
2016-10-14 07:00:00	AAPL	Stock	29.415	29.415	29.38	29.4125	18540.0
2016-10-14 07:05:00	AAPL	Stock	29.4	29.4125	29.4	29.4	6400.0
2016-10-14 07:10:00	AAPL	Stock	29.4	29.415	29.4	29.415	29800.0
2016-10-14 07:15:00	AAPL	Stock	29.3925	29.3925	29.3825	29.3825	4012.0
2016-10-14 07:20:00	AAPL	Stock	29.3875	29.3875	29.3875	29.3875	2800.0
2016-10-14 07:25:00	AAPL	Stock	29.3825	29.3975	29.3825	29.3975	2532.0
2016-10-14 07:30:00	AAPL	Stock	29.3975	29.415	29.3975	29.415	20068.0
2016-10-14 07:35:00	AAPL	Stock	29.415	29.415	29.4025	29.4025	8668.0
2016-10-14 07:45:00	AAPL	Stock	29.4025	29.4025	29.4025	29.4025	4000.0
2016-10-14 07:50:00	AAPL	Stock	29.4075	29.415	29.4	29.415	41616.0
2016-10-14 07:55:00	AAPL	Stock	29.415	29.43	29.415	29.43	11128.0
2016-10-14 08:00:00	AAPL	Stock	29.435	29.435	29.1875	29.4225	101680.0
2016-10-14 08:05:00	AAPL	Stock	29.4225	29.4375	29.4	29.43	67660.0
2016-10-14 08:10:00	AAPL	Stock	29.425	29.4375	29.42	29.435	24420.0
2016-10-14 08:15:00	AAPL	Stock	29.425	29.435	29.4225	29.4225	6760.0
2016-10-14 08:20:00	AAPL	Stock	29.4225	29.4225	29.4	29.4	29108.0
2016-10-14 08:25:00	AAPL	Stock	29.4	29.415	29.3875	29.405	124008.0
2016-10-14 08:30:00	AAPL	Stock	29.4125	29.42	29.4125	29.42	23200.0
2016-10-14 08:35:00	AAPL	Stock	29.4175	29.45	29.4175	29.4375	74072.0
2016-10-14 08:40:00	AAPL	Stock	29.4375	29.4375	29.43	29.4375	39900.0
2016-10-14 08:45:00	AAPL	Stock	29.4475	29.4975	29.4375	29.475	74172.0
2016-10-14 08:50:00	AAPL	Stock	29.48	29.48	29.4325	29.4325	64008.0
2016-10-14 08:55:00	AAPL	Stock	29.4425	29.4575	29.4425	29.445	10472.0
2016-10-14 09:00:00	AAPL	Stock	29.45	29.4625	29.45	29.4625	35632.0
2016-10-14 09:05:00	AAPL	Stock	29.4625	29.4625	29.455	29.46	20092.0
2016-10-14 09:10:00	AAPL	Stock	29.46	29.46	29.45	29.45	7600.0
2016-10-14 09:15:00	AAPL	Stock	29.45	29.475	29.4425	29.4525	462732.0
2016-10-14 09:20:00	AAPL	Stock	29.4575	29.485	29.4575	29.485	36300.0
2016-10-14 09:25:00	AAPL	Stock	29.4875	29.5075	29.4525	29.4775	189500.0
2016-10-14 09:30:00	AAPL	Stock	29.47	29.5425	29.375	29.3975	9802492.0
2016-10-14 09:35:00	AAPL	Stock	29.3975	29.5125	29.3952	29.405	3679100.0
2016-10-14 09:40:00	AAPL	Stock	29.4025	29.45	29.3725	29.425	3417080.0
2016-10-14 09:45:00	AAPL	Stock	29.4275	29.4775	29.4275	29.4625	2804116.0
2016-10-14 09:50:00	AAPL	Stock	29.465	29.47	29.4025	29.415	2356880.0
2016-10-14 09:55:00	AAPL	Stock	29.4162	29.4275	29.39	29.3912	1375852.0
2016-10-14 10:00:00	AAPL	Stock	29.3925	29.395	29.31	29.3445	2971900.0
2016-10-14 10:05:00	AAPL	Stock	29.345	29.3775	29.33	29.3775	1642740.0
2016-10-14 10:10:00	AAPL	Stock	29.3775	29.4112	29.3675	29.39	2114756.0
2016-10-14 10:15:00	AAPL	Stock	29.39	29.4178	29.38	29.4148	1274396.0
2016-10-14 10:20:00	AAPL	Stock	29.4125	29.4425	29.405	29.41	1761628.0

> showing 50 of 341,023 rows — these rows as CSV

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