PREVIEW / stock_1hour / 2012-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-19.parquet
  size:    956 KB
  rows:    44,882
  symbols: 3,477

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-19 04:00:00	AAPL	Stock	18.9375	19.1071	18.9375	19.0768	227976.0
2012-11-19 05:00:00	AAPL	Stock	19.0893	19.1075	19.0714	19.0714	375760.0
2012-11-19 06:00:00	AAPL	Stock	19.0786	19.1071	19.0714	19.0996	511252.0
2012-11-19 07:00:00	AAPL	Stock	19.0996	19.1314	19.0375	19.0818	1586844.0
2012-11-19 08:00:00	AAPL	Stock	19.0736	19.2004	19.0629	19.1664	6500928.0
2012-11-19 09:00:00	AAPL	Stock	19.1657	19.6311	19.1539	19.6182	173726616.0
2012-11-19 10:00:00	AAPL	Stock	19.6196	19.7767	19.5314	19.7429	145181708.0
2012-11-19 11:00:00	AAPL	Stock	19.7418	19.8214	19.7054	19.7961	84706888.0
2012-11-19 12:00:00	AAPL	Stock	19.8	19.9868	19.7889	19.9596	93438184.0
2012-11-19 13:00:00	AAPL	Stock	19.9596	19.9825	19.8371	19.9418	55180020.0
2012-11-19 14:00:00	AAPL	Stock	19.9396	20.0929	19.9219	20.0716	78791720.0
2012-11-19 15:00:00	AAPL	Stock	20.0725	20.2679	20.0286	20.2118	133423220.0
2012-11-19 16:00:00	AAPL	Stock	20.2261	20.234	19.4301	20.2229	22623944.0
2012-11-19 17:00:00	AAPL	Stock	20.2214	20.2246	20.1871	20.1993	1437044.0
2012-11-19 18:00:00	AAPL	Stock	20.1932	20.2	20.1879	20.1893	356160.0
2012-11-19 19:00:00	AAPL	Stock	20.1907	20.1921	20.1786	20.1889	593376.0
2012-11-19 07:00:00	MSFT	Stock	26.64	26.75	26.6	26.75	9300.0
2012-11-19 08:00:00	MSFT	Stock	26.73	26.78	26.66	26.76	209866.0
2012-11-19 09:00:00	MSFT	Stock	26.72	26.81	26.57	26.57	8469452.0
2012-11-19 10:00:00	MSFT	Stock	26.575	26.71	26.47	26.66	11855924.0
2012-11-19 11:00:00	MSFT	Stock	26.67	26.728	26.62	26.675	5244618.0
2012-11-19 12:00:00	MSFT	Stock	26.674	26.78	26.67	26.77	5007201.0
2012-11-19 13:00:00	MSFT	Stock	26.77	26.78	26.61	26.66	4331047.0
2012-11-19 14:00:00	MSFT	Stock	26.67	26.68	26.61	26.633	4282825.0
2012-11-19 15:00:00	MSFT	Stock	26.635	26.76	26.59	26.74	11286946.0
2012-11-19 16:00:00	MSFT	Stock	26.72	26.78	26.514	26.77	6077939.0
2012-11-19 17:00:00	MSFT	Stock	26.79	26.79	26.71	26.75	34458.0
2012-11-19 18:00:00	MSFT	Stock	26.75	26.79	26.75	26.75	32862.0
2012-11-19 19:00:00	MSFT	Stock	26.74	26.77	26.73	26.73	13050.0
2012-11-19 08:00:00	NVDA	Stock	0.2905	0.2925	0.285	0.2898	546600.0
2012-11-19 09:00:00	NVDA	Stock	0.2885	0.2902	0.2868	0.2872	56116720.0
2012-11-19 10:00:00	NVDA	Stock	0.287	0.29	0.2862	0.2892	51889480.0
2012-11-19 11:00:00	NVDA	Stock	0.2892	0.2902	0.2875	0.2878	54213440.0
2012-11-19 12:00:00	NVDA	Stock	0.288	0.2908	0.2878	0.2908	54281640.0
2012-11-19 13:00:00	NVDA	Stock	0.2908	0.293	0.2905	0.2925	56111680.0
2012-11-19 14:00:00	NVDA	Stock	0.2925	0.2935	0.292	0.2922	44170000.0
2012-11-19 15:00:00	NVDA	Stock	0.2925	0.293	0.2912	0.2922	63927240.0
2012-11-19 16:00:00	NVDA	Stock	0.2925	0.2926	0.2882	0.2882	18440760.0
2012-11-19 17:00:00	NVDA	Stock	0.2925	0.2925	0.2925	0.2925	93360.0
2012-11-19 18:00:00	NVDA	Stock	0.2925	0.2925	0.2925	0.2925	28000.0
2012-11-19 19:00:00	NVDA	Stock	0.2932	0.2932	0.2932	0.2932	8000.0
2012-11-19 04:00:00	AMZN	Stock	11.35	11.35	11.35	11.35	6000.0
2012-11-19 07:00:00	AMZN	Stock	11.3415	11.362	11.3415	11.362	12000.0
2012-11-19 08:00:00	AMZN	Stock	11.348	11.424	11.348	11.405	678120.0
2012-11-19 09:00:00	AMZN	Stock	11.4025	11.585	11.3815	11.5735	12883360.0
2012-11-19 10:00:00	AMZN	Stock	11.577	11.625	11.474	11.585	12231420.0
2012-11-19 11:00:00	AMZN	Stock	11.585	11.6001	11.495	11.4978	6261140.0
2012-11-19 12:00:00	AMZN	Stock	11.5	11.5315	11.425	11.438	7755680.0
2012-11-19 13:00:00	AMZN	Stock	11.444	11.481	11.3725	11.4343	8012060.0
2012-11-19 14:00:00	AMZN	Stock	11.431	11.4805	11.412	11.4525	6550800.0

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

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