PREVIEW / stock_5min / 2017-01-27

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-27.parquet
  size:    5.2 MB
  rows:    342,078
  symbols: 3,105

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-01-27 04:45:00	AAPL	Stock	30.4675	30.4675	30.4675	30.4675	400.0
2017-01-27 07:15:00	AAPL	Stock	30.5	30.5125	30.5	30.5125	6400.0
2017-01-27 07:40:00	AAPL	Stock	30.48	30.48	30.4625	30.48	1200.0
2017-01-27 07:45:00	AAPL	Stock	30.505	30.505	30.505	30.505	1400.0
2017-01-27 07:50:00	AAPL	Stock	30.4925	30.4925	30.4925	30.4925	3600.0
2017-01-27 07:55:00	AAPL	Stock	30.48	30.48	30.4775	30.4775	3200.0
2017-01-27 08:00:00	AAPL	Stock	30.4775	30.4975	30.4775	30.4975	5636.0
2017-01-27 08:10:00	AAPL	Stock	30.49	30.49	30.4775	30.49	4000.0
2017-01-27 08:15:00	AAPL	Stock	30.4775	30.4775	30.4775	30.4775	632.0
2017-01-27 08:20:00	AAPL	Stock	30.49	30.5	30.49	30.5	21444.0
2017-01-27 08:25:00	AAPL	Stock	30.5025	30.5025	30.495	30.4975	13636.0
2017-01-27 08:30:00	AAPL	Stock	30.5	30.5	30.5	30.5	1200.0
2017-01-27 08:35:00	AAPL	Stock	30.515	30.5275	30.515	30.5275	1868.0
2017-01-27 08:40:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	400.0
2017-01-27 08:50:00	AAPL	Stock	30.5175	30.525	30.5175	30.525	3080.0
2017-01-27 08:55:00	AAPL	Stock	30.525	30.525	30.5175	30.525	2760.0
2017-01-27 09:00:00	AAPL	Stock	30.5175	30.5175	30.5175	30.5175	2000.0
2017-01-27 09:05:00	AAPL	Stock	30.5175	30.5175	30.495	30.495	20064.0
2017-01-27 09:10:00	AAPL	Stock	30.495	30.495	30.49	30.4925	15168.0
2017-01-27 09:15:00	AAPL	Stock	30.49	30.49	30.49	30.49	18028.0
2017-01-27 09:20:00	AAPL	Stock	30.495	30.495	30.49	30.49	6400.0
2017-01-27 09:25:00	AAPL	Stock	30.5	30.55	30.49	30.5125	91064.0
2017-01-27 09:30:00	AAPL	Stock	30.53	30.5875	30.4802	30.5538	4558496.0
2017-01-27 09:35:00	AAPL	Stock	30.555	30.5625	30.5	30.5425	1508156.0
2017-01-27 09:40:00	AAPL	Stock	30.54	30.545	30.4852	30.495	1607040.0
2017-01-27 09:45:00	AAPL	Stock	30.495	30.525	30.4675	30.505	1705892.0
2017-01-27 09:50:00	AAPL	Stock	30.5075	30.54	30.503	30.5325	996776.0
2017-01-27 09:55:00	AAPL	Stock	30.535	30.5488	30.5062	30.546	1074072.0
2017-01-27 10:00:00	AAPL	Stock	30.545	30.5675	30.54	30.56	1472824.0
2017-01-27 10:05:00	AAPL	Stock	30.56	30.565	30.5025	30.51	1200160.0
2017-01-27 10:10:00	AAPL	Stock	30.51	30.5425	30.505	30.52	1157720.0
2017-01-27 10:15:00	AAPL	Stock	30.5205	30.529	30.5	30.5275	763136.0
2017-01-27 10:20:00	AAPL	Stock	30.5275	30.5325	30.5125	30.5178	541876.0
2017-01-27 10:25:00	AAPL	Stock	30.5178	30.5312	30.5175	30.5275	617488.0
2017-01-27 10:30:00	AAPL	Stock	30.5275	30.545	30.515	30.525	823212.0
2017-01-27 10:35:00	AAPL	Stock	30.5255	30.53	30.5125	30.515	484728.0
2017-01-27 10:40:00	AAPL	Stock	30.5175	30.5388	30.51	30.52	850612.0
2017-01-27 10:45:00	AAPL	Stock	30.5178	30.5325	30.51	30.5175	824888.0
2017-01-27 10:50:00	AAPL	Stock	30.5188	30.525	30.5	30.51	507496.0
2017-01-27 10:55:00	AAPL	Stock	30.5088	30.5162	30.4875	30.495	816484.0
2017-01-27 11:00:00	AAPL	Stock	30.495	30.5125	30.4925	30.495	766724.0
2017-01-27 11:05:00	AAPL	Stock	30.4962	30.51	30.4925	30.5075	766420.0
2017-01-27 11:10:00	AAPL	Stock	30.5075	30.5125	30.49	30.4975	884312.0
2017-01-27 11:15:00	AAPL	Stock	30.4988	30.505	30.485	30.489	746804.0
2017-01-27 11:20:00	AAPL	Stock	30.4888	30.5075	30.485	30.505	551768.0
2017-01-27 11:25:00	AAPL	Stock	30.505	30.515	30.495	30.5025	575908.0
2017-01-27 11:30:00	AAPL	Stock	30.5025	30.5075	30.4975	30.4975	419644.0
2017-01-27 11:35:00	AAPL	Stock	30.5	30.505	30.49	30.5012	431568.0
2017-01-27 11:40:00	AAPL	Stock	30.5025	30.5062	30.4925	30.496	376744.0
2017-01-27 11:45:00	AAPL	Stock	30.4975	30.5	30.4925	30.4975	339096.0

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

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