PREVIEW / stock_1hour / 2012-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-08.parquet
  size:    935 KB
  rows:    44,225
  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
2012-11-08 04:00:00	AAPL	Stock	20.0011	20.0011	20.0011	20.0011	2800.0
2012-11-08 05:00:00	AAPL	Stock	19.9736	20.1082	19.9643	20.1071	335720.0
2012-11-08 06:00:00	AAPL	Stock	20.0932	20.0932	20.0214	20.0214	117040.0
2012-11-08 07:00:00	AAPL	Stock	20.0357	20.1318	20.025	20.1036	1070020.0
2012-11-08 08:00:00	AAPL	Stock	20.0886	20.1454	20.0636	20.1057	3399816.0
2012-11-08 09:00:00	AAPL	Stock	20.1071	20.1079	19.735	19.8493	124747140.0
2012-11-08 10:00:00	AAPL	Stock	19.8543	19.8743	19.3279	19.5796	277066972.0
2012-11-08 11:00:00	AAPL	Stock	19.5832	19.7136	19.4443	19.7068	129124240.0
2012-11-08 12:00:00	AAPL	Stock	19.7136	19.7171	19.425	19.4957	94099236.0
2012-11-08 13:00:00	AAPL	Stock	19.4926	19.5339	19.3214	19.5154	99016316.0
2012-11-08 14:00:00	AAPL	Stock	19.5164	19.5314	19.2625	19.4168	100556316.0
2012-11-08 15:00:00	AAPL	Stock	19.4175	19.4175	19.1175	19.2082	167324864.0
2012-11-08 16:00:00	AAPL	Stock	19.2016	19.9282	19.1793	19.2532	28516824.0
2012-11-08 17:00:00	AAPL	Stock	19.2504	19.2675	19.2054	19.2518	1058848.0
2012-11-08 18:00:00	AAPL	Stock	19.25	19.2607	19.2132	19.2143	556696.0
2012-11-08 19:00:00	AAPL	Stock	19.2068	19.2339	19.1946	19.2036	1029560.0
2012-11-08 08:00:00	MSFT	Stock	29.26	29.26	29.16	29.18	69561.0
2012-11-08 09:00:00	MSFT	Stock	29.18	29.37	29.11	29.27	4601583.0
2012-11-08 10:00:00	MSFT	Stock	29.28	29.34	29.1	29.16	6653464.0
2012-11-08 11:00:00	MSFT	Stock	29.175	29.2	29.07	29.12	6019235.0
2012-11-08 12:00:00	MSFT	Stock	29.11	29.13	29.03	29.115	6087583.0
2012-11-08 13:00:00	MSFT	Stock	29.116	29.12	29.0	29.105	5905049.0
2012-11-08 14:00:00	MSFT	Stock	29.105	29.11	28.95	28.97	7613039.0
2012-11-08 15:00:00	MSFT	Stock	28.97	29.02	28.8	28.82	9879972.0
2012-11-08 16:00:00	MSFT	Stock	28.81	29.172	28.76	28.81	1890943.0
2012-11-08 17:00:00	MSFT	Stock	28.83	28.88	28.83	28.88	2293.0
2012-11-08 18:00:00	MSFT	Stock	28.87	28.9	28.87	28.9	4045.0
2012-11-08 19:00:00	MSFT	Stock	28.88	28.9	28.88	28.9	5462.0
2012-11-08 08:00:00	NVDA	Stock	0.3185	0.3198	0.3185	0.3198	82000.0
2012-11-08 09:00:00	NVDA	Stock	0.3185	0.3245	0.3163	0.3208	85466040.0
2012-11-08 10:00:00	NVDA	Stock	0.3208	0.3233	0.3185	0.3199	93617560.0
2012-11-08 11:00:00	NVDA	Stock	0.3199	0.3215	0.318	0.3194	52547720.0
2012-11-08 12:00:00	NVDA	Stock	0.3193	0.3193	0.3163	0.318	35521000.0
2012-11-08 13:00:00	NVDA	Stock	0.318	0.3244	0.3166	0.3235	91318680.0
2012-11-08 14:00:00	NVDA	Stock	0.3235	0.327	0.3205	0.3218	138360200.0
2012-11-08 15:00:00	NVDA	Stock	0.3218	0.3238	0.3163	0.3172	293583240.0
2012-11-08 16:00:00	NVDA	Stock	0.317	0.3275	0.305	0.3213	33514200.0
2012-11-08 17:00:00	NVDA	Stock	0.3213	0.325	0.3198	0.3225	5334080.0
2012-11-08 18:00:00	NVDA	Stock	0.3225	0.3238	0.3178	0.3188	1422000.0
2012-11-08 19:00:00	NVDA	Stock	0.3178	0.3225	0.3175	0.318	383720.0
2012-11-08 07:00:00	AMZN	Stock	11.625	11.625	11.625	11.625	4000.0
2012-11-08 08:00:00	AMZN	Stock	11.644	11.669	11.644	11.65	123960.0
2012-11-08 09:00:00	AMZN	Stock	11.657	11.6725	11.6	11.639	5749320.0
2012-11-08 10:00:00	AMZN	Stock	11.6355	11.643	11.5005	11.5195	10897300.0
2012-11-08 11:00:00	AMZN	Stock	11.5235	11.549	11.4645	11.5108	8430100.0
2012-11-08 12:00:00	AMZN	Stock	11.5105	11.515	11.4595	11.4715	5678900.0
2012-11-08 13:00:00	AMZN	Stock	11.475	11.4875	11.406	11.454	7421620.0
2012-11-08 14:00:00	AMZN	Stock	11.454	11.479	11.4105	11.425	5025320.0
2012-11-08 15:00:00	AMZN	Stock	11.423	11.4315	11.355	11.3735	13242200.0
2012-11-08 16:00:00	AMZN	Stock	11.3675	11.5945	11.3445	11.347	790620.0

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

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