PREVIEW / stock_1hour / 2011-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-01.parquet
  size:    980 KB
  rows:    46,930
  symbols: 3,564

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-06-01 04:00:00	AAPL	Stock	12.4607	12.4607	12.4339	12.4339	5600.0
2011-06-01 05:00:00	AAPL	Stock	12.4286	12.4286	12.4054	12.4107	66080.0
2011-06-01 06:00:00	AAPL	Stock	12.4	12.4071	12.3929	12.4036	55888.0
2011-06-01 07:00:00	AAPL	Stock	12.4161	12.4461	12.4107	12.425	418488.0
2011-06-01 08:00:00	AAPL	Stock	12.4225	12.4621	12.4086	12.4286	3173156.0
2011-06-01 09:00:00	AAPL	Stock	12.4218	12.5761	12.4143	12.5414	113996736.0
2011-06-01 10:00:00	AAPL	Stock	12.5414	12.5536	12.4725	12.4843	101286808.0
2011-06-01 11:00:00	AAPL	Stock	12.4846	12.5	12.4189	12.4768	58901332.0
2011-06-01 12:00:00	AAPL	Stock	12.4764	12.485	12.3986	12.4661	47341588.0
2011-06-01 13:00:00	AAPL	Stock	12.4657	12.4839	12.3986	12.4436	44500848.0
2011-06-01 14:00:00	AAPL	Stock	12.4432	12.4439	12.3107	12.3654	76557936.0
2011-06-01 15:00:00	AAPL	Stock	12.3646	12.3925	12.3089	12.3393	80257912.0
2011-06-01 16:00:00	AAPL	Stock	12.3393	12.4496	12.3179	12.34	20793220.0
2011-06-01 17:00:00	AAPL	Stock	12.3443	12.3851	12.3307	12.3393	885024.0
2011-06-01 18:00:00	AAPL	Stock	12.3393	12.3396	12.3271	12.3271	139524.0
2011-06-01 19:00:00	AAPL	Stock	12.3304	12.3682	12.3304	12.3571	585732.0
2011-06-01 07:00:00	MSFT	Stock	25.02	25.04	25.02	25.04	772.0
2011-06-01 08:00:00	MSFT	Stock	25.02	25.04	24.93	24.93	18020.0
2011-06-01 09:00:00	MSFT	Stock	24.93	25.1	24.93	24.97	3913040.0
2011-06-01 10:00:00	MSFT	Stock	24.96	24.969	24.61	24.67	11006409.0
2011-06-01 11:00:00	MSFT	Stock	24.68	24.69	24.44	24.544	20885582.0
2011-06-01 12:00:00	MSFT	Stock	24.55	24.58	24.44	24.522	5809597.0
2011-06-01 13:00:00	MSFT	Stock	24.52	24.61	24.49	24.53	3813447.0
2011-06-01 14:00:00	MSFT	Stock	24.53	24.55	24.42	24.49	4794196.0
2011-06-01 15:00:00	MSFT	Stock	24.488	24.49	24.37	24.43	12138173.0
2011-06-01 16:00:00	MSFT	Stock	24.43	24.594	24.41	24.47	10929162.0
2011-06-01 17:00:00	MSFT	Stock	24.614	24.614	24.38	24.43	279023.0
2011-06-01 18:00:00	MSFT	Stock	24.43	24.43	24.4	24.4	22845.0
2011-06-01 19:00:00	MSFT	Stock	24.42	24.42	24.4	24.42	900.0
2011-06-01 08:00:00	NVDA	Stock	0.5	0.501	0.4975	0.4988	5723520.0
2011-06-01 09:00:00	NVDA	Stock	0.4988	0.4995	0.4915	0.4923	92719760.0
2011-06-01 10:00:00	NVDA	Stock	0.4923	0.4988	0.4883	0.4912	178436640.0
2011-06-01 11:00:00	NVDA	Stock	0.4915	0.4925	0.4892	0.4915	51281160.0
2011-06-01 12:00:00	NVDA	Stock	0.4915	0.492	0.488	0.4902	48988800.0
2011-06-01 13:00:00	NVDA	Stock	0.4905	0.492	0.485	0.4865	66321760.0
2011-06-01 14:00:00	NVDA	Stock	0.4865	0.4869	0.4788	0.4794	103312200.0
2011-06-01 15:00:00	NVDA	Stock	0.4795	0.4812	0.4775	0.4785	171493800.0
2011-06-01 16:00:00	NVDA	Stock	0.4786	0.4873	0.4775	0.4775	27061880.0
2011-06-01 17:00:00	NVDA	Stock	0.4778	0.4786	0.4775	0.4786	623640.0
2011-06-01 18:00:00	NVDA	Stock	0.4778	0.4798	0.476	0.4793	284000.0
2011-06-01 19:00:00	NVDA	Stock	0.4793	0.4793	0.4775	0.4775	25080.0
2011-06-01 08:00:00	AMZN	Stock	9.825	9.8345	9.72	9.772	65040.0
2011-06-01 09:00:00	AMZN	Stock	9.769	9.8625	9.7565	9.837	8891340.0
2011-06-01 10:00:00	AMZN	Stock	9.8315	9.863	9.787	9.8235	11507080.0
2011-06-01 11:00:00	AMZN	Stock	9.825	9.8265	9.7815	9.803	5222900.0
2011-06-01 12:00:00	AMZN	Stock	9.7995	9.8115	9.727	9.772	7897840.0
2011-06-01 13:00:00	AMZN	Stock	9.7745	9.7885	9.7	9.729	5867140.0
2011-06-01 14:00:00	AMZN	Stock	9.7275	9.739	9.6641	9.6905	7603680.0
2011-06-01 15:00:00	AMZN	Stock	9.688	9.707	9.6025	9.6155	15494600.0
2011-06-01 16:00:00	AMZN	Stock	9.6135	9.7332	9.6095	9.6592	916680.0

> showing 50 of 46,930 rows — these rows as CSV

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