PREVIEW / stock_1min / 2017-06-28

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-06-28.parquet
  size:    14.5 MB
  rows:    1,063,777
  symbols: 2,495

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-28 04:00:00	AAPL	Stock	35.6875	35.71	35.625	35.71	2800.0
2017-06-28 04:03:00	AAPL	Stock	35.7125	35.7125	35.71	35.71	2400.0
2017-06-28 04:04:00	AAPL	Stock	35.7075	35.7075	35.7075	35.7075	400.0
2017-06-28 04:07:00	AAPL	Stock	35.625	35.625	35.6125	35.6125	6568.0
2017-06-28 04:08:00	AAPL	Stock	35.6175	35.6175	35.6175	35.6175	800.0
2017-06-28 04:11:00	AAPL	Stock	35.5625	35.5625	35.5625	35.5625	400.0
2017-06-28 04:22:00	AAPL	Stock	35.5625	35.5625	35.5625	35.5625	400.0
2017-06-28 04:25:00	AAPL	Stock	35.505	35.5125	35.46	35.46	4400.0
2017-06-28 04:26:00	AAPL	Stock	35.425	35.425	35.425	35.425	4000.0
2017-06-28 04:27:00	AAPL	Stock	35.475	35.5	35.475	35.5	4400.0
2017-06-28 04:28:00	AAPL	Stock	35.5025	35.5025	35.5025	35.5025	1200.0
2017-06-28 04:36:00	AAPL	Stock	35.5025	35.5025	35.44	35.44	5600.0
2017-06-28 04:42:00	AAPL	Stock	35.5	35.5	35.5	35.5	1600.0
2017-06-28 04:43:00	AAPL	Stock	35.5	35.5	35.5	35.5	400.0
2017-06-28 04:44:00	AAPL	Stock	35.5025	35.5025	35.5	35.5	1600.0
2017-06-28 04:47:00	AAPL	Stock	35.5425	35.5425	35.5025	35.5025	1608.0
2017-06-28 04:50:00	AAPL	Stock	35.5625	35.5625	35.5625	35.5625	628.0
2017-06-28 04:54:00	AAPL	Stock	35.6	35.6	35.6	35.6	2000.0
2017-06-28 04:58:00	AAPL	Stock	35.6	35.6	35.6	35.6	400.0
2017-06-28 04:59:00	AAPL	Stock	35.525	35.525	35.525	35.525	1600.0
2017-06-28 05:00:00	AAPL	Stock	35.6	35.6	35.6	35.6	600.0
2017-06-28 05:01:00	AAPL	Stock	35.525	35.525	35.525	35.525	2000.0
2017-06-28 05:10:00	AAPL	Stock	35.5875	35.5975	35.5875	35.5975	2000.0
2017-06-28 05:16:00	AAPL	Stock	35.585	35.585	35.585	35.585	400.0
2017-06-28 05:18:00	AAPL	Stock	35.5975	35.5975	35.5975	35.5975	4000.0
2017-06-28 05:19:00	AAPL	Stock	35.5975	35.5975	35.5975	35.5975	3020.0
2017-06-28 05:24:00	AAPL	Stock	35.5875	35.5875	35.5875	35.5875	680.0
2017-06-28 05:27:00	AAPL	Stock	35.6225	35.6225	35.6225	35.6225	3724.0
2017-06-28 05:28:00	AAPL	Stock	35.6225	35.625	35.6225	35.625	2340.0
2017-06-28 05:29:00	AAPL	Stock	35.6625	35.6625	35.6625	35.6625	784.0
2017-06-28 05:31:00	AAPL	Stock	35.695	35.7025	35.695	35.7	6768.0
2017-06-28 05:36:00	AAPL	Stock	35.75	35.75	35.75	35.75	400.0
2017-06-28 05:40:00	AAPL	Stock	35.7	35.7	35.7	35.7	5448.0
2017-06-28 05:42:00	AAPL	Stock	35.725	35.7325	35.725	35.7325	4400.0
2017-06-28 05:44:00	AAPL	Stock	35.7375	35.7375	35.7375	35.7375	400.0
2017-06-28 05:46:00	AAPL	Stock	35.7625	35.7625	35.7625	35.7625	400.0
2017-06-28 05:48:00	AAPL	Stock	35.7625	35.7625	35.7625	35.7625	800.0
2017-06-28 05:52:00	AAPL	Stock	35.7625	35.7625	35.7375	35.7375	5400.0
2017-06-28 05:53:00	AAPL	Stock	35.7375	35.7375	35.7375	35.7375	1000.0
2017-06-28 05:54:00	AAPL	Stock	35.7375	35.7375	35.7375	35.7375	400.0
2017-06-28 05:56:00	AAPL	Stock	35.7125	35.7125	35.7125	35.7125	2400.0
2017-06-28 05:58:00	AAPL	Stock	35.75	35.75	35.75	35.75	1600.0
2017-06-28 06:10:00	AAPL	Stock	35.75	35.75	35.75	35.75	2100.0
2017-06-28 06:11:00	AAPL	Stock	35.75	35.75	35.75	35.75	6904.0
2017-06-28 06:12:00	AAPL	Stock	35.7525	35.7525	35.7525	35.7525	480.0
2017-06-28 06:13:00	AAPL	Stock	35.7725	35.7725	35.7725	35.7725	7820.0
2017-06-28 06:15:00	AAPL	Stock	35.7575	35.7575	35.75	35.75	3464.0
2017-06-28 06:19:00	AAPL	Stock	35.7125	35.7125	35.7125	35.7125	800.0
2017-06-28 06:20:00	AAPL	Stock	35.715	35.715	35.7125	35.7125	3624.0
2017-06-28 06:24:00	AAPL	Stock	35.7125	35.7125	35.7125	35.7125	8000.0

> showing 50 of 1,063,777 rows — these rows as CSV

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