PREVIEW / stock_1min / 2017-10-02

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-02.parquet
  size:    15.0 MB
  rows:    1,077,412
  symbols: 2,451

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-02 04:00:00	AAPL	Stock	38.53	38.53	38.53	38.53	400.0
2017-10-02 04:44:00	AAPL	Stock	38.535	38.535	38.535	38.535	400.0
2017-10-02 05:25:00	AAPL	Stock	38.5375	38.5375	38.5375	38.5375	400.0
2017-10-02 05:27:00	AAPL	Stock	38.5375	38.5375	38.53	38.53	41600.0
2017-10-02 06:28:00	AAPL	Stock	38.5475	38.5475	38.5475	38.5475	1200.0
2017-10-02 06:35:00	AAPL	Stock	38.5	38.5575	38.5	38.5575	2952.0
2017-10-02 06:36:00	AAPL	Stock	38.5375	38.5575	38.5375	38.5575	2976.0
2017-10-02 06:44:00	AAPL	Stock	38.5375	38.5375	38.5375	38.5375	6120.0
2017-10-02 06:53:00	AAPL	Stock	38.545	38.545	38.545	38.545	400.0
2017-10-02 06:55:00	AAPL	Stock	38.5375	38.5375	38.525	38.525	960.0
2017-10-02 06:56:00	AAPL	Stock	38.5375	38.5625	38.5375	38.5625	23860.0
2017-10-02 06:58:00	AAPL	Stock	38.56	38.56	38.56	38.56	400.0
2017-10-02 07:00:00	AAPL	Stock	38.5525	38.5525	38.5525	38.5525	400.0
2017-10-02 07:01:00	AAPL	Stock	38.5725	38.5725	38.5725	38.5725	720.0
2017-10-02 07:04:00	AAPL	Stock	38.575	38.575	38.575	38.575	1200.0
2017-10-02 07:06:00	AAPL	Stock	38.575	38.5775	38.575	38.575	4412.0
2017-10-02 07:07:00	AAPL	Stock	38.5825	38.5925	38.5825	38.5925	8240.0
2017-10-02 07:08:00	AAPL	Stock	38.61	38.6125	38.595	38.605	2192.0
2017-10-02 07:09:00	AAPL	Stock	38.6175	38.6175	38.6175	38.6175	8724.0
2017-10-02 07:12:00	AAPL	Stock	38.6	38.6	38.5825	38.5825	4400.0
2017-10-02 07:13:00	AAPL	Stock	38.5825	38.5825	38.5825	38.5825	2712.0
2017-10-02 07:15:00	AAPL	Stock	38.5825	38.5825	38.5825	38.5825	1800.0
2017-10-02 07:16:00	AAPL	Stock	38.6	38.6	38.6	38.6	2800.0
2017-10-02 07:17:00	AAPL	Stock	38.6	38.6	38.6	38.6	1200.0
2017-10-02 07:19:00	AAPL	Stock	38.5825	38.5825	38.5825	38.5825	1000.0
2017-10-02 07:21:00	AAPL	Stock	38.6	38.6	38.6	38.6	1076.0
2017-10-02 07:22:00	AAPL	Stock	38.6	38.6125	38.6	38.6125	4612.0
2017-10-02 07:23:00	AAPL	Stock	38.6	38.6	38.6	38.6	400.0
2017-10-02 07:25:00	AAPL	Stock	38.6125	38.6225	38.595	38.595	9000.0
2017-10-02 07:28:00	AAPL	Stock	38.6	38.6	38.6	38.6	1588.0
2017-10-02 07:29:00	AAPL	Stock	38.585	38.585	38.585	38.585	400.0
2017-10-02 07:30:00	AAPL	Stock	38.585	38.585	38.585	38.585	1200.0
2017-10-02 07:31:00	AAPL	Stock	38.5825	38.5825	38.5825	38.5825	512.0
2017-10-02 07:34:00	AAPL	Stock	38.5825	38.5825	38.5825	38.5825	10000.0
2017-10-02 07:35:00	AAPL	Stock	38.5825	38.6	38.58	38.6	14612.0
2017-10-02 07:36:00	AAPL	Stock	38.6225	38.6225	38.6225	38.6225	2180.0
2017-10-02 07:42:00	AAPL	Stock	38.6	38.6	38.6	38.6	740.0
2017-10-02 07:44:00	AAPL	Stock	38.5775	38.6	38.575	38.575	11264.0
2017-10-02 07:45:00	AAPL	Stock	38.5775	38.5775	38.5775	38.5775	12000.0
2017-10-02 07:46:00	AAPL	Stock	38.6125	38.6175	38.6125	38.6125	14336.0
2017-10-02 07:48:00	AAPL	Stock	38.6175	38.6175	38.6125	38.6125	1264.0
2017-10-02 07:49:00	AAPL	Stock	38.6175	38.6175	38.6175	38.6175	628.0
2017-10-02 07:50:00	AAPL	Stock	38.6225	38.625	38.6125	38.625	12880.0
2017-10-02 07:53:00	AAPL	Stock	38.625	38.625	38.62	38.62	17464.0
2017-10-02 07:54:00	AAPL	Stock	38.6125	38.6125	38.6125	38.6125	1200.0
2017-10-02 07:57:00	AAPL	Stock	38.6125	38.6125	38.6125	38.6125	400.0
2017-10-02 07:58:00	AAPL	Stock	38.6125	38.6125	38.6	38.6	22020.0
2017-10-02 08:00:00	AAPL	Stock	38.6125	38.62	38.585	38.62	14304.0
2017-10-02 08:01:00	AAPL	Stock	38.62	38.62	38.62	38.62	2000.0
2017-10-02 08:02:00	AAPL	Stock	38.62	38.62	38.62	38.62	2800.0

> showing 50 of 1,077,412 rows — these rows as CSV

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