PREVIEW / stock_1hour / 2013-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-04.parquet
  size:    969 KB
  rows:    45,295
  symbols: 3,454

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
2013-04-04 04:00:00	AAPL	Stock	15.4893	15.4893	15.4893	15.4893	8400.0
2013-04-04 05:00:00	AAPL	Stock	15.5	15.5	15.5	15.5	5600.0
2013-04-04 06:00:00	AAPL	Stock	15.5336	15.5357	15.5268	15.5343	30688.0
2013-04-04 07:00:00	AAPL	Stock	15.5325	15.5625	15.5182	15.5182	256844.0
2013-04-04 08:00:00	AAPL	Stock	15.5343	15.5607	15.3929	15.4161	2235324.0
2013-04-04 09:00:00	AAPL	Stock	15.4268	15.5357	15.2729	15.3071	73168424.0
2013-04-04 10:00:00	AAPL	Stock	15.3161	15.4004	15.2556	15.2968	67247152.0
2013-04-04 11:00:00	AAPL	Stock	15.2971	15.3214	15.2557	15.2666	38384444.0
2013-04-04 12:00:00	AAPL	Stock	15.2662	15.3304	15.1875	15.2904	61786200.0
2013-04-04 13:00:00	AAPL	Stock	15.2946	15.3696	15.2509	15.3218	38642660.0
2013-04-04 14:00:00	AAPL	Stock	15.325	15.3321	15.2607	15.2811	24865792.0
2013-04-04 15:00:00	AAPL	Stock	15.2782	15.2946	15.2329	15.2721	39086544.0
2013-04-04 16:00:00	AAPL	Stock	15.275	15.3368	15.2333	15.2643	8384460.0
2013-04-04 17:00:00	AAPL	Stock	15.2668	15.2768	15.2504	15.2536	212940.0
2013-04-04 18:00:00	AAPL	Stock	15.2539	15.2607	15.2529	15.2607	119280.0
2013-04-04 19:00:00	AAPL	Stock	15.255	15.2675	15.2525	15.2571	181944.0
2013-04-04 04:00:00	MSFT	Stock	28.27	28.48	28.27	28.37	2447.0
2013-04-04 05:00:00	MSFT	Stock	28.37	28.38	28.34	28.34	1280.0
2013-04-04 06:00:00	MSFT	Stock	28.38	28.38	28.34	28.35	2662.0
2013-04-04 07:00:00	MSFT	Stock	28.36	28.53	28.35	28.4	121403.0
2013-04-04 08:00:00	MSFT	Stock	28.45	28.5	28.35	28.42	1154936.0
2013-04-04 09:00:00	MSFT	Stock	28.42	28.46	28.27	28.38	8636220.0
2013-04-04 10:00:00	MSFT	Stock	28.375	28.49	28.36	28.405	10637541.0
2013-04-04 11:00:00	MSFT	Stock	28.404	28.47	28.37	28.42	4912264.0
2013-04-04 12:00:00	MSFT	Stock	28.425	28.45	28.37	28.412	4507995.0
2013-04-04 13:00:00	MSFT	Stock	28.415	28.495	28.38	28.479	3785638.0
2013-04-04 14:00:00	MSFT	Stock	28.48	28.5	28.43	28.463	2280525.0
2013-04-04 15:00:00	MSFT	Stock	28.465	28.61	28.45	28.6	6624037.0
2013-04-04 16:00:00	MSFT	Stock	28.6	28.602	28.421	28.432	2151038.0
2013-04-04 17:00:00	MSFT	Stock	28.58	28.59	28.52	28.59	26325.0
2013-04-04 18:00:00	MSFT	Stock	28.449	28.59	28.449	28.55	1358.0
2013-04-04 19:00:00	MSFT	Stock	28.57	28.6	28.56	28.56	4035.0
2013-04-04 08:00:00	NVDA	Stock	0.3045	0.3045	0.304	0.304	40000.0
2013-04-04 09:00:00	NVDA	Stock	0.3045	0.3048	0.3012	0.3042	32967320.0
2013-04-04 10:00:00	NVDA	Stock	0.304	0.306	0.3015	0.3049	64205440.0
2013-04-04 11:00:00	NVDA	Stock	0.3049	0.3068	0.3048	0.3048	34928840.0
2013-04-04 12:00:00	NVDA	Stock	0.3049	0.3052	0.3038	0.3052	31962160.0
2013-04-04 13:00:00	NVDA	Stock	0.3051	0.3068	0.3045	0.3068	21066120.0
2013-04-04 14:00:00	NVDA	Stock	0.3068	0.3073	0.3064	0.3065	23339480.0
2013-04-04 15:00:00	NVDA	Stock	0.3066	0.3073	0.306	0.306	56449760.0
2013-04-04 16:00:00	NVDA	Stock	0.3061	0.3062	0.3037	0.3055	12625440.0
2013-04-04 17:00:00	NVDA	Stock	0.306	0.3062	0.306	0.306	16878760.0
2013-04-04 19:00:00	NVDA	Stock	0.3052	0.3052	0.3052	0.3052	56000.0
2013-04-04 08:00:00	AMZN	Stock	12.9505	12.952	12.925	12.932	45020.0
2013-04-04 09:00:00	AMZN	Stock	12.9265	13.0095	12.806	12.979	8068140.0
2013-04-04 10:00:00	AMZN	Stock	12.981	13.0205	12.881	12.936	6245860.0
2013-04-04 11:00:00	AMZN	Stock	12.9355	13.0132	12.9301	12.957	2335920.0
2013-04-04 12:00:00	AMZN	Stock	12.9571	12.9571	12.9	12.913	2515540.0
2013-04-04 13:00:00	AMZN	Stock	12.918	12.945	12.864	12.9345	3005420.0
2013-04-04 14:00:00	AMZN	Stock	12.934	12.9675	12.878	12.8815	3262820.0

> showing 50 of 45,295 rows — these rows as CSV

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