PREVIEW / stock_1hour / 2011-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-17.parquet
  size:    923 KB
  rows:    43,892
  symbols: 3,499

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-11-17 05:00:00	AAPL	Stock	13.7143	13.7143	13.7143	13.7143	2800.0
2011-11-17 06:00:00	AAPL	Stock	13.7264	13.7264	13.6893	13.6893	28000.0
2011-11-17 07:00:00	AAPL	Stock	13.6893	13.7143	13.6643	13.7046	266812.0
2011-11-17 08:00:00	AAPL	Stock	13.7118	13.7418	13.6886	13.7207	2566536.0
2011-11-17 09:00:00	AAPL	Stock	13.7189	13.7646	13.6429	13.6997	49602700.0
2011-11-17 10:00:00	AAPL	Stock	13.7032	13.7221	13.6471	13.6611	54759544.0
2011-11-17 11:00:00	AAPL	Stock	13.6643	13.6782	13.5971	13.6239	56604044.0
2011-11-17 12:00:00	AAPL	Stock	13.6236	13.6329	13.4107	13.4491	97680520.0
2011-11-17 13:00:00	AAPL	Stock	13.4525	13.5122	13.4161	13.4707	65422168.0
2011-11-17 14:00:00	AAPL	Stock	13.4668	13.5168	13.4318	13.4756	56368788.0
2011-11-17 15:00:00	AAPL	Stock	13.4746	13.4979	13.42	13.4789	81151840.0
2011-11-17 16:00:00	AAPL	Stock	13.4904	13.5399	13.4279	13.5	10753820.0
2011-11-17 17:00:00	AAPL	Stock	13.5096	13.5214	13.4789	13.4789	235508.0
2011-11-17 18:00:00	AAPL	Stock	13.5064	13.5064	13.4789	13.4793	232932.0
2011-11-17 19:00:00	AAPL	Stock	13.4821	13.5104	13.4821	13.5	98504.0
2011-11-17 04:00:00	MSFT	Stock	26.0	26.0	26.0	26.0	150.0
2011-11-17 06:00:00	MSFT	Stock	26.01	26.01	25.92	25.92	700.0
2011-11-17 07:00:00	MSFT	Stock	25.9	25.96	25.84	25.93	11435.0
2011-11-17 08:00:00	MSFT	Stock	26.0	26.12	25.5	26.0	620734.0
2011-11-17 09:00:00	MSFT	Stock	26.03	26.12	25.87	25.94	5229919.0
2011-11-17 10:00:00	MSFT	Stock	25.93	25.99	25.85	25.915	7582758.0
2011-11-17 11:00:00	MSFT	Stock	25.92	25.958	25.81	25.889	6442369.0
2011-11-17 12:00:00	MSFT	Stock	25.89	25.92	25.6	25.72	10986026.0
2011-11-17 13:00:00	MSFT	Stock	25.72	25.74	25.56	25.669	8577306.0
2011-11-17 14:00:00	MSFT	Stock	25.65	25.658	25.49	25.595	9156965.0
2011-11-17 15:00:00	MSFT	Stock	25.59	25.64	25.44	25.57	15639035.0
2011-11-17 16:00:00	MSFT	Stock	25.58	25.945	25.455	25.6	3825440.0
2011-11-17 17:00:00	MSFT	Stock	26.07	26.07	25.54	25.54	36527.0
2011-11-17 18:00:00	MSFT	Stock	25.59	25.6	25.51	25.55	65674.0
2011-11-17 19:00:00	MSFT	Stock	25.6	25.6	25.59	25.59	600.0
2011-11-17 08:00:00	NVDA	Stock	0.365	0.3682	0.3625	0.3682	1784200.0
2011-11-17 09:00:00	NVDA	Stock	0.3675	0.3698	0.356	0.3602	64939560.0
2011-11-17 10:00:00	NVDA	Stock	0.36	0.361	0.3563	0.3572	76014760.0
2011-11-17 11:00:00	NVDA	Stock	0.3572	0.3585	0.3533	0.3562	86831760.0
2011-11-17 12:00:00	NVDA	Stock	0.356	0.3562	0.345	0.351	107618560.0
2011-11-17 13:00:00	NVDA	Stock	0.3508	0.3538	0.3485	0.353	83806480.0
2011-11-17 14:00:00	NVDA	Stock	0.353	0.3545	0.3502	0.3525	70461760.0
2011-11-17 15:00:00	NVDA	Stock	0.3522	0.3538	0.3495	0.3515	139369000.0
2011-11-17 16:00:00	NVDA	Stock	0.3518	0.354	0.3502	0.3515	8478040.0
2011-11-17 17:00:00	NVDA	Stock	0.352	0.354	0.3518	0.354	72000.0
2011-11-17 18:00:00	NVDA	Stock	0.3538	0.3538	0.3528	0.3528	101200.0
2011-11-17 19:00:00	NVDA	Stock	0.3525	0.3535	0.352	0.3535	68000.0
2011-11-17 06:00:00	AMZN	Stock	10.545	10.552	10.545	10.552	4000.0
2011-11-17 07:00:00	AMZN	Stock	10.535	10.609	10.5155	10.609	60000.0
2011-11-17 08:00:00	AMZN	Stock	10.6	10.64	10.568	10.599	738000.0
2011-11-17 09:00:00	AMZN	Stock	10.605	10.685	10.4305	10.4781	18837440.0
2011-11-17 10:00:00	AMZN	Stock	10.48	10.5	10.3545	10.3575	23437280.0
2011-11-17 11:00:00	AMZN	Stock	10.3585	10.379	10.2935	10.3165	18324000.0
2011-11-17 12:00:00	AMZN	Stock	10.3185	10.3235	10.1255	10.2238	26013460.0
2011-11-17 13:00:00	AMZN	Stock	10.2226	10.2226	10.105	10.1909	19716780.0

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

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