PREVIEW / stock_1hour / 2012-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-07.parquet
  size:    947 KB
  rows:    44,580
  symbols: 3,471

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-11-07 04:00:00	AAPL	Stock	20.8214	20.8214	20.7857	20.7857	11200.0
2012-11-07 06:00:00	AAPL	Stock	20.8036	20.8036	20.7179	20.75	137060.0
2012-11-07 07:00:00	AAPL	Stock	20.7479	20.7479	20.5821	20.6071	992628.0
2012-11-07 08:00:00	AAPL	Stock	20.6071	20.6854	20.4411	20.4818	4918928.0
2012-11-07 09:00:00	AAPL	Stock	20.4814	20.5336	20.2625	20.3289	115215912.0
2012-11-07 10:00:00	AAPL	Stock	20.3314	20.3714	20.0361	20.0393	139112876.0
2012-11-07 11:00:00	AAPL	Stock	20.038	20.1536	19.8586	20.1108	148930012.0
2012-11-07 12:00:00	AAPL	Stock	20.11	20.205	19.9511	19.9621	88417224.0
2012-11-07 13:00:00	AAPL	Stock	19.9684	20.1414	19.9311	19.9729	68718860.0
2012-11-07 14:00:00	AAPL	Stock	19.9758	20.0529	19.8482	20.0361	83125812.0
2012-11-07 15:00:00	AAPL	Stock	20.0436	20.1036	19.9214	19.9311	107769480.0
2012-11-07 16:00:00	AAPL	Stock	19.9332	20.1186	19.9242	19.9821	12457928.0
2012-11-07 17:00:00	AAPL	Stock	19.9925	19.9975	19.9414	19.9546	719768.0
2012-11-07 18:00:00	AAPL	Stock	19.9536	20.0	19.9536	19.9821	422016.0
2012-11-07 19:00:00	AAPL	Stock	19.9761	20.0	19.9554	20.0	307496.0
2012-11-07 07:00:00	MSFT	Stock	29.71	29.71	29.5	29.55	2540.0
2012-11-07 08:00:00	MSFT	Stock	29.58	29.69	29.4	29.5	66176.0
2012-11-07 09:00:00	MSFT	Stock	29.47	29.825	29.34	29.68	6246561.0
2012-11-07 10:00:00	MSFT	Stock	29.685	29.7	29.21	29.21	7622305.0
2012-11-07 11:00:00	MSFT	Stock	29.21	29.38	29.12	29.165	8492235.0
2012-11-07 12:00:00	MSFT	Stock	29.152	29.2	29.05	29.095	5814513.0
2012-11-07 13:00:00	MSFT	Stock	29.095	29.24	29.06	29.165	5917583.0
2012-11-07 14:00:00	MSFT	Stock	29.17	29.265	29.12	29.252	4392442.0
2012-11-07 15:00:00	MSFT	Stock	29.255	29.29	29.06	29.073	12029538.0
2012-11-07 16:00:00	MSFT	Stock	29.08	29.276	29.0	29.13	5996861.0
2012-11-07 17:00:00	MSFT	Stock	29.13	29.17	29.08	29.08	7232.0
2012-11-07 18:00:00	MSFT	Stock	29.15	29.22	29.1	29.16	3050.0
2012-11-07 19:00:00	MSFT	Stock	29.15	29.15	29.09	29.1	2628.0
2012-11-07 07:00:00	NVDA	Stock	0.3298	0.3298	0.325	0.325	30400.0
2012-11-07 08:00:00	NVDA	Stock	0.3203	0.3203	0.3203	0.3203	24000.0
2012-11-07 09:00:00	NVDA	Stock	0.3215	0.3245	0.3195	0.3243	37350320.0
2012-11-07 10:00:00	NVDA	Stock	0.3245	0.3248	0.3188	0.3188	49045680.0
2012-11-07 11:00:00	NVDA	Stock	0.319	0.32	0.3138	0.3155	68073240.0
2012-11-07 12:00:00	NVDA	Stock	0.3158	0.3165	0.315	0.3155	25193400.0
2012-11-07 13:00:00	NVDA	Stock	0.3155	0.318	0.3146	0.3153	33085160.0
2012-11-07 14:00:00	NVDA	Stock	0.3153	0.3175	0.3145	0.3175	33522320.0
2012-11-07 15:00:00	NVDA	Stock	0.3175	0.3175	0.3148	0.3148	68045000.0
2012-11-07 16:00:00	NVDA	Stock	0.3148	0.3248	0.3143	0.3163	9075920.0
2012-11-07 17:00:00	NVDA	Stock	0.317	0.317	0.317	0.317	80000.0
2012-11-07 18:00:00	NVDA	Stock	0.3173	0.3173	0.3173	0.3173	5200.0
2012-11-07 04:00:00	AMZN	Stock	11.875	11.875	11.875	11.875	2000.0
2012-11-07 08:00:00	AMZN	Stock	11.819	11.819	11.7575	11.78	888960.0
2012-11-07 09:00:00	AMZN	Stock	11.7705	11.785	11.676	11.695	8418800.0
2012-11-07 10:00:00	AMZN	Stock	11.6925	11.709	11.534	11.5405	15668360.0
2012-11-07 11:00:00	AMZN	Stock	11.5405	11.575	11.471	11.5595	10553840.0
2012-11-07 12:00:00	AMZN	Stock	11.569	11.611	11.554	11.585	5503880.0
2012-11-07 13:00:00	AMZN	Stock	11.581	11.6495	11.5565	11.5703	5681620.0
2012-11-07 14:00:00	AMZN	Stock	11.5705	11.602	11.525	11.5825	5338460.0
2012-11-07 15:00:00	AMZN	Stock	11.583	11.6895	11.5435	11.597	17587540.0
2012-11-07 16:00:00	AMZN	Stock	11.5945	11.6772	11.5485	11.5975	933460.0

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

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