PREVIEW / stock_1min / 2014-04-07

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-04-07.parquet
  size:    15.7 MB
  rows:    1,129,686
  symbols: 2,878

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-04-07 04:00:00	AAPL	Stock	18.8532	18.8532	18.8532	18.8532	2800.0
2014-04-07 04:17:00	AAPL	Stock	18.8793	18.8793	18.8793	18.8793	3080.0
2014-04-07 04:22:00	AAPL	Stock	18.8686	18.8686	18.8668	18.8686	26656.0
2014-04-07 04:23:00	AAPL	Stock	18.8686	18.8686	18.8686	18.8686	4144.0
2014-04-07 04:27:00	AAPL	Stock	18.8886	18.8886	18.8886	18.8886	2800.0
2014-04-07 04:48:00	AAPL	Stock	18.9054	18.9054	18.9054	18.9054	5600.0
2014-04-07 06:20:00	AAPL	Stock	18.9004	18.9004	18.9004	18.9004	2800.0
2014-04-07 06:24:00	AAPL	Stock	18.8814	18.8814	18.8571	18.8571	6328.0
2014-04-07 07:02:00	AAPL	Stock	18.8671	18.8671	18.8671	18.8671	4200.0
2014-04-07 07:11:00	AAPL	Stock	18.8714	18.8714	18.8657	18.8661	16800.0
2014-04-07 07:12:00	AAPL	Stock	18.8657	18.8657	18.8629	18.8629	8400.0
2014-04-07 07:14:00	AAPL	Stock	18.8636	18.8636	18.8571	18.8571	28000.0
2014-04-07 07:15:00	AAPL	Stock	18.8621	18.8629	18.8621	18.8629	8400.0
2014-04-07 07:18:00	AAPL	Stock	18.8571	18.8571	18.8571	18.8571	2800.0
2014-04-07 07:25:00	AAPL	Stock	18.8571	18.8571	18.8571	18.8571	11760.0
2014-04-07 07:26:00	AAPL	Stock	18.8571	18.8571	18.8571	18.8571	5600.0
2014-04-07 07:32:00	AAPL	Stock	18.8571	18.8571	18.8571	18.8571	19600.0
2014-04-07 07:33:00	AAPL	Stock	18.8571	18.8571	18.8571	18.8571	5600.0
2014-04-07 07:36:00	AAPL	Stock	18.8693	18.8693	18.8693	18.8693	5600.0
2014-04-07 07:38:00	AAPL	Stock	18.8693	18.8714	18.8661	18.8661	8400.0
2014-04-07 07:46:00	AAPL	Stock	18.875	18.8754	18.8746	18.8754	14000.0
2014-04-07 07:47:00	AAPL	Stock	18.8746	18.8829	18.8746	18.8829	5600.0
2014-04-07 07:49:00	AAPL	Stock	18.8671	18.8671	18.8661	18.8664	9100.0
2014-04-07 07:50:00	AAPL	Stock	18.8611	18.8618	18.8571	18.8571	25340.0
2014-04-07 07:51:00	AAPL	Stock	18.8568	18.8568	18.8568	18.8568	5600.0
2014-04-07 07:52:00	AAPL	Stock	18.8571	18.8571	18.8571	18.8571	5600.0
2014-04-07 07:58:00	AAPL	Stock	18.8679	18.8679	18.8679	18.8679	2800.0
2014-04-07 08:00:00	AAPL	Stock	18.8607	18.8914	18.8461	18.8839	96628.0
2014-04-07 08:01:00	AAPL	Stock	18.8679	18.8839	18.8671	18.8839	12600.0
2014-04-07 08:05:00	AAPL	Stock	18.8814	18.8839	18.8814	18.8839	7420.0
2014-04-07 08:06:00	AAPL	Stock	18.8839	18.8839	18.8839	18.8839	3976.0
2014-04-07 08:07:00	AAPL	Stock	18.8775	18.8929	18.8768	18.8839	14000.0
2014-04-07 08:11:00	AAPL	Stock	18.8786	18.8786	18.8786	18.8786	2800.0
2014-04-07 08:12:00	AAPL	Stock	18.8768	18.8768	18.8768	18.8768	3920.0
2014-04-07 08:13:00	AAPL	Stock	18.8679	18.8679	18.8679	18.8679	8400.0
2014-04-07 08:16:00	AAPL	Stock	18.875	18.875	18.8725	18.8725	5600.0
2014-04-07 08:17:00	AAPL	Stock	18.8714	18.8714	18.8714	18.8714	2800.0
2014-04-07 08:18:00	AAPL	Stock	18.8721	18.875	18.8721	18.875	25200.0
2014-04-07 08:22:00	AAPL	Stock	18.8732	18.8786	18.8732	18.8768	19376.0
2014-04-07 08:23:00	AAPL	Stock	18.8768	18.8768	18.8768	18.8768	2800.0
2014-04-07 08:24:00	AAPL	Stock	18.8886	18.8893	18.8857	18.8893	33600.0
2014-04-07 08:25:00	AAPL	Stock	18.8764	18.8764	18.8764	18.8764	2800.0
2014-04-07 08:26:00	AAPL	Stock	18.8854	18.8925	18.8854	18.8925	10668.0
2014-04-07 08:27:00	AAPL	Stock	18.8914	18.8929	18.8914	18.8929	9912.0
2014-04-07 08:29:00	AAPL	Stock	18.8854	18.8854	18.8854	18.8854	2800.0
2014-04-07 08:30:00	AAPL	Stock	18.8925	18.8925	18.8925	18.8925	9800.0
2014-04-07 08:31:00	AAPL	Stock	18.8929	18.8929	18.8929	18.8929	9660.0
2014-04-07 08:32:00	AAPL	Stock	18.8925	18.8925	18.8886	18.8886	8400.0
2014-04-07 08:33:00	AAPL	Stock	18.8929	18.8929	18.8929	18.8929	30520.0
2014-04-07 08:34:00	AAPL	Stock	18.8925	18.8925	18.8925	18.8925	2800.0

> showing 50 of 1,129,686 rows — these rows as CSV

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