PREVIEW / stock_1hour / 2013-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-31.parquet
  size:    972 KB
  rows:    45,267
  symbols: 3,460

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-01-31 06:00:00	AAPL	Stock	16.2571	16.2836	16.2571	16.2836	30240.0
2013-01-31 07:00:00	AAPL	Stock	16.2536	16.2857	16.2343	16.2857	206920.0
2013-01-31 08:00:00	AAPL	Stock	16.2857	16.3118	16.2343	16.2618	729736.0
2013-01-31 09:00:00	AAPL	Stock	16.2557	16.4029	16.255	16.3529	56340116.0
2013-01-31 10:00:00	AAPL	Stock	16.3436	16.3729	16.3057	16.3261	36040004.0
2013-01-31 11:00:00	AAPL	Stock	16.3268	16.3439	16.2493	16.2598	37658796.0
2013-01-31 12:00:00	AAPL	Stock	16.2607	16.3143	16.2511	16.2775	28333508.0
2013-01-31 13:00:00	AAPL	Stock	16.2757	16.3146	16.2536	16.2879	23494856.0
2013-01-31 14:00:00	AAPL	Stock	16.2874	16.3679	16.2768	16.3443	28666456.0
2013-01-31 15:00:00	AAPL	Stock	16.3436	16.3514	16.2507	16.2636	54622680.0
2013-01-31 16:00:00	AAPL	Stock	16.2614	16.3121	16.2589	16.2804	45420900.0
2013-01-31 17:00:00	AAPL	Stock	16.2839	16.2857	16.2611	16.2732	1200528.0
2013-01-31 18:00:00	AAPL	Stock	16.2732	16.2961	16.2732	16.2954	395164.0
2013-01-31 19:00:00	AAPL	Stock	16.2961	16.3011	16.2875	16.3	179228.0
2013-01-31 08:00:00	MSFT	Stock	27.85	27.87	27.82	27.84	28500.0
2013-01-31 09:00:00	MSFT	Stock	27.82	27.97	27.6	27.82	4804223.0
2013-01-31 10:00:00	MSFT	Stock	27.82	27.82	27.55	27.59	6653926.0
2013-01-31 11:00:00	MSFT	Stock	27.6	27.61	27.51	27.55	5755163.0
2013-01-31 12:00:00	MSFT	Stock	27.55	27.57	27.5	27.566	5095129.0
2013-01-31 13:00:00	MSFT	Stock	27.57	27.62	27.52	27.525	3745522.0
2013-01-31 14:00:00	MSFT	Stock	27.52	27.55	27.45	27.514	6406651.0
2013-01-31 15:00:00	MSFT	Stock	27.51	27.52	27.4	27.47	12771611.0
2013-01-31 16:00:00	MSFT	Stock	27.47	27.85	27.43	27.47	4587668.0
2013-01-31 17:00:00	MSFT	Stock	27.47	27.48	27.45	27.48	109829.0
2013-01-31 18:00:00	MSFT	Stock	27.49	27.5	27.48	27.5	2668.0
2013-01-31 19:00:00	MSFT	Stock	27.52	27.53	27.52	27.53	4789.0
2013-01-31 08:00:00	NVDA	Stock	0.3088	0.3098	0.3088	0.3098	32000.0
2013-01-31 09:00:00	NVDA	Stock	0.3108	0.3115	0.3075	0.309	43973240.0
2013-01-31 10:00:00	NVDA	Stock	0.3093	0.3095	0.3059	0.308	69932800.0
2013-01-31 11:00:00	NVDA	Stock	0.3078	0.3083	0.3068	0.3069	38960600.0
2013-01-31 12:00:00	NVDA	Stock	0.3069	0.3075	0.3062	0.3073	25585600.0
2013-01-31 13:00:00	NVDA	Stock	0.3073	0.3073	0.3055	0.3058	55070360.0
2013-01-31 14:00:00	NVDA	Stock	0.3058	0.3068	0.3045	0.306	58637800.0
2013-01-31 15:00:00	NVDA	Stock	0.306	0.307	0.3045	0.3065	130590120.0
2013-01-31 16:00:00	NVDA	Stock	0.3065	0.3073	0.306	0.3066	8990200.0
2013-01-31 17:00:00	NVDA	Stock	0.3068	0.3068	0.3065	0.3068	34960.0
2013-01-31 18:00:00	NVDA	Stock	0.3068	0.3068	0.3068	0.3068	80000.0
2013-01-31 19:00:00	NVDA	Stock	0.3068	0.3068	0.3068	0.3068	25200.0
2013-01-31 07:00:00	AMZN	Stock	13.597	13.6	13.597	13.6	31760.0
2013-01-31 08:00:00	AMZN	Stock	13.62	13.62	13.525	13.569	161340.0
2013-01-31 09:00:00	AMZN	Stock	13.57	13.7531	13.4741	13.749	19074860.0
2013-01-31 10:00:00	AMZN	Stock	13.7425	13.797	13.5355	13.5375	19084060.0
2013-01-31 11:00:00	AMZN	Stock	13.5346	13.5525	13.4275	13.4325	13702640.0
2013-01-31 12:00:00	AMZN	Stock	13.429	13.451	13.276	13.404	19476560.0
2013-01-31 13:00:00	AMZN	Stock	13.4075	13.4315	13.325	13.395	13295220.0
2013-01-31 14:00:00	AMZN	Stock	13.3952	13.3975	13.2795	13.292	12800720.0
2013-01-31 15:00:00	AMZN	Stock	13.29	13.3075	13.185	13.275	29594200.0
2013-01-31 16:00:00	AMZN	Stock	13.275	13.5653	13.27	13.3005	5027580.0
2013-01-31 17:00:00	AMZN	Stock	13.2905	13.31	13.275	13.275	424000.0
2013-01-31 18:00:00	AMZN	Stock	13.2885	13.3025	13.2875	13.3025	26820.0

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

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