PREVIEW / stock_1hour / 2011-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-27.parquet
  size:    933 KB
  rows:    44,751
  symbols: 3,548

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-09-27 04:00:00	AAPL	Stock	14.4854	14.5357	14.4854	14.5357	81200.0
2011-09-27 05:00:00	AAPL	Stock	14.5179	14.535	14.5107	14.5107	28252.0
2011-09-27 06:00:00	AAPL	Stock	14.5179	14.5589	14.5179	14.5357	126588.0
2011-09-27 07:00:00	AAPL	Stock	14.5357	14.6286	14.5357	14.6193	1015420.0
2011-09-27 08:00:00	AAPL	Stock	14.6079	14.625	14.5889	14.5982	4743732.0
2011-09-27 09:00:00	AAPL	Stock	14.5986	14.6214	14.4821	14.5411	105991060.0
2011-09-27 10:00:00	AAPL	Stock	14.5411	14.5668	14.4321	14.565	99836660.0
2011-09-27 11:00:00	AAPL	Stock	14.5621	14.5657	14.4554	14.4825	66408468.0
2011-09-27 12:00:00	AAPL	Stock	14.4875	14.5157	14.3139	14.4057	81855508.0
2011-09-27 13:00:00	AAPL	Stock	14.4071	14.5339	14.3771	14.5146	63688576.0
2011-09-27 14:00:00	AAPL	Stock	14.5143	14.525	14.3968	14.4157	59642688.0
2011-09-27 15:00:00	AAPL	Stock	14.4157	14.4561	14.2164	14.2593	135234232.0
2011-09-27 16:00:00	AAPL	Stock	14.2764	14.4512	14.25	14.3143	9942324.0
2011-09-27 17:00:00	AAPL	Stock	14.3193	14.3193	14.2836	14.2861	617316.0
2011-09-27 18:00:00	AAPL	Stock	14.2911	14.2946	14.2593	14.2614	682472.0
2011-09-27 19:00:00	AAPL	Stock	14.2625	14.2664	14.2525	14.2618	422800.0
2011-09-27 06:00:00	MSFT	Stock	25.75	25.75	25.62	25.62	950.0
2011-09-27 07:00:00	MSFT	Stock	25.63	25.89	25.57	25.8	29198.0
2011-09-27 08:00:00	MSFT	Stock	25.79	25.85	25.73	25.75	38405.0
2011-09-27 09:00:00	MSFT	Stock	25.75	25.81	25.5	25.74	6341615.0
2011-09-27 10:00:00	MSFT	Stock	25.73	25.82	25.45	25.55	10109551.0
2011-09-27 11:00:00	MSFT	Stock	25.56	25.69	25.53	25.58	6354396.0
2011-09-27 12:00:00	MSFT	Stock	25.575	25.76	25.56	25.665	4053708.0
2011-09-27 13:00:00	MSFT	Stock	25.67	25.88	25.64	25.84	4352574.0
2011-09-27 14:00:00	MSFT	Stock	25.84	25.92	25.78	25.845	4919356.0
2011-09-27 15:00:00	MSFT	Stock	25.841	25.845	25.48	25.67	14974302.0
2011-09-27 16:00:00	MSFT	Stock	25.68	25.77	25.44	25.63	2832861.0
2011-09-27 17:00:00	MSFT	Stock	25.69	25.69	25.65	25.65	650.0
2011-09-27 18:00:00	MSFT	Stock	25.65	25.69	25.56	25.56	13977.0
2011-09-27 19:00:00	MSFT	Stock	25.67	25.67	25.63	25.64	1000.0
2011-09-27 07:00:00	NVDA	Stock	0.3508	0.3508	0.3508	0.3508	20000.0
2011-09-27 08:00:00	NVDA	Stock	0.3508	0.3618	0.3502	0.355	6037320.0
2011-09-27 09:00:00	NVDA	Stock	0.3562	0.3575	0.3508	0.355	122772000.0
2011-09-27 10:00:00	NVDA	Stock	0.355	0.3565	0.3495	0.355	133152440.0
2011-09-27 11:00:00	NVDA	Stock	0.355	0.3553	0.3508	0.352	67401520.0
2011-09-27 12:00:00	NVDA	Stock	0.3522	0.3545	0.3513	0.3528	52852400.0
2011-09-27 13:00:00	NVDA	Stock	0.3528	0.3558	0.3522	0.3551	69475000.0
2011-09-27 14:00:00	NVDA	Stock	0.355	0.3562	0.3525	0.353	67586480.0
2011-09-27 15:00:00	NVDA	Stock	0.3528	0.3533	0.3433	0.3455	238658520.0
2011-09-27 16:00:00	NVDA	Stock	0.346	0.353	0.3453	0.35	20324880.0
2011-09-27 17:00:00	NVDA	Stock	0.3502	0.3502	0.3475	0.3502	916640.0
2011-09-27 18:00:00	NVDA	Stock	0.3482	0.3488	0.348	0.348	109360.0
2011-09-27 19:00:00	NVDA	Stock	0.348	0.348	0.348	0.348	38000.0
2011-09-27 04:00:00	AMZN	Stock	11.52	11.5645	11.52	11.5645	6000.0
2011-09-27 06:00:00	AMZN	Stock	11.645	11.645	11.645	11.645	4000.0
2011-09-27 07:00:00	AMZN	Stock	11.6	11.662	11.6	11.655	288200.0
2011-09-27 08:00:00	AMZN	Stock	11.65	11.724	11.6475	11.7025	1099400.0
2011-09-27 09:00:00	AMZN	Stock	11.7145	11.7375	11.3915	11.4385	33947320.0
2011-09-27 10:00:00	AMZN	Stock	11.4385	11.475	11.1425	11.4462	38789920.0
2011-09-27 11:00:00	AMZN	Stock	11.445	11.45	11.2318	11.3025	16637880.0

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

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