PREVIEW / stock_1min / 2018-01-16

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-01-16.parquet
  size:    18.4 MB
  rows:    1,158,909
  symbols: 2,418

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
2018-01-16 04:00:00	AAPL	Stock	44.35	44.375	44.35	44.375	2640.0
2018-01-16 04:01:00	AAPL	Stock	44.4	44.4	44.4	44.4	7960.0
2018-01-16 04:08:00	AAPL	Stock	44.45	44.45	44.4375	44.45	10636.0
2018-01-16 04:09:00	AAPL	Stock	44.4125	44.5	44.4	44.5	19128.0
2018-01-16 04:10:00	AAPL	Stock	44.5	44.5	44.5	44.5	11048.0
2018-01-16 04:11:00	AAPL	Stock	44.6	44.6	44.6	44.6	2000.0
2018-01-16 04:12:00	AAPL	Stock	44.6	44.6	44.6	44.6	800.0
2018-01-16 04:18:00	AAPL	Stock	44.57	44.575	44.57	44.575	9336.0
2018-01-16 04:27:00	AAPL	Stock	44.5625	44.5625	44.5625	44.5625	1920.0
2018-01-16 04:35:00	AAPL	Stock	44.575	44.575	44.575	44.575	400.0
2018-01-16 04:36:00	AAPL	Stock	44.575	44.575	44.575	44.575	400.0
2018-01-16 04:50:00	AAPL	Stock	44.5625	44.5625	44.5625	44.5625	400.0
2018-01-16 04:54:00	AAPL	Stock	44.5625	44.5625	44.5625	44.5625	800.0
2018-01-16 05:01:00	AAPL	Stock	44.525	44.525	44.525	44.525	400.0
2018-01-16 05:10:00	AAPL	Stock	44.55	44.55	44.55	44.55	400.0
2018-01-16 05:21:00	AAPL	Stock	44.5	44.5	44.5	44.5	400.0
2018-01-16 05:28:00	AAPL	Stock	44.505	44.505	44.5	44.5	2984.0
2018-01-16 05:36:00	AAPL	Stock	44.5025	44.5025	44.5025	44.5025	732.0
2018-01-16 05:38:00	AAPL	Stock	44.5	44.5	44.5	44.5	772.0
2018-01-16 05:45:00	AAPL	Stock	44.55	44.55	44.55	44.55	1600.0
2018-01-16 05:53:00	AAPL	Stock	44.5175	44.5175	44.5175	44.5175	400.0
2018-01-16 06:00:00	AAPL	Stock	44.5375	44.5375	44.5375	44.5375	1600.0
2018-01-16 06:02:00	AAPL	Stock	44.5625	44.5625	44.5625	44.5625	19200.0
2018-01-16 06:05:00	AAPL	Stock	44.5625	44.5625	44.5625	44.5625	2000.0
2018-01-16 06:06:00	AAPL	Stock	44.575	44.575	44.5625	44.5625	2732.0
2018-01-16 06:09:00	AAPL	Stock	44.55	44.55	44.55	44.55	400.0
2018-01-16 06:17:00	AAPL	Stock	44.575	44.575	44.575	44.575	4000.0
2018-01-16 06:23:00	AAPL	Stock	44.5725	44.5725	44.5675	44.5725	7600.0
2018-01-16 06:24:00	AAPL	Stock	44.5725	44.5725	44.5725	44.5725	1176.0
2018-01-16 06:26:00	AAPL	Stock	44.57	44.57	44.57	44.57	776.0
2018-01-16 06:29:00	AAPL	Stock	44.5425	44.5425	44.5425	44.5425	3084.0
2018-01-16 06:31:00	AAPL	Stock	44.5625	44.5625	44.5625	44.5625	3600.0
2018-01-16 06:32:00	AAPL	Stock	44.54	44.54	44.5375	44.5375	4000.0
2018-01-16 06:35:00	AAPL	Stock	44.55	44.55	44.55	44.55	800.0
2018-01-16 06:36:00	AAPL	Stock	44.5625	44.5625	44.5625	44.5625	800.0
2018-01-16 06:37:00	AAPL	Stock	44.55	44.55	44.55	44.55	4700.0
2018-01-16 06:48:00	AAPL	Stock	44.5725	44.575	44.5725	44.575	1748.0
2018-01-16 06:50:00	AAPL	Stock	44.575	44.575	44.575	44.575	400.0
2018-01-16 06:59:00	AAPL	Stock	44.5875	44.5975	44.5875	44.5975	5180.0
2018-01-16 07:00:00	AAPL	Stock	44.56	44.5975	44.5375	44.55	11888.0
2018-01-16 07:01:00	AAPL	Stock	44.55	44.55	44.5	44.54	22672.0
2018-01-16 07:02:00	AAPL	Stock	44.545	44.545	44.5125	44.5125	3532.0
2018-01-16 07:03:00	AAPL	Stock	44.5275	44.5275	44.525	44.525	2000.0
2018-01-16 07:04:00	AAPL	Stock	44.525	44.525	44.5	44.5	13800.0
2018-01-16 07:07:00	AAPL	Stock	44.525	44.5275	44.525	44.5275	3800.0
2018-01-16 07:08:00	AAPL	Stock	44.5275	44.545	44.5275	44.545	2380.0
2018-01-16 07:09:00	AAPL	Stock	44.5275	44.5275	44.5275	44.5275	3340.0
2018-01-16 07:10:00	AAPL	Stock	44.5425	44.545	44.5425	44.5425	2600.0
2018-01-16 07:11:00	AAPL	Stock	44.525	44.5375	44.5	44.5375	10000.0
2018-01-16 07:13:00	AAPL	Stock	44.56	44.5875	44.56	44.5625	3976.0

> showing 50 of 1,158,909 rows — these rows as CSV

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