PREVIEW / stock_1hour / 2011-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-29.parquet
  size:    906 KB
  rows:    43,686
  symbols: 3,482

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-09-29 04:00:00	AAPL	Stock	14.2857	14.3214	14.2857	14.3125	36400.0
2011-09-29 05:00:00	AAPL	Stock	14.3036	14.3214	14.25	14.3214	42000.0
2011-09-29 06:00:00	AAPL	Stock	14.3211	14.3214	14.2521	14.2521	46200.0
2011-09-29 07:00:00	AAPL	Stock	14.2679	14.2918	14.22	14.2275	511448.0
2011-09-29 08:00:00	AAPL	Stock	14.2457	14.3929	14.2421	14.3582	4683980.0
2011-09-29 09:00:00	AAPL	Stock	14.3568	14.3804	14.195	14.2464	67205040.0
2011-09-29 10:00:00	AAPL	Stock	14.2461	14.2679	13.9643	14.0796	127445612.0
2011-09-29 11:00:00	AAPL	Stock	14.0818	14.1657	14.0114	14.1118	69692196.0
2011-09-29 12:00:00	AAPL	Stock	14.1161	14.1296	14.0	14.026	42110712.0
2011-09-29 13:00:00	AAPL	Stock	14.0229	14.0714	13.9139	13.9482	79649024.0
2011-09-29 14:00:00	AAPL	Stock	13.9461	13.9911	13.7932	13.8929	114577260.0
2011-09-29 15:00:00	AAPL	Stock	13.8925	13.9643	13.8125	13.9354	133119980.0
2011-09-29 16:00:00	AAPL	Stock	13.9354	14.2796	13.8732	13.97	8898204.0
2011-09-29 17:00:00	AAPL	Stock	13.9704	13.9821	13.9489	13.9661	357364.0
2011-09-29 18:00:00	AAPL	Stock	13.9686	13.9929	13.9489	13.9836	153804.0
2011-09-29 19:00:00	AAPL	Stock	13.9821	14.0032	13.9782	13.9932	178892.0
2011-09-29 04:00:00	MSFT	Stock	25.8	25.84	25.8	25.84	900.0
2011-09-29 06:00:00	MSFT	Stock	25.85	25.85	25.85	25.85	400.0
2011-09-29 07:00:00	MSFT	Stock	25.7	25.82	25.7	25.82	500.0
2011-09-29 08:00:00	MSFT	Stock	25.75	26.14	25.75	26.05	41846.0
2011-09-29 09:00:00	MSFT	Stock	26.03	26.17	25.89	26.07	4561229.0
2011-09-29 10:00:00	MSFT	Stock	26.07	26.16	25.73	25.8	7273570.0
2011-09-29 11:00:00	MSFT	Stock	25.8	25.835	25.68	25.73	5932232.0
2011-09-29 12:00:00	MSFT	Stock	25.74	25.8	25.63	25.645	6290264.0
2011-09-29 13:00:00	MSFT	Stock	25.645	25.65	25.32	25.39	8840925.0
2011-09-29 14:00:00	MSFT	Stock	25.39	25.43	25.11	25.27	9456714.0
2011-09-29 15:00:00	MSFT	Stock	25.27	25.47	25.09	25.44	17318852.0
2011-09-29 16:00:00	MSFT	Stock	25.45	25.747	25.344	25.45	2392882.0
2011-09-29 17:00:00	MSFT	Stock	25.53	25.53	25.53	25.53	100.0
2011-09-29 18:00:00	MSFT	Stock	25.45	25.54	25.45	25.53	9100.0
2011-09-29 19:00:00	MSFT	Stock	25.54	25.54	25.5	25.5	3567.0
2011-09-29 04:00:00	NVDA	Stock	0.3335	0.3382	0.3335	0.3382	136000.0
2011-09-29 05:00:00	NVDA	Stock	0.3405	0.3405	0.3405	0.3405	4000.0
2011-09-29 07:00:00	NVDA	Stock	0.3368	0.3388	0.3368	0.3385	88000.0
2011-09-29 08:00:00	NVDA	Stock	0.3378	0.345	0.3375	0.3438	1761920.0
2011-09-29 09:00:00	NVDA	Stock	0.3442	0.3473	0.339	0.3402	106052960.0
2011-09-29 10:00:00	NVDA	Stock	0.3402	0.3418	0.3365	0.3388	153407800.0
2011-09-29 11:00:00	NVDA	Stock	0.3385	0.3395	0.3308	0.3322	125007560.0
2011-09-29 12:00:00	NVDA	Stock	0.3323	0.3335	0.3268	0.3275	86042160.0
2011-09-29 13:00:00	NVDA	Stock	0.3278	0.33	0.3215	0.3238	107970160.0
2011-09-29 14:00:00	NVDA	Stock	0.3238	0.3245	0.3188	0.322	107697720.0
2011-09-29 15:00:00	NVDA	Stock	0.3223	0.3275	0.3198	0.3273	165223280.0
2011-09-29 16:00:00	NVDA	Stock	0.3275	0.3381	0.3236	0.327	11853400.0
2011-09-29 17:00:00	NVDA	Stock	0.327	0.3273	0.3263	0.3273	238120.0
2011-09-29 19:00:00	NVDA	Stock	0.327	0.328	0.327	0.328	198800.0
2011-09-29 04:00:00	AMZN	Stock	11.5375	11.6	11.5375	11.6	12000.0
2011-09-29 06:00:00	AMZN	Stock	11.5885	11.5885	11.5885	11.5885	2000.0
2011-09-29 07:00:00	AMZN	Stock	11.5935	11.6235	11.5935	11.594	29200.0
2011-09-29 08:00:00	AMZN	Stock	11.6125	11.71	11.572	11.675	829300.0
2011-09-29 09:00:00	AMZN	Stock	11.6935	11.715	11.45	11.4725	27216000.0

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

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