PREVIEW / stock_1min / 2015-07-20

all stock 1-min files

  file:    by_date/stock_1min/2015/2015-07-20.parquet
  size:    14.6 MB
  rows:    1,065,012
  symbols: 2,862

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
2015-07-20 04:00:00	AAPL	Stock	32.5	32.5325	32.5	32.5	7344.0
2015-07-20 04:02:00	AAPL	Stock	32.5125	32.5125	32.5125	32.5125	400.0
2015-07-20 04:03:00	AAPL	Stock	32.55	32.55	32.55	32.55	504.0
2015-07-20 04:05:00	AAPL	Stock	32.5475	32.5475	32.5475	32.5475	800.0
2015-07-20 04:10:00	AAPL	Stock	32.5375	32.5375	32.525	32.525	1200.0
2015-07-20 04:11:00	AAPL	Stock	32.5375	32.5375	32.5375	32.5375	400.0
2015-07-20 04:12:00	AAPL	Stock	32.5475	32.5475	32.5475	32.5475	800.0
2015-07-20 04:16:00	AAPL	Stock	32.5425	32.5425	32.5425	32.5425	400.0
2015-07-20 04:17:00	AAPL	Stock	32.55	32.55	32.55	32.55	10000.0
2015-07-20 04:21:00	AAPL	Stock	32.55	32.55	32.55	32.55	1996.0
2015-07-20 04:22:00	AAPL	Stock	32.5525	32.56	32.5525	32.56	8400.0
2015-07-20 04:24:00	AAPL	Stock	32.56	32.56	32.56	32.56	2000.0
2015-07-20 04:25:00	AAPL	Stock	32.5575	32.5575	32.5575	32.5575	1604.0
2015-07-20 04:26:00	AAPL	Stock	32.5525	32.5525	32.5525	32.5525	1200.0
2015-07-20 04:28:00	AAPL	Stock	32.5625	32.5625	32.5625	32.5625	1600.0
2015-07-20 04:31:00	AAPL	Stock	32.555	32.555	32.555	32.555	840.0
2015-07-20 04:34:00	AAPL	Stock	32.56	32.56	32.5525	32.5525	13160.0
2015-07-20 04:35:00	AAPL	Stock	32.545	32.545	32.5425	32.5425	2100.0
2015-07-20 04:36:00	AAPL	Stock	32.5525	32.5525	32.5525	32.5525	792.0
2015-07-20 04:37:00	AAPL	Stock	32.555	32.57	32.555	32.57	6000.0
2015-07-20 04:39:00	AAPL	Stock	32.565	32.565	32.565	32.565	2000.0
2015-07-20 04:41:00	AAPL	Stock	32.575	32.575	32.575	32.575	1200.0
2015-07-20 04:42:00	AAPL	Stock	32.575	32.575	32.575	32.575	512.0
2015-07-20 04:43:00	AAPL	Stock	32.5675	32.5675	32.565	32.565	11600.0
2015-07-20 04:45:00	AAPL	Stock	32.605	32.605	32.605	32.605	1288.0
2015-07-20 04:49:00	AAPL	Stock	32.605	32.605	32.605	32.605	7856.0
2015-07-20 04:50:00	AAPL	Stock	32.605	32.605	32.605	32.605	656.0
2015-07-20 04:55:00	AAPL	Stock	32.62	32.62	32.62	32.62	1544.0
2015-07-20 04:58:00	AAPL	Stock	32.5775	32.5775	32.5775	32.5775	400.0
2015-07-20 05:00:00	AAPL	Stock	32.6225	32.6225	32.6225	32.6225	400.0
2015-07-20 05:12:00	AAPL	Stock	32.5775	32.5825	32.575	32.5825	15668.0
2015-07-20 05:20:00	AAPL	Stock	32.575	32.575	32.575	32.575	400.0
2015-07-20 05:23:00	AAPL	Stock	32.575	32.575	32.575	32.575	9600.0
2015-07-20 05:24:00	AAPL	Stock	32.595	32.6	32.595	32.6	3960.0
2015-07-20 05:26:00	AAPL	Stock	32.6025	32.6125	32.6025	32.6125	1200.0
2015-07-20 05:27:00	AAPL	Stock	32.6	32.6	32.6	32.6	1960.0
2015-07-20 05:29:00	AAPL	Stock	32.6125	32.6125	32.6125	32.6125	1840.0
2015-07-20 05:36:00	AAPL	Stock	32.6125	32.615	32.6125	32.6125	4000.0
2015-07-20 05:37:00	AAPL	Stock	32.6175	32.6175	32.6175	32.6175	3200.0
2015-07-20 05:38:00	AAPL	Stock	32.615	32.6175	32.6125	32.615	5000.0
2015-07-20 05:49:00	AAPL	Stock	32.605	32.62	32.605	32.62	1040.0
2015-07-20 05:50:00	AAPL	Stock	32.62	32.62	32.62	32.62	2000.0
2015-07-20 05:51:00	AAPL	Stock	32.62	32.62	32.62	32.62	800.0
2015-07-20 05:55:00	AAPL	Stock	32.625	32.625	32.625	32.625	2000.0
2015-07-20 06:01:00	AAPL	Stock	32.625	32.625	32.625	32.625	2000.0
2015-07-20 06:02:00	AAPL	Stock	32.64	32.64	32.64	32.64	2800.0
2015-07-20 06:03:00	AAPL	Stock	32.64	32.645	32.64	32.645	4800.0
2015-07-20 06:04:00	AAPL	Stock	32.64	32.645	32.64	32.645	8000.0
2015-07-20 06:07:00	AAPL	Stock	32.645	32.645	32.64	32.64	3780.0
2015-07-20 06:08:00	AAPL	Stock	32.64	32.6425	32.64	32.6425	2000.0

> showing 50 of 1,065,012 rows — these rows as CSV

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