PREVIEW / stock_1hour / 2011-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-21.parquet
  size:    907 KB
  rows:    43,393
  symbols: 3,500

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-09-21 04:00:00	AAPL	Stock	14.8457	14.8475	14.7793	14.8039	52920.0
2011-09-21 05:00:00	AAPL	Stock	14.8129	14.8736	14.8129	14.8557	22400.0
2011-09-21 06:00:00	AAPL	Stock	14.8321	14.8386	14.8254	14.8254	14000.0
2011-09-21 07:00:00	AAPL	Stock	14.8254	14.9221	14.825	14.8286	1383116.0
2011-09-21 08:00:00	AAPL	Stock	14.8304	14.9096	14.7821	14.9011	3733744.0
2011-09-21 09:00:00	AAPL	Stock	14.9	15.0568	14.8829	14.9646	103401284.0
2011-09-21 10:00:00	AAPL	Stock	14.9679	14.9821	14.8532	14.8932	85920716.0
2011-09-21 11:00:00	AAPL	Stock	14.8893	15.0282	14.8854	14.9943	59238984.0
2011-09-21 12:00:00	AAPL	Stock	14.9943	15.0268	14.9132	14.9414	52717224.0
2011-09-21 13:00:00	AAPL	Stock	14.9404	14.9857	14.9268	14.9302	30148076.0
2011-09-21 14:00:00	AAPL	Stock	14.93	15.0416	14.8432	14.9668	113449140.0
2011-09-21 15:00:00	AAPL	Stock	14.9668	15.0039	14.7143	14.7214	135014096.0
2011-09-21 16:00:00	AAPL	Stock	14.7143	14.9932	14.6939	14.7118	9488556.0
2011-09-21 17:00:00	AAPL	Stock	14.7118	14.72	14.6836	14.6839	1179220.0
2011-09-21 18:00:00	AAPL	Stock	14.6836	14.7193	14.6429	14.6539	1093400.0
2011-09-21 19:00:00	AAPL	Stock	14.6604	14.6875	14.6496	14.6839	542836.0
2011-09-21 07:00:00	MSFT	Stock	27.13	27.13	26.96	26.97	34550.0
2011-09-21 08:00:00	MSFT	Stock	26.99	27.17	26.9	27.05	80638.0
2011-09-21 09:00:00	MSFT	Stock	27.04	27.06	26.725	26.762	9344914.0
2011-09-21 10:00:00	MSFT	Stock	26.76	26.79	26.375	26.45	10984726.0
2011-09-21 11:00:00	MSFT	Stock	26.44	26.61	26.43	26.59	5948908.0
2011-09-21 12:00:00	MSFT	Stock	26.59	26.66	26.53	26.6	4936475.0
2011-09-21 13:00:00	MSFT	Stock	26.59	26.6	26.48	26.585	4151595.0
2011-09-21 14:00:00	MSFT	Stock	26.589	26.64	26.27	26.365	12012461.0
2011-09-21 15:00:00	MSFT	Stock	26.37	26.47	25.97	25.98	20600026.0
2011-09-21 16:00:00	MSFT	Stock	25.99	26.53	25.9	25.98	3282105.0
2011-09-21 17:00:00	MSFT	Stock	25.96	26.123	25.96	26.02	78103.0
2011-09-21 18:00:00	MSFT	Stock	26.02	26.02	25.95	25.98	45210.0
2011-09-21 19:00:00	MSFT	Stock	25.97	26.0	25.94	26.0	7831.0
2011-09-21 07:00:00	NVDA	Stock	0.3688	0.3688	0.3688	0.3688	8000.0
2011-09-21 08:00:00	NVDA	Stock	0.3713	0.3715	0.3675	0.3715	340360.0
2011-09-21 09:00:00	NVDA	Stock	0.3715	0.374	0.3672	0.3719	62737720.0
2011-09-21 10:00:00	NVDA	Stock	0.372	0.3733	0.3675	0.369	87651240.0
2011-09-21 11:00:00	NVDA	Stock	0.369	0.374	0.3685	0.3733	70730480.0
2011-09-21 12:00:00	NVDA	Stock	0.3733	0.3771	0.3728	0.374	88918480.0
2011-09-21 13:00:00	NVDA	Stock	0.3738	0.3755	0.3735	0.3743	53466920.0
2011-09-21 14:00:00	NVDA	Stock	0.374	0.377	0.3688	0.3718	137042200.0
2011-09-21 15:00:00	NVDA	Stock	0.3715	0.375	0.3615	0.3615	192812800.0
2011-09-21 16:00:00	NVDA	Stock	0.3618	0.3711	0.36	0.3612	6961000.0
2011-09-21 17:00:00	NVDA	Stock	0.3602	0.361	0.36	0.361	408200.0
2011-09-21 18:00:00	NVDA	Stock	0.3612	0.3618	0.3575	0.3592	1031200.0
2011-09-21 19:00:00	NVDA	Stock	0.3582	0.3588	0.358	0.3585	159560.0
2011-09-21 07:00:00	AMZN	Stock	11.676	11.7	11.676	11.68	26000.0
2011-09-21 08:00:00	AMZN	Stock	11.656	11.665	11.5955	11.6625	294040.0
2011-09-21 09:00:00	AMZN	Stock	11.6745	11.8415	11.6505	11.825	17034340.0
2011-09-21 10:00:00	AMZN	Stock	11.825	11.899	11.714	11.755	17347960.0
2011-09-21 11:00:00	AMZN	Stock	11.755	11.924	11.725	11.899	12095820.0
2011-09-21 12:00:00	AMZN	Stock	11.9032	11.9165	11.7929	11.817	9157220.0
2011-09-21 13:00:00	AMZN	Stock	11.814	11.8275	11.78	11.815	5057880.0
2011-09-21 14:00:00	AMZN	Stock	11.817	11.934	11.7185	11.856	21107200.0

> showing 50 of 43,393 rows — these rows as CSV

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