PREVIEW / stock_1hour / 2012-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-31.parquet
  size:    940 KB
  rows:    44,255
  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
2012-01-31 04:00:00	AAPL	Stock	16.3039	16.3132	16.2857	16.2857	57568.0
2012-01-31 05:00:00	AAPL	Stock	16.2857	16.3036	16.2857	16.3036	72520.0
2012-01-31 06:00:00	AAPL	Stock	16.3036	16.3175	16.2718	16.285	86800.0
2012-01-31 07:00:00	AAPL	Stock	16.285	16.2943	16.2429	16.2539	817992.0
2012-01-31 08:00:00	AAPL	Stock	16.2521	16.2771	16.2521	16.2625	1625848.0
2012-01-31 09:00:00	AAPL	Stock	16.2643	16.3429	16.2521	16.3336	81292036.0
2012-01-31 10:00:00	AAPL	Stock	16.3336	16.3657	16.2646	16.2796	85654212.0
2012-01-31 11:00:00	AAPL	Stock	16.2796	16.2982	16.1811	16.2169	53179896.0
2012-01-31 12:00:00	AAPL	Stock	16.2197	16.2379	16.185	16.2104	32897172.0
2012-01-31 13:00:00	AAPL	Stock	16.2114	16.2532	16.2075	16.2154	26609968.0
2012-01-31 14:00:00	AAPL	Stock	16.2173	16.2854	16.2157	16.2718	25940908.0
2012-01-31 15:00:00	AAPL	Stock	16.2746	16.3089	16.2643	16.3029	51777852.0
2012-01-31 16:00:00	AAPL	Stock	16.2959	16.3074	16.2504	16.2786	18274760.0
2012-01-31 17:00:00	AAPL	Stock	16.3029	16.3029	16.2625	16.2757	294336.0
2012-01-31 18:00:00	AAPL	Stock	16.2768	16.2793	16.2732	16.2768	277844.0
2012-01-31 19:00:00	AAPL	Stock	16.2768	16.2854	16.2625	16.2625	385056.0
2012-01-31 07:00:00	MSFT	Stock	29.66	29.66	29.65	29.65	2000.0
2012-01-31 08:00:00	MSFT	Stock	29.7	29.7	29.61	29.68	12500.0
2012-01-31 09:00:00	MSFT	Stock	29.68	29.7	29.51	29.59	5102313.0
2012-01-31 10:00:00	MSFT	Stock	29.57	29.635	29.3	29.35	7158553.0
2012-01-31 11:00:00	MSFT	Stock	29.34	29.38	29.23	29.31	6282763.0
2012-01-31 12:00:00	MSFT	Stock	29.32	29.47	29.31	29.445	3316856.0
2012-01-31 13:00:00	MSFT	Stock	29.445	29.525	29.44	29.47	2870941.0
2012-01-31 14:00:00	MSFT	Stock	29.46	29.63	29.42	29.61	7661417.0
2012-01-31 15:00:00	MSFT	Stock	29.61	29.62	29.5	29.54	7474187.0
2012-01-31 16:00:00	MSFT	Stock	29.545	29.601	29.45	29.47	6122986.0
2012-01-31 17:00:00	MSFT	Stock	29.53	29.61	29.47	29.5	10406.0
2012-01-31 19:00:00	MSFT	Stock	29.47	29.47	29.47	29.47	500.0
2012-01-31 08:00:00	NVDA	Stock	0.3725	0.3743	0.3725	0.374	32000.0
2012-01-31 09:00:00	NVDA	Stock	0.3723	0.3723	0.3652	0.3675	60329560.0
2012-01-31 10:00:00	NVDA	Stock	0.3678	0.368	0.3628	0.363	71537920.0
2012-01-31 11:00:00	NVDA	Stock	0.3632	0.3668	0.363	0.3658	49113880.0
2012-01-31 12:00:00	NVDA	Stock	0.3658	0.3678	0.365	0.3672	21624880.0
2012-01-31 13:00:00	NVDA	Stock	0.3672	0.3692	0.3672	0.3678	33434560.0
2012-01-31 14:00:00	NVDA	Stock	0.368	0.3705	0.3671	0.3684	26411640.0
2012-01-31 15:00:00	NVDA	Stock	0.3682	0.37	0.367	0.369	64087800.0
2012-01-31 16:00:00	NVDA	Stock	0.369	0.37	0.367	0.3692	5577720.0
2012-01-31 17:00:00	NVDA	Stock	0.3692	0.3705	0.3692	0.3705	109480.0
2012-01-31 18:00:00	NVDA	Stock	0.3682	0.3682	0.3682	0.3682	37160.0
2012-01-31 04:00:00	AMZN	Stock	9.675	9.689	9.675	9.6885	111100.0
2012-01-31 06:00:00	AMZN	Stock	9.7355	9.7355	9.7315	9.7315	4000.0
2012-01-31 07:00:00	AMZN	Stock	9.725	9.7445	9.7	9.7	267860.0
2012-01-31 08:00:00	AMZN	Stock	9.7	9.7285	9.685	9.7155	341840.0
2012-01-31 09:00:00	AMZN	Stock	9.7205	9.7815	9.559	9.6525	30664840.0
2012-01-31 10:00:00	AMZN	Stock	9.65	9.665	9.5055	9.528	27278360.0
2012-01-31 11:00:00	AMZN	Stock	9.5275	9.5655	9.485	9.5495	15273740.0
2012-01-31 12:00:00	AMZN	Stock	9.5485	9.615	9.5355	9.6045	12946320.0
2012-01-31 13:00:00	AMZN	Stock	9.607	9.66	9.5841	9.5936	14890120.0
2012-01-31 14:00:00	AMZN	Stock	9.5925	9.6345	9.5651	9.6315	15241160.0
2012-01-31 15:00:00	AMZN	Stock	9.631	9.745	9.6175	9.7255	46969240.0

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

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