PREVIEW / stock_1hour / 2011-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-12.parquet
  size:    947 KB
  rows:    44,549
  symbols: 3,520

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-01-12 04:00:00	AAPL	Stock	12.2679	12.2896	12.2679	12.2893	23800.0
2011-01-12 05:00:00	AAPL	Stock	12.285	12.3214	12.2679	12.3214	56000.0
2011-01-12 06:00:00	AAPL	Stock	12.2893	12.2936	12.2732	12.2732	36400.0
2011-01-12 07:00:00	AAPL	Stock	12.2736	12.2857	12.25	12.2507	644140.0
2011-01-12 08:00:00	AAPL	Stock	12.25	12.2754	12.2393	12.2543	2134664.0
2011-01-12 09:00:00	AAPL	Stock	12.2518	12.2693	12.2143	12.2618	51198084.0
2011-01-12 10:00:00	AAPL	Stock	12.2619	12.2625	12.2275	12.2539	50542632.0
2011-01-12 11:00:00	AAPL	Stock	12.2518	12.2986	12.25	12.2704	43215956.0
2011-01-12 12:00:00	AAPL	Stock	12.2693	12.2786	12.2575	12.2593	21204120.0
2011-01-12 13:00:00	AAPL	Stock	12.2586	12.2975	12.2586	12.2936	25054540.0
2011-01-12 14:00:00	AAPL	Stock	12.2932	12.2961	12.2721	12.2764	29976884.0
2011-01-12 15:00:00	AAPL	Stock	12.2769	12.3011	12.2714	12.3007	55542368.0
2011-01-12 16:00:00	AAPL	Stock	12.2982	12.3036	12.2349	12.2961	18796120.0
2011-01-12 17:00:00	AAPL	Stock	12.2954	12.3046	12.2946	12.3046	408632.0
2011-01-12 18:00:00	AAPL	Stock	12.3068	12.3071	12.3007	12.3068	155988.0
2011-01-12 19:00:00	AAPL	Stock	12.3064	12.3207	12.3054	12.3193	332304.0
2011-01-12 07:00:00	MSFT	Stock	28.16	28.24	28.16	28.24	7500.0
2011-01-12 08:00:00	MSFT	Stock	28.2	28.21	28.17	28.19	24900.0
2011-01-12 09:00:00	MSFT	Stock	28.18	28.3	28.07	28.3	5233833.0
2011-01-12 10:00:00	MSFT	Stock	28.3	28.47	28.25	28.46	7084395.0
2011-01-12 11:00:00	MSFT	Stock	28.465	28.59	28.41	28.52	8263217.0
2011-01-12 12:00:00	MSFT	Stock	28.53	28.55	28.46	28.48	6145709.0
2011-01-12 13:00:00	MSFT	Stock	28.471	28.51	28.4	28.5	6560398.0
2011-01-12 14:00:00	MSFT	Stock	28.49	28.56	28.49	28.51	4275063.0
2011-01-12 15:00:00	MSFT	Stock	28.505	28.57	28.42	28.55	11454231.0
2011-01-12 16:00:00	MSFT	Stock	28.548	28.56	28.13	28.55	2015277.0
2011-01-12 17:00:00	MSFT	Stock	28.53	28.54	28.53	28.53	19121.0
2011-01-12 18:00:00	MSFT	Stock	28.55	28.55	28.53	28.53	8713.0
2011-01-12 19:00:00	MSFT	Stock	28.53	28.55	28.53	28.55	3620.0
2011-01-12 07:00:00	NVDA	Stock	0.516	0.5195	0.5108	0.5138	356000.0
2011-01-12 08:00:00	NVDA	Stock	0.5088	0.5168	0.5088	0.509	1155280.0
2011-01-12 09:00:00	NVDA	Stock	0.5112	0.5185	0.5053	0.518	182997280.0
2011-01-12 10:00:00	NVDA	Stock	0.518	0.5372	0.5155	0.5359	488791840.0
2011-01-12 11:00:00	NVDA	Stock	0.5359	0.5468	0.5309	0.546	414557480.0
2011-01-12 12:00:00	NVDA	Stock	0.546	0.556	0.5435	0.5556	509235400.0
2011-01-12 13:00:00	NVDA	Stock	0.5558	0.566	0.555	0.5656	468536720.0
2011-01-12 14:00:00	NVDA	Stock	0.5655	0.5768	0.5628	0.5693	509140320.0
2011-01-12 15:00:00	NVDA	Stock	0.5694	0.5843	0.5656	0.5836	796290760.0
2011-01-12 16:00:00	NVDA	Stock	0.584	0.5843	0.5536	0.5825	42150760.0
2011-01-12 17:00:00	NVDA	Stock	0.5835	0.584	0.5805	0.5818	2609960.0
2011-01-12 18:00:00	NVDA	Stock	0.5818	0.5818	0.5808	0.581	740560.0
2011-01-12 19:00:00	NVDA	Stock	0.5808	0.5818	0.5775	0.578	1743520.0
2011-01-12 06:00:00	AMZN	Stock	9.25	9.275	9.25	9.275	16000.0
2011-01-12 07:00:00	AMZN	Stock	9.255	9.255	9.2355	9.25	18000.0
2011-01-12 08:00:00	AMZN	Stock	9.247	9.253	9.235	9.24	172940.0
2011-01-12 09:00:00	AMZN	Stock	9.24	9.269	9.1782	9.191	8399320.0
2011-01-12 10:00:00	AMZN	Stock	9.1915	9.213	9.165	9.1845	11013560.0
2011-01-12 11:00:00	AMZN	Stock	9.1845	9.2215	9.1805	9.1925	7744920.0
2011-01-12 12:00:00	AMZN	Stock	9.193	9.21	9.175	9.2014	5526160.0
2011-01-12 13:00:00	AMZN	Stock	9.2015	9.24	9.1975	9.2284	5413700.0

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

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