PREVIEW / stock_1hour / 2011-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-07.parquet
  size:    932 KB
  rows:    44,075
  symbols: 3,516

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-01-07 04:00:00	AAPL	Stock	11.9468	11.9611	11.9189	11.9189	14000.0
2011-01-07 05:00:00	AAPL	Stock	11.9489	11.9489	11.9489	11.9489	2800.0
2011-01-07 06:00:00	AAPL	Stock	11.9543	11.9543	11.9543	11.9543	2800.0
2011-01-07 07:00:00	AAPL	Stock	11.9393	11.9714	11.9286	11.9393	286440.0
2011-01-07 08:00:00	AAPL	Stock	11.9382	11.9382	11.8693	11.9143	2217992.0
2011-01-07 09:00:00	AAPL	Stock	11.9179	11.9418	11.8725	11.9014	39964456.0
2011-01-07 10:00:00	AAPL	Stock	11.9014	11.9861	11.8986	11.9461	66641708.0
2011-01-07 11:00:00	AAPL	Stock	11.9457	11.9518	11.8943	11.9321	37886072.0
2011-01-07 12:00:00	AAPL	Stock	11.9314	11.9357	11.8536	11.8979	39738020.0
2011-01-07 13:00:00	AAPL	Stock	11.9004	11.9304	11.885	11.9194	26971896.0
2011-01-07 14:00:00	AAPL	Stock	11.9207	11.9486	11.9168	11.9357	21397180.0
2011-01-07 15:00:00	AAPL	Stock	11.9357	12.0125	11.9339	12.0046	60251576.0
2011-01-07 16:00:00	AAPL	Stock	12.0079	12.0304	11.9221	12.0304	7479248.0
2011-01-07 17:00:00	AAPL	Stock	12.0311	12.0982	12.0311	12.0786	3311644.0
2011-01-07 18:00:00	AAPL	Stock	12.0804	12.0864	12.0043	12.0764	817180.0
2011-01-07 19:00:00	AAPL	Stock	12.0793	12.0807	12.0679	12.075	550032.0
2011-01-07 04:00:00	MSFT	Stock	28.6	28.6	28.6	28.6	100.0
2011-01-07 05:00:00	MSFT	Stock	28.6	28.6	28.55	28.55	900.0
2011-01-07 06:00:00	MSFT	Stock	28.58	28.66	28.58	28.62	1000.0
2011-01-07 07:00:00	MSFT	Stock	28.62	28.7	28.44	28.68	16600.0
2011-01-07 08:00:00	MSFT	Stock	28.69	28.78	28.66	28.77	98043.0
2011-01-07 09:00:00	MSFT	Stock	28.77	28.8	28.42	28.55	11082736.0
2011-01-07 10:00:00	MSFT	Stock	28.56	28.57	28.44	28.465	10317143.0
2011-01-07 11:00:00	MSFT	Stock	28.46	28.47	28.28	28.429	8314329.0
2011-01-07 12:00:00	MSFT	Stock	28.42	28.56	28.25	28.36	10168454.0
2011-01-07 13:00:00	MSFT	Stock	28.36	28.37	28.25	28.32	5254928.0
2011-01-07 14:00:00	MSFT	Stock	28.32	28.45	28.28	28.415	5545809.0
2011-01-07 15:00:00	MSFT	Stock	28.41	28.65	28.37	28.59	14328379.0
2011-01-07 16:00:00	MSFT	Stock	28.6	28.605	28.456	28.53	1723031.0
2011-01-07 17:00:00	MSFT	Stock	28.54	28.54	28.5	28.5	1200.0
2011-01-07 18:00:00	MSFT	Stock	28.55	28.6	28.55	28.6	19971.0
2011-01-07 19:00:00	MSFT	Stock	28.59	28.59	28.55	28.55	2430.0
2011-01-07 07:00:00	NVDA	Stock	0.487	0.4898	0.4812	0.4812	322000.0
2011-01-07 08:00:00	NVDA	Stock	0.4815	0.4845	0.4758	0.483	3858600.0
2011-01-07 09:00:00	NVDA	Stock	0.4843	0.4888	0.467	0.4735	400125160.0
2011-01-07 10:00:00	NVDA	Stock	0.4735	0.4888	0.4732	0.482	542136200.0
2011-01-07 11:00:00	NVDA	Stock	0.4821	0.483	0.4742	0.4818	278533480.0
2011-01-07 12:00:00	NVDA	Stock	0.4815	0.4851	0.4763	0.4824	218172800.0
2011-01-07 13:00:00	NVDA	Stock	0.4822	0.4968	0.4808	0.49	373100560.0
2011-01-07 14:00:00	NVDA	Stock	0.4902	0.4975	0.4878	0.4948	229298320.0
2011-01-07 15:00:00	NVDA	Stock	0.4948	0.4982	0.493	0.4975	445984280.0
2011-01-07 16:00:00	NVDA	Stock	0.4978	0.4978	0.4852	0.4963	39384960.0
2011-01-07 17:00:00	NVDA	Stock	0.4791	0.4976	0.4791	0.4948	574800.0
2011-01-07 18:00:00	NVDA	Stock	0.4948	0.4968	0.4938	0.4938	226000.0
2011-01-07 19:00:00	NVDA	Stock	0.4945	0.4968	0.4938	0.4942	214000.0
2011-01-07 04:00:00	AMZN	Stock	9.209	9.209	9.209	9.209	3800.0
2011-01-07 06:00:00	AMZN	Stock	9.3095	9.3525	9.3095	9.3525	36000.0
2011-01-07 07:00:00	AMZN	Stock	9.3525	9.398	9.3495	9.3535	102700.0
2011-01-07 08:00:00	AMZN	Stock	9.343	9.38	9.31	9.3425	557080.0
2011-01-07 09:00:00	AMZN	Stock	9.3445	9.4145	9.3445	9.387	13252140.0

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

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