PREVIEW / stock_1min / 2017-02-07

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-02-07.parquet
  size:    14.4 MB
  rows:    1,039,155
  symbols: 2,558

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-07 04:00:00	AAPL	Stock	32.5625	32.5625	32.555	32.555	2212.0
2017-02-07 04:01:00	AAPL	Stock	32.515	32.515	32.515	32.515	4800.0
2017-02-07 04:12:00	AAPL	Stock	32.555	32.555	32.555	32.555	2104.0
2017-02-07 05:08:00	AAPL	Stock	32.5625	32.5625	32.5625	32.5625	1980.0
2017-02-07 05:39:00	AAPL	Stock	32.5625	32.5625	32.5625	32.5625	1968.0
2017-02-07 05:40:00	AAPL	Stock	32.5625	32.5625	32.5625	32.5625	408.0
2017-02-07 05:46:00	AAPL	Stock	32.5625	32.5625	32.5625	32.5625	800.0
2017-02-07 05:48:00	AAPL	Stock	32.5625	32.5625	32.5625	32.5625	1808.0
2017-02-07 06:13:00	AAPL	Stock	32.57	32.57	32.57	32.57	800.0
2017-02-07 06:22:00	AAPL	Stock	32.6075	32.61	32.6075	32.61	2000.0
2017-02-07 06:25:00	AAPL	Stock	32.6075	32.6125	32.6075	32.6125	6800.0
2017-02-07 06:40:00	AAPL	Stock	32.59	32.59	32.59	32.59	976.0
2017-02-07 06:42:00	AAPL	Stock	32.62	32.625	32.62	32.625	3620.0
2017-02-07 06:45:00	AAPL	Stock	32.625	32.625	32.625	32.625	480.0
2017-02-07 06:53:00	AAPL	Stock	32.625	32.625	32.625	32.625	880.0
2017-02-07 06:57:00	AAPL	Stock	32.6325	32.6325	32.62	32.62	2800.0
2017-02-07 07:04:00	AAPL	Stock	32.6125	32.6125	32.61	32.6125	4420.0
2017-02-07 07:05:00	AAPL	Stock	32.615	32.615	32.615	32.615	800.0
2017-02-07 07:12:00	AAPL	Stock	32.6225	32.625	32.6225	32.625	2000.0
2017-02-07 07:13:00	AAPL	Stock	32.625	32.625	32.625	32.625	768.0
2017-02-07 07:14:00	AAPL	Stock	32.6325	32.6325	32.6325	32.6325	800.0
2017-02-07 07:18:00	AAPL	Stock	32.6325	32.6325	32.6325	32.6325	400.0
2017-02-07 07:19:00	AAPL	Stock	32.635	32.635	32.635	32.635	904.0
2017-02-07 07:21:00	AAPL	Stock	32.6325	32.6325	32.6325	32.6325	1600.0
2017-02-07 07:23:00	AAPL	Stock	32.63	32.63	32.63	32.63	800.0
2017-02-07 07:26:00	AAPL	Stock	32.6325	32.6325	32.6325	32.6325	6084.0
2017-02-07 07:32:00	AAPL	Stock	32.6425	32.645	32.6425	32.645	800.0
2017-02-07 07:36:00	AAPL	Stock	32.645	32.655	32.645	32.65	2796.0
2017-02-07 07:37:00	AAPL	Stock	32.655	32.655	32.655	32.655	1200.0
2017-02-07 07:38:00	AAPL	Stock	32.6625	32.6625	32.6625	32.6625	400.0
2017-02-07 07:39:00	AAPL	Stock	32.6725	32.6725	32.6725	32.6725	1200.0
2017-02-07 07:40:00	AAPL	Stock	32.67	32.67	32.67	32.67	1600.0
2017-02-07 07:41:00	AAPL	Stock	32.67	32.67	32.67	32.67	2000.0
2017-02-07 07:42:00	AAPL	Stock	32.65	32.65	32.65	32.65	1240.0
2017-02-07 07:43:00	AAPL	Stock	32.6675	32.6675	32.6675	32.6675	800.0
2017-02-07 07:45:00	AAPL	Stock	32.65	32.65	32.65	32.65	8200.0
2017-02-07 07:46:00	AAPL	Stock	32.6525	32.6525	32.6525	32.6525	3032.0
2017-02-07 07:54:00	AAPL	Stock	32.65	32.65	32.65	32.65	400.0
2017-02-07 07:55:00	AAPL	Stock	32.65	32.655	32.65	32.65	17160.0
2017-02-07 07:56:00	AAPL	Stock	32.65	32.65	32.6375	32.6375	11280.0
2017-02-07 07:57:00	AAPL	Stock	32.645	32.65	32.645	32.65	10756.0
2017-02-07 07:58:00	AAPL	Stock	32.65	32.6525	32.65	32.6525	9744.0
2017-02-07 08:00:00	AAPL	Stock	32.65	32.67	32.6125	32.6525	25568.0
2017-02-07 08:01:00	AAPL	Stock	32.4875	32.65	32.4875	32.65	6400.0
2017-02-07 08:02:00	AAPL	Stock	32.65	32.65	32.6425	32.6425	10000.0
2017-02-07 08:03:00	AAPL	Stock	32.64	32.64	32.6375	32.6375	3044.0
2017-02-07 08:04:00	AAPL	Stock	32.63	32.6375	32.63	32.6375	13296.0
2017-02-07 08:05:00	AAPL	Stock	32.6375	32.6375	32.6375	32.6375	5888.0
2017-02-07 08:06:00	AAPL	Stock	32.65	32.65	32.65	32.65	400.0
2017-02-07 08:08:00	AAPL	Stock	32.655	32.655	32.655	32.655	3600.0

> showing 50 of 1,039,155 rows — these rows as CSV

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