PREVIEW / stock_1hour / 2012-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-02.parquet
  size:    951 KB
  rows:    45,073
  symbols: 3,552

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-05-02 04:00:00	AAPL	Stock	20.8214	20.8214	20.7611	20.7611	54600.0
2012-05-02 05:00:00	AAPL	Stock	20.7939	20.7939	20.7571	20.7571	11200.0
2012-05-02 06:00:00	AAPL	Stock	20.75	20.7704	20.75	20.7704	11200.0
2012-05-02 07:00:00	AAPL	Stock	20.7268	20.83	20.7268	20.8179	215628.0
2012-05-02 08:00:00	AAPL	Stock	20.8196	20.8214	20.7232	20.7446	3150672.0
2012-05-02 09:00:00	AAPL	Stock	20.7446	20.9786	20.67	20.8929	96331144.0
2012-05-02 10:00:00	AAPL	Stock	20.8918	20.9121	20.6964	20.8696	97765808.0
2012-05-02 11:00:00	AAPL	Stock	20.8647	20.9643	20.8236	20.8604	65380700.0
2012-05-02 12:00:00	AAPL	Stock	20.865	20.935	20.8293	20.8596	31359300.0
2012-05-02 13:00:00	AAPL	Stock	20.8604	20.8957	20.7893	20.8664	29302560.0
2012-05-02 14:00:00	AAPL	Stock	20.8664	20.9325	20.8475	20.8625	36692656.0
2012-05-02 15:00:00	AAPL	Stock	20.865	20.93	20.8161	20.9286	47931408.0
2012-05-02 16:00:00	AAPL	Stock	20.9282	20.9539	20.7904	20.9464	10312904.0
2012-05-02 17:00:00	AAPL	Stock	20.9432	20.9521	20.8781	20.9396	484092.0
2012-05-02 18:00:00	AAPL	Stock	20.9418	20.9464	20.9325	20.9457	98140.0
2012-05-02 19:00:00	AAPL	Stock	20.9429	20.9546	20.9429	20.9546	193564.0
2012-05-02 07:00:00	MSFT	Stock	31.9	31.95	31.86	31.95	1300.0
2012-05-02 08:00:00	MSFT	Stock	31.91	31.91	31.8	31.86	12412.0
2012-05-02 09:00:00	MSFT	Stock	31.81	31.925	31.78	31.79	4292654.0
2012-05-02 10:00:00	MSFT	Stock	31.785	31.85	31.64	31.698	7289730.0
2012-05-02 11:00:00	MSFT	Stock	31.7	31.77	31.65	31.74	3654023.0
2012-05-02 12:00:00	MSFT	Stock	31.74	31.8	31.69	31.75	2837336.0
2012-05-02 13:00:00	MSFT	Stock	31.76	31.78	31.68	31.745	2803223.0
2012-05-02 14:00:00	MSFT	Stock	31.74	31.82	31.7	31.705	3489934.0
2012-05-02 15:00:00	MSFT	Stock	31.705	31.81	31.66	31.8	9663830.0
2012-05-02 16:00:00	MSFT	Stock	31.79	32.01	31.71	31.8	2990657.0
2012-05-02 17:00:00	MSFT	Stock	31.758	31.84	31.758	31.8	25617.0
2012-05-02 18:00:00	MSFT	Stock	31.82	31.83	31.82	31.83	860.0
2012-05-02 19:00:00	MSFT	Stock	31.82	31.82	31.81	31.81	2188.0
2012-05-02 08:00:00	NVDA	Stock	0.3308	0.3308	0.3308	0.3308	8000.0
2012-05-02 09:00:00	NVDA	Stock	0.3293	0.3308	0.327	0.3284	28824760.0
2012-05-02 10:00:00	NVDA	Stock	0.3285	0.3288	0.322	0.322	125260080.0
2012-05-02 11:00:00	NVDA	Stock	0.3223	0.324	0.3215	0.3225	99070680.0
2012-05-02 12:00:00	NVDA	Stock	0.3225	0.323	0.3213	0.3218	83089080.0
2012-05-02 13:00:00	NVDA	Stock	0.322	0.3225	0.3203	0.3214	107273560.0
2012-05-02 14:00:00	NVDA	Stock	0.3214	0.322	0.321	0.3218	68732800.0
2012-05-02 15:00:00	NVDA	Stock	0.3215	0.322	0.3195	0.3213	154021120.0
2012-05-02 16:00:00	NVDA	Stock	0.321	0.3224	0.3198	0.3203	14751480.0
2012-05-02 17:00:00	NVDA	Stock	0.3253	0.3253	0.3183	0.3183	882040.0
2012-05-02 19:00:00	NVDA	Stock	0.3213	0.3213	0.3213	0.3213	43320.0
2012-05-02 08:00:00	AMZN	Stock	11.465	11.4675	11.377	11.4	668060.0
2012-05-02 09:00:00	AMZN	Stock	11.3975	11.5425	11.37	11.5387	14182140.0
2012-05-02 10:00:00	AMZN	Stock	11.536	11.5388	11.423	11.4421	18261200.0
2012-05-02 11:00:00	AMZN	Stock	11.445	11.5635	11.441	11.5095	12216620.0
2012-05-02 12:00:00	AMZN	Stock	11.514	11.572	11.4946	11.5045	8803500.0
2012-05-02 13:00:00	AMZN	Stock	11.5	11.534	11.4775	11.515	6714480.0
2012-05-02 14:00:00	AMZN	Stock	11.5155	11.532	11.452	11.46	8224120.0
2012-05-02 15:00:00	AMZN	Stock	11.46	11.528	11.4255	11.5165	15757960.0
2012-05-02 16:00:00	AMZN	Stock	11.517	11.5325	11.4854	11.5175	4043640.0
2012-05-02 17:00:00	AMZN	Stock	11.505	11.5325	11.505	11.53	37300.0

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

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