PREVIEW / stock_1min / 2017-11-06

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-11-06.parquet
  size:    14.7 MB
  rows:    1,057,030
  symbols: 2,455

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-11-06 04:00:00	AAPL	Stock	43.25	43.275	43.225	43.275	41572.0
2017-11-06 04:01:00	AAPL	Stock	43.275	43.275	43.275	43.275	4000.0
2017-11-06 04:02:00	AAPL	Stock	43.2725	43.2725	43.2725	43.2725	600.0
2017-11-06 04:06:00	AAPL	Stock	43.26	43.26	43.26	43.26	1176.0
2017-11-06 04:12:00	AAPL	Stock	43.2475	43.2475	43.2475	43.2475	4356.0
2017-11-06 04:13:00	AAPL	Stock	43.25	43.25	43.25	43.25	1600.0
2017-11-06 04:15:00	AAPL	Stock	43.27	43.27	43.27	43.27	1200.0
2017-11-06 04:27:00	AAPL	Stock	43.25	43.25	43.25	43.25	2000.0
2017-11-06 04:31:00	AAPL	Stock	43.245	43.245	43.245	43.245	1800.0
2017-11-06 04:39:00	AAPL	Stock	43.2425	43.2425	43.2425	43.2425	2000.0
2017-11-06 04:41:00	AAPL	Stock	43.235	43.235	43.235	43.235	800.0
2017-11-06 04:44:00	AAPL	Stock	43.235	43.235	43.235	43.235	1040.0
2017-11-06 04:46:00	AAPL	Stock	43.225	43.225	43.225	43.225	8000.0
2017-11-06 04:47:00	AAPL	Stock	43.225	43.225	43.225	43.225	4000.0
2017-11-06 04:54:00	AAPL	Stock	43.2375	43.2375	43.2375	43.2375	400.0
2017-11-06 04:58:00	AAPL	Stock	43.235	43.235	43.235	43.235	764.0
2017-11-06 05:13:00	AAPL	Stock	43.2325	43.2325	43.2325	43.2325	800.0
2017-11-06 05:17:00	AAPL	Stock	43.2325	43.2325	43.2325	43.2325	1012.0
2017-11-06 05:27:00	AAPL	Stock	43.225	43.225	43.225	43.225	1200.0
2017-11-06 05:28:00	AAPL	Stock	43.225	43.225	43.2225	43.2225	1200.0
2017-11-06 05:36:00	AAPL	Stock	43.2	43.2175	43.2	43.2175	4280.0
2017-11-06 05:41:00	AAPL	Stock	43.2175	43.2175	43.2175	43.2175	1236.0
2017-11-06 05:43:00	AAPL	Stock	43.2175	43.22	43.2175	43.22	6020.0
2017-11-06 05:44:00	AAPL	Stock	43.225	43.2325	43.225	43.2325	800.0
2017-11-06 05:45:00	AAPL	Stock	43.225	43.225	43.225	43.225	400.0
2017-11-06 05:46:00	AAPL	Stock	43.225	43.225	43.225	43.225	400.0
2017-11-06 05:50:00	AAPL	Stock	43.225	43.225	43.225	43.225	1524.0
2017-11-06 05:57:00	AAPL	Stock	43.22	43.225	43.2175	43.22	8000.0
2017-11-06 05:58:00	AAPL	Stock	43.2	43.22	43.2	43.22	5364.0
2017-11-06 05:59:00	AAPL	Stock	43.175	43.175	43.175	43.175	1592.0
2017-11-06 06:00:00	AAPL	Stock	43.175	43.175	43.175	43.175	3664.0
2017-11-06 06:01:00	AAPL	Stock	43.1725	43.1725	43.1725	43.1725	6312.0
2017-11-06 06:02:00	AAPL	Stock	43.1725	43.175	43.1725	43.1725	12516.0
2017-11-06 06:03:00	AAPL	Stock	43.195	43.1975	43.1775	43.1775	13856.0
2017-11-06 06:08:00	AAPL	Stock	43.1975	43.205	43.1975	43.205	2160.0
2017-11-06 06:09:00	AAPL	Stock	43.2125	43.22	43.2125	43.22	5156.0
2017-11-06 06:10:00	AAPL	Stock	43.2	43.2	43.2	43.2	3200.0
2017-11-06 06:12:00	AAPL	Stock	43.175	43.1925	43.175	43.1925	12276.0
2017-11-06 06:14:00	AAPL	Stock	43.1975	43.1975	43.1975	43.1975	1512.0
2017-11-06 06:15:00	AAPL	Stock	43.2	43.225	43.2	43.225	11756.0
2017-11-06 06:20:00	AAPL	Stock	43.2225	43.225	43.2225	43.225	1600.0
2017-11-06 06:23:00	AAPL	Stock	43.2375	43.2375	43.2375	43.2375	400.0
2017-11-06 06:24:00	AAPL	Stock	43.225	43.225	43.225	43.225	2800.0
2017-11-06 06:27:00	AAPL	Stock	43.225	43.225	43.225	43.225	544.0
2017-11-06 06:28:00	AAPL	Stock	43.225	43.225	43.225	43.225	2000.0
2017-11-06 06:30:00	AAPL	Stock	43.225	43.225	43.225	43.225	400.0
2017-11-06 06:32:00	AAPL	Stock	43.2375	43.25	43.2375	43.25	2000.0
2017-11-06 06:33:00	AAPL	Stock	43.25	43.25	43.2375	43.2375	7740.0
2017-11-06 06:37:00	AAPL	Stock	43.2125	43.2125	43.21	43.21	2740.0
2017-11-06 06:42:00	AAPL	Stock	43.22	43.22	43.22	43.22	2000.0

> showing 50 of 1,057,030 rows — these rows as CSV

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