PREVIEW / stock_1hour / 2011-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-17.parquet
  size:    955 KB
  rows:    45,866
  symbols: 3,527

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-02-17 04:00:00	AAPL	Stock	12.7929	12.8571	12.6793	12.7018	214788.0
2011-02-17 05:00:00	AAPL	Stock	12.7143	12.75	12.5418	12.6939	306068.0
2011-02-17 06:00:00	AAPL	Stock	12.7036	12.8029	12.6786	12.7857	508564.0
2011-02-17 07:00:00	AAPL	Stock	12.7782	12.8664	12.7679	12.8071	3175844.0
2011-02-17 08:00:00	AAPL	Stock	12.8071	12.8911	12.7918	12.8054	8538040.0
2011-02-17 09:00:00	AAPL	Stock	12.8054	12.8571	12.75	12.8443	116466140.0
2011-02-17 10:00:00	AAPL	Stock	12.8439	12.8668	12.7496	12.7614	99081920.0
2011-02-17 11:00:00	AAPL	Stock	12.7614	12.8389	12.7329	12.8268	88506068.0
2011-02-17 12:00:00	AAPL	Stock	12.8275	12.8314	12.7786	12.7804	35130872.0
2011-02-17 13:00:00	AAPL	Stock	12.78	12.8093	12.7679	12.7821	41272756.0
2011-02-17 14:00:00	AAPL	Stock	12.7829	12.8127	12.7725	12.7793	37198756.0
2011-02-17 15:00:00	AAPL	Stock	12.7818	12.7964	12.75	12.7961	77322168.0
2011-02-17 16:00:00	AAPL	Stock	12.7927	12.8261	12.7697	12.8107	12490744.0
2011-02-17 17:00:00	AAPL	Stock	12.815	12.8189	12.8036	12.8143	485800.0
2011-02-17 18:00:00	AAPL	Stock	12.8157	12.8193	12.7964	12.8132	284060.0
2011-02-17 19:00:00	AAPL	Stock	12.8168	12.8193	12.7929	12.8036	741412.0
2011-02-17 06:00:00	MSFT	Stock	27.04	27.06	27.04	27.06	300.0
2011-02-17 07:00:00	MSFT	Stock	27.05	27.05	27.05	27.05	3600.0
2011-02-17 08:00:00	MSFT	Stock	27.05	27.08	26.96	27.02	37009.0
2011-02-17 09:00:00	MSFT	Stock	27.03	27.19	26.91	27.18	6004255.0
2011-02-17 10:00:00	MSFT	Stock	27.19	27.3	27.16	27.24	10182679.0
2011-02-17 11:00:00	MSFT	Stock	27.239	27.37	27.21	27.35	8135529.0
2011-02-17 12:00:00	MSFT	Stock	27.35	27.37	27.2	27.22	9274491.0
2011-02-17 13:00:00	MSFT	Stock	27.22	27.3	27.22	27.26	3349727.0
2011-02-17 14:00:00	MSFT	Stock	27.26	27.3	27.24	27.26	5198478.0
2011-02-17 15:00:00	MSFT	Stock	27.26	27.3	27.14	27.2	10984733.0
2011-02-17 16:00:00	MSFT	Stock	27.19	27.236	27.148	27.17	1415098.0
2011-02-17 17:00:00	MSFT	Stock	27.21	27.24	27.21	27.24	5634.0
2011-02-17 18:00:00	MSFT	Stock	27.23	27.23	27.17	27.17	42894.0
2011-02-17 19:00:00	MSFT	Stock	27.17	27.17	27.17	27.17	2149.0
2011-02-17 04:00:00	NVDA	Stock	0.5812	0.5812	0.5812	0.5812	80000.0
2011-02-17 05:00:00	NVDA	Stock	0.575	0.575	0.575	0.575	60000.0
2011-02-17 06:00:00	NVDA	Stock	0.565	0.5675	0.565	0.5675	60000.0
2011-02-17 07:00:00	NVDA	Stock	0.5675	0.5695	0.5625	0.5655	3086560.0
2011-02-17 08:00:00	NVDA	Stock	0.567	0.5792	0.5642	0.567	14768000.0
2011-02-17 09:00:00	NVDA	Stock	0.5665	0.6065	0.5628	0.6045	605023040.0
2011-02-17 10:00:00	NVDA	Stock	0.6043	0.6113	0.591	0.6082	578457800.0
2011-02-17 11:00:00	NVDA	Stock	0.608	0.617	0.607	0.61	301776720.0
2011-02-17 12:00:00	NVDA	Stock	0.6103	0.6188	0.6088	0.6178	262146760.0
2011-02-17 13:00:00	NVDA	Stock	0.618	0.637	0.618	0.6327	530660760.0
2011-02-17 14:00:00	NVDA	Stock	0.6328	0.6448	0.6293	0.6383	529677000.0
2011-02-17 15:00:00	NVDA	Stock	0.6383	0.6503	0.6338	0.6423	595502720.0
2011-02-17 16:00:00	NVDA	Stock	0.6418	0.6438	0.6009	0.6393	10668640.0
2011-02-17 17:00:00	NVDA	Stock	0.5843	0.641	0.5843	0.641	1505600.0
2011-02-17 18:00:00	NVDA	Stock	0.6412	0.642	0.64	0.6408	959240.0
2011-02-17 19:00:00	NVDA	Stock	0.6402	0.6402	0.639	0.6395	675080.0
2011-02-17 06:00:00	AMZN	Stock	9.265	9.265	9.265	9.265	2000.0
2011-02-17 08:00:00	AMZN	Stock	9.313	9.315	9.2805	9.2805	101900.0
2011-02-17 09:00:00	AMZN	Stock	9.2775	9.364	9.2525	9.3405	9579600.0
2011-02-17 10:00:00	AMZN	Stock	9.3475	9.367	9.325	9.3305	11822260.0

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

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