PREVIEW / stock_5min / 2017-06-23

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-23.parquet
  size:    5.4 MB
  rows:    354,012
  symbols: 3,005

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-06-23 06:15:00	AAPL	Stock	36.4875	36.4875	36.4875	36.4875	1600.0
2017-06-23 06:25:00	AAPL	Stock	36.425	36.425	36.4125	36.4125	4800.0
2017-06-23 06:35:00	AAPL	Stock	36.4	36.4	36.4	36.4	1188.0
2017-06-23 06:45:00	AAPL	Stock	36.38	36.38	36.365	36.365	3600.0
2017-06-23 06:55:00	AAPL	Stock	36.38	36.38	36.38	36.38	400.0
2017-06-23 07:00:00	AAPL	Stock	36.365	36.365	36.365	36.365	2400.0
2017-06-23 07:05:00	AAPL	Stock	36.38	36.3875	36.38	36.3875	1444.0
2017-06-23 07:10:00	AAPL	Stock	36.3925	36.3925	36.375	36.375	6864.0
2017-06-23 07:15:00	AAPL	Stock	36.3875	36.3875	36.3875	36.3875	2000.0
2017-06-23 07:25:00	AAPL	Stock	36.375	36.3775	36.3625	36.3675	5000.0
2017-06-23 07:35:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	868.0
2017-06-23 07:45:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	2580.0
2017-06-23 07:55:00	AAPL	Stock	36.3575	36.3575	36.355	36.355	4000.0
2017-06-23 08:00:00	AAPL	Stock	36.3625	36.3875	36.3625	36.3675	12452.0
2017-06-23 08:05:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	22000.0
2017-06-23 08:10:00	AAPL	Stock	36.3675	36.3675	36.3525	36.3525	6100.0
2017-06-23 08:15:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	2800.0
2017-06-23 08:20:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	1200.0
2017-06-23 08:25:00	AAPL	Stock	36.3575	36.3575	36.3575	36.3575	600.0
2017-06-23 08:30:00	AAPL	Stock	36.3575	36.3575	36.325	36.325	14908.0
2017-06-23 08:35:00	AAPL	Stock	36.335	36.335	36.335	36.335	800.0
2017-06-23 08:40:00	AAPL	Stock	36.335	36.3375	36.335	36.3375	3192.0
2017-06-23 08:45:00	AAPL	Stock	36.345	36.345	36.345	36.345	7200.0
2017-06-23 08:50:00	AAPL	Stock	36.345	36.345	36.345	36.345	1800.0
2017-06-23 08:55:00	AAPL	Stock	36.345	36.38	36.3375	36.38	22064.0
2017-06-23 09:00:00	AAPL	Stock	36.38	36.38	36.3525	36.3675	6400.0
2017-06-23 09:05:00	AAPL	Stock	36.3675	36.3675	36.3525	36.365	4264.0
2017-06-23 09:10:00	AAPL	Stock	36.38	36.38	36.3625	36.3625	6788.0
2017-06-23 09:15:00	AAPL	Stock	36.3625	36.3875	36.3625	36.38	24444.0
2017-06-23 09:25:00	AAPL	Stock	36.3675	36.3675	36.265	36.2925	84308.0
2017-06-23 09:30:00	AAPL	Stock	36.2875	36.47	36.2775	36.4	2843980.0
2017-06-23 09:35:00	AAPL	Stock	36.405	36.4775	36.36	36.46	1085896.0
2017-06-23 09:40:00	AAPL	Stock	36.46	36.4675	36.3625	36.375	1542232.0
2017-06-23 09:45:00	AAPL	Stock	36.38	36.4325	36.3375	36.415	1005720.0
2017-06-23 09:50:00	AAPL	Stock	36.415	36.4285	36.3875	36.415	947536.0
2017-06-23 09:55:00	AAPL	Stock	36.4125	36.46	36.39	36.4525	985520.0
2017-06-23 10:00:00	AAPL	Stock	36.45	36.4575	36.4175	36.4225	699292.0
2017-06-23 10:05:00	AAPL	Stock	36.425	36.4438	36.4025	36.4325	793416.0
2017-06-23 10:10:00	AAPL	Stock	36.4325	36.4375	36.3975	36.3975	712632.0
2017-06-23 10:15:00	AAPL	Stock	36.3975	36.4175	36.29	36.3675	910660.0
2017-06-23 10:20:00	AAPL	Stock	36.365	36.43	36.3625	36.42	954000.0
2017-06-23 10:25:00	AAPL	Stock	36.4225	36.4425	36.4125	36.4288	700376.0
2017-06-23 10:30:00	AAPL	Stock	36.4288	36.485	36.4263	36.4798	1108380.0
2017-06-23 10:35:00	AAPL	Stock	36.4825	36.4925	36.4625	36.49	619836.0
2017-06-23 10:40:00	AAPL	Stock	36.4925	36.5375	36.49	36.5225	1056976.0
2017-06-23 10:45:00	AAPL	Stock	36.525	36.5375	36.5088	36.5375	661960.0
2017-06-23 10:50:00	AAPL	Stock	36.535	36.575	36.535	36.555	857076.0
2017-06-23 10:55:00	AAPL	Stock	36.5575	36.5592	36.5275	36.53	607516.0
2017-06-23 11:00:00	AAPL	Stock	36.53	36.575	36.525	36.575	469496.0
2017-06-23 11:05:00	AAPL	Stock	36.5742	36.5975	36.565	36.5775	763308.0

> showing 50 of 354,012 rows — these rows as CSV

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