PREVIEW / stock_1hour / 2011-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-13.parquet
  size:    939 KB
  rows:    44,657
  symbols: 3,534

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
2011-07-13 04:00:00	AAPL	Stock	12.7129	12.7132	12.6964	12.7018	30800.0
2011-07-13 05:00:00	AAPL	Stock	12.7018	12.7475	12.7018	12.7475	49000.0
2011-07-13 06:00:00	AAPL	Stock	12.7179	12.7429	12.7179	12.725	45360.0
2011-07-13 07:00:00	AAPL	Stock	12.7254	12.8	12.725	12.7768	520604.0
2011-07-13 08:00:00	AAPL	Stock	12.7707	12.7839	12.7443	12.7482	1839628.0
2011-07-13 09:00:00	AAPL	Stock	12.75	12.8354	12.7361	12.7725	78813896.0
2011-07-13 10:00:00	AAPL	Stock	12.7718	12.8496	12.7707	12.8473	72069256.0
2011-07-13 11:00:00	AAPL	Stock	12.8475	12.8571	12.8268	12.8418	47553100.0
2011-07-13 12:00:00	AAPL	Stock	12.8421	12.8436	12.8071	12.81	26668572.0
2011-07-13 13:00:00	AAPL	Stock	12.8093	12.8311	12.7939	12.8125	29056048.0
2011-07-13 14:00:00	AAPL	Stock	12.8125	12.8279	12.7814	12.8207	32093740.0
2011-07-13 15:00:00	AAPL	Stock	12.8204	12.8268	12.7279	12.7907	89039160.0
2011-07-13 16:00:00	AAPL	Stock	12.7893	12.8076	12.7504	12.8032	9849728.0
2011-07-13 17:00:00	AAPL	Stock	12.8	12.8	12.6964	12.7136	1312444.0
2011-07-13 18:00:00	AAPL	Stock	12.7143	12.7864	12.7129	12.7375	460432.0
2011-07-13 19:00:00	AAPL	Stock	12.74	12.7464	12.72	12.725	297248.0
2011-07-13 06:00:00	MSFT	Stock	26.7	26.7	26.7	26.7	250.0
2011-07-13 07:00:00	MSFT	Stock	26.65	26.68	26.65	26.68	300.0
2011-07-13 08:00:00	MSFT	Stock	26.71	26.72	24.0	26.61	97866.0
2011-07-13 09:00:00	MSFT	Stock	26.6	26.75	26.57	26.71	4099049.0
2011-07-13 10:00:00	MSFT	Stock	26.7	26.96	26.7	26.91	7979627.0
2011-07-13 11:00:00	MSFT	Stock	26.92	26.939	26.84	26.89	3699021.0
2011-07-13 12:00:00	MSFT	Stock	26.89	26.9	26.82	26.851	3387589.0
2011-07-13 13:00:00	MSFT	Stock	26.853	26.9	26.76	26.77	4052199.0
2011-07-13 14:00:00	MSFT	Stock	26.78	26.85	26.69	26.76	4534333.0
2011-07-13 15:00:00	MSFT	Stock	26.76	26.8	26.51	26.64	9144649.0
2011-07-13 16:00:00	MSFT	Stock	26.64	26.827	26.562	26.6	3111571.0
2011-07-13 17:00:00	MSFT	Stock	26.54	26.62	26.45	26.58	28372.0
2011-07-13 18:00:00	MSFT	Stock	26.52	26.63	26.46	26.46	10168.0
2011-07-13 19:00:00	MSFT	Stock	26.55	26.55	26.46	26.48	3500.0
2011-07-13 08:00:00	NVDA	Stock	0.3725	0.3725	0.37	0.37	44000.0
2011-07-13 09:00:00	NVDA	Stock	0.3713	0.3725	0.363	0.3631	86455400.0
2011-07-13 10:00:00	NVDA	Stock	0.3632	0.3728	0.363	0.3723	148858240.0
2011-07-13 11:00:00	NVDA	Stock	0.3724	0.3738	0.3718	0.3725	67545280.0
2011-07-13 12:00:00	NVDA	Stock	0.3725	0.3748	0.3718	0.3743	62038760.0
2011-07-13 13:00:00	NVDA	Stock	0.3743	0.3745	0.3715	0.3718	41089840.0
2011-07-13 14:00:00	NVDA	Stock	0.372	0.372	0.369	0.371	73090280.0
2011-07-13 15:00:00	NVDA	Stock	0.3708	0.371	0.365	0.3662	137753760.0
2011-07-13 16:00:00	NVDA	Stock	0.3662	0.3694	0.3642	0.3671	13981000.0
2011-07-13 17:00:00	NVDA	Stock	0.3658	0.3658	0.364	0.364	134920.0
2011-07-13 18:00:00	NVDA	Stock	0.3662	0.367	0.3662	0.367	172000.0
2011-07-13 19:00:00	NVDA	Stock	0.3662	0.3662	0.3662	0.3662	4000.0
2011-07-13 04:00:00	AMZN	Stock	10.626	10.6795	10.626	10.6795	6000.0
2011-07-13 05:00:00	AMZN	Stock	10.7	10.725	10.7	10.725	28000.0
2011-07-13 06:00:00	AMZN	Stock	10.799	10.799	10.7	10.725	8000.0
2011-07-13 07:00:00	AMZN	Stock	10.6925	10.725	10.6925	10.7025	44660.0
2011-07-13 08:00:00	AMZN	Stock	10.71	10.7335	10.679	10.7	365300.0
2011-07-13 09:00:00	AMZN	Stock	10.685	10.75	10.655	10.6675	12763240.0
2011-07-13 10:00:00	AMZN	Stock	10.6675	10.7475	10.607	10.745	16961640.0
2011-07-13 11:00:00	AMZN	Stock	10.7425	10.8125	10.7165	10.793	11562680.0

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

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