PREVIEW / stock_1hour / 2011-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-08.parquet
  size:    947 KB
  rows:    44,630
  symbols: 3,570

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-06-08 04:00:00	AAPL	Stock	11.8464	11.8464	11.7729	11.7857	16940.0
2011-06-08 05:00:00	AAPL	Stock	11.7857	11.8039	11.7843	11.8036	28000.0
2011-06-08 06:00:00	AAPL	Stock	11.8061	11.8061	11.7918	11.7918	131600.0
2011-06-08 07:00:00	AAPL	Stock	11.8	11.8429	11.8	11.8214	755860.0
2011-06-08 08:00:00	AAPL	Stock	11.8168	11.875	11.7961	11.8554	1795780.0
2011-06-08 09:00:00	AAPL	Stock	11.8536	11.9236	11.8089	11.8221	65275420.0
2011-06-08 10:00:00	AAPL	Stock	11.8232	11.9446	11.8189	11.9186	71224328.0
2011-06-08 11:00:00	AAPL	Stock	11.9207	11.9571	11.89	11.9129	41414044.0
2011-06-08 12:00:00	AAPL	Stock	11.9121	11.9225	11.8636	11.9082	25031104.0
2011-06-08 13:00:00	AAPL	Stock	11.9079	11.9143	11.8246	11.8336	28716352.0
2011-06-08 14:00:00	AAPL	Stock	11.8332	11.8925	11.8286	11.8586	33672128.0
2011-06-08 15:00:00	AAPL	Stock	11.8618	11.8914	11.8232	11.8682	50962492.0
2011-06-08 16:00:00	AAPL	Stock	11.8625	11.8932	11.8302	11.8571	11900364.0
2011-06-08 17:00:00	AAPL	Stock	11.8607	11.8646	11.8582	11.8636	233856.0
2011-06-08 18:00:00	AAPL	Stock	11.8621	11.8657	11.8532	11.8564	272076.0
2011-06-08 19:00:00	AAPL	Stock	11.8579	11.865	11.8557	11.865	170380.0
2011-06-08 04:00:00	MSFT	Stock	24.02	24.02	24.02	24.02	300.0
2011-06-08 07:00:00	MSFT	Stock	23.89	23.99	23.89	23.99	678.0
2011-06-08 08:00:00	MSFT	Stock	23.95	24.06	23.87	24.06	59261.0
2011-06-08 09:00:00	MSFT	Stock	23.95	24.02	23.86	23.959	5716497.0
2011-06-08 10:00:00	MSFT	Stock	23.95	24.01	23.86	23.95	6934019.0
2011-06-08 11:00:00	MSFT	Stock	23.96	24.01	23.89	23.951	5542861.0
2011-06-08 12:00:00	MSFT	Stock	23.95	23.98	23.87	23.97	4263504.0
2011-06-08 13:00:00	MSFT	Stock	23.972	24.0	23.89	23.925	4682031.0
2011-06-08 14:00:00	MSFT	Stock	23.92	23.99	23.88	23.96	5391768.0
2011-06-08 15:00:00	MSFT	Stock	23.969	23.99	23.88	23.96	7828297.0
2011-06-08 16:00:00	MSFT	Stock	23.95	23.96	23.88	23.92	1463045.0
2011-06-08 17:00:00	MSFT	Stock	23.9	23.92	23.89	23.91	2559.0
2011-06-08 18:00:00	MSFT	Stock	23.94	23.94	23.92	23.92	10330.0
2011-06-08 19:00:00	MSFT	Stock	23.94	23.95	23.94	23.95	1900.0
2011-06-08 08:00:00	NVDA	Stock	0.4572	0.4572	0.4472	0.4495	168000.0
2011-06-08 09:00:00	NVDA	Stock	0.448	0.452	0.4388	0.4401	112283400.0
2011-06-08 10:00:00	NVDA	Stock	0.4402	0.4475	0.44	0.4442	117204200.0
2011-06-08 11:00:00	NVDA	Stock	0.4442	0.447	0.4408	0.4425	58233680.0
2011-06-08 12:00:00	NVDA	Stock	0.4428	0.4432	0.4392	0.4425	45790360.0
2011-06-08 13:00:00	NVDA	Stock	0.4425	0.443	0.4382	0.4388	41544400.0
2011-06-08 14:00:00	NVDA	Stock	0.4386	0.44	0.4375	0.4378	69802080.0
2011-06-08 15:00:00	NVDA	Stock	0.4378	0.441	0.4358	0.4395	110242760.0
2011-06-08 16:00:00	NVDA	Stock	0.439	0.4417	0.4367	0.4382	13472800.0
2011-06-08 17:00:00	NVDA	Stock	0.4385	0.441	0.4385	0.441	88000.0
2011-06-08 18:00:00	NVDA	Stock	0.4402	0.4448	0.4392	0.4448	179920.0
2011-06-08 04:00:00	AMZN	Stock	9.3675	9.3675	9.3675	9.3675	2000.0
2011-06-08 08:00:00	AMZN	Stock	9.3625	9.399	9.3015	9.3875	422060.0
2011-06-08 09:00:00	AMZN	Stock	9.387	9.476	9.3355	9.4041	13021880.0
2011-06-08 10:00:00	AMZN	Stock	9.3995	9.4905	9.369	9.4125	16165100.0
2011-06-08 11:00:00	AMZN	Stock	9.4165	9.4575	9.4025	9.452	6792420.0
2011-06-08 12:00:00	AMZN	Stock	9.4485	9.4565	9.3855	9.441	6176580.0
2011-06-08 13:00:00	AMZN	Stock	9.4425	9.452	9.316	9.329	7371020.0
2011-06-08 14:00:00	AMZN	Stock	9.3255	9.433	9.3215	9.394	10417200.0
2011-06-08 15:00:00	AMZN	Stock	9.3965	9.4325	9.3535	9.4045	11772160.0

> showing 50 of 44,630 rows — these rows as CSV

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