PREVIEW / stock_1hour / 2012-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-10.parquet
  size:    930 KB
  rows:    43,910
  symbols: 3,505

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-10 04:00:00	AAPL	Stock	21.8775	21.8789	21.8775	21.8775	19600.0
2012-07-10 05:00:00	AAPL	Stock	21.9657	22.0321	21.965	22.0321	53172.0
2012-07-10 06:00:00	AAPL	Stock	21.9893	21.9893	21.9821	21.9893	120876.0
2012-07-10 07:00:00	AAPL	Stock	22.0139	22.0393	21.9625	22.0089	1715840.0
2012-07-10 08:00:00	AAPL	Stock	22.0039	22.0739	21.9682	22.0357	6646080.0
2012-07-10 09:00:00	AAPL	Stock	22.0346	22.1382	22.0286	22.063	89728240.0
2012-07-10 10:00:00	AAPL	Stock	22.0671	22.0996	21.9468	21.9671	93569840.0
2012-07-10 11:00:00	AAPL	Stock	21.9675	21.9839	21.8571	21.9525	65406460.0
2012-07-10 12:00:00	AAPL	Stock	21.9546	21.9907	21.8839	21.9479	32571168.0
2012-07-10 13:00:00	AAPL	Stock	21.9493	21.9961	21.9021	21.9321	35479276.0
2012-07-10 14:00:00	AAPL	Stock	21.9304	21.9336	21.6821	21.7146	81386508.0
2012-07-10 15:00:00	AAPL	Stock	21.7143	21.7946	21.6182	21.7196	86621892.0
2012-07-10 16:00:00	AAPL	Stock	21.7196	21.987	21.6607	21.7136	9877980.0
2012-07-10 17:00:00	AAPL	Stock	21.7218	21.7218	21.6857	21.6857	894040.0
2012-07-10 18:00:00	AAPL	Stock	21.6954	21.6964	21.645	21.6532	430416.0
2012-07-10 19:00:00	AAPL	Stock	21.6536	21.6671	21.6393	21.6571	344400.0
2012-07-10 07:00:00	MSFT	Stock	30.14	30.15	30.14	30.15	1300.0
2012-07-10 08:00:00	MSFT	Stock	30.06	30.2	29.97	30.13	31570.0
2012-07-10 09:00:00	MSFT	Stock	30.15	30.22	30.05	30.15	4012800.0
2012-07-10 10:00:00	MSFT	Stock	30.16	30.17	29.78	29.825	5891154.0
2012-07-10 11:00:00	MSFT	Stock	29.82	29.83	29.61	29.74	4945822.0
2012-07-10 12:00:00	MSFT	Stock	29.74	29.8	29.66	29.767	2836489.0
2012-07-10 13:00:00	MSFT	Stock	29.76	29.77	29.66	29.715	2418029.0
2012-07-10 14:00:00	MSFT	Stock	29.715	29.74	29.52	29.56	3456515.0
2012-07-10 15:00:00	MSFT	Stock	29.551	29.77	29.51	29.74	10286656.0
2012-07-10 16:00:00	MSFT	Stock	29.74	30.05	29.535	29.8	2389331.0
2012-07-10 17:00:00	MSFT	Stock	29.74	29.75	29.74	29.75	165780.0
2012-07-10 18:00:00	MSFT	Stock	29.75	29.79	29.75	29.79	2574.0
2012-07-10 19:00:00	MSFT	Stock	29.75	29.78	29.75	29.76	2620.0
2012-07-10 08:00:00	NVDA	Stock	0.329	0.329	0.3288	0.329	418000.0
2012-07-10 09:00:00	NVDA	Stock	0.329	0.3368	0.3265	0.3298	81571840.0
2012-07-10 10:00:00	NVDA	Stock	0.3295	0.3298	0.323	0.3248	82233840.0
2012-07-10 11:00:00	NVDA	Stock	0.3246	0.325	0.323	0.3245	53004560.0
2012-07-10 12:00:00	NVDA	Stock	0.3245	0.3255	0.3238	0.324	34447680.0
2012-07-10 13:00:00	NVDA	Stock	0.324	0.3254	0.3218	0.3218	49001080.0
2012-07-10 14:00:00	NVDA	Stock	0.322	0.323	0.3188	0.319	51020600.0
2012-07-10 15:00:00	NVDA	Stock	0.319	0.3209	0.318	0.3205	115927120.0
2012-07-10 16:00:00	NVDA	Stock	0.3203	0.3303	0.319	0.3208	5067080.0
2012-07-10 17:00:00	NVDA	Stock	0.3205	0.3205	0.3205	0.3205	692000.0
2012-07-10 18:00:00	NVDA	Stock	0.3203	0.3203	0.3203	0.3203	8000.0
2012-07-10 07:00:00	AMZN	Stock	11.3475	11.372	11.303	11.3255	45400.0
2012-07-10 08:00:00	AMZN	Stock	11.2895	11.291	11.2895	11.2895	16460.0
2012-07-10 09:00:00	AMZN	Stock	11.289	11.357	11.24	11.284	6140300.0
2012-07-10 10:00:00	AMZN	Stock	11.284	11.288	11.15	11.1748	10354160.0
2012-07-10 11:00:00	AMZN	Stock	11.17	11.1815	11.0985	11.1305	7321840.0
2012-07-10 12:00:00	AMZN	Stock	11.1265	11.213	11.125	11.1565	6778420.0
2012-07-10 13:00:00	AMZN	Stock	11.16	11.1744	11.107	11.1105	4167000.0
2012-07-10 14:00:00	AMZN	Stock	11.112	11.1155	10.9605	10.9855	9795420.0
2012-07-10 15:00:00	AMZN	Stock	10.9795	11.017	10.914	10.9735	12110960.0
2012-07-10 16:00:00	AMZN	Stock	10.975	11.0062	10.9535	10.955	550000.0

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

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