PREVIEW / stock_1hour / 2011-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-14.parquet
  size:    925 KB
  rows:    43,746
  symbols: 3,515

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-04-14 04:00:00	AAPL	Stock	12.0	12.0	12.0	12.0	2800.0
2011-04-14 05:00:00	AAPL	Stock	11.9664	11.9714	11.9464	11.9464	44800.0
2011-04-14 06:00:00	AAPL	Stock	11.9379	11.9493	11.9286	11.9393	46480.0
2011-04-14 07:00:00	AAPL	Stock	11.9321	11.9464	11.9146	11.9314	674240.0
2011-04-14 08:00:00	AAPL	Stock	11.9296	11.975	11.9296	11.9725	1515808.0
2011-04-14 09:00:00	AAPL	Stock	11.9696	12.0	11.9021	11.9389	59795288.0
2011-04-14 10:00:00	AAPL	Stock	11.9393	11.9579	11.9079	11.9114	51354464.0
2011-04-14 11:00:00	AAPL	Stock	11.9118	11.9121	11.8654	11.8911	47097596.0
2011-04-14 12:00:00	AAPL	Stock	11.8911	11.905	11.8839	11.8996	25169816.0
2011-04-14 13:00:00	AAPL	Stock	11.9	11.9204	11.8661	11.8699	26660368.0
2011-04-14 14:00:00	AAPL	Stock	11.8696	11.9018	11.8661	11.8889	28048104.0
2011-04-14 15:00:00	AAPL	Stock	11.8893	11.9193	11.8593	11.8596	49847560.0
2011-04-14 16:00:00	AAPL	Stock	11.8604	11.9518	11.8125	11.8343	7135436.0
2011-04-14 17:00:00	AAPL	Stock	11.8307	11.8429	11.8296	11.8411	544180.0
2011-04-14 18:00:00	AAPL	Stock	11.8418	11.8721	11.8418	11.8432	317044.0
2011-04-14 19:00:00	AAPL	Stock	11.8479	11.8536	11.8446	11.8482	114968.0
2011-04-14 05:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	200.0
2011-04-14 06:00:00	MSFT	Stock	25.43	25.43	25.37	25.38	400.0
2011-04-14 07:00:00	MSFT	Stock	25.35	25.5	25.35	25.42	17178.0
2011-04-14 08:00:00	MSFT	Stock	25.42	25.42	25.33	25.37	140852.0
2011-04-14 09:00:00	MSFT	Stock	25.36	25.47	25.1	25.142	10601988.0
2011-04-14 10:00:00	MSFT	Stock	25.149	25.35	25.09	25.25	10164850.0
2011-04-14 11:00:00	MSFT	Stock	25.25	25.33	25.18	25.31	5086984.0
2011-04-14 12:00:00	MSFT	Stock	25.31	25.36	25.26	25.31	4368951.0
2011-04-14 13:00:00	MSFT	Stock	25.315	25.35	25.2	25.2	4868759.0
2011-04-14 14:00:00	MSFT	Stock	25.205	25.33	25.19	25.27	5197801.0
2011-04-14 15:00:00	MSFT	Stock	25.27	25.42	25.27	25.4	10777903.0
2011-04-14 16:00:00	MSFT	Stock	25.4	25.42	25.27	25.4	2329034.0
2011-04-14 17:00:00	MSFT	Stock	25.39	25.4	25.39	25.4	8400.0
2011-04-14 18:00:00	MSFT	Stock	25.39	25.42	25.39	25.4	21091.0
2011-04-14 19:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	2000.0
2011-04-14 08:00:00	NVDA	Stock	0.441	0.4412	0.4402	0.4405	88000.0
2011-04-14 09:00:00	NVDA	Stock	0.4378	0.4432	0.4375	0.4426	115788520.0
2011-04-14 10:00:00	NVDA	Stock	0.4425	0.458	0.4425	0.4562	366395880.0
2011-04-14 11:00:00	NVDA	Stock	0.4562	0.4565	0.4508	0.452	165045000.0
2011-04-14 12:00:00	NVDA	Stock	0.452	0.457	0.452	0.4544	104698320.0
2011-04-14 13:00:00	NVDA	Stock	0.4542	0.4558	0.4498	0.4502	89009960.0
2011-04-14 14:00:00	NVDA	Stock	0.4502	0.4548	0.4502	0.4532	77409240.0
2011-04-14 15:00:00	NVDA	Stock	0.4532	0.463	0.453	0.4625	316509200.0
2011-04-14 16:00:00	NVDA	Stock	0.4628	0.4628	0.4531	0.461	10910880.0
2011-04-14 17:00:00	NVDA	Stock	0.4612	0.4618	0.4598	0.4598	123920.0
2011-04-14 18:00:00	NVDA	Stock	0.4618	0.4618	0.46	0.46	8400.0
2011-04-14 19:00:00	NVDA	Stock	0.4598	0.4612	0.4598	0.4612	100960.0
2011-04-14 07:00:00	AMZN	Stock	9.06	9.072	9.0135	9.03	18000.0
2011-04-14 08:00:00	AMZN	Stock	9.077	9.084	9.061	9.0615	132400.0
2011-04-14 09:00:00	AMZN	Stock	9.0635	9.082	8.975	8.9965	9717940.0
2011-04-14 10:00:00	AMZN	Stock	8.995	9.0765	8.9845	8.9995	14004800.0
2011-04-14 11:00:00	AMZN	Stock	8.9985	9.02	8.979	8.9945	7454180.0
2011-04-14 12:00:00	AMZN	Stock	8.992	9.0162	8.968	8.993	7158400.0
2011-04-14 13:00:00	AMZN	Stock	8.993	9.011	8.975	9.0051	7580740.0

> showing 50 of 43,746 rows — these rows as CSV

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