PREVIEW / stock_1hour / 2012-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-27.parquet
  size:    949 KB
  rows:    44,900
  symbols: 3,524

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-03-27 04:00:00	AAPL	Stock	21.6879	21.6961	21.6679	21.6679	70168.0
2012-03-27 05:00:00	AAPL	Stock	21.6779	21.6964	21.6679	21.6679	138600.0
2012-03-27 06:00:00	AAPL	Stock	21.6679	21.6964	21.6679	21.6714	98336.0
2012-03-27 07:00:00	AAPL	Stock	21.6782	21.6782	21.595	21.6179	652904.0
2012-03-27 08:00:00	AAPL	Stock	21.6071	21.675	21.6036	21.65	3037972.0
2012-03-27 09:00:00	AAPL	Stock	21.6518	21.9071	21.6311	21.8354	135696344.0
2012-03-27 10:00:00	AAPL	Stock	21.8371	21.9611	21.8146	21.8786	128434488.0
2012-03-27 11:00:00	AAPL	Stock	21.8802	21.9439	21.8768	21.9086	49675976.0
2012-03-27 12:00:00	AAPL	Stock	21.9096	21.9504	21.9054	21.92	41338136.0
2012-03-27 13:00:00	AAPL	Stock	21.9186	21.9814	21.9146	21.975	43782956.0
2012-03-27 14:00:00	AAPL	Stock	21.975	21.9814	21.9379	21.9554	50528744.0
2012-03-27 15:00:00	AAPL	Stock	21.959	22.01	21.8721	21.9489	128745932.0
2012-03-27 16:00:00	AAPL	Stock	21.9457	21.9536	21.8972	21.9375	10568404.0
2012-03-27 17:00:00	AAPL	Stock	21.9357	21.9375	21.6736	21.9314	501732.0
2012-03-27 18:00:00	AAPL	Stock	21.9279	21.9418	21.9257	21.9396	282016.0
2012-03-27 19:00:00	AAPL	Stock	21.9396	21.9568	21.9375	21.9568	833168.0
2012-03-27 08:00:00	MSFT	Stock	32.66	32.66	32.63	32.63	2521.0
2012-03-27 09:00:00	MSFT	Stock	32.65	32.7	32.5	32.54	3315786.0
2012-03-27 10:00:00	MSFT	Stock	32.55	32.67	32.4	32.64	5202715.0
2012-03-27 11:00:00	MSFT	Stock	32.64	32.68	32.57	32.6	3543431.0
2012-03-27 12:00:00	MSFT	Stock	32.598	32.64	32.53	32.575	3059560.0
2012-03-27 13:00:00	MSFT	Stock	32.576	32.63	32.5	32.626	2839319.0
2012-03-27 14:00:00	MSFT	Stock	32.625	32.69	32.59	32.67	4209136.0
2012-03-27 15:00:00	MSFT	Stock	32.66	32.7	32.47	32.53	7656080.0
2012-03-27 16:00:00	MSFT	Stock	32.52	32.6	32.46	32.47	4913583.0
2012-03-27 17:00:00	MSFT	Stock	32.59	32.59	32.46	32.5	23908.0
2012-03-27 18:00:00	MSFT	Stock	32.5	32.5	32.5	32.5	108.0
2012-03-27 19:00:00	MSFT	Stock	32.51	32.51	32.51	32.51	500.0
2012-03-27 08:00:00	NVDA	Stock	0.3688	0.3688	0.3688	0.3688	10840.0
2012-03-27 09:00:00	NVDA	Stock	0.3688	0.375	0.3688	0.3744	49700600.0
2012-03-27 10:00:00	NVDA	Stock	0.3745	0.3745	0.371	0.3735	81776640.0
2012-03-27 11:00:00	NVDA	Stock	0.3733	0.3735	0.3715	0.3718	42642520.0
2012-03-27 12:00:00	NVDA	Stock	0.3718	0.3738	0.3718	0.3735	39098960.0
2012-03-27 13:00:00	NVDA	Stock	0.3735	0.3738	0.3718	0.3729	48313760.0
2012-03-27 14:00:00	NVDA	Stock	0.3728	0.374	0.3708	0.371	53410960.0
2012-03-27 15:00:00	NVDA	Stock	0.3711	0.3723	0.3703	0.3705	91563320.0
2012-03-27 16:00:00	NVDA	Stock	0.3705	0.3723	0.3695	0.3705	12795880.0
2012-03-27 17:00:00	NVDA	Stock	0.37	0.3725	0.37	0.3725	150360.0
2012-03-27 07:00:00	AMZN	Stock	10.1435	10.1435	10.1435	10.1435	8000.0
2012-03-27 08:00:00	AMZN	Stock	10.103	10.245	10.103	10.2255	1211500.0
2012-03-27 09:00:00	AMZN	Stock	10.212	10.322	10.144	10.2055	34361540.0
2012-03-27 10:00:00	AMZN	Stock	10.2055	10.361	10.1875	10.3195	36407080.0
2012-03-27 11:00:00	AMZN	Stock	10.3195	10.4375	10.3177	10.4025	28159820.0
2012-03-27 12:00:00	AMZN	Stock	10.404	10.48	10.393	10.46	20118240.0
2012-03-27 13:00:00	AMZN	Stock	10.462	10.4925	10.43	10.473	16058300.0
2012-03-27 14:00:00	AMZN	Stock	10.47	10.4855	10.443	10.4535	12692300.0
2012-03-27 15:00:00	AMZN	Stock	10.4541	10.4575	10.258	10.2725	38487760.0
2012-03-27 16:00:00	AMZN	Stock	10.277	10.3534	10.1816	10.272	1250900.0
2012-03-27 17:00:00	AMZN	Stock	10.272	10.272	10.25	10.25	35960.0
2012-03-27 18:00:00	AMZN	Stock	10.262	10.2945	10.262	10.2775	85600.0

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

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