PREVIEW / stock_1min / 2017-02-27

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-02-27.parquet
  size:    14.7 MB
  rows:    1,067,980
  symbols: 2,561

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-02-27 04:28:00	AAPL	Stock	34.125	34.125	34.125	34.125	800.0
2017-02-27 06:15:00	AAPL	Stock	34.1525	34.1525	34.1525	34.1525	800.0
2017-02-27 06:16:00	AAPL	Stock	34.1525	34.1525	34.1525	34.1525	800.0
2017-02-27 06:17:00	AAPL	Stock	34.1525	34.1525	34.1525	34.1525	4000.0
2017-02-27 06:20:00	AAPL	Stock	34.1525	34.1525	34.15	34.15	4400.0
2017-02-27 06:21:00	AAPL	Stock	34.1525	34.1525	34.1525	34.1525	2800.0
2017-02-27 06:22:00	AAPL	Stock	34.1875	34.1925	34.1875	34.1925	2400.0
2017-02-27 06:25:00	AAPL	Stock	34.2125	34.225	34.2125	34.225	800.0
2017-02-27 06:26:00	AAPL	Stock	34.2375	34.25	34.2375	34.24	9200.0
2017-02-27 06:27:00	AAPL	Stock	34.25	34.25	34.225	34.225	4800.0
2017-02-27 06:28:00	AAPL	Stock	34.225	34.25	34.225	34.2375	7668.0
2017-02-27 06:29:00	AAPL	Stock	34.2525	34.2525	34.25	34.25	3876.0
2017-02-27 06:30:00	AAPL	Stock	34.25	34.2675	34.25	34.2675	3320.0
2017-02-27 06:31:00	AAPL	Stock	34.285	34.285	34.285	34.285	400.0
2017-02-27 06:32:00	AAPL	Stock	34.285	34.285	34.285	34.285	400.0
2017-02-27 06:33:00	AAPL	Stock	34.2675	34.2675	34.2675	34.2675	400.0
2017-02-27 06:34:00	AAPL	Stock	34.275	34.275	34.275	34.275	4000.0
2017-02-27 06:36:00	AAPL	Stock	34.2625	34.2625	34.2625	34.2625	1200.0
2017-02-27 06:37:00	AAPL	Stock	34.2725	34.2725	34.2725	34.2725	400.0
2017-02-27 06:38:00	AAPL	Stock	34.27	34.27	34.27	34.27	400.0
2017-02-27 06:41:00	AAPL	Stock	34.2725	34.275	34.2625	34.2625	6680.0
2017-02-27 06:42:00	AAPL	Stock	34.27	34.285	34.27	34.285	4320.0
2017-02-27 06:44:00	AAPL	Stock	34.275	34.3	34.275	34.3	10720.0
2017-02-27 06:46:00	AAPL	Stock	34.3	34.3	34.3	34.3	400.0
2017-02-27 06:48:00	AAPL	Stock	34.31	34.31	34.31	34.31	2000.0
2017-02-27 06:49:00	AAPL	Stock	34.31	34.31	34.31	34.31	2000.0
2017-02-27 06:50:00	AAPL	Stock	34.3125	34.3225	34.3125	34.3225	4800.0
2017-02-27 06:51:00	AAPL	Stock	34.3125	34.3125	34.3025	34.3025	2400.0
2017-02-27 06:53:00	AAPL	Stock	34.3075	34.3075	34.2875	34.2875	2400.0
2017-02-27 06:54:00	AAPL	Stock	34.275	34.275	34.255	34.255	1600.0
2017-02-27 06:55:00	AAPL	Stock	34.3	34.3	34.3	34.3	2000.0
2017-02-27 06:56:00	AAPL	Stock	34.3	34.3	34.3	34.3	400.0
2017-02-27 06:57:00	AAPL	Stock	34.3	34.3	34.3	34.3	3200.0
2017-02-27 06:58:00	AAPL	Stock	34.3	34.3075	34.3	34.3075	1600.0
2017-02-27 06:59:00	AAPL	Stock	34.3075	34.3125	34.3	34.3125	9600.0
2017-02-27 07:00:00	AAPL	Stock	34.3125	34.325	34.3	34.325	5400.0
2017-02-27 07:01:00	AAPL	Stock	34.3125	34.3125	34.3	34.3	9680.0
2017-02-27 07:02:00	AAPL	Stock	34.3125	34.3225	34.3125	34.3225	4200.0
2017-02-27 07:03:00	AAPL	Stock	34.3225	34.3225	34.2625	34.2625	11860.0
2017-02-27 07:04:00	AAPL	Stock	34.2625	34.2625	34.2625	34.2625	1200.0
2017-02-27 07:05:00	AAPL	Stock	34.265	34.31	34.25	34.2575	26140.0
2017-02-27 07:06:00	AAPL	Stock	34.245	34.245	34.215	34.2175	7400.0
2017-02-27 07:08:00	AAPL	Stock	34.26	34.26	34.26	34.26	800.0
2017-02-27 07:09:00	AAPL	Stock	34.26	34.26	34.26	34.26	800.0
2017-02-27 07:11:00	AAPL	Stock	34.265	34.265	34.26	34.26	7548.0
2017-02-27 07:14:00	AAPL	Stock	34.265	34.2675	34.265	34.2675	6800.0
2017-02-27 07:15:00	AAPL	Stock	34.2675	34.2675	34.2675	34.2675	4000.0
2017-02-27 07:16:00	AAPL	Stock	34.2525	34.2525	34.25	34.25	13600.0
2017-02-27 07:18:00	AAPL	Stock	34.25	34.25	34.25	34.25	1600.0
2017-02-27 07:19:00	AAPL	Stock	34.25	34.2575	34.25	34.2525	4800.0

> showing 50 of 1,067,980 rows — these rows as CSV

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