PREVIEW / stock_5min / 2017-05-26

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-05-26.parquet
  size:    5.2 MB
  rows:    339,972
  symbols: 3,033

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-26 04:00:00	AAPL	Stock	38.5	38.5	38.5	38.5	400.0
2017-05-26 05:55:00	AAPL	Stock	38.455	38.455	38.455	38.455	400.0
2017-05-26 06:10:00	AAPL	Stock	38.45	38.45	38.45	38.45	896.0
2017-05-26 07:00:00	AAPL	Stock	38.4875	38.4875	38.4875	38.4875	4000.0
2017-05-26 07:10:00	AAPL	Stock	38.5075	38.5075	38.5075	38.5075	752.0
2017-05-26 07:20:00	AAPL	Stock	38.505	38.505	38.505	38.505	3660.0
2017-05-26 07:25:00	AAPL	Stock	38.4575	38.4575	38.4575	38.4575	6000.0
2017-05-26 07:35:00	AAPL	Stock	38.425	38.425	38.425	38.425	3552.0
2017-05-26 07:45:00	AAPL	Stock	38.3925	38.3925	38.3925	38.3925	2000.0
2017-05-26 07:50:00	AAPL	Stock	38.39	38.39	38.375	38.375	2700.0
2017-05-26 07:55:00	AAPL	Stock	38.365	38.365	38.35	38.35	12200.0
2017-05-26 08:00:00	AAPL	Stock	38.3575	38.3875	38.34	38.3875	7200.0
2017-05-26 08:05:00	AAPL	Stock	38.3825	38.385	38.365	38.365	4340.0
2017-05-26 08:10:00	AAPL	Stock	38.375	38.375	38.3675	38.3675	2000.0
2017-05-26 08:15:00	AAPL	Stock	38.375	38.375	38.335	38.35	49904.0
2017-05-26 08:20:00	AAPL	Stock	38.35	38.35	38.3375	38.35	9600.0
2017-05-26 08:25:00	AAPL	Stock	38.335	38.335	38.3125	38.325	29056.0
2017-05-26 08:30:00	AAPL	Stock	38.325	38.35	38.325	38.35	15472.0
2017-05-26 08:35:00	AAPL	Stock	38.355	38.375	38.34	38.34	12740.0
2017-05-26 08:40:00	AAPL	Stock	38.36	38.375	38.36	38.37	9240.0
2017-05-26 08:50:00	AAPL	Stock	38.36	38.36	38.36	38.36	400.0
2017-05-26 08:55:00	AAPL	Stock	38.3625	38.375	38.3575	38.3575	4100.0
2017-05-26 09:00:00	AAPL	Stock	38.385	38.3925	38.3825	38.3825	26128.0
2017-05-26 09:05:00	AAPL	Stock	38.3825	38.3925	38.3825	38.3875	5600.0
2017-05-26 09:10:00	AAPL	Stock	38.3875	38.3875	38.3825	38.3825	5224.0
2017-05-26 09:15:00	AAPL	Stock	38.3825	38.39	38.3825	38.39	10292.0
2017-05-26 09:20:00	AAPL	Stock	38.395	38.4125	38.395	38.41	50852.0
2017-05-26 09:25:00	AAPL	Stock	38.415	38.47	38.415	38.4575	44776.0
2017-05-26 09:30:00	AAPL	Stock	38.4525	38.5195	38.3625	38.44	3566564.0
2017-05-26 09:35:00	AAPL	Stock	38.4338	38.56	38.43	38.5025	1892652.0
2017-05-26 09:40:00	AAPL	Stock	38.5025	38.5075	38.4575	38.47	1009680.0
2017-05-26 09:45:00	AAPL	Stock	38.4725	38.5375	38.47	38.4875	982384.0
2017-05-26 09:50:00	AAPL	Stock	38.4875	38.505	38.4448	38.46	842220.0
2017-05-26 09:55:00	AAPL	Stock	38.46	38.4925	38.4375	38.475	1002992.0
2017-05-26 10:00:00	AAPL	Stock	38.4725	38.51	38.47	38.485	949028.0
2017-05-26 10:05:00	AAPL	Stock	38.485	38.5	38.46	38.48	723752.0
2017-05-26 10:10:00	AAPL	Stock	38.4802	38.4875	38.425	38.4375	1136096.0
2017-05-26 10:15:00	AAPL	Stock	38.4388	38.4525	38.4075	38.44	680600.0
2017-05-26 10:20:00	AAPL	Stock	38.44	38.445	38.4225	38.4288	586568.0
2017-05-26 10:25:00	AAPL	Stock	38.4275	38.435	38.3978	38.4	721772.0
2017-05-26 10:30:00	AAPL	Stock	38.4	38.4397	38.4	38.4382	540508.0
2017-05-26 10:35:00	AAPL	Stock	38.4375	38.4762	38.43	38.464	678140.0
2017-05-26 10:40:00	AAPL	Stock	38.4628	38.48	38.45	38.4505	371140.0
2017-05-26 10:45:00	AAPL	Stock	38.45	38.4575	38.4325	38.4408	456404.0
2017-05-26 10:50:00	AAPL	Stock	38.44	38.44	38.415	38.4288	422896.0
2017-05-26 10:55:00	AAPL	Stock	38.4288	38.4425	38.4125	38.4125	504408.0
2017-05-26 11:00:00	AAPL	Stock	38.415	38.425	38.3775	38.3952	911656.0
2017-05-26 11:05:00	AAPL	Stock	38.396	38.4215	38.395	38.4025	557300.0
2017-05-26 11:10:00	AAPL	Stock	38.402	38.41	38.3775	38.385	435664.0
2017-05-26 11:15:00	AAPL	Stock	38.385	38.4025	38.3775	38.38	588180.0

> showing 50 of 339,972 rows — these rows as CSV

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