PREVIEW / stock_1hour / 2012-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-16.parquet
  size:    949 KB
  rows:    44,801
  symbols: 3,473

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-11-16 04:00:00	AAPL	Stock	18.7179	18.75	18.6786	18.6786	26180.0
2012-11-16 05:00:00	AAPL	Stock	18.6614	18.6614	18.6304	18.6429	93212.0
2012-11-16 06:00:00	AAPL	Stock	18.6243	18.695	18.6243	18.695	142632.0
2012-11-16 07:00:00	AAPL	Stock	18.7068	18.8393	18.7068	18.8214	868700.0
2012-11-16 08:00:00	AAPL	Stock	18.8079	18.9679	18.7146	18.8361	3742984.0
2012-11-16 09:00:00	AAPL	Stock	18.8368	18.8661	18.4464	18.5296	175985404.0
2012-11-16 10:00:00	AAPL	Stock	18.5336	18.5714	18.3397	18.3979	190920604.0
2012-11-16 11:00:00	AAPL	Stock	18.3968	18.55	18.0625	18.5469	246308860.0
2012-11-16 12:00:00	AAPL	Stock	18.5486	18.9286	18.5214	18.775	242510436.0
2012-11-16 13:00:00	AAPL	Stock	18.7843	18.8786	18.6204	18.8518	113417108.0
2012-11-16 14:00:00	AAPL	Stock	18.8484	18.8657	18.56	18.7489	109944660.0
2012-11-16 15:00:00	AAPL	Stock	18.7446	18.8896	18.6611	18.8454	146257524.0
2012-11-16 16:00:00	AAPL	Stock	18.8425	18.9439	18.3571	18.9293	18669420.0
2012-11-16 17:00:00	AAPL	Stock	18.9293	18.935	18.8457	18.8946	2887892.0
2012-11-16 18:00:00	AAPL	Stock	18.8943	18.9221	18.8811	18.8811	767004.0
2012-11-16 19:00:00	AAPL	Stock	18.8893	18.9139	18.8807	18.9139	458080.0
2012-11-16 07:00:00	MSFT	Stock	26.66	26.7	26.66	26.7	2800.0
2012-11-16 08:00:00	MSFT	Stock	26.7	26.8	26.7	26.73	34942.0
2012-11-16 09:00:00	MSFT	Stock	26.73	26.8	26.46	26.535	13047579.0
2012-11-16 10:00:00	MSFT	Stock	26.54	26.55	26.41	26.473	11089520.0
2012-11-16 11:00:00	MSFT	Stock	26.475	26.54	26.36	26.535	8509194.0
2012-11-16 12:00:00	MSFT	Stock	26.54	26.65	26.51	26.57	7903450.0
2012-11-16 13:00:00	MSFT	Stock	26.56	26.63	26.5	26.56	2968355.0
2012-11-16 14:00:00	MSFT	Stock	26.55	26.57	26.41	26.492	4567647.0
2012-11-16 15:00:00	MSFT	Stock	26.5	26.67	26.46	26.53	9532854.0
2012-11-16 16:00:00	MSFT	Stock	26.525	26.57	26.471	26.55	5382367.0
2012-11-16 17:00:00	MSFT	Stock	26.55	26.7	26.55	26.57	6740.0
2012-11-16 18:00:00	MSFT	Stock	26.56	26.6	26.56	26.6	4315.0
2012-11-16 19:00:00	MSFT	Stock	26.56	26.56	26.56	26.56	1204.0
2012-11-16 09:00:00	NVDA	Stock	0.2898	0.2908	0.2838	0.285	111479440.0
2012-11-16 10:00:00	NVDA	Stock	0.2848	0.2868	0.2825	0.285	112552360.0
2012-11-16 11:00:00	NVDA	Stock	0.2848	0.2848	0.2788	0.2825	88281680.0
2012-11-16 12:00:00	NVDA	Stock	0.2828	0.2855	0.2815	0.2848	54349080.0
2012-11-16 13:00:00	NVDA	Stock	0.2848	0.2852	0.2818	0.2829	40375320.0
2012-11-16 14:00:00	NVDA	Stock	0.2829	0.2838	0.2812	0.283	50202800.0
2012-11-16 15:00:00	NVDA	Stock	0.283	0.2868	0.2828	0.2842	115298240.0
2012-11-16 16:00:00	NVDA	Stock	0.2845	0.2846	0.284	0.2845	6413160.0
2012-11-16 17:00:00	NVDA	Stock	0.2848	0.2848	0.2848	0.2848	28000.0
2012-11-16 18:00:00	NVDA	Stock	0.2858	0.2858	0.2858	0.2858	40000.0
2012-11-16 19:00:00	NVDA	Stock	0.2868	0.2868	0.285	0.285	39280.0
2012-11-16 06:00:00	AMZN	Stock	11.0625	11.0625	11.0625	11.0625	2000.0
2012-11-16 07:00:00	AMZN	Stock	11.069	11.069	11.069	11.069	2000.0
2012-11-16 08:00:00	AMZN	Stock	11.067	11.1375	11.067	11.115	126200.0
2012-11-16 09:00:00	AMZN	Stock	11.125	11.125	10.932	11.0355	13850080.0
2012-11-16 10:00:00	AMZN	Stock	11.0305	11.19	10.965	11.1025	16841900.0
2012-11-16 11:00:00	AMZN	Stock	11.103	11.224	11.017	11.222	10624480.0
2012-11-16 12:00:00	AMZN	Stock	11.2225	11.3125	11.209	11.252	11204240.0
2012-11-16 13:00:00	AMZN	Stock	11.2525	11.308	11.232	11.2935	5726320.0
2012-11-16 14:00:00	AMZN	Stock	11.2905	11.297	11.1965	11.2285	8213460.0
2012-11-16 15:00:00	AMZN	Stock	11.23	11.3095	11.204	11.262	15061940.0

> showing 50 of 44,801 rows — these rows as CSV

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