PREVIEW / stock_1hour / 2011-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-06.parquet
  size:    912 KB
  rows:    43,493
  symbols: 3,526

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-12-06 04:00:00	AAPL	Stock	14.0107	14.0429	14.0107	14.0179	47600.0
2011-12-06 05:00:00	AAPL	Stock	14.0179	14.0429	14.0179	14.0429	78708.0
2011-12-06 06:00:00	AAPL	Stock	14.0446	14.0446	14.0143	14.0143	8400.0
2011-12-06 07:00:00	AAPL	Stock	14.0536	14.0536	14.0271	14.0271	67200.0
2011-12-06 08:00:00	AAPL	Stock	14.0357	14.0411	13.9689	14.0107	628740.0
2011-12-06 09:00:00	AAPL	Stock	14.0107	14.0939	13.9993	14.0532	43722616.0
2011-12-06 10:00:00	AAPL	Stock	14.0518	14.0657	13.95	13.9832	55068636.0
2011-12-06 11:00:00	AAPL	Stock	13.9857	14.0036	13.9121	13.9468	39439484.0
2011-12-06 12:00:00	AAPL	Stock	13.9464	13.9582	13.9064	13.9361	20076084.0
2011-12-06 13:00:00	AAPL	Stock	13.9382	13.9739	13.9079	13.9539	23264360.0
2011-12-06 14:00:00	AAPL	Stock	13.9536	14.0293	13.9397	14.0171	35158984.0
2011-12-06 15:00:00	AAPL	Stock	14.0175	14.0393	13.9493	13.9643	56663012.0
2011-12-06 16:00:00	AAPL	Stock	13.9643	14.0334	13.9554	13.9757	8483692.0
2011-12-06 17:00:00	AAPL	Stock	13.9721	13.9818	13.9607	13.975	116340.0
2011-12-06 18:00:00	AAPL	Stock	13.9721	13.9732	13.9646	13.9714	173404.0
2011-12-06 19:00:00	AAPL	Stock	13.9721	13.9954	13.9707	13.9954	174552.0
2011-12-06 05:00:00	MSFT	Stock	25.77	25.77	25.77	25.77	2000.0
2011-12-06 07:00:00	MSFT	Stock	25.8	25.8	25.76	25.77	4700.0
2011-12-06 08:00:00	MSFT	Stock	25.77	25.8	25.7	25.7	19420.0
2011-12-06 09:00:00	MSFT	Stock	25.7	25.87	25.7	25.74	4892993.0
2011-12-06 10:00:00	MSFT	Stock	25.74	25.79	25.61	25.72	9889990.0
2011-12-06 11:00:00	MSFT	Stock	25.72	25.79	25.64	25.73	6348844.0
2011-12-06 12:00:00	MSFT	Stock	25.737	25.74	25.65	25.715	3057518.0
2011-12-06 13:00:00	MSFT	Stock	25.71	25.75	25.68	25.73	3598628.0
2011-12-06 14:00:00	MSFT	Stock	25.73	25.81	25.7	25.775	7074303.0
2011-12-06 15:00:00	MSFT	Stock	25.77	25.79	25.66	25.66	8493838.0
2011-12-06 16:00:00	MSFT	Stock	25.66	25.759	25.61	25.68	1956841.0
2011-12-06 17:00:00	MSFT	Stock	25.68	25.68	25.68	25.68	4255.0
2011-12-06 18:00:00	MSFT	Stock	25.66	25.69	25.66	25.69	3250.0
2011-12-06 19:00:00	MSFT	Stock	25.69	25.69	25.69	25.69	100.0
2011-12-06 08:00:00	NVDA	Stock	0.39	0.39	0.3888	0.3888	16000.0
2011-12-06 09:00:00	NVDA	Stock	0.388	0.39	0.3833	0.3882	53201800.0
2011-12-06 10:00:00	NVDA	Stock	0.3885	0.389	0.3828	0.3833	87090400.0
2011-12-06 11:00:00	NVDA	Stock	0.3834	0.3842	0.378	0.3805	86908000.0
2011-12-06 12:00:00	NVDA	Stock	0.3805	0.3806	0.3775	0.3785	58763400.0
2011-12-06 13:00:00	NVDA	Stock	0.3788	0.3815	0.3785	0.3813	56115680.0
2011-12-06 14:00:00	NVDA	Stock	0.3813	0.3835	0.379	0.3822	78369320.0
2011-12-06 15:00:00	NVDA	Stock	0.3825	0.3842	0.381	0.3813	140974040.0
2011-12-06 16:00:00	NVDA	Stock	0.3815	0.383	0.3805	0.383	9885680.0
2011-12-06 17:00:00	NVDA	Stock	0.3818	0.3818	0.3818	0.3818	4000.0
2011-12-06 19:00:00	NVDA	Stock	0.3825	0.383	0.3825	0.3825	64000.0
2011-12-06 05:00:00	AMZN	Stock	9.8995	9.9175	9.8995	9.917	12000.0
2011-12-06 06:00:00	AMZN	Stock	9.9175	9.9175	9.86	9.86	17600.0
2011-12-06 07:00:00	AMZN	Stock	9.8645	9.892	9.76	9.791	122000.0
2011-12-06 08:00:00	AMZN	Stock	9.785	9.788	9.71	9.71	178980.0
2011-12-06 09:00:00	AMZN	Stock	9.7535	9.916	9.7515	9.818	14808680.0
2011-12-06 10:00:00	AMZN	Stock	9.821	9.8385	9.6775	9.6775	15369080.0
2011-12-06 11:00:00	AMZN	Stock	9.6795	9.696	9.6165	9.6445	12505560.0
2011-12-06 12:00:00	AMZN	Stock	9.6455	9.6715	9.62	9.626	8655320.0
2011-12-06 13:00:00	AMZN	Stock	9.6295	9.6375	9.5055	9.5485	16710220.0

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

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