PREVIEW / stock_1hour / 2012-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-30.parquet
  size:    921 KB
  rows:    43,732
  symbols: 3,502

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-07-30 04:00:00	AAPL	Stock	20.8964	20.8964	20.8661	20.8679	11200.0
2012-07-30 05:00:00	AAPL	Stock	20.8682	20.9171	20.8679	20.9171	27132.0
2012-07-30 06:00:00	AAPL	Stock	20.9104	20.9107	20.8696	20.8964	38836.0
2012-07-30 07:00:00	AAPL	Stock	20.8964	20.9125	20.87	20.8839	307468.0
2012-07-30 08:00:00	AAPL	Stock	20.8832	21.1929	20.875	21.1071	6030640.0
2012-07-30 09:00:00	AAPL	Stock	21.1064	21.3686	20.9936	21.3179	90810020.0
2012-07-30 10:00:00	AAPL	Stock	21.3199	21.4086	21.2039	21.2229	80836364.0
2012-07-30 11:00:00	AAPL	Stock	21.2236	21.2946	21.1754	21.2571	48799240.0
2012-07-30 12:00:00	AAPL	Stock	21.2528	21.3346	21.2386	21.2921	33640096.0
2012-07-30 13:00:00	AAPL	Stock	21.2939	21.3357	21.2654	21.3129	20926500.0
2012-07-30 14:00:00	AAPL	Stock	21.3136	21.3146	21.2518	21.2721	27911996.0
2012-07-30 15:00:00	AAPL	Stock	21.2721	21.2964	21.1686	21.2486	56423948.0
2012-07-30 16:00:00	AAPL	Stock	21.2507	21.3204	21.2349	21.3204	6691468.0
2012-07-30 17:00:00	AAPL	Stock	21.3193	21.3346	21.2511	21.3214	527576.0
2012-07-30 18:00:00	AAPL	Stock	21.3214	21.3261	21.3	21.3107	229740.0
2012-07-30 19:00:00	AAPL	Stock	21.3193	21.3282	21.3114	21.325	217056.0
2012-07-30 04:00:00	MSFT	Stock	30.09	30.09	30.08	30.08	2740.0
2012-07-30 07:00:00	MSFT	Stock	29.9	29.9	29.9	29.9	142.0
2012-07-30 08:00:00	MSFT	Stock	29.73	29.83	29.73	29.73	6104.0
2012-07-30 09:00:00	MSFT	Stock	29.72	29.82	29.61	29.68	3218644.0
2012-07-30 10:00:00	MSFT	Stock	29.675	29.73	29.56	29.57	4793312.0
2012-07-30 11:00:00	MSFT	Stock	29.56	29.63	29.46	29.545	4816123.0
2012-07-30 12:00:00	MSFT	Stock	29.545	29.62	29.48	29.554	2847820.0
2012-07-30 13:00:00	MSFT	Stock	29.56	29.66	29.52	29.618	2439438.0
2012-07-30 14:00:00	MSFT	Stock	29.61	29.66	29.57	29.645	3069627.0
2012-07-30 15:00:00	MSFT	Stock	29.65	29.65	29.52	29.635	5939287.0
2012-07-30 16:00:00	MSFT	Stock	29.63	29.755	29.5	29.6	1464156.0
2012-07-30 17:00:00	MSFT	Stock	29.64	29.755	29.62	29.755	13425.0
2012-07-30 18:00:00	MSFT	Stock	29.62	29.62	29.62	29.62	600.0
2012-07-30 19:00:00	MSFT	Stock	29.6	29.6	29.6	29.6	200.0
2012-07-30 09:00:00	NVDA	Stock	0.3375	0.3413	0.3362	0.3388	28582160.0
2012-07-30 10:00:00	NVDA	Stock	0.339	0.34	0.336	0.3362	93624000.0
2012-07-30 11:00:00	NVDA	Stock	0.3362	0.3378	0.3342	0.3355	69904920.0
2012-07-30 12:00:00	NVDA	Stock	0.3355	0.336	0.3338	0.334	45497640.0
2012-07-30 13:00:00	NVDA	Stock	0.3342	0.3344	0.3313	0.3315	31273560.0
2012-07-30 14:00:00	NVDA	Stock	0.3316	0.3335	0.3305	0.3333	27026280.0
2012-07-30 15:00:00	NVDA	Stock	0.3333	0.334	0.3313	0.333	51981480.0
2012-07-30 16:00:00	NVDA	Stock	0.3333	0.335	0.3328	0.3333	14959880.0
2012-07-30 17:00:00	NVDA	Stock	0.3333	0.3333	0.3333	0.3333	11400.0
2012-07-30 07:00:00	AMZN	Stock	11.815	11.815	11.815	11.815	2000.0
2012-07-30 08:00:00	AMZN	Stock	11.8645	11.871	11.84	11.865	281300.0
2012-07-30 09:00:00	AMZN	Stock	11.865	12.037	11.801	11.8682	18385120.0
2012-07-30 10:00:00	AMZN	Stock	11.8633	11.875	11.7355	11.7985	16318520.0
2012-07-30 11:00:00	AMZN	Stock	11.7975	11.825	11.7035	11.8205	10132960.0
2012-07-30 12:00:00	AMZN	Stock	11.8225	11.825	11.725	11.7645	6842960.0
2012-07-30 13:00:00	AMZN	Stock	11.7645	11.794	11.7405	11.744	4453240.0
2012-07-30 14:00:00	AMZN	Stock	11.748	11.857	11.7365	11.8376	7396400.0
2012-07-30 15:00:00	AMZN	Stock	11.841	11.841	11.7735	11.811	8950300.0
2012-07-30 16:00:00	AMZN	Stock	11.8045	11.8251	11.792	11.792	1645040.0
2012-07-30 17:00:00	AMZN	Stock	11.8045	11.8085	11.8045	11.8075	23480.0

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

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