PREVIEW / stock_1hour / 2012-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-11.parquet
  size:    908 KB
  rows:    43,344
  symbols: 3,466

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-07-11 04:00:00	AAPL	Stock	21.7536	21.7854	21.7536	21.7854	8400.0
2012-07-11 05:00:00	AAPL	Stock	21.8214	21.8214	21.8214	21.8214	2800.0
2012-07-11 06:00:00	AAPL	Stock	21.7946	21.7946	21.7911	21.7946	27580.0
2012-07-11 07:00:00	AAPL	Stock	21.7893	21.8179	21.6918	21.7093	1060108.0
2012-07-11 08:00:00	AAPL	Stock	21.7082	21.7418	21.6429	21.6629	2578632.0
2012-07-11 09:00:00	AAPL	Stock	21.6675	21.7036	21.5179	21.63	65382240.0
2012-07-11 10:00:00	AAPL	Stock	21.631	21.6904	21.4893	21.5036	56881216.0
2012-07-11 11:00:00	AAPL	Stock	21.5036	21.5857	21.4857	21.5568	34929048.0
2012-07-11 12:00:00	AAPL	Stock	21.5593	21.6396	21.5118	21.6354	26221076.0
2012-07-11 13:00:00	AAPL	Stock	21.6364	21.6364	21.5357	21.5923	23888088.0
2012-07-11 14:00:00	AAPL	Stock	21.5907	21.6175	21.3293	21.3618	98730520.0
2012-07-11 15:00:00	AAPL	Stock	21.3664	21.6307	21.3621	21.5868	90359920.0
2012-07-11 16:00:00	AAPL	Stock	21.5825	21.6018	21.4445	21.5982	62177136.0
2012-07-11 17:00:00	AAPL	Stock	21.5009	21.6554	21.4939	21.6329	943460.0
2012-07-11 18:00:00	AAPL	Stock	21.6346	21.6346	21.6196	21.6321	154308.0
2012-07-11 19:00:00	AAPL	Stock	21.6304	21.6425	21.625	21.6386	381668.0
2012-07-11 08:00:00	MSFT	Stock	29.89	29.89	29.8	29.8	3483.0
2012-07-11 09:00:00	MSFT	Stock	29.81	29.82	29.39	29.4	4005522.0
2012-07-11 10:00:00	MSFT	Stock	29.4	29.62	29.35	29.37	4715361.0
2012-07-11 11:00:00	MSFT	Stock	29.36	29.45	29.35	29.44	3392346.0
2012-07-11 12:00:00	MSFT	Stock	29.43	29.48	29.34	29.35	2890257.0
2012-07-11 13:00:00	MSFT	Stock	29.345	29.372	29.24	29.37	3624485.0
2012-07-11 14:00:00	MSFT	Stock	29.38	29.39	29.105	29.168	5839553.0
2012-07-11 15:00:00	MSFT	Stock	29.16	29.39	29.16	29.29	11073110.0
2012-07-11 16:00:00	MSFT	Stock	29.29	29.74	29.21	29.74	3457772.0
2012-07-11 17:00:00	MSFT	Stock	29.263	29.32	29.261	29.32	68963.0
2012-07-11 18:00:00	MSFT	Stock	29.32	29.32	29.3	29.3	1747.0
2012-07-11 19:00:00	MSFT	Stock	29.31	29.31	29.31	29.31	3000.0
2012-07-11 06:00:00	NVDA	Stock	0.3205	0.3205	0.3205	0.3205	4000.0
2012-07-11 08:00:00	NVDA	Stock	0.3225	0.3225	0.3205	0.3225	183600.0
2012-07-11 09:00:00	NVDA	Stock	0.322	0.324	0.3195	0.3225	40230480.0
2012-07-11 10:00:00	NVDA	Stock	0.3228	0.3255	0.318	0.3182	91133680.0
2012-07-11 11:00:00	NVDA	Stock	0.318	0.3203	0.318	0.3193	25555560.0
2012-07-11 12:00:00	NVDA	Stock	0.3195	0.3203	0.3188	0.3195	21291400.0
2012-07-11 13:00:00	NVDA	Stock	0.3195	0.3195	0.317	0.3185	27374400.0
2012-07-11 14:00:00	NVDA	Stock	0.3185	0.3193	0.3148	0.3149	90464560.0
2012-07-11 15:00:00	NVDA	Stock	0.3149	0.3163	0.3138	0.315	168666440.0
2012-07-11 16:00:00	NVDA	Stock	0.315	0.3205	0.3145	0.3152	9554960.0
2012-07-11 17:00:00	NVDA	Stock	0.3153	0.3155	0.3153	0.3155	121680.0
2012-07-11 18:00:00	NVDA	Stock	0.3155	0.3155	0.3155	0.3155	48000.0
2012-07-11 19:00:00	NVDA	Stock	0.3155	0.3155	0.315	0.315	164280.0
2012-07-11 08:00:00	AMZN	Stock	11.0	11.0	10.9535	10.9535	175200.0
2012-07-11 09:00:00	AMZN	Stock	10.955	11.0602	10.908	11.0125	7362420.0
2012-07-11 10:00:00	AMZN	Stock	11.0125	11.087	10.876	10.8925	12258560.0
2012-07-11 11:00:00	AMZN	Stock	10.8905	10.9525	10.8525	10.9365	6670780.0
2012-07-11 12:00:00	AMZN	Stock	10.9385	10.9575	10.88	10.9045	3462480.0
2012-07-11 13:00:00	AMZN	Stock	10.903	10.903	10.8266	10.8555	5466960.0
2012-07-11 14:00:00	AMZN	Stock	10.861	10.8655	10.767	10.8365	7710460.0
2012-07-11 15:00:00	AMZN	Stock	10.8395	10.933	10.8295	10.915	9148080.0
2012-07-11 16:00:00	AMZN	Stock	10.9185	10.9702	10.8276	10.9163	2006400.0

> showing 50 of 43,344 rows — these rows as CSV

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