PREVIEW / stock_1min / 2016-09-29

all stock 1-min files

  file:    by_date/stock_1min/2016/2016-09-29.parquet
  size:    14.4 MB
  rows:    1,050,697
  symbols: 2,638

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
2016-09-29 04:01:00	AAPL	Stock	28.4625	28.4625	28.4625	28.4625	1044.0
2016-09-29 04:02:00	AAPL	Stock	28.425	28.4625	28.425	28.4625	1244.0
2016-09-29 04:12:00	AAPL	Stock	28.4425	28.45	28.4425	28.45	800.0
2016-09-29 04:14:00	AAPL	Stock	28.4525	28.4525	28.4525	28.4525	400.0
2016-09-29 04:18:00	AAPL	Stock	28.425	28.425	28.425	28.425	400.0
2016-09-29 04:38:00	AAPL	Stock	28.4	28.4	28.4	28.4	1372.0
2016-09-29 05:17:00	AAPL	Stock	28.3875	28.3875	28.3875	28.3875	480.0
2016-09-29 05:20:00	AAPL	Stock	28.375	28.375	28.375	28.375	400.0
2016-09-29 05:32:00	AAPL	Stock	28.3775	28.3775	28.3625	28.3625	1024.0
2016-09-29 05:40:00	AAPL	Stock	28.375	28.375	28.375	28.375	440.0
2016-09-29 05:41:00	AAPL	Stock	28.375	28.375	28.375	28.375	960.0
2016-09-29 06:07:00	AAPL	Stock	28.4125	28.4125	28.4125	28.4125	4000.0
2016-09-29 06:08:00	AAPL	Stock	28.4125	28.4125	28.4125	28.4125	400.0
2016-09-29 06:22:00	AAPL	Stock	28.3875	28.3875	28.3875	28.3875	5400.0
2016-09-29 06:26:00	AAPL	Stock	28.37	28.37	28.37	28.37	3000.0
2016-09-29 06:29:00	AAPL	Stock	28.37	28.37	28.35	28.35	5880.0
2016-09-29 06:35:00	AAPL	Stock	28.35	28.35	28.3375	28.3375	840.0
2016-09-29 06:36:00	AAPL	Stock	28.3375	28.3375	28.3125	28.3125	8560.0
2016-09-29 06:38:00	AAPL	Stock	28.295	28.295	28.295	28.295	3680.0
2016-09-29 06:43:00	AAPL	Stock	28.305	28.305	28.3	28.3	2000.0
2016-09-29 06:45:00	AAPL	Stock	28.325	28.325	28.325	28.325	3840.0
2016-09-29 06:49:00	AAPL	Stock	28.325	28.325	28.325	28.325	1200.0
2016-09-29 06:50:00	AAPL	Stock	28.325	28.325	28.325	28.325	2000.0
2016-09-29 06:51:00	AAPL	Stock	28.3125	28.3125	28.2975	28.2975	5200.0
2016-09-29 06:52:00	AAPL	Stock	28.3	28.3	28.3	28.3	7200.0
2016-09-29 06:54:00	AAPL	Stock	28.29	28.3175	28.275	28.28	10000.0
2016-09-29 06:57:00	AAPL	Stock	28.28	28.28	28.2775	28.2775	4752.0
2016-09-29 06:58:00	AAPL	Stock	28.2775	28.2875	28.275	28.2875	5600.0
2016-09-29 07:00:00	AAPL	Stock	28.2775	28.28	28.275	28.275	9576.0
2016-09-29 07:01:00	AAPL	Stock	28.26	28.26	28.2575	28.2575	2800.0
2016-09-29 07:02:00	AAPL	Stock	28.27	28.3	28.27	28.3	2876.0
2016-09-29 07:03:00	AAPL	Stock	28.2775	28.2775	28.275	28.275	1756.0
2016-09-29 07:04:00	AAPL	Stock	28.3	28.3	28.3	28.3	400.0
2016-09-29 07:05:00	AAPL	Stock	28.3	28.3	28.3	28.3	6000.0
2016-09-29 07:08:00	AAPL	Stock	28.3	28.3	28.3	28.3	4000.0
2016-09-29 07:09:00	AAPL	Stock	28.3	28.3	28.3	28.3	4000.0
2016-09-29 07:10:00	AAPL	Stock	28.3	28.3	28.2525	28.2525	18328.0
2016-09-29 07:11:00	AAPL	Stock	28.2975	28.2975	28.2975	28.2975	400.0
2016-09-29 07:14:00	AAPL	Stock	28.265	28.265	28.265	28.265	400.0
2016-09-29 07:15:00	AAPL	Stock	28.2725	28.2725	28.2725	28.2725	400.0
2016-09-29 07:18:00	AAPL	Stock	28.3	28.3	28.3	28.3	800.0
2016-09-29 07:19:00	AAPL	Stock	28.3	28.3	28.3	28.3	1200.0
2016-09-29 07:21:00	AAPL	Stock	28.3	28.3	28.3	28.3	1200.0
2016-09-29 07:22:00	AAPL	Stock	28.3	28.3	28.3	28.3	1600.0
2016-09-29 07:23:00	AAPL	Stock	28.3	28.3	28.3	28.3	400.0
2016-09-29 07:24:00	AAPL	Stock	28.3	28.3	28.3	28.3	2400.0
2016-09-29 07:27:00	AAPL	Stock	28.3075	28.31	28.3075	28.31	800.0
2016-09-29 07:28:00	AAPL	Stock	28.3125	28.3125	28.3	28.3	4600.0
2016-09-29 07:30:00	AAPL	Stock	28.295	28.295	28.295	28.295	480.0
2016-09-29 07:31:00	AAPL	Stock	28.3	28.3	28.3	28.3	4480.0

> showing 50 of 1,050,697 rows — these rows as CSV

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