PREVIEW / stock_1hour / 2013-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-08.parquet
  size:    968 KB
  rows:    45,373
  symbols: 3,492

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-04-08 04:00:00	AAPL	Stock	15.1779	15.2411	15.1779	15.2411	20104.0
2013-04-08 05:00:00	AAPL	Stock	15.2411	15.2468	15.2264	15.2468	47600.0
2013-04-08 06:00:00	AAPL	Stock	15.2321	15.2704	15.2321	15.2596	50540.0
2013-04-08 07:00:00	AAPL	Stock	15.25	15.33	15.1821	15.2611	613984.0
2013-04-08 08:00:00	AAPL	Stock	15.2525	15.3214	15.1539	15.1768	2627632.0
2013-04-08 09:00:00	AAPL	Stock	15.1768	15.2679	15.1429	15.2066	50785084.0
2013-04-08 10:00:00	AAPL	Stock	15.2061	15.2095	15.0986	15.1964	55366612.0
2013-04-08 11:00:00	AAPL	Stock	15.195	15.1954	15.09	15.1221	32256504.0
2013-04-08 12:00:00	AAPL	Stock	15.1222	15.1461	15.0889	15.125	24218432.0
2013-04-08 13:00:00	AAPL	Stock	15.125	15.2232	15.1089	15.2165	26162080.0
2013-04-08 14:00:00	AAPL	Stock	15.2168	15.2521	15.1714	15.1771	30586472.0
2013-04-08 15:00:00	AAPL	Stock	15.1782	15.2229	15.1654	15.2218	34717536.0
2013-04-08 16:00:00	AAPL	Stock	15.2218	15.2325	15.1479	15.2268	27992888.0
2013-04-08 17:00:00	AAPL	Stock	15.2321	15.2321	15.2161	15.2214	205016.0
2013-04-08 18:00:00	AAPL	Stock	15.225	15.225	15.215	15.2207	222992.0
2013-04-08 19:00:00	AAPL	Stock	15.2196	15.225	15.2196	15.2204	157388.0
2013-04-08 07:00:00	MSFT	Stock	28.79	28.79	28.79	28.79	100.0
2013-04-08 08:00:00	MSFT	Stock	28.77	28.8	28.6	28.77	6749.0
2013-04-08 09:00:00	MSFT	Stock	28.75	28.77	28.57	28.63	3352317.0
2013-04-08 10:00:00	MSFT	Stock	28.63	28.69	28.5	28.555	4521349.0
2013-04-08 11:00:00	MSFT	Stock	28.555	28.56	28.47	28.5	3978636.0
2013-04-08 12:00:00	MSFT	Stock	28.5	28.55	28.49	28.5	2690213.0
2013-04-08 13:00:00	MSFT	Stock	28.5	28.54	28.48	28.531	2915176.0
2013-04-08 14:00:00	MSFT	Stock	28.53	28.57	28.495	28.505	4771750.0
2013-04-08 15:00:00	MSFT	Stock	28.505	28.59	28.49	28.59	9638992.0
2013-04-08 16:00:00	MSFT	Stock	28.59	28.64	28.5	28.64	2198398.0
2013-04-08 17:00:00	MSFT	Stock	28.68	28.68	28.59	28.59	30165.0
2013-04-08 19:00:00	MSFT	Stock	28.66	28.66	28.66	28.66	300.0
2013-04-08 08:00:00	NVDA	Stock	0.312	0.312	0.3118	0.3118	248000.0
2013-04-08 09:00:00	NVDA	Stock	0.312	0.312	0.3068	0.3073	49554040.0
2013-04-08 10:00:00	NVDA	Stock	0.3075	0.3078	0.3049	0.3066	87056200.0
2013-04-08 11:00:00	NVDA	Stock	0.3065	0.3078	0.3062	0.3073	30016800.0
2013-04-08 12:00:00	NVDA	Stock	0.3073	0.3083	0.307	0.308	18264840.0
2013-04-08 13:00:00	NVDA	Stock	0.308	0.3098	0.308	0.3098	33677360.0
2013-04-08 14:00:00	NVDA	Stock	0.3095	0.3105	0.3095	0.3101	27510080.0
2013-04-08 15:00:00	NVDA	Stock	0.31	0.311	0.31	0.3105	64708280.0
2013-04-08 16:00:00	NVDA	Stock	0.3108	0.3115	0.3083	0.3115	12415720.0
2013-04-08 17:00:00	NVDA	Stock	0.3113	0.3113	0.3108	0.3108	117600.0
2013-04-08 04:00:00	AMZN	Stock	12.794	12.8225	12.794	12.8225	4000.0
2013-04-08 08:00:00	AMZN	Stock	12.844	12.844	12.8	12.8205	15000.0
2013-04-08 09:00:00	AMZN	Stock	12.8	12.9435	12.79	12.931	10009940.0
2013-04-08 10:00:00	AMZN	Stock	12.932	12.984	12.825	12.865	10457860.0
2013-04-08 11:00:00	AMZN	Stock	12.862	12.883	12.8175	12.823	4064200.0
2013-04-08 12:00:00	AMZN	Stock	12.817	12.845	12.7815	12.8255	3644640.0
2013-04-08 13:00:00	AMZN	Stock	12.8255	12.876	12.804	12.8636	4310540.0
2013-04-08 14:00:00	AMZN	Stock	12.872	12.905	12.8565	12.874	2997660.0
2013-04-08 15:00:00	AMZN	Stock	12.8725	12.9535	12.8725	12.9495	7384540.0
2013-04-08 16:00:00	AMZN	Stock	12.9495	12.955	12.8713	12.9094	2596020.0
2013-04-08 17:00:00	AMZN	Stock	12.9475	12.9635	12.9475	12.9625	19900.0
2013-04-08 18:00:00	AMZN	Stock	12.9675	12.9675	12.9675	12.9675	9000.0

> showing 50 of 45,373 rows — these rows as CSV

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