PREVIEW / stock_1min / 2011-08-31

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-08-31.parquet
  size:    13.8 MB
  rows:    1,035,278
  symbols: 2,867

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-08-31 04:00:00	AAPL	Stock	13.9461	13.975	13.9461	13.975	11200.0
2011-08-31 04:16:00	AAPL	Stock	13.9618	13.9618	13.9618	13.9618	2800.0
2011-08-31 04:22:00	AAPL	Stock	13.9804	13.9804	13.9804	13.9804	2800.0
2011-08-31 05:05:00	AAPL	Stock	14.0079	14.0079	14.0079	14.0079	2800.0
2011-08-31 05:47:00	AAPL	Stock	14.0036	14.0039	14.0036	14.0039	8400.0
2011-08-31 06:17:00	AAPL	Stock	14.0039	14.0039	14.0039	14.0039	2800.0
2011-08-31 06:19:00	AAPL	Stock	14.0139	14.0139	14.0139	14.0139	2800.0
2011-08-31 06:55:00	AAPL	Stock	14.0079	14.0079	14.0079	14.0079	2800.0
2011-08-31 06:57:00	AAPL	Stock	14.0039	14.0039	14.0039	14.0039	8400.0
2011-08-31 06:59:00	AAPL	Stock	14.0039	14.0039	14.0039	14.0039	6580.0
2011-08-31 07:00:00	AAPL	Stock	14.0	14.0	14.0	14.0	16800.0
2011-08-31 07:01:00	AAPL	Stock	13.9961	13.9961	13.9961	13.9961	14000.0
2011-08-31 07:02:00	AAPL	Stock	13.9925	13.9929	13.9857	13.9929	32200.0
2011-08-31 07:03:00	AAPL	Stock	13.9857	13.9857	13.9857	13.9857	30800.0
2011-08-31 07:06:00	AAPL	Stock	13.985	13.985	13.985	13.985	11200.0
2011-08-31 07:07:00	AAPL	Stock	13.9843	13.9843	13.9843	13.9843	5600.0
2011-08-31 07:08:00	AAPL	Stock	13.9843	13.9843	13.9643	13.9714	13720.0
2011-08-31 07:13:00	AAPL	Stock	13.9654	13.9654	13.9654	13.9654	11200.0
2011-08-31 07:15:00	AAPL	Stock	13.9689	13.9846	13.9689	13.9846	8400.0
2011-08-31 07:17:00	AAPL	Stock	13.9786	13.9821	13.9786	13.9821	11200.0
2011-08-31 07:18:00	AAPL	Stock	13.9736	13.9736	13.9736	13.9736	2800.0
2011-08-31 07:19:00	AAPL	Stock	13.9857	13.9857	13.9857	13.9857	2800.0
2011-08-31 07:20:00	AAPL	Stock	13.9821	13.9821	13.9821	13.9821	2800.0
2011-08-31 07:23:00	AAPL	Stock	13.9818	13.9818	13.9818	13.9818	2800.0
2011-08-31 07:24:00	AAPL	Stock	13.975	13.975	13.975	13.975	14700.0
2011-08-31 07:25:00	AAPL	Stock	13.9661	13.9661	13.9661	13.9661	2800.0
2011-08-31 07:26:00	AAPL	Stock	13.9657	13.9657	13.9643	13.9643	8400.0
2011-08-31 07:28:00	AAPL	Stock	13.9643	13.9643	13.9561	13.9561	19600.0
2011-08-31 07:29:00	AAPL	Stock	13.9607	13.9632	13.9482	13.9496	42000.0
2011-08-31 07:30:00	AAPL	Stock	13.9561	13.9561	13.9557	13.9557	8400.0
2011-08-31 07:31:00	AAPL	Stock	13.9589	13.9714	13.9589	13.9714	107940.0
2011-08-31 07:33:00	AAPL	Stock	13.9718	13.9786	13.9714	13.9786	16800.0
2011-08-31 07:34:00	AAPL	Stock	13.9714	13.9714	13.965	13.965	19600.0
2011-08-31 07:35:00	AAPL	Stock	13.9629	13.9629	13.9629	13.9629	2800.0
2011-08-31 07:37:00	AAPL	Stock	13.9643	13.9711	13.9643	13.9711	11200.0
2011-08-31 07:39:00	AAPL	Stock	13.9707	13.9707	13.9707	13.9707	2800.0
2011-08-31 07:40:00	AAPL	Stock	13.9725	13.9811	13.9725	13.9811	70000.0
2011-08-31 07:41:00	AAPL	Stock	13.9807	13.9807	13.9807	13.9807	27972.0
2011-08-31 07:44:00	AAPL	Stock	13.9725	13.9725	13.9721	13.9721	22400.0
2011-08-31 07:45:00	AAPL	Stock	13.9754	13.9782	13.9754	13.9782	14980.0
2011-08-31 07:49:00	AAPL	Stock	13.9714	13.9714	13.9714	13.9714	11200.0
2011-08-31 07:50:00	AAPL	Stock	13.9696	13.9696	13.9696	13.9696	5600.0
2011-08-31 07:52:00	AAPL	Stock	13.9679	13.9689	13.9679	13.9682	33600.0
2011-08-31 07:53:00	AAPL	Stock	13.9686	13.9686	13.9686	13.9686	2800.0
2011-08-31 07:57:00	AAPL	Stock	13.97	13.97	13.9693	13.9693	8400.0
2011-08-31 07:58:00	AAPL	Stock	13.9693	13.9693	13.9579	13.9579	8400.0
2011-08-31 08:00:00	AAPL	Stock	13.9586	13.9843	13.9554	13.9557	64512.0
2011-08-31 08:01:00	AAPL	Stock	13.9571	13.9604	13.9571	13.9604	25200.0
2011-08-31 08:02:00	AAPL	Stock	13.9554	13.9607	13.9536	13.9568	94220.0
2011-08-31 08:03:00	AAPL	Stock	13.9568	13.9643	13.9568	13.9643	104776.0

> showing 50 of 1,035,278 rows — these rows as CSV

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