PREVIEW / stock_1min / 2014-07-31

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-07-31.parquet
  size:    15.7 MB
  rows:    1,130,163
  symbols: 2,921

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-07-31 04:00:00	AAPL	Stock	24.4875	24.4875	24.4875	24.4875	400.0
2014-07-31 04:08:00	AAPL	Stock	24.45	24.45	24.45	24.45	800.0
2014-07-31 04:11:00	AAPL	Stock	24.4225	24.4225	24.415	24.415	1800.0
2014-07-31 04:13:00	AAPL	Stock	24.4	24.4	24.4	24.4	2000.0
2014-07-31 04:14:00	AAPL	Stock	24.3875	24.3875	24.3875	24.3875	2000.0
2014-07-31 04:15:00	AAPL	Stock	24.3875	24.3875	24.3875	24.3875	400.0
2014-07-31 04:16:00	AAPL	Stock	24.3875	24.3875	24.3875	24.3875	3000.0
2014-07-31 04:26:00	AAPL	Stock	24.3875	24.3875	24.3775	24.3775	2800.0
2014-07-31 04:31:00	AAPL	Stock	24.355	24.355	24.355	24.355	400.0
2014-07-31 04:34:00	AAPL	Stock	24.35	24.35	24.35	24.35	1440.0
2014-07-31 04:35:00	AAPL	Stock	24.355	24.355	24.355	24.355	544.0
2014-07-31 04:36:00	AAPL	Stock	24.3625	24.3625	24.3475	24.3475	4560.0
2014-07-31 04:41:00	AAPL	Stock	24.325	24.325	24.325	24.325	2000.0
2014-07-31 04:42:00	AAPL	Stock	24.325	24.325	24.325	24.325	6376.0
2014-07-31 04:44:00	AAPL	Stock	24.3225	24.3225	24.3225	24.3225	2800.0
2014-07-31 04:50:00	AAPL	Stock	24.3025	24.3025	24.3	24.3	1748.0
2014-07-31 04:52:00	AAPL	Stock	24.29	24.29	24.25	24.25	4524.0
2014-07-31 04:53:00	AAPL	Stock	24.25	24.25	24.25	24.25	3764.0
2014-07-31 04:54:00	AAPL	Stock	24.25	24.25	24.25	24.25	3364.0
2014-07-31 04:56:00	AAPL	Stock	24.25	24.25	24.25	24.25	512.0
2014-07-31 04:58:00	AAPL	Stock	24.225	24.225	24.225	24.225	1900.0
2014-07-31 04:59:00	AAPL	Stock	24.25	24.25	24.25	24.25	1200.0
2014-07-31 05:00:00	AAPL	Stock	24.225	24.225	24.225	24.225	3600.0
2014-07-31 05:01:00	AAPL	Stock	24.225	24.225	24.225	24.225	400.0
2014-07-31 05:02:00	AAPL	Stock	24.225	24.225	24.225	24.225	1200.0
2014-07-31 05:05:00	AAPL	Stock	24.225	24.225	24.225	24.225	500.0
2014-07-31 05:07:00	AAPL	Stock	24.225	24.225	24.225	24.225	400.0
2014-07-31 05:10:00	AAPL	Stock	24.225	24.2275	24.2225	24.2275	2936.0
2014-07-31 05:11:00	AAPL	Stock	24.25	24.25	24.25	24.25	5200.0
2014-07-31 05:13:00	AAPL	Stock	24.175	24.175	24.175	24.175	2492.0
2014-07-31 05:14:00	AAPL	Stock	24.22	24.22	24.2125	24.2125	2892.0
2014-07-31 05:15:00	AAPL	Stock	24.22	24.22	24.22	24.22	400.0
2014-07-31 05:17:00	AAPL	Stock	24.22	24.22	24.22	24.22	712.0
2014-07-31 05:18:00	AAPL	Stock	24.225	24.225	24.225	24.225	1200.0
2014-07-31 05:20:00	AAPL	Stock	24.225	24.225	24.225	24.225	800.0
2014-07-31 05:25:00	AAPL	Stock	24.2375	24.2375	24.2375	24.2375	400.0
2014-07-31 05:26:00	AAPL	Stock	24.24	24.24	24.24	24.24	2000.0
2014-07-31 05:28:00	AAPL	Stock	24.24	24.25	24.24	24.25	4408.0
2014-07-31 05:29:00	AAPL	Stock	24.25	24.25	24.225	24.225	3452.0
2014-07-31 05:30:00	AAPL	Stock	24.25	24.25	24.25	24.25	1428.0
2014-07-31 05:31:00	AAPL	Stock	24.2275	24.2275	24.2275	24.2275	4000.0
2014-07-31 05:32:00	AAPL	Stock	24.2225	24.2225	24.2125	24.2125	9200.0
2014-07-31 05:33:00	AAPL	Stock	24.2125	24.2125	24.2125	24.2125	6800.0
2014-07-31 05:37:00	AAPL	Stock	24.2225	24.2275	24.2225	24.2275	2740.0
2014-07-31 05:38:00	AAPL	Stock	24.2275	24.2275	24.2275	24.2275	400.0
2014-07-31 06:03:00	AAPL	Stock	24.25	24.25	24.25	24.25	400.0
2014-07-31 06:04:00	AAPL	Stock	24.25	24.25	24.25	24.25	3600.0
2014-07-31 06:06:00	AAPL	Stock	24.2675	24.2675	24.2675	24.2675	400.0
2014-07-31 06:08:00	AAPL	Stock	24.2525	24.2525	24.2525	24.2525	400.0
2014-07-31 06:11:00	AAPL	Stock	24.22	24.22	24.2175	24.2175	3200.0

> showing 50 of 1,130,163 rows — these rows as CSV

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