PREVIEW / stock_1min / 2017-10-16

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-16.parquet
  size:    14.2 MB
  rows:    1,017,456
  symbols: 2,446

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-10-16 04:00:00	AAPL	Stock	39.535	39.55	39.535	39.55	8564.0
2017-10-16 04:05:00	AAPL	Stock	39.555	39.555	39.555	39.555	800.0
2017-10-16 04:06:00	AAPL	Stock	39.555	39.555	39.5525	39.5525	4520.0
2017-10-16 04:18:00	AAPL	Stock	39.5625	39.5625	39.5625	39.5625	576.0
2017-10-16 04:31:00	AAPL	Stock	39.55	39.55	39.55	39.55	720.0
2017-10-16 04:33:00	AAPL	Stock	39.465	39.465	39.4525	39.4525	3192.0
2017-10-16 04:34:00	AAPL	Stock	39.55	39.55	39.55	39.55	1144.0
2017-10-16 04:46:00	AAPL	Stock	39.5425	39.5425	39.5425	39.5425	2000.0
2017-10-16 04:53:00	AAPL	Stock	39.54	39.54	39.54	39.54	1600.0
2017-10-16 04:55:00	AAPL	Stock	39.545	39.545	39.545	39.545	3840.0
2017-10-16 05:19:00	AAPL	Stock	39.5375	39.5425	39.5375	39.5425	1712.0
2017-10-16 05:20:00	AAPL	Stock	39.535	39.535	39.535	39.535	400.0
2017-10-16 05:25:00	AAPL	Stock	39.505	39.505	39.5	39.5	1900.0
2017-10-16 05:26:00	AAPL	Stock	39.5	39.5	39.5	39.5	400.0
2017-10-16 05:27:00	AAPL	Stock	39.5025	39.5025	39.5025	39.5025	400.0
2017-10-16 05:29:00	AAPL	Stock	39.5225	39.5225	39.5225	39.5225	800.0
2017-10-16 05:42:00	AAPL	Stock	39.5125	39.5125	39.5125	39.5125	400.0
2017-10-16 05:57:00	AAPL	Stock	39.5425	39.5425	39.5425	39.5425	2784.0
2017-10-16 06:02:00	AAPL	Stock	39.5425	39.5425	39.5425	39.5425	400.0
2017-10-16 06:05:00	AAPL	Stock	39.5425	39.5425	39.5425	39.5425	1196.0
2017-10-16 06:08:00	AAPL	Stock	39.5425	39.5425	39.5425	39.5425	400.0
2017-10-16 06:18:00	AAPL	Stock	39.5425	39.5425	39.5425	39.5425	4240.0
2017-10-16 06:21:00	AAPL	Stock	39.5675	39.57	39.5675	39.57	4000.0
2017-10-16 06:23:00	AAPL	Stock	39.5675	39.57	39.5675	39.57	2800.0
2017-10-16 06:24:00	AAPL	Stock	39.5675	39.57	39.5675	39.57	1988.0
2017-10-16 06:25:00	AAPL	Stock	39.57	39.57	39.57	39.57	400.0
2017-10-16 06:28:00	AAPL	Stock	39.575	39.575	39.575	39.575	400.0
2017-10-16 06:29:00	AAPL	Stock	39.5775	39.5775	39.5775	39.5775	1200.0
2017-10-16 06:37:00	AAPL	Stock	39.5975	39.5975	39.5975	39.5975	3188.0
2017-10-16 06:40:00	AAPL	Stock	39.5975	39.5975	39.5975	39.5975	400.0
2017-10-16 06:42:00	AAPL	Stock	39.6	39.6	39.6	39.6	400.0
2017-10-16 06:43:00	AAPL	Stock	39.6	39.6	39.6	39.6	2400.0
2017-10-16 06:44:00	AAPL	Stock	39.6	39.6	39.5975	39.5975	800.0
2017-10-16 06:50:00	AAPL	Stock	39.6	39.625	39.6	39.625	6000.0
2017-10-16 06:51:00	AAPL	Stock	39.625	39.625	39.625	39.625	8160.0
2017-10-16 06:53:00	AAPL	Stock	39.625	39.625	39.625	39.625	400.0
2017-10-16 06:54:00	AAPL	Stock	39.625	39.625	39.6	39.6	30160.0
2017-10-16 07:00:00	AAPL	Stock	39.565	39.5825	39.5425	39.5825	32912.0
2017-10-16 07:01:00	AAPL	Stock	39.5825	39.5825	39.5825	39.5825	800.0
2017-10-16 07:02:00	AAPL	Stock	39.5825	39.5825	39.5625	39.5625	6528.0
2017-10-16 07:03:00	AAPL	Stock	39.575	39.575	39.5625	39.5625	1600.0
2017-10-16 07:05:00	AAPL	Stock	39.5425	39.5425	39.525	39.525	19880.0
2017-10-16 07:06:00	AAPL	Stock	39.55	39.55	39.55	39.55	1836.0
2017-10-16 07:07:00	AAPL	Stock	39.55	39.55	39.55	39.55	6004.0
2017-10-16 07:08:00	AAPL	Stock	39.5375	39.5375	39.5375	39.5375	11600.0
2017-10-16 07:10:00	AAPL	Stock	39.5575	39.5575	39.525	39.525	22432.0
2017-10-16 07:12:00	AAPL	Stock	39.545	39.55	39.545	39.55	5600.0
2017-10-16 07:13:00	AAPL	Stock	39.55	39.55	39.55	39.55	1200.0
2017-10-16 07:14:00	AAPL	Stock	39.53	39.55	39.53	39.55	3500.0
2017-10-16 07:15:00	AAPL	Stock	39.55	39.55	39.55	39.55	10780.0

> showing 50 of 1,017,456 rows — these rows as CSV

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