PREVIEW / stock_1hour / 2012-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-06.parquet
  size:    919 KB
  rows:    43,530
  symbols: 3,463

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-08-06 06:00:00	AAPL	Stock	22.0661	22.0661	22.0554	22.0589	70000.0
2012-08-06 07:00:00	AAPL	Stock	22.0589	22.1014	22.0554	22.0946	566972.0
2012-08-06 08:00:00	AAPL	Stock	22.0875	22.0921	22.0689	22.0743	1474816.0
2012-08-06 09:00:00	AAPL	Stock	22.0743	22.1029	21.9736	22.0646	45916416.0
2012-08-06 10:00:00	AAPL	Stock	22.0622	22.2286	22.0536	22.2032	73109876.0
2012-08-06 11:00:00	AAPL	Stock	22.2006	22.2604	22.1889	22.2585	41150928.0
2012-08-06 12:00:00	AAPL	Stock	22.2585	22.3093	22.2411	22.3059	30051756.0
2012-08-06 13:00:00	AAPL	Stock	22.3036	22.3167	22.245	22.2768	30882320.0
2012-08-06 14:00:00	AAPL	Stock	22.2761	22.3089	22.2518	22.2675	20265588.0
2012-08-06 15:00:00	AAPL	Stock	22.2654	22.2857	22.1986	22.2315	42164388.0
2012-08-06 16:00:00	AAPL	Stock	22.2306	22.2935	22.1092	22.2125	5566036.0
2012-08-06 17:00:00	AAPL	Stock	22.2136	22.2193	22.2075	22.2193	101584.0
2012-08-06 18:00:00	AAPL	Stock	22.2179	22.2196	22.2107	22.2186	124768.0
2012-08-06 19:00:00	AAPL	Stock	22.2196	22.2207	22.2143	22.2143	176792.0
2012-08-06 08:00:00	MSFT	Stock	29.92	29.98	29.92	29.98	9124.0
2012-08-06 09:00:00	MSFT	Stock	29.98	30.03	29.81	30.005	3859398.0
2012-08-06 10:00:00	MSFT	Stock	30.02	30.11	29.9	29.975	5565057.0
2012-08-06 11:00:00	MSFT	Stock	29.98	30.02	29.93	29.985	2458438.0
2012-08-06 12:00:00	MSFT	Stock	29.98	30.08	29.95	30.06	2269147.0
2012-08-06 13:00:00	MSFT	Stock	30.06	30.09	30.0	30.018	2167739.0
2012-08-06 14:00:00	MSFT	Stock	30.02	30.08	29.98	30.05	2220824.0
2012-08-06 15:00:00	MSFT	Stock	30.05	30.09	29.9	29.95	6306878.0
2012-08-06 16:00:00	MSFT	Stock	29.94	30.073	29.88	29.92	2341191.0
2012-08-06 17:00:00	MSFT	Stock	29.93	29.93	29.89	29.89	910.0
2012-08-06 19:00:00	MSFT	Stock	29.9	29.9	29.9	29.9	2050.0
2012-08-06 07:00:00	NVDA	Stock	0.3425	0.3425	0.3425	0.3425	4000.0
2012-08-06 08:00:00	NVDA	Stock	0.3425	0.3468	0.3425	0.3442	264000.0
2012-08-06 09:00:00	NVDA	Stock	0.345	0.35	0.345	0.3488	57240040.0
2012-08-06 10:00:00	NVDA	Stock	0.3488	0.3513	0.3485	0.3495	77729720.0
2012-08-06 11:00:00	NVDA	Stock	0.3496	0.3513	0.3495	0.3508	41993200.0
2012-08-06 12:00:00	NVDA	Stock	0.3508	0.352	0.3505	0.351	31215520.0
2012-08-06 13:00:00	NVDA	Stock	0.3513	0.3513	0.35	0.351	35810640.0
2012-08-06 14:00:00	NVDA	Stock	0.3508	0.3513	0.3505	0.3513	25624080.0
2012-08-06 15:00:00	NVDA	Stock	0.3513	0.3515	0.3495	0.3498	77928720.0
2012-08-06 16:00:00	NVDA	Stock	0.3502	0.351	0.343	0.3502	12049640.0
2012-08-06 17:00:00	NVDA	Stock	0.3502	0.3502	0.3502	0.3502	4000.0
2012-08-06 18:00:00	NVDA	Stock	0.3513	0.3513	0.348	0.348	439200.0
2012-08-06 08:00:00	AMZN	Stock	11.76	11.7835	11.7525	11.78	22300.0
2012-08-06 09:00:00	AMZN	Stock	11.775	11.7885	11.7275	11.7375	6244240.0
2012-08-06 10:00:00	AMZN	Stock	11.74	11.755	11.7	11.7375	6633580.0
2012-08-06 11:00:00	AMZN	Stock	11.7335	11.778	11.7216	11.7548	4731460.0
2012-08-06 12:00:00	AMZN	Stock	11.754	11.7735	11.728	11.7725	3939500.0
2012-08-06 13:00:00	AMZN	Stock	11.77	11.7724	11.725	11.7375	3463100.0
2012-08-06 14:00:00	AMZN	Stock	11.738	11.7495	11.72	11.725	2481980.0
2012-08-06 15:00:00	AMZN	Stock	11.726	11.7395	11.6905	11.698	7975000.0
2012-08-06 16:00:00	AMZN	Stock	11.6995	11.7426	11.6925	11.7	1313220.0
2012-08-06 05:00:00	META	Stock	21.4	21.45	21.4	21.4	1900.0
2012-08-06 06:00:00	META	Stock	21.45	21.53	21.45	21.53	600.0
2012-08-06 07:00:00	META	Stock	21.45	21.47	21.29	21.31	15649.0
2012-08-06 08:00:00	META	Stock	21.3	21.45	21.2	21.36	114752.0

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

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