PREVIEW / stock_1min / 2017-09-15

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-15.parquet
  size:    14.3 MB
  rows:    1,043,688
  symbols: 2,462

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-09-15 05:43:00	AAPL	Stock	39.55	39.55	39.5375	39.5375	5200.0
2017-09-15 05:50:00	AAPL	Stock	39.57	39.57	39.57	39.57	400.0
2017-09-15 06:00:00	AAPL	Stock	39.5375	39.5375	39.5375	39.5375	16492.0
2017-09-15 06:29:00	AAPL	Stock	39.5175	39.5175	39.5175	39.5175	440.0
2017-09-15 06:36:00	AAPL	Stock	39.5125	39.5125	39.5125	39.5125	2380.0
2017-09-15 06:39:00	AAPL	Stock	39.5125	39.5125	39.5125	39.5125	600.0
2017-09-15 06:44:00	AAPL	Stock	39.505	39.505	39.505	39.505	2000.0
2017-09-15 06:45:00	AAPL	Stock	39.55	39.55	39.55	39.55	1340.0
2017-09-15 06:46:00	AAPL	Stock	39.55	39.5675	39.55	39.5675	2348.0
2017-09-15 07:05:00	AAPL	Stock	39.5275	39.5275	39.525	39.525	3504.0
2017-09-15 07:10:00	AAPL	Stock	39.535	39.535	39.535	39.535	1200.0
2017-09-15 07:14:00	AAPL	Stock	39.5625	39.5625	39.5625	39.5625	3608.0
2017-09-15 07:15:00	AAPL	Stock	39.5675	39.5675	39.5675	39.5675	800.0
2017-09-15 07:17:00	AAPL	Stock	39.555	39.555	39.555	39.555	800.0
2017-09-15 07:19:00	AAPL	Stock	39.555	39.5675	39.555	39.5675	2800.0
2017-09-15 07:26:00	AAPL	Stock	39.575	39.575	39.575	39.575	400.0
2017-09-15 07:27:00	AAPL	Stock	39.57	39.57	39.57	39.57	400.0
2017-09-15 07:33:00	AAPL	Stock	39.6	39.6	39.6	39.6	4000.0
2017-09-15 07:35:00	AAPL	Stock	39.62	39.6225	39.62	39.6225	4224.0
2017-09-15 07:36:00	AAPL	Stock	39.625	39.625	39.6225	39.6225	22200.0
2017-09-15 07:37:00	AAPL	Stock	39.625	39.625	39.625	39.625	4760.0
2017-09-15 07:38:00	AAPL	Stock	39.625	39.625	39.6125	39.6125	1300.0
2017-09-15 07:39:00	AAPL	Stock	39.64	39.64	39.64	39.64	5456.0
2017-09-15 07:41:00	AAPL	Stock	39.6425	39.6425	39.6425	39.6425	4000.0
2017-09-15 07:43:00	AAPL	Stock	39.6375	39.6375	39.6375	39.6375	400.0
2017-09-15 07:44:00	AAPL	Stock	39.645	39.6725	39.645	39.6725	10696.0
2017-09-15 07:45:00	AAPL	Stock	39.675	39.675	39.655	39.655	20400.0
2017-09-15 07:46:00	AAPL	Stock	39.675	39.675	39.675	39.675	4000.0
2017-09-15 07:47:00	AAPL	Stock	39.675	39.675	39.675	39.675	400.0
2017-09-15 07:48:00	AAPL	Stock	39.675	39.675	39.675	39.675	3280.0
2017-09-15 07:49:00	AAPL	Stock	39.6575	39.6575	39.6575	39.6575	1596.0
2017-09-15 07:50:00	AAPL	Stock	39.675	39.675	39.6625	39.675	3348.0
2017-09-15 07:51:00	AAPL	Stock	39.6575	39.6575	39.6575	39.6575	1600.0
2017-09-15 07:52:00	AAPL	Stock	39.6575	39.6575	39.65	39.6575	27100.0
2017-09-15 07:53:00	AAPL	Stock	39.655	39.6575	39.655	39.655	3252.0
2017-09-15 07:54:00	AAPL	Stock	39.6575	39.6575	39.655	39.655	11052.0
2017-09-15 07:55:00	AAPL	Stock	39.63	39.63	39.63	39.63	400.0
2017-09-15 08:00:00	AAPL	Stock	39.6425	39.675	39.575	39.6375	28200.0
2017-09-15 08:01:00	AAPL	Stock	39.6375	39.65	39.6325	39.645	12524.0
2017-09-15 08:02:00	AAPL	Stock	39.625	39.625	39.625	39.625	4668.0
2017-09-15 08:03:00	AAPL	Stock	39.6425	39.6425	39.6325	39.6325	11440.0
2017-09-15 08:04:00	AAPL	Stock	39.625	39.6325	39.625	39.6325	2120.0
2017-09-15 08:05:00	AAPL	Stock	39.625	39.6325	39.625	39.6325	1660.0
2017-09-15 08:06:00	AAPL	Stock	39.6325	39.6325	39.6325	39.6325	3260.0
2017-09-15 08:07:00	AAPL	Stock	39.635	39.635	39.6275	39.6275	6400.0
2017-09-15 08:09:00	AAPL	Stock	39.6375	39.6375	39.6375	39.6375	856.0
2017-09-15 08:10:00	AAPL	Stock	39.6375	39.6375	39.6375	39.6375	4000.0
2017-09-15 08:11:00	AAPL	Stock	39.6375	39.64	39.6375	39.64	4120.0
2017-09-15 08:12:00	AAPL	Stock	39.6425	39.65	39.6425	39.6425	8488.0
2017-09-15 08:13:00	AAPL	Stock	39.6425	39.65	39.6425	39.65	1580.0

> showing 50 of 1,043,688 rows — these rows as CSV

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