PREVIEW / stock_1min / 2014-07-25

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-07-25.parquet
  size:    13.5 MB
  rows:    1,007,551
  symbols: 2,907

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-25 04:29:00	AAPL	Stock	24.225	24.225	24.225	24.225	800.0
2014-07-25 05:08:00	AAPL	Stock	24.2175	24.225	24.2175	24.225	4400.0
2014-07-25 05:21:00	AAPL	Stock	24.2	24.2	24.2	24.2	800.0
2014-07-25 05:22:00	AAPL	Stock	24.195	24.195	24.195	24.195	800.0
2014-07-25 05:29:00	AAPL	Stock	24.205	24.205	24.205	24.205	2000.0
2014-07-25 05:43:00	AAPL	Stock	24.2125	24.2125	24.2125	24.2125	2400.0
2014-07-25 05:49:00	AAPL	Stock	24.2125	24.2125	24.2125	24.2125	7600.0
2014-07-25 06:00:00	AAPL	Stock	24.2125	24.2125	24.2125	24.2125	6000.0
2014-07-25 06:07:00	AAPL	Stock	24.21	24.21	24.21	24.21	880.0
2014-07-25 06:09:00	AAPL	Stock	24.2275	24.2275	24.2275	24.2275	1176.0
2014-07-25 06:12:00	AAPL	Stock	24.225	24.225	24.225	24.225	708.0
2014-07-25 06:13:00	AAPL	Stock	24.225	24.225	24.225	24.225	800.0
2014-07-25 06:22:00	AAPL	Stock	24.2125	24.2125	24.2125	24.2125	2760.0
2014-07-25 06:46:00	AAPL	Stock	24.2125	24.2125	24.2125	24.2125	680.0
2014-07-25 06:47:00	AAPL	Stock	24.2	24.2	24.195	24.195	932.0
2014-07-25 07:05:00	AAPL	Stock	24.205	24.205	24.205	24.205	1600.0
2014-07-25 07:06:00	AAPL	Stock	24.195	24.205	24.195	24.205	1600.0
2014-07-25 07:14:00	AAPL	Stock	24.1925	24.1925	24.19	24.19	1600.0
2014-07-25 07:15:00	AAPL	Stock	24.19	24.19	24.1875	24.1875	4020.0
2014-07-25 07:16:00	AAPL	Stock	24.1875	24.19	24.1875	24.19	2800.0
2014-07-25 07:17:00	AAPL	Stock	24.1875	24.19	24.1875	24.19	4400.0
2014-07-25 07:19:00	AAPL	Stock	24.1875	24.19	24.1875	24.19	2000.0
2014-07-25 07:20:00	AAPL	Stock	24.19	24.19	24.19	24.19	800.0
2014-07-25 07:27:00	AAPL	Stock	24.1975	24.2	24.1975	24.2	4800.0
2014-07-25 07:31:00	AAPL	Stock	24.2	24.2	24.2	24.2	400.0
2014-07-25 07:32:00	AAPL	Stock	24.2	24.2	24.2	24.2	1600.0
2014-07-25 07:38:00	AAPL	Stock	24.195	24.2	24.195	24.2	1200.0
2014-07-25 07:40:00	AAPL	Stock	24.2	24.2	24.2	24.2	400.0
2014-07-25 07:42:00	AAPL	Stock	24.195	24.195	24.195	24.195	400.0
2014-07-25 07:44:00	AAPL	Stock	24.195	24.195	24.195	24.195	400.0
2014-07-25 07:46:00	AAPL	Stock	24.2	24.2	24.2	24.2	2000.0
2014-07-25 07:48:00	AAPL	Stock	24.2	24.2	24.2	24.2	8320.0
2014-07-25 07:49:00	AAPL	Stock	24.1975	24.1975	24.1975	24.1975	2312.0
2014-07-25 07:51:00	AAPL	Stock	24.1975	24.1975	24.1975	24.1975	400.0
2014-07-25 07:52:00	AAPL	Stock	24.1975	24.1975	24.1975	24.1975	1540.0
2014-07-25 07:57:00	AAPL	Stock	24.2	24.2	24.2	24.2	12476.0
2014-07-25 07:59:00	AAPL	Stock	24.2	24.2	24.2	24.2	2000.0
2014-07-25 08:00:00	AAPL	Stock	24.195	24.2575	24.18	24.2	44164.0
2014-07-25 08:01:00	AAPL	Stock	24.2	24.2025	24.2	24.2025	6448.0
2014-07-25 08:02:00	AAPL	Stock	24.205	24.2175	24.205	24.2125	3600.0
2014-07-25 08:03:00	AAPL	Stock	24.2075	24.2075	24.2075	24.2075	14000.0
2014-07-25 08:04:00	AAPL	Stock	24.2075	24.2075	24.2075	24.2075	2000.0
2014-07-25 08:05:00	AAPL	Stock	24.2075	24.2125	24.2075	24.2125	800.0
2014-07-25 08:06:00	AAPL	Stock	24.22	24.2275	24.22	24.225	26960.0
2014-07-25 08:07:00	AAPL	Stock	24.23	24.2325	24.23	24.23	20012.0
2014-07-25 08:08:00	AAPL	Stock	24.2375	24.245	24.2375	24.2375	11128.0
2014-07-25 08:09:00	AAPL	Stock	24.24	24.24	24.2375	24.2375	2800.0
2014-07-25 08:10:00	AAPL	Stock	24.24	24.24	24.24	24.24	800.0
2014-07-25 08:11:00	AAPL	Stock	24.2375	24.2375	24.235	24.235	6700.0
2014-07-25 08:12:00	AAPL	Stock	24.235	24.235	24.235	24.235	2200.0

> showing 50 of 1,007,551 rows — these rows as CSV

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