PREVIEW / stock_1hour / 2011-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-02.parquet
  size:    959 KB
  rows:    44,989
  symbols: 3,567

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-05-02 04:00:00	AAPL	Stock	12.5786	12.6071	12.5786	12.5932	63560.0
2011-05-02 05:00:00	AAPL	Stock	12.6071	12.6154	12.6071	12.6071	16800.0
2011-05-02 06:00:00	AAPL	Stock	12.5829	12.61	12.5714	12.5961	147560.0
2011-05-02 07:00:00	AAPL	Stock	12.5796	12.5964	12.5368	12.5689	1818964.0
2011-05-02 08:00:00	AAPL	Stock	12.5643	12.5732	12.4368	12.4671	9365496.0
2011-05-02 09:00:00	AAPL	Stock	12.4668	12.5167	12.425	12.4714	101802764.0
2011-05-02 10:00:00	AAPL	Stock	12.4714	12.4918	12.4107	12.4189	75469520.0
2011-05-02 11:00:00	AAPL	Stock	12.4161	12.4518	12.3839	12.4065	48237476.0
2011-05-02 12:00:00	AAPL	Stock	12.4054	12.4168	12.3543	12.3764	42890176.0
2011-05-02 13:00:00	AAPL	Stock	12.3761	12.4444	12.3757	12.4133	29133132.0
2011-05-02 14:00:00	AAPL	Stock	12.4121	12.445	12.3696	12.3696	34493816.0
2011-05-02 15:00:00	AAPL	Stock	12.37	12.3929	12.3393	12.3653	64672832.0
2011-05-02 16:00:00	AAPL	Stock	12.3671	12.4463	12.3499	12.3725	20754132.0
2011-05-02 17:00:00	AAPL	Stock	12.3736	12.3743	12.3661	12.3732	85232.0
2011-05-02 18:00:00	AAPL	Stock	12.3714	12.4111	12.3671	12.3964	880404.0
2011-05-02 19:00:00	AAPL	Stock	12.3929	12.3964	12.3804	12.3929	232456.0
2011-05-02 04:00:00	MSFT	Stock	26.0	26.05	26.0	26.05	4100.0
2011-05-02 05:00:00	MSFT	Stock	26.15	26.15	26.14	26.14	1700.0
2011-05-02 06:00:00	MSFT	Stock	26.14	26.14	26.09	26.09	3116.0
2011-05-02 07:00:00	MSFT	Stock	26.09	26.09	25.96	26.0	61551.0
2011-05-02 08:00:00	MSFT	Stock	26.03	26.04	25.93	25.95	267009.0
2011-05-02 09:00:00	MSFT	Stock	25.95	26.0	25.59	25.6	15300524.0
2011-05-02 10:00:00	MSFT	Stock	25.59	25.69	25.52	25.65	14926489.0
2011-05-02 11:00:00	MSFT	Stock	25.65	25.77	25.55	25.58	11651559.0
2011-05-02 12:00:00	MSFT	Stock	25.585	25.62	25.48	25.49	10072436.0
2011-05-02 13:00:00	MSFT	Stock	25.485	25.58	25.48	25.56	7608961.0
2011-05-02 14:00:00	MSFT	Stock	25.57	25.65	25.51	25.52	6474494.0
2011-05-02 15:00:00	MSFT	Stock	25.52	25.69	25.515	25.66	14117546.0
2011-05-02 16:00:00	MSFT	Stock	25.655	25.68	25.565	25.68	2263708.0
2011-05-02 17:00:00	MSFT	Stock	25.63	25.66	25.6	25.6	5972363.0
2011-05-02 18:00:00	MSFT	Stock	25.66	25.66	25.62	25.62	57968.0
2011-05-02 19:00:00	MSFT	Stock	25.62	25.66	25.61	25.65	7234.0
2011-05-02 08:00:00	NVDA	Stock	0.5093	0.5098	0.5	0.5075	695000.0
2011-05-02 09:00:00	NVDA	Stock	0.5	0.5112	0.5	0.505	75833160.0
2011-05-02 10:00:00	NVDA	Stock	0.505	0.5088	0.5045	0.5055	96559160.0
2011-05-02 11:00:00	NVDA	Stock	0.5058	0.5061	0.4958	0.4978	105076360.0
2011-05-02 12:00:00	NVDA	Stock	0.4978	0.4985	0.493	0.4978	57040400.0
2011-05-02 13:00:00	NVDA	Stock	0.4978	0.5015	0.497	0.4998	51059360.0
2011-05-02 14:00:00	NVDA	Stock	0.4998	0.502	0.4952	0.4955	67041680.0
2011-05-02 15:00:00	NVDA	Stock	0.4956	0.4958	0.4908	0.4932	141396480.0
2011-05-02 16:00:00	NVDA	Stock	0.4932	0.5028	0.4918	0.4918	9009160.0
2011-05-02 18:00:00	NVDA	Stock	0.4923	0.494	0.4923	0.4932	77080.0
2011-05-02 19:00:00	NVDA	Stock	0.4932	0.4932	0.492	0.492	94800.0
2011-05-02 05:00:00	AMZN	Stock	9.85	9.85	9.85	9.85	2000.0
2011-05-02 06:00:00	AMZN	Stock	9.875	9.875	9.8725	9.8725	18000.0
2011-05-02 07:00:00	AMZN	Stock	9.817	9.86	9.817	9.85	38000.0
2011-05-02 08:00:00	AMZN	Stock	9.848	9.855	9.815	9.838	218740.0
2011-05-02 09:00:00	AMZN	Stock	9.8425	9.936	9.809	9.898	18522640.0
2011-05-02 10:00:00	AMZN	Stock	9.893	10.0295	9.893	10.0175	35247680.0
2011-05-02 11:00:00	AMZN	Stock	10.0165	10.0415	9.9365	9.9767	25235540.0

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

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