PREVIEW / stock_1min / 2014-11-06

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-11-06.parquet
  size:    14.8 MB
  rows:    1,077,258
  symbols: 2,889

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-11-06 04:11:00	AAPL	Stock	27.125	27.125	27.125	27.125	400.0
2014-11-06 04:13:00	AAPL	Stock	27.125	27.125	27.125	27.125	400.0
2014-11-06 04:16:00	AAPL	Stock	27.1125	27.1125	27.0825	27.0825	2760.0
2014-11-06 04:21:00	AAPL	Stock	27.0975	27.0975	27.0875	27.0975	7200.0
2014-11-06 04:32:00	AAPL	Stock	27.09	27.09	27.09	27.09	1200.0
2014-11-06 04:33:00	AAPL	Stock	27.09	27.09	27.09	27.09	2300.0
2014-11-06 04:34:00	AAPL	Stock	27.09	27.09	27.09	27.09	6000.0
2014-11-06 04:35:00	AAPL	Stock	27.09	27.09	27.09	27.09	14400.0
2014-11-06 04:42:00	AAPL	Stock	27.1	27.1	27.1	27.1	3632.0
2014-11-06 04:46:00	AAPL	Stock	27.1	27.1	27.1	27.1	6000.0
2014-11-06 04:56:00	AAPL	Stock	27.0975	27.0975	27.0975	27.0975	1000.0
2014-11-06 05:02:00	AAPL	Stock	27.105	27.105	27.105	27.105	800.0
2014-11-06 05:33:00	AAPL	Stock	27.11	27.1125	27.11	27.1125	2200.0
2014-11-06 05:45:00	AAPL	Stock	27.125	27.125	27.125	27.125	2160.0
2014-11-06 05:47:00	AAPL	Stock	27.125	27.125	27.125	27.125	1600.0
2014-11-06 06:15:00	AAPL	Stock	27.16	27.16	27.16	27.16	3600.0
2014-11-06 06:16:00	AAPL	Stock	27.1625	27.1625	27.1625	27.1625	4000.0
2014-11-06 06:19:00	AAPL	Stock	27.125	27.125	27.125	27.125	800.0
2014-11-06 06:41:00	AAPL	Stock	27.145	27.145	27.145	27.145	4000.0
2014-11-06 06:44:00	AAPL	Stock	27.125	27.125	27.125	27.125	2000.0
2014-11-06 06:46:00	AAPL	Stock	27.125	27.125	27.125	27.125	1736.0
2014-11-06 06:58:00	AAPL	Stock	27.1275	27.135	27.1275	27.135	800.0
2014-11-06 07:00:00	AAPL	Stock	27.145	27.1625	27.145	27.1625	12360.0
2014-11-06 07:01:00	AAPL	Stock	27.1575	27.1625	27.1575	27.1625	7776.0
2014-11-06 07:02:00	AAPL	Stock	27.1625	27.1625	27.1625	27.1625	800.0
2014-11-06 07:03:00	AAPL	Stock	27.1625	27.1625	27.1625	27.1625	3760.0
2014-11-06 07:05:00	AAPL	Stock	27.1575	27.1575	27.1525	27.1525	6264.0
2014-11-06 07:08:00	AAPL	Stock	27.1475	27.1525	27.1475	27.1525	4800.0
2014-11-06 07:09:00	AAPL	Stock	27.1525	27.1525	27.15	27.15	7200.0
2014-11-06 07:13:00	AAPL	Stock	27.1475	27.1525	27.1475	27.1525	12000.0
2014-11-06 07:17:00	AAPL	Stock	27.1425	27.1425	27.125	27.125	10400.0
2014-11-06 07:18:00	AAPL	Stock	27.125	27.125	27.125	27.125	1600.0
2014-11-06 07:21:00	AAPL	Stock	27.125	27.125	27.125	27.125	400.0
2014-11-06 07:22:00	AAPL	Stock	27.125	27.14	27.125	27.14	3600.0
2014-11-06 07:23:00	AAPL	Stock	27.145	27.145	27.145	27.145	4000.0
2014-11-06 07:24:00	AAPL	Stock	27.145	27.1475	27.145	27.1475	5200.0
2014-11-06 07:29:00	AAPL	Stock	27.1475	27.1475	27.1475	27.1475	400.0
2014-11-06 07:31:00	AAPL	Stock	27.135	27.135	27.125	27.125	6752.0
2014-11-06 07:32:00	AAPL	Stock	27.125	27.125	27.12	27.12	15644.0
2014-11-06 07:33:00	AAPL	Stock	27.12	27.1325	27.12	27.1325	11244.0
2014-11-06 07:36:00	AAPL	Stock	27.1325	27.1325	27.1325	27.1325	2000.0
2014-11-06 07:39:00	AAPL	Stock	27.125	27.125	27.125	27.125	400.0
2014-11-06 07:40:00	AAPL	Stock	27.125	27.125	27.1175	27.1225	5200.0
2014-11-06 07:41:00	AAPL	Stock	27.1225	27.1225	27.1225	27.1225	2000.0
2014-11-06 07:42:00	AAPL	Stock	27.12	27.1225	27.1175	27.1175	6680.0
2014-11-06 07:43:00	AAPL	Stock	27.1175	27.1175	27.1125	27.1125	6000.0
2014-11-06 07:45:00	AAPL	Stock	27.1125	27.1125	27.1125	27.1125	800.0
2014-11-06 07:46:00	AAPL	Stock	27.1125	27.1125	27.1075	27.1075	2400.0
2014-11-06 07:47:00	AAPL	Stock	27.1125	27.1125	27.1125	27.1125	5200.0
2014-11-06 07:48:00	AAPL	Stock	27.1125	27.1125	27.1125	27.1125	1200.0

> showing 50 of 1,077,258 rows — these rows as CSV

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