PREVIEW / stock_1min / 2017-07-31

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-31.parquet
  size:    14.1 MB
  rows:    1,021,242
  symbols: 2,475

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-07-31 04:00:00	AAPL	Stock	37.4375	37.4375	37.4375	37.4375	400.0
2017-07-31 04:15:00	AAPL	Stock	37.465	37.465	37.465	37.465	524.0
2017-07-31 05:06:00	AAPL	Stock	37.55	37.55	37.55	37.55	5792.0
2017-07-31 05:07:00	AAPL	Stock	37.55	37.55	37.55	37.55	800.0
2017-07-31 05:29:00	AAPL	Stock	37.5625	37.5625	37.5625	37.5625	400.0
2017-07-31 05:50:00	AAPL	Stock	37.5575	37.5575	37.5575	37.5575	400.0
2017-07-31 05:59:00	AAPL	Stock	37.51	37.51	37.51	37.51	400.0
2017-07-31 06:07:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	516.0
2017-07-31 06:17:00	AAPL	Stock	37.5325	37.5325	37.5325	37.5325	1200.0
2017-07-31 06:20:00	AAPL	Stock	37.525	37.525	37.525	37.525	1200.0
2017-07-31 06:30:00	AAPL	Stock	37.5375	37.55	37.5375	37.55	4000.0
2017-07-31 06:33:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	800.0
2017-07-31 06:48:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	1908.0
2017-07-31 06:51:00	AAPL	Stock	37.5025	37.5025	37.5	37.5	3172.0
2017-07-31 07:03:00	AAPL	Stock	37.5	37.5	37.5	37.5	5500.0
2017-07-31 07:05:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	632.0
2017-07-31 07:06:00	AAPL	Stock	37.52	37.52	37.52	37.52	1600.0
2017-07-31 07:08:00	AAPL	Stock	37.5025	37.505	37.5025	37.505	2400.0
2017-07-31 07:09:00	AAPL	Stock	37.5175	37.5175	37.5175	37.5175	2000.0
2017-07-31 07:11:00	AAPL	Stock	37.515	37.515	37.515	37.515	2400.0
2017-07-31 07:15:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	4000.0
2017-07-31 07:19:00	AAPL	Stock	37.515	37.52	37.515	37.52	4364.0
2017-07-31 07:23:00	AAPL	Stock	37.52	37.525	37.52	37.525	6608.0
2017-07-31 07:24:00	AAPL	Stock	37.525	37.525	37.525	37.525	2036.0
2017-07-31 07:25:00	AAPL	Stock	37.5225	37.5225	37.5225	37.5225	1200.0
2017-07-31 07:31:00	AAPL	Stock	37.5225	37.5225	37.5225	37.5225	400.0
2017-07-31 07:32:00	AAPL	Stock	37.5225	37.5225	37.51	37.51	1200.0
2017-07-31 07:33:00	AAPL	Stock	37.5175	37.5175	37.5175	37.5175	400.0
2017-07-31 07:36:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	4000.0
2017-07-31 07:37:00	AAPL	Stock	37.5225	37.5225	37.5075	37.5075	1600.0
2017-07-31 07:42:00	AAPL	Stock	37.5075	37.5075	37.5075	37.5075	2000.0
2017-07-31 07:48:00	AAPL	Stock	37.5	37.5	37.5	37.5	2000.0
2017-07-31 07:49:00	AAPL	Stock	37.5	37.5	37.5	37.5	3012.0
2017-07-31 07:50:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	2432.0
2017-07-31 07:51:00	AAPL	Stock	37.505	37.505	37.505	37.505	1200.0
2017-07-31 07:53:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	3800.0
2017-07-31 07:55:00	AAPL	Stock	37.5075	37.5075	37.5075	37.5075	400.0
2017-07-31 07:57:00	AAPL	Stock	37.5175	37.5225	37.5175	37.5225	8000.0
2017-07-31 07:58:00	AAPL	Stock	37.505	37.505	37.5	37.5	6736.0
2017-07-31 08:00:00	AAPL	Stock	37.4775	37.525	37.4775	37.4875	27856.0
2017-07-31 08:01:00	AAPL	Stock	37.49	37.49	37.4775	37.4775	2200.0
2017-07-31 08:02:00	AAPL	Stock	37.4925	37.4925	37.4875	37.4875	9000.0
2017-07-31 08:03:00	AAPL	Stock	37.495	37.495	37.495	37.495	1000.0
2017-07-31 08:04:00	AAPL	Stock	37.495	37.495	37.495	37.495	1200.0
2017-07-31 08:05:00	AAPL	Stock	37.4875	37.49	37.485	37.49	21200.0
2017-07-31 08:08:00	AAPL	Stock	37.48	37.49	37.475	37.475	2924.0
2017-07-31 08:09:00	AAPL	Stock	37.475	37.475	37.475	37.475	1844.0
2017-07-31 08:11:00	AAPL	Stock	37.4875	37.4875	37.4875	37.4875	1700.0
2017-07-31 08:12:00	AAPL	Stock	37.49	37.49	37.49	37.49	780.0
2017-07-31 08:13:00	AAPL	Stock	37.4975	37.4975	37.49	37.49	10600.0

> showing 50 of 1,021,242 rows — these rows as CSV

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