PREVIEW / stock_1min / 2014-06-25

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-06-25.parquet
  size:    14.7 MB
  rows:    1,078,854
  symbols: 2,901

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
2014-06-25 04:00:00	AAPL	Stock	22.6025	22.6025	22.6025	22.6025	400.0
2014-06-25 04:18:00	AAPL	Stock	22.57	22.575	22.57	22.575	1600.0
2014-06-25 04:31:00	AAPL	Stock	22.575	22.575	22.53	22.53	2400.0
2014-06-25 04:34:00	AAPL	Stock	22.53	22.53	22.53	22.53	800.0
2014-06-25 04:36:00	AAPL	Stock	22.575	22.575	22.575	22.575	2000.0
2014-06-25 04:37:00	AAPL	Stock	22.5525	22.5525	22.55	22.5525	6000.0
2014-06-25 04:40:00	AAPL	Stock	22.555	22.555	22.5375	22.5375	1472.0
2014-06-25 04:44:00	AAPL	Stock	22.5375	22.5375	22.5375	22.5375	800.0
2014-06-25 04:50:00	AAPL	Stock	22.5375	22.5375	22.5375	22.5375	1600.0
2014-06-25 04:51:00	AAPL	Stock	22.5375	22.5375	22.5325	22.5325	2400.0
2014-06-25 04:55:00	AAPL	Stock	22.535	22.535	22.535	22.535	400.0
2014-06-25 05:09:00	AAPL	Stock	22.535	22.535	22.525	22.525	2676.0
2014-06-25 05:17:00	AAPL	Stock	22.525	22.525	22.525	22.525	3600.0
2014-06-25 05:20:00	AAPL	Stock	22.525	22.525	22.525	22.525	400.0
2014-06-25 05:24:00	AAPL	Stock	22.5375	22.5375	22.5375	22.5375	1200.0
2014-06-25 05:25:00	AAPL	Stock	22.54	22.54	22.51	22.51	12400.0
2014-06-25 05:34:00	AAPL	Stock	22.5275	22.5425	22.5275	22.53	6560.0
2014-06-25 05:42:00	AAPL	Stock	22.5425	22.5425	22.5425	22.5425	1600.0
2014-06-25 05:44:00	AAPL	Stock	22.555	22.555	22.555	22.555	2000.0
2014-06-25 05:45:00	AAPL	Stock	22.5375	22.5375	22.5375	22.5375	1200.0
2014-06-25 05:46:00	AAPL	Stock	22.5425	22.5425	22.5425	22.5425	1400.0
2014-06-25 05:55:00	AAPL	Stock	22.545	22.545	22.545	22.545	1200.0
2014-06-25 06:06:00	AAPL	Stock	22.555	22.5575	22.555	22.5575	7000.0
2014-06-25 06:08:00	AAPL	Stock	22.555	22.5575	22.555	22.5575	3832.0
2014-06-25 06:13:00	AAPL	Stock	22.5525	22.5525	22.5525	22.5525	1672.0
2014-06-25 06:15:00	AAPL	Stock	22.5525	22.5525	22.5525	22.5525	8000.0
2014-06-25 06:16:00	AAPL	Stock	22.5525	22.5525	22.55	22.55	10000.0
2014-06-25 06:22:00	AAPL	Stock	22.5375	22.5375	22.5375	22.5375	800.0
2014-06-25 06:23:00	AAPL	Stock	22.5375	22.54	22.5375	22.5375	5200.0
2014-06-25 06:25:00	AAPL	Stock	22.5525	22.5525	22.5525	22.5525	596.0
2014-06-25 06:30:00	AAPL	Stock	22.5325	22.5325	22.5325	22.5325	2800.0
2014-06-25 06:33:00	AAPL	Stock	22.5325	22.5325	22.5325	22.5325	3200.0
2014-06-25 06:34:00	AAPL	Stock	22.5325	22.5325	22.5125	22.5125	13664.0
2014-06-25 06:35:00	AAPL	Stock	22.5275	22.5275	22.5275	22.5275	2200.0
2014-06-25 06:45:00	AAPL	Stock	22.5225	22.525	22.5225	22.525	2000.0
2014-06-25 06:46:00	AAPL	Stock	22.525	22.525	22.525	22.525	1920.0
2014-06-25 06:47:00	AAPL	Stock	22.5375	22.5375	22.5375	22.5375	1600.0
2014-06-25 06:50:00	AAPL	Stock	22.5375	22.5375	22.5375	22.5375	800.0
2014-06-25 06:52:00	AAPL	Stock	22.54	22.54	22.525	22.525	5200.0
2014-06-25 07:00:00	AAPL	Stock	22.53	22.54	22.53	22.54	2404.0
2014-06-25 07:03:00	AAPL	Stock	22.5425	22.5425	22.5425	22.5425	4640.0
2014-06-25 07:04:00	AAPL	Stock	22.54	22.555	22.54	22.555	3388.0
2014-06-25 07:05:00	AAPL	Stock	22.555	22.555	22.555	22.555	1384.0
2014-06-25 07:06:00	AAPL	Stock	22.555	22.555	22.555	22.555	1584.0
2014-06-25 07:07:00	AAPL	Stock	22.57	22.57	22.57	22.57	1976.0
2014-06-25 07:09:00	AAPL	Stock	22.57	22.57	22.57	22.57	400.0
2014-06-25 07:10:00	AAPL	Stock	22.57	22.57	22.57	22.57	1600.0
2014-06-25 07:13:00	AAPL	Stock	22.57	22.57	22.57	22.57	400.0
2014-06-25 07:16:00	AAPL	Stock	22.5875	22.5875	22.5875	22.5875	7996.0
2014-06-25 07:17:00	AAPL	Stock	22.57	22.57	22.57	22.57	2000.0

> showing 50 of 1,078,854 rows — these rows as CSV

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