PREVIEW / stock_1hour / 2012-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-08.parquet
  size:    913 KB
  rows:    43,504
  symbols: 3,498

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
2012-06-08 04:00:00	AAPL	Stock	20.3214	20.3368	20.3214	20.3368	30800.0
2012-06-08 05:00:00	AAPL	Stock	20.2611	20.3682	20.2607	20.3682	46200.0
2012-06-08 06:00:00	AAPL	Stock	20.3689	20.3711	20.3464	20.3575	52668.0
2012-06-08 07:00:00	AAPL	Stock	20.3393	20.3907	20.3214	20.3707	239036.0
2012-06-08 08:00:00	AAPL	Stock	20.3621	20.4107	20.3429	20.3946	1664964.0
2012-06-08 09:00:00	AAPL	Stock	20.3996	20.4571	20.3214	20.4152	44152864.0
2012-06-08 10:00:00	AAPL	Stock	20.4189	20.5018	20.4014	20.4996	53419380.0
2012-06-08 11:00:00	AAPL	Stock	20.5014	20.5039	20.4182	20.4275	28825048.0
2012-06-08 12:00:00	AAPL	Stock	20.4263	20.4993	20.4254	20.4904	22015952.0
2012-06-08 13:00:00	AAPL	Stock	20.4864	20.5961	20.4857	20.5636	48725152.0
2012-06-08 14:00:00	AAPL	Stock	20.5671	20.6321	20.545	20.6032	32925900.0
2012-06-08 15:00:00	AAPL	Stock	20.6021	20.7351	20.5982	20.7239	92595244.0
2012-06-08 16:00:00	AAPL	Stock	20.7246	20.7857	20.4186	20.7379	14303044.0
2012-06-08 17:00:00	AAPL	Stock	20.7379	20.7875	20.7343	20.7871	764428.0
2012-06-08 18:00:00	AAPL	Stock	20.7768	20.7875	20.775	20.775	194880.0
2012-06-08 19:00:00	AAPL	Stock	20.7686	20.7839	20.7579	20.7821	350532.0
2012-06-08 08:00:00	MSFT	Stock	29.18	29.24	29.18	29.2	6951.0
2012-06-08 09:00:00	MSFT	Stock	29.17	29.29	29.05	29.235	3691202.0
2012-06-08 10:00:00	MSFT	Stock	29.23	29.45	29.19	29.435	6318516.0
2012-06-08 11:00:00	MSFT	Stock	29.43	29.45	29.33	29.34	5861923.0
2012-06-08 12:00:00	MSFT	Stock	29.34	29.44	29.28	29.35	4356789.0
2012-06-08 13:00:00	MSFT	Stock	29.355	29.46	29.34	29.37	4330478.0
2012-06-08 14:00:00	MSFT	Stock	29.375	29.56	29.36	29.506	4631887.0
2012-06-08 15:00:00	MSFT	Stock	29.5	29.68	29.5	29.64	8906651.0
2012-06-08 16:00:00	MSFT	Stock	29.65	29.7	29.292	29.65	3811154.0
2012-06-08 17:00:00	MSFT	Stock	29.63	29.64	29.62	29.63	29600.0
2012-06-08 18:00:00	MSFT	Stock	29.65	29.66	29.65	29.66	1200.0
2012-06-08 19:00:00	MSFT	Stock	29.65	29.68	29.65	29.68	2314.0
2012-06-08 07:00:00	NVDA	Stock	0.2942	0.2942	0.2942	0.2942	8000.0
2012-06-08 08:00:00	NVDA	Stock	0.2975	0.2985	0.2962	0.2962	76000.0
2012-06-08 09:00:00	NVDA	Stock	0.296	0.3005	0.296	0.3	56068560.0
2012-06-08 10:00:00	NVDA	Stock	0.2999	0.303	0.2995	0.3015	64685040.0
2012-06-08 11:00:00	NVDA	Stock	0.3018	0.3022	0.299	0.2992	39857000.0
2012-06-08 12:00:00	NVDA	Stock	0.2991	0.3018	0.2985	0.301	36742920.0
2012-06-08 13:00:00	NVDA	Stock	0.3011	0.3035	0.301	0.3023	47210240.0
2012-06-08 14:00:00	NVDA	Stock	0.3022	0.3032	0.3015	0.3027	37629200.0
2012-06-08 15:00:00	NVDA	Stock	0.3028	0.304	0.3025	0.303	68228840.0
2012-06-08 16:00:00	NVDA	Stock	0.303	0.305	0.2957	0.2957	18793920.0
2012-06-08 18:00:00	NVDA	Stock	0.3032	0.3032	0.303	0.303	98000.0
2012-06-08 19:00:00	NVDA	Stock	0.3028	0.3032	0.3028	0.3032	200000.0
2012-06-08 08:00:00	AMZN	Stock	10.92	10.92	10.9055	10.915	61740.0
2012-06-08 09:00:00	AMZN	Stock	10.924	10.946	10.856	10.9165	6123600.0
2012-06-08 10:00:00	AMZN	Stock	10.9244	10.971	10.8785	10.9385	9352820.0
2012-06-08 11:00:00	AMZN	Stock	10.942	10.9535	10.871	10.8755	7852920.0
2012-06-08 12:00:00	AMZN	Stock	10.876	10.888	10.833	10.87	6996400.0
2012-06-08 13:00:00	AMZN	Stock	10.8685	10.916	10.853	10.902	7199080.0
2012-06-08 14:00:00	AMZN	Stock	10.9	10.916	10.87	10.901	5253220.0
2012-06-08 15:00:00	AMZN	Stock	10.9015	10.9395	10.8976	10.921	11666740.0
2012-06-08 16:00:00	AMZN	Stock	10.922	10.9355	10.9005	10.925	2412580.0
2012-06-08 17:00:00	AMZN	Stock	10.918	10.924	10.918	10.924	9660.0

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

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