PREVIEW / stock_1min / 2011-05-27

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-05-27.parquet
  size:    12.6 MB
  rows:    951,111
  symbols: 2,861

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
2011-05-27 05:08:00	AAPL	Stock	11.9732	11.9732	11.9732	11.9732	2800.0
2011-05-27 07:20:00	AAPL	Stock	11.9889	11.9889	11.9889	11.9889	2800.0
2011-05-27 07:39:00	AAPL	Stock	11.9804	11.9804	11.9804	11.9804	2800.0
2011-05-27 07:40:00	AAPL	Stock	11.9804	11.9804	11.9804	11.9804	2800.0
2011-05-27 08:00:00	AAPL	Stock	11.9714	11.9721	11.9714	11.9721	9128.0
2011-05-27 08:01:00	AAPL	Stock	11.9875	11.9875	11.9875	11.9875	3332.0
2011-05-27 08:04:00	AAPL	Stock	11.9821	11.9839	11.9821	11.9839	10360.0
2011-05-27 08:08:00	AAPL	Stock	11.9886	11.9886	11.9886	11.9886	2800.0
2011-05-27 08:09:00	AAPL	Stock	11.9864	11.9864	11.9864	11.9864	2800.0
2011-05-27 08:10:00	AAPL	Stock	11.9857	11.9857	11.9857	11.9857	2800.0
2011-05-27 08:19:00	AAPL	Stock	11.9857	11.9857	11.9857	11.9857	2800.0
2011-05-27 08:21:00	AAPL	Stock	11.9861	11.9861	11.9861	11.9861	2800.0
2011-05-27 08:23:00	AAPL	Stock	11.9929	11.9929	11.9929	11.9929	78400.0
2011-05-27 08:26:00	AAPL	Stock	11.9936	11.9943	11.9936	11.9943	14000.0
2011-05-27 08:28:00	AAPL	Stock	11.9943	11.995	11.9943	11.995	16044.0
2011-05-27 08:29:00	AAPL	Stock	11.9861	11.9861	11.9861	11.9861	2800.0
2011-05-27 08:32:00	AAPL	Stock	11.9946	11.9957	11.9946	11.9957	36400.0
2011-05-27 08:33:00	AAPL	Stock	11.9968	12.0	11.9968	12.0	140896.0
2011-05-27 08:36:00	AAPL	Stock	11.9993	11.9996	11.9986	11.9986	16800.0
2011-05-27 08:40:00	AAPL	Stock	11.9986	11.9986	11.9986	11.9986	2800.0
2011-05-27 08:41:00	AAPL	Stock	11.9964	11.9964	11.9964	11.9964	5600.0
2011-05-27 08:42:00	AAPL	Stock	11.9964	11.9964	11.9964	11.9964	2800.0
2011-05-27 08:43:00	AAPL	Stock	11.9929	11.9929	11.9929	11.9929	7980.0
2011-05-27 08:44:00	AAPL	Stock	11.9911	11.9911	11.9911	11.9911	16800.0
2011-05-27 08:45:00	AAPL	Stock	11.9911	11.9911	11.9911	11.9911	11200.0
2011-05-27 08:49:00	AAPL	Stock	11.9925	11.9925	11.9925	11.9925	2800.0
2011-05-27 08:51:00	AAPL	Stock	11.9943	11.9943	11.9943	11.9943	2800.0
2011-05-27 08:52:00	AAPL	Stock	11.9964	11.9964	11.9964	11.9964	4816.0
2011-05-27 08:55:00	AAPL	Stock	11.9889	11.9889	11.9886	11.9886	39200.0
2011-05-27 08:56:00	AAPL	Stock	11.9861	11.9861	11.9857	11.9857	16800.0
2011-05-27 08:57:00	AAPL	Stock	11.9857	11.9857	11.9857	11.9857	2800.0
2011-05-27 09:02:00	AAPL	Stock	11.9893	11.9893	11.9821	11.9821	16800.0
2011-05-27 09:04:00	AAPL	Stock	11.9821	11.9857	11.9821	11.9857	36484.0
2011-05-27 09:05:00	AAPL	Stock	11.9918	11.9918	11.9918	11.9918	25200.0
2011-05-27 09:08:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	28000.0
2011-05-27 09:11:00	AAPL	Stock	11.9875	11.9875	11.9875	11.9875	2800.0
2011-05-27 09:12:00	AAPL	Stock	11.9886	11.9886	11.9886	11.9886	14000.0
2011-05-27 09:13:00	AAPL	Stock	11.9818	11.9818	11.9818	11.9818	8400.0
2011-05-27 09:14:00	AAPL	Stock	11.9839	11.9839	11.9839	11.9839	11200.0
2011-05-27 09:18:00	AAPL	Stock	11.9793	11.9793	11.9793	11.9793	2800.0
2011-05-27 09:19:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	2800.0
2011-05-27 09:20:00	AAPL	Stock	11.9821	11.9839	11.9821	11.9839	27748.0
2011-05-27 09:22:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	5600.0
2011-05-27 09:24:00	AAPL	Stock	11.9839	11.9839	11.9839	11.9839	8400.0
2011-05-27 09:25:00	AAPL	Stock	11.9825	11.9825	11.9825	11.9825	5600.0
2011-05-27 09:27:00	AAPL	Stock	11.9829	11.9846	11.9829	11.9846	8400.0
2011-05-27 09:28:00	AAPL	Stock	11.9786	11.9786	11.9679	11.9779	212800.0
2011-05-27 09:29:00	AAPL	Stock	11.9686	11.9686	11.96	11.96	154140.0
2011-05-27 09:30:00	AAPL	Stock	11.9571	11.9818	11.9571	11.9661	4888296.0
2011-05-27 09:31:00	AAPL	Stock	11.9668	11.9704	11.9571	11.9686	1496348.0

> showing 50 of 951,111 rows — these rows as CSV

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