PREVIEW / stock_1min / 2014-08-18

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-08-18.parquet
  size:    14.0 MB
  rows:    1,024,358
  symbols: 2,930

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-08-18 04:00:00	AAPL	Stock	24.495	24.625	24.495	24.625	2400.0
2014-08-18 04:08:00	AAPL	Stock	24.645	24.645	24.645	24.645	2000.0
2014-08-18 04:13:00	AAPL	Stock	24.62	24.645	24.62	24.645	2000.0
2014-08-18 04:28:00	AAPL	Stock	24.645	24.645	24.645	24.645	1600.0
2014-08-18 04:31:00	AAPL	Stock	24.645	24.645	24.645	24.645	400.0
2014-08-18 04:48:00	AAPL	Stock	24.65	24.65	24.65	24.65	400.0
2014-08-18 04:50:00	AAPL	Stock	24.6375	24.6375	24.6375	24.6375	800.0
2014-08-18 04:53:00	AAPL	Stock	24.6375	24.6375	24.6375	24.6375	3820.0
2014-08-18 05:09:00	AAPL	Stock	24.63	24.63	24.63	24.63	400.0
2014-08-18 05:13:00	AAPL	Stock	24.645	24.645	24.645	24.645	400.0
2014-08-18 05:33:00	AAPL	Stock	24.6375	24.6375	24.6375	24.6375	2400.0
2014-08-18 05:34:00	AAPL	Stock	24.63	24.63	24.63	24.63	1200.0
2014-08-18 05:42:00	AAPL	Stock	24.635	24.635	24.635	24.635	400.0
2014-08-18 05:44:00	AAPL	Stock	24.635	24.635	24.635	24.635	400.0
2014-08-18 05:57:00	AAPL	Stock	24.625	24.625	24.625	24.625	1600.0
2014-08-18 05:58:00	AAPL	Stock	24.625	24.625	24.625	24.625	800.0
2014-08-18 06:00:00	AAPL	Stock	24.63	24.63	24.63	24.63	1896.0
2014-08-18 06:15:00	AAPL	Stock	24.6325	24.635	24.6325	24.635	8332.0
2014-08-18 06:16:00	AAPL	Stock	24.64	24.64	24.635	24.64	5844.0
2014-08-18 06:17:00	AAPL	Stock	24.635	24.64	24.635	24.64	5600.0
2014-08-18 06:19:00	AAPL	Stock	24.635	24.64	24.635	24.64	1480.0
2014-08-18 06:33:00	AAPL	Stock	24.6325	24.6325	24.6325	24.6325	400.0
2014-08-18 06:35:00	AAPL	Stock	24.6475	24.6475	24.64	24.64	2000.0
2014-08-18 06:41:00	AAPL	Stock	24.635	24.635	24.635	24.635	4820.0
2014-08-18 06:44:00	AAPL	Stock	24.635	24.635	24.635	24.635	680.0
2014-08-18 06:50:00	AAPL	Stock	24.6325	24.6325	24.6325	24.6325	1216.0
2014-08-18 06:55:00	AAPL	Stock	24.6325	24.6325	24.6325	24.6325	2296.0
2014-08-18 06:56:00	AAPL	Stock	24.6275	24.6275	24.625	24.625	10996.0
2014-08-18 06:58:00	AAPL	Stock	24.625	24.625	24.625	24.625	2400.0
2014-08-18 07:01:00	AAPL	Stock	24.6325	24.6325	24.6325	24.6325	4000.0
2014-08-18 07:02:00	AAPL	Stock	24.6325	24.6325	24.6325	24.6325	8400.0
2014-08-18 07:03:00	AAPL	Stock	24.63	24.63	24.63	24.63	3600.0
2014-08-18 07:06:00	AAPL	Stock	24.6325	24.6375	24.6325	24.6375	8156.0
2014-08-18 07:07:00	AAPL	Stock	24.635	24.635	24.635	24.635	1632.0
2014-08-18 07:10:00	AAPL	Stock	24.635	24.635	24.635	24.635	768.0
2014-08-18 07:11:00	AAPL	Stock	24.6375	24.6475	24.6375	24.6475	2604.0
2014-08-18 07:14:00	AAPL	Stock	24.645	24.645	24.645	24.645	7720.0
2014-08-18 07:16:00	AAPL	Stock	24.635	24.635	24.635	24.635	400.0
2014-08-18 07:20:00	AAPL	Stock	24.645	24.645	24.645	24.645	440.0
2014-08-18 07:21:00	AAPL	Stock	24.645	24.645	24.6375	24.645	2000.0
2014-08-18 07:22:00	AAPL	Stock	24.6425	24.6425	24.6425	24.6425	400.0
2014-08-18 07:24:00	AAPL	Stock	24.6475	24.6475	24.6475	24.6475	2640.0
2014-08-18 07:25:00	AAPL	Stock	24.6475	24.65	24.6475	24.65	5600.0
2014-08-18 07:26:00	AAPL	Stock	24.6475	24.6475	24.6475	24.6475	2000.0
2014-08-18 07:27:00	AAPL	Stock	24.6525	24.6525	24.65	24.6525	5200.0
2014-08-18 07:28:00	AAPL	Stock	24.6525	24.6525	24.6525	24.6525	7800.0
2014-08-18 07:30:00	AAPL	Stock	24.6525	24.6525	24.6525	24.6525	400.0
2014-08-18 07:31:00	AAPL	Stock	24.6525	24.6525	24.6525	24.6525	2800.0
2014-08-18 07:32:00	AAPL	Stock	24.6525	24.66	24.6525	24.66	10000.0
2014-08-18 07:33:00	AAPL	Stock	24.66	24.66	24.66	24.66	3792.0

> showing 50 of 1,024,358 rows — these rows as CSV

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