PREVIEW / stock_1hour / 2013-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-30.parquet
  size:    986 KB
  rows:    45,647
  symbols: 3,486

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
2013-08-30 04:00:00	AAPL	Stock	17.5893	17.5893	17.5893	17.5893	8400.0
2013-08-30 05:00:00	AAPL	Stock	17.5864	17.6071	17.5864	17.6071	6160.0
2013-08-30 07:00:00	AAPL	Stock	17.6107	17.6393	17.5714	17.6036	223440.0
2013-08-30 08:00:00	AAPL	Stock	17.6018	17.625	17.5732	17.5811	1148420.0
2013-08-30 09:00:00	AAPL	Stock	17.5864	17.6054	17.5125	17.5404	40991076.0
2013-08-30 10:00:00	AAPL	Stock	17.5404	17.5404	17.4111	17.4218	56674212.0
2013-08-30 11:00:00	AAPL	Stock	17.42	17.4514	17.3768	17.3839	34973512.0
2013-08-30 12:00:00	AAPL	Stock	17.3825	17.4554	17.375	17.4414	21988008.0
2013-08-30 13:00:00	AAPL	Stock	17.4389	17.4543	17.375	17.4146	28539308.0
2013-08-30 14:00:00	AAPL	Stock	17.4129	17.4521	17.3989	17.4307	17192924.0
2013-08-30 15:00:00	AAPL	Stock	17.4289	17.4457	17.3796	17.4029	41446244.0
2013-08-30 16:00:00	AAPL	Stock	17.3946	17.4481	17.3877	17.4114	26962068.0
2013-08-30 17:00:00	AAPL	Stock	17.4143	17.4268	17.4107	17.4207	51660.0
2013-08-30 18:00:00	AAPL	Stock	17.4082	17.4196	17.4018	17.4189	69356.0
2013-08-30 19:00:00	AAPL	Stock	17.4125	17.4196	17.4107	17.4196	63616.0
2013-08-30 04:00:00	MSFT	Stock	33.49	33.49	33.49	33.49	300.0
2013-08-30 05:00:00	MSFT	Stock	33.49	33.49	33.49	33.49	600.0
2013-08-30 06:00:00	MSFT	Stock	33.49	33.49	33.49	33.49	5287.0
2013-08-30 07:00:00	MSFT	Stock	33.49	33.54	33.49	33.54	1900.0
2013-08-30 08:00:00	MSFT	Stock	33.52	33.54	33.45	33.52	11839.0
2013-08-30 09:00:00	MSFT	Stock	33.46	33.52	33.2	33.295	4750396.0
2013-08-30 10:00:00	MSFT	Stock	33.29	33.34	33.09	33.203	5928920.0
2013-08-30 11:00:00	MSFT	Stock	33.2	33.31	33.185	33.26	3442737.0
2013-08-30 12:00:00	MSFT	Stock	33.255	33.29	33.165	33.22	2880159.0
2013-08-30 13:00:00	MSFT	Stock	33.22	33.46	33.13	33.385	4239453.0
2013-08-30 14:00:00	MSFT	Stock	33.38	33.45	33.34	33.39	2877293.0
2013-08-30 15:00:00	MSFT	Stock	33.39	33.45	33.27	33.4	9769416.0
2013-08-30 16:00:00	MSFT	Stock	33.402	33.61	33.212	33.405	7980464.0
2013-08-30 17:00:00	MSFT	Stock	33.52	33.53	33.48	33.52	22520.0
2013-08-30 18:00:00	MSFT	Stock	33.51	33.51	33.42	33.42	6201.0
2013-08-30 19:00:00	MSFT	Stock	33.47	33.51	33.47	33.48	4436.0
2013-08-30 09:00:00	NVDA	Stock	0.3695	0.3705	0.368	0.3692	21695560.0
2013-08-30 10:00:00	NVDA	Stock	0.369	0.3703	0.3678	0.3694	40428640.0
2013-08-30 11:00:00	NVDA	Stock	0.3694	0.3703	0.3688	0.3691	21006200.0
2013-08-30 12:00:00	NVDA	Stock	0.3691	0.3695	0.3682	0.3688	23666600.0
2013-08-30 13:00:00	NVDA	Stock	0.3688	0.3692	0.3675	0.3686	27771080.0
2013-08-30 14:00:00	NVDA	Stock	0.3686	0.3692	0.368	0.3692	15997160.0
2013-08-30 15:00:00	NVDA	Stock	0.3691	0.3692	0.367	0.3685	68171200.0
2013-08-30 16:00:00	NVDA	Stock	0.3688	0.3692	0.3674	0.3689	59167040.0
2013-08-30 05:00:00	AMZN	Stock	14.25	14.25	14.25	14.25	2000.0
2013-08-30 08:00:00	AMZN	Stock	14.2375	14.2375	14.2	14.2	48000.0
2013-08-30 09:00:00	AMZN	Stock	14.217	14.2435	14.0585	14.0675	3792760.0
2013-08-30 10:00:00	AMZN	Stock	14.07	14.1325	14.04	14.057	6028180.0
2013-08-30 11:00:00	AMZN	Stock	14.0555	14.1295	14.03	14.0425	2997600.0
2013-08-30 12:00:00	AMZN	Stock	14.0415	14.074	14.033	14.0585	1666940.0
2013-08-30 13:00:00	AMZN	Stock	14.0555	14.0905	14.0	14.043	2972120.0
2013-08-30 14:00:00	AMZN	Stock	14.043	14.098	14.0344	14.065	1330160.0
2013-08-30 15:00:00	AMZN	Stock	14.063	14.079	14.0075	14.0495	6401140.0
2013-08-30 16:00:00	AMZN	Stock	14.049	14.0875	14.0434	14.049	1878480.0
2013-08-30 19:00:00	AMZN	Stock	14.0525	14.0525	14.0525	14.0525	2000.0

> showing 50 of 45,647 rows — these rows as CSV

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