PREVIEW / stock_1hour / 2013-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-08.parquet
  size:    940 KB
  rows:    44,122
  symbols: 3,464

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
2013-02-08 04:00:00	AAPL	Stock	16.7221	16.7221	16.6729	16.7107	30660.0
2013-02-08 05:00:00	AAPL	Stock	16.7107	16.7214	16.7089	16.7214	43932.0
2013-02-08 06:00:00	AAPL	Stock	16.7214	16.7214	16.675	16.675	111664.0
2013-02-08 07:00:00	AAPL	Stock	16.675	16.8732	16.6607	16.8729	3969336.0
2013-02-08 08:00:00	AAPL	Stock	16.8664	16.8743	16.7857	16.8343	10757684.0
2013-02-08 09:00:00	AAPL	Stock	16.8343	16.9643	16.7946	16.9307	147503104.0
2013-02-08 10:00:00	AAPL	Stock	16.9289	17.0071	16.8486	17.0021	93897720.0
2013-02-08 11:00:00	AAPL	Stock	17.0016	17.0554	16.9814	17.0204	78429008.0
2013-02-08 12:00:00	AAPL	Stock	17.0239	17.0264	16.9168	16.9826	51590028.0
2013-02-08 13:00:00	AAPL	Stock	16.9867	17.0229	16.9479	16.9996	36287748.0
2013-02-08 14:00:00	AAPL	Stock	16.9996	17.1004	16.9921	17.055	75760020.0
2013-02-08 15:00:00	AAPL	Stock	17.0589	17.0857	16.94	16.9632	101289776.0
2013-02-08 16:00:00	AAPL	Stock	16.9636	17.0197	16.8719	16.9679	12573232.0
2013-02-08 17:00:00	AAPL	Stock	16.9664	16.9671	16.9629	16.9661	182868.0
2013-02-08 18:00:00	AAPL	Stock	16.9646	16.98	16.9646	16.9746	134148.0
2013-02-08 19:00:00	AAPL	Stock	16.9786	16.9921	16.9768	16.9875	348124.0
2013-02-08 07:00:00	MSFT	Stock	27.4	27.4	27.35	27.35	1000.0
2013-02-08 08:00:00	MSFT	Stock	27.38	27.39	27.28	27.28	63379.0
2013-02-08 09:00:00	MSFT	Stock	27.34	27.71	27.31	27.64	6810794.0
2013-02-08 10:00:00	MSFT	Stock	27.645	27.67	27.55	27.6	6669936.0
2013-02-08 11:00:00	MSFT	Stock	27.6	27.64	27.52	27.59	4115247.0
2013-02-08 12:00:00	MSFT	Stock	27.6	27.63	27.575	27.586	2352794.0
2013-02-08 13:00:00	MSFT	Stock	27.59	27.645	27.58	27.61	2254119.0
2013-02-08 14:00:00	MSFT	Stock	27.61	27.63	27.5	27.507	2570816.0
2013-02-08 15:00:00	MSFT	Stock	27.51	27.55	27.47	27.55	5813269.0
2013-02-08 16:00:00	MSFT	Stock	27.55	27.639	27.47	27.53	2317260.0
2013-02-08 18:00:00	MSFT	Stock	27.52	27.52	27.52	27.52	130.0
2013-02-08 19:00:00	MSFT	Stock	27.51	27.51	27.51	27.51	2000.0
2013-02-08 08:00:00	NVDA	Stock	0.309	0.309	0.309	0.309	4000.0
2013-02-08 09:00:00	NVDA	Stock	0.309	0.3118	0.3078	0.3098	45387360.0
2013-02-08 10:00:00	NVDA	Stock	0.3099	0.3113	0.3095	0.3113	44101240.0
2013-02-08 11:00:00	NVDA	Stock	0.3113	0.3113	0.308	0.308	31973680.0
2013-02-08 12:00:00	NVDA	Stock	0.308	0.3088	0.3073	0.3083	54172880.0
2013-02-08 13:00:00	NVDA	Stock	0.3083	0.309	0.3078	0.3084	32754440.0
2013-02-08 14:00:00	NVDA	Stock	0.3085	0.3088	0.3078	0.3081	25564040.0
2013-02-08 15:00:00	NVDA	Stock	0.3083	0.3095	0.308	0.309	60242440.0
2013-02-08 16:00:00	NVDA	Stock	0.3093	0.3093	0.3085	0.3085	12484760.0
2013-02-08 17:00:00	NVDA	Stock	0.3085	0.3085	0.3085	0.3085	80000.0
2013-02-08 18:00:00	NVDA	Stock	0.3093	0.3095	0.3093	0.3095	136000.0
2013-02-08 19:00:00	NVDA	Stock	0.3095	0.3095	0.3095	0.3095	22000.0
2013-02-08 07:00:00	AMZN	Stock	13.087	13.09	13.087	13.09	6000.0
2013-02-08 08:00:00	AMZN	Stock	13.075	13.076	13.0505	13.0505	21120.0
2013-02-08 09:00:00	AMZN	Stock	13.0675	13.19	13.0675	13.1795	8124420.0
2013-02-08 10:00:00	AMZN	Stock	13.178	13.2625	13.116	13.1535	14307760.0
2013-02-08 11:00:00	AMZN	Stock	13.151	13.181	13.1065	13.1125	6047360.0
2013-02-08 12:00:00	AMZN	Stock	13.111	13.1192	13.0278	13.11	9511460.0
2013-02-08 13:00:00	AMZN	Stock	13.1115	13.168	13.096	13.1165	11036040.0
2013-02-08 14:00:00	AMZN	Stock	13.1155	13.149	13.075	13.0925	11013340.0
2013-02-08 15:00:00	AMZN	Stock	13.095	13.118	13.0706	13.1	15022720.0
2013-02-08 16:00:00	AMZN	Stock	13.0975	13.1463	13.0895	13.095	2322680.0

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

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