PREVIEW / stock_1min / 2014-11-07

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-11-07.parquet
  size:    14.5 MB
  rows:    1,064,137
  symbols: 2,896

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-07 04:00:00	AAPL	Stock	27.1925	27.2	27.1925	27.2	6400.0
2014-11-07 04:03:00	AAPL	Stock	27.175	27.1875	27.175	27.1875	800.0
2014-11-07 04:40:00	AAPL	Stock	27.2	27.2	27.2	27.2	400.0
2014-11-07 04:43:00	AAPL	Stock	27.2	27.2	27.2	27.2	4000.0
2014-11-07 04:46:00	AAPL	Stock	27.2	27.2	27.2	27.2	4000.0
2014-11-07 04:47:00	AAPL	Stock	27.2	27.2	27.2	27.2	1512.0
2014-11-07 04:54:00	AAPL	Stock	27.205	27.205	27.205	27.205	1600.0
2014-11-07 05:06:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	400.0
2014-11-07 05:07:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	1200.0
2014-11-07 05:16:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	3480.0
2014-11-07 05:17:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	400.0
2014-11-07 05:33:00	AAPL	Stock	27.2125	27.2275	27.2125	27.2275	2072.0
2014-11-07 05:34:00	AAPL	Stock	27.22	27.22	27.22	27.22	4000.0
2014-11-07 05:35:00	AAPL	Stock	27.225	27.225	27.225	27.225	2000.0
2014-11-07 05:45:00	AAPL	Stock	27.24	27.245	27.24	27.245	800.0
2014-11-07 05:47:00	AAPL	Stock	27.245	27.245	27.245	27.245	1120.0
2014-11-07 05:50:00	AAPL	Stock	27.2475	27.2475	27.2475	27.2475	1600.0
2014-11-07 05:54:00	AAPL	Stock	27.2475	27.2475	27.2375	27.2375	2640.0
2014-11-07 05:55:00	AAPL	Stock	27.245	27.245	27.2425	27.2425	1280.0
2014-11-07 06:01:00	AAPL	Stock	27.2425	27.2425	27.2425	27.2425	800.0
2014-11-07 06:07:00	AAPL	Stock	27.2425	27.2425	27.2425	27.2425	400.0
2014-11-07 06:20:00	AAPL	Stock	27.2475	27.2475	27.2475	27.2475	400.0
2014-11-07 06:21:00	AAPL	Stock	27.2375	27.2375	27.2375	27.2375	800.0
2014-11-07 06:22:00	AAPL	Stock	27.2475	27.2475	27.2475	27.2475	400.0
2014-11-07 06:26:00	AAPL	Stock	27.24	27.24	27.24	27.24	400.0
2014-11-07 06:31:00	AAPL	Stock	27.2375	27.2375	27.2375	27.2375	4084.0
2014-11-07 06:40:00	AAPL	Stock	27.2375	27.2375	27.2375	27.2375	800.0
2014-11-07 06:45:00	AAPL	Stock	27.24	27.24	27.24	27.24	400.0
2014-11-07 06:47:00	AAPL	Stock	27.24	27.24	27.24	27.24	2400.0
2014-11-07 06:48:00	AAPL	Stock	27.225	27.225	27.225	27.225	2000.0
2014-11-07 06:53:00	AAPL	Stock	27.225	27.225	27.225	27.225	400.0
2014-11-07 06:56:00	AAPL	Stock	27.225	27.2275	27.225	27.225	5952.0
2014-11-07 06:57:00	AAPL	Stock	27.225	27.225	27.225	27.225	5248.0
2014-11-07 07:00:00	AAPL	Stock	27.225	27.225	27.22	27.22	10852.0
2014-11-07 07:05:00	AAPL	Stock	27.215	27.215	27.215	27.215	400.0
2014-11-07 07:06:00	AAPL	Stock	27.22	27.22	27.22	27.22	976.0
2014-11-07 07:08:00	AAPL	Stock	27.2025	27.2025	27.2025	27.2025	400.0
2014-11-07 07:10:00	AAPL	Stock	27.2	27.2	27.2	27.2	4400.0
2014-11-07 07:11:00	AAPL	Stock	27.2	27.2	27.2	27.2	3200.0
2014-11-07 07:12:00	AAPL	Stock	27.2	27.2	27.2	27.2	1200.0
2014-11-07 07:14:00	AAPL	Stock	27.1975	27.2	27.1975	27.2	15156.0
2014-11-07 07:15:00	AAPL	Stock	27.2	27.2	27.1975	27.1975	5600.0
2014-11-07 07:16:00	AAPL	Stock	27.1975	27.1975	27.1975	27.1975	400.0
2014-11-07 07:18:00	AAPL	Stock	27.2	27.2	27.2	27.2	13644.0
2014-11-07 07:26:00	AAPL	Stock	27.1975	27.1975	27.1975	27.1975	400.0
2014-11-07 07:28:00	AAPL	Stock	27.1925	27.1925	27.1875	27.1875	5360.0
2014-11-07 07:30:00	AAPL	Stock	27.175	27.175	27.175	27.175	4000.0
2014-11-07 07:33:00	AAPL	Stock	27.1725	27.175	27.1725	27.175	3600.0
2014-11-07 07:35:00	AAPL	Stock	27.175	27.175	27.175	27.175	4196.0
2014-11-07 07:39:00	AAPL	Stock	27.1825	27.1825	27.1825	27.1825	400.0

> showing 50 of 1,064,137 rows — these rows as CSV

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