PREVIEW / stock_1min / 2017-09-28

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-28.parquet
  size:    14.5 MB
  rows:    1,062,110
  symbols: 2,438

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-09-28 04:00:00	AAPL	Stock	38.5575	38.5575	38.5575	38.5575	1080.0
2017-09-28 04:02:00	AAPL	Stock	38.57	38.57	38.57	38.57	800.0
2017-09-28 04:04:00	AAPL	Stock	38.5725	38.5725	38.5725	38.5725	400.0
2017-09-28 04:19:00	AAPL	Stock	38.5525	38.5525	38.5525	38.5525	800.0
2017-09-28 05:27:00	AAPL	Stock	38.5875	38.5875	38.5875	38.5875	400.0
2017-09-28 06:07:00	AAPL	Stock	38.575	38.575	38.575	38.575	1192.0
2017-09-28 06:09:00	AAPL	Stock	38.595	38.595	38.595	38.595	2000.0
2017-09-28 06:25:00	AAPL	Stock	38.61	38.61	38.61	38.61	1736.0
2017-09-28 06:35:00	AAPL	Stock	38.6	38.6	38.6	38.6	400.0
2017-09-28 06:43:00	AAPL	Stock	38.6125	38.6125	38.6125	38.6125	3600.0
2017-09-28 06:52:00	AAPL	Stock	38.61	38.61	38.61	38.61	1200.0
2017-09-28 06:56:00	AAPL	Stock	38.6	38.6	38.595	38.595	1200.0
2017-09-28 07:00:00	AAPL	Stock	38.5775	38.5775	38.575	38.575	2152.0
2017-09-28 07:01:00	AAPL	Stock	38.575	38.575	38.5625	38.5625	1480.0
2017-09-28 07:03:00	AAPL	Stock	38.585	38.585	38.585	38.585	3140.0
2017-09-28 07:08:00	AAPL	Stock	38.5625	38.5625	38.5625	38.5625	5604.0
2017-09-28 07:10:00	AAPL	Stock	38.585	38.585	38.585	38.585	1600.0
2017-09-28 07:17:00	AAPL	Stock	38.5725	38.5725	38.5725	38.5725	400.0
2017-09-28 07:18:00	AAPL	Stock	38.5675	38.575	38.5625	38.575	4620.0
2017-09-28 07:20:00	AAPL	Stock	38.5925	38.5925	38.5925	38.5925	400.0
2017-09-28 07:26:00	AAPL	Stock	38.575	38.575	38.575	38.575	800.0
2017-09-28 07:28:00	AAPL	Stock	38.5575	38.5575	38.5575	38.5575	1256.0
2017-09-28 07:30:00	AAPL	Stock	38.56	38.56	38.5575	38.5575	1820.0
2017-09-28 07:35:00	AAPL	Stock	38.5575	38.5575	38.5575	38.5575	1000.0
2017-09-28 07:36:00	AAPL	Stock	38.555	38.555	38.555	38.555	800.0
2017-09-28 07:37:00	AAPL	Stock	38.5475	38.5475	38.5475	38.5475	400.0
2017-09-28 07:40:00	AAPL	Stock	38.5275	38.5275	38.5275	38.5275	400.0
2017-09-28 07:47:00	AAPL	Stock	38.5275	38.5275	38.5275	38.5275	1600.0
2017-09-28 07:48:00	AAPL	Stock	38.5175	38.5175	38.5	38.5075	11008.0
2017-09-28 07:49:00	AAPL	Stock	38.505	38.505	38.505	38.505	1400.0
2017-09-28 07:52:00	AAPL	Stock	38.5125	38.5125	38.5	38.5	3200.0
2017-09-28 07:56:00	AAPL	Stock	38.5	38.5	38.4975	38.4975	2624.0
2017-09-28 07:58:00	AAPL	Stock	38.465	38.465	38.465	38.465	800.0
2017-09-28 08:00:00	AAPL	Stock	38.5862	38.595	38.4675	38.4975	29460.0
2017-09-28 08:01:00	AAPL	Stock	38.475	38.475	38.475	38.475	1600.0
2017-09-28 08:02:00	AAPL	Stock	38.475	38.475	38.475	38.475	1120.0
2017-09-28 08:03:00	AAPL	Stock	38.475	38.475	38.475	38.475	1600.0
2017-09-28 08:04:00	AAPL	Stock	38.4675	38.4675	38.4675	38.4675	2300.0
2017-09-28 08:05:00	AAPL	Stock	38.475	38.475	38.475	38.475	400.0
2017-09-28 08:06:00	AAPL	Stock	38.4675	38.4675	38.46	38.465	4600.0
2017-09-28 08:07:00	AAPL	Stock	38.465	38.465	38.465	38.465	400.0
2017-09-28 08:08:00	AAPL	Stock	38.465	38.465	38.465	38.465	2400.0
2017-09-28 08:09:00	AAPL	Stock	38.465	38.4675	38.465	38.465	3360.0
2017-09-28 08:10:00	AAPL	Stock	38.48	38.485	38.48	38.485	15508.0
2017-09-28 08:13:00	AAPL	Stock	38.48	38.48	38.48	38.48	400.0
2017-09-28 08:14:00	AAPL	Stock	38.465	38.465	38.4525	38.4525	1400.0
2017-09-28 08:17:00	AAPL	Stock	38.44	38.4425	38.44	38.4425	3380.0
2017-09-28 08:18:00	AAPL	Stock	38.4525	38.4525	38.45	38.45	1880.0
2017-09-28 08:19:00	AAPL	Stock	38.45	38.45	38.45	38.45	6316.0
2017-09-28 08:20:00	AAPL	Stock	38.45	38.46	38.4475	38.4475	9080.0

> showing 50 of 1,062,110 rows — these rows as CSV

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