PREVIEW / stock_1min / 2011-08-23

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-08-23.parquet
  size:    14.0 MB
  rows:    1,046,543
  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-08-23 04:00:00	AAPL	Stock	12.8443	12.9589	12.8443	12.9589	31500.0
2011-08-23 04:01:00	AAPL	Stock	12.9614	12.9668	12.9614	12.9668	5600.0
2011-08-23 04:02:00	AAPL	Stock	12.9482	12.9696	12.9468	12.9696	19600.0
2011-08-23 04:03:00	AAPL	Stock	12.9768	12.9768	12.9768	12.9768	2800.0
2011-08-23 04:04:00	AAPL	Stock	12.9686	12.9686	12.9686	12.9686	2800.0
2011-08-23 04:05:00	AAPL	Stock	12.9732	12.9804	12.9732	12.9804	28000.0
2011-08-23 04:29:00	AAPL	Stock	12.9782	12.9782	12.9782	12.9782	2800.0
2011-08-23 04:30:00	AAPL	Stock	12.9679	12.9679	12.9679	12.9679	2800.0
2011-08-23 04:31:00	AAPL	Stock	12.9557	12.9557	12.9557	12.9557	2800.0
2011-08-23 04:35:00	AAPL	Stock	12.9443	12.9443	12.9443	12.9443	2800.0
2011-08-23 04:37:00	AAPL	Stock	12.9464	12.9464	12.9464	12.9464	2800.0
2011-08-23 04:39:00	AAPL	Stock	12.9361	12.9364	12.9361	12.9364	8400.0
2011-08-23 04:41:00	AAPL	Stock	12.935	12.935	12.935	12.935	2800.0
2011-08-23 04:45:00	AAPL	Stock	12.9439	12.9439	12.9	12.9	28000.0
2011-08-23 04:47:00	AAPL	Stock	12.9439	12.9454	12.9429	12.9429	16800.0
2011-08-23 04:51:00	AAPL	Stock	12.9464	12.9464	12.9464	12.9464	7000.0
2011-08-23 04:53:00	AAPL	Stock	12.9571	12.9571	12.9571	12.9571	2800.0
2011-08-23 04:55:00	AAPL	Stock	12.9286	12.9286	12.9286	12.9286	5600.0
2011-08-23 04:58:00	AAPL	Stock	12.9286	12.9286	12.9286	12.9286	2800.0
2011-08-23 05:00:00	AAPL	Stock	12.9179	12.9179	12.9179	12.9179	8400.0
2011-08-23 05:04:00	AAPL	Stock	12.9275	12.9275	12.9275	12.9275	5600.0
2011-08-23 05:05:00	AAPL	Stock	12.925	12.925	12.925	12.925	8400.0
2011-08-23 05:17:00	AAPL	Stock	12.9389	12.9389	12.9389	12.9389	2800.0
2011-08-23 05:24:00	AAPL	Stock	12.9425	12.9425	12.9425	12.9425	2800.0
2011-08-23 05:25:00	AAPL	Stock	12.9425	12.9429	12.9425	12.9429	5600.0
2011-08-23 05:27:00	AAPL	Stock	12.9464	12.9464	12.9464	12.9464	2800.0
2011-08-23 05:34:00	AAPL	Stock	12.9786	12.9804	12.9786	12.9804	5600.0
2011-08-23 05:38:00	AAPL	Stock	12.9768	12.9768	12.9768	12.9768	2800.0
2011-08-23 06:00:00	AAPL	Stock	12.9714	12.9714	12.9714	12.9714	2800.0
2011-08-23 06:04:00	AAPL	Stock	12.9714	12.9714	12.9289	12.9289	66080.0
2011-08-23 06:05:00	AAPL	Stock	12.9332	12.9332	12.9286	12.9286	70000.0
2011-08-23 06:06:00	AAPL	Stock	12.92	12.92	12.92	12.92	2800.0
2011-08-23 06:10:00	AAPL	Stock	12.9196	12.9196	12.9196	12.9196	5600.0
2011-08-23 06:28:00	AAPL	Stock	12.9486	12.9486	12.9486	12.9486	2800.0
2011-08-23 06:33:00	AAPL	Stock	12.9579	12.9579	12.9579	12.9579	2800.0
2011-08-23 06:34:00	AAPL	Stock	12.9607	12.9607	12.9607	12.9607	2800.0
2011-08-23 06:45:00	AAPL	Stock	12.95	12.95	12.95	12.95	19348.0
2011-08-23 06:52:00	AAPL	Stock	12.9289	12.9289	12.9286	12.9286	8400.0
2011-08-23 06:54:00	AAPL	Stock	12.9286	12.9286	12.9286	12.9286	2800.0
2011-08-23 07:00:00	AAPL	Stock	12.9111	12.9286	12.9111	12.9286	11200.0
2011-08-23 07:01:00	AAPL	Stock	12.9089	12.9089	12.8786	12.8929	63000.0
2011-08-23 07:02:00	AAPL	Stock	12.8904	12.8918	12.8839	12.8893	42000.0
2011-08-23 07:03:00	AAPL	Stock	12.8911	12.8911	12.8911	12.8911	2800.0
2011-08-23 07:04:00	AAPL	Stock	12.8886	12.8886	12.8886	12.8886	7000.0
2011-08-23 07:05:00	AAPL	Stock	12.8907	12.8911	12.8614	12.8614	16800.0
2011-08-23 07:06:00	AAPL	Stock	12.8893	12.9714	12.8893	12.8929	381920.0
2011-08-23 07:07:00	AAPL	Stock	12.9025	12.9025	12.9025	12.9025	5600.0
2011-08-23 07:08:00	AAPL	Stock	12.9036	12.9404	12.9036	12.9404	112000.0
2011-08-23 07:09:00	AAPL	Stock	12.9404	12.9439	12.9286	12.9404	87080.0
2011-08-23 07:10:00	AAPL	Stock	12.9343	12.9343	12.9286	12.9286	11200.0

> showing 50 of 1,046,543 rows — these rows as CSV

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