PREVIEW / stock_1hour / 2011-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-10.parquet
  size:    963 KB
  rows:    46,273
  symbols: 3,531

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-08-10 04:00:00	AAPL	Stock	13.4957	13.4986	13.4375	13.4643	78400.0
2011-08-10 05:00:00	AAPL	Stock	13.4686	13.5357	13.4639	13.5143	131040.0
2011-08-10 06:00:00	AAPL	Stock	13.4936	13.5007	13.4554	13.4954	206696.0
2011-08-10 07:00:00	AAPL	Stock	13.4821	13.4911	13.3043	13.3493	1576008.0
2011-08-10 08:00:00	AAPL	Stock	13.3607	13.3839	13.2054	13.2107	7950488.0
2011-08-10 09:00:00	AAPL	Stock	13.2086	13.2811	13.1036	13.1264	135367820.0
2011-08-10 10:00:00	AAPL	Stock	13.1239	13.1714	13.0357	13.0914	138486208.0
2011-08-10 11:00:00	AAPL	Stock	13.0904	13.1554	13.01	13.1157	113876252.0
2011-08-10 12:00:00	AAPL	Stock	13.1154	13.2139	13.0954	13.1725	74801160.0
2011-08-10 13:00:00	AAPL	Stock	13.1679	13.2575	13.0971	13.2525	80345608.0
2011-08-10 14:00:00	AAPL	Stock	13.2525	13.3804	13.2104	13.2104	138262096.0
2011-08-10 15:00:00	AAPL	Stock	13.2104	13.2511	12.9464	12.9643	149858044.0
2011-08-10 16:00:00	AAPL	Stock	12.9643	13.1701	12.9621	13.06	33377652.0
2011-08-10 17:00:00	AAPL	Stock	13.0536	13.0604	13.0132	13.0361	465724.0
2011-08-10 18:00:00	AAPL	Stock	13.0304	13.0304	12.9889	13.015	339444.0
2011-08-10 19:00:00	AAPL	Stock	13.0136	13.0679	13.0136	13.0571	456792.0
2011-08-10 04:00:00	MSFT	Stock	25.72	25.72	25.61	25.61	200.0
2011-08-10 05:00:00	MSFT	Stock	25.58	25.58	25.5	25.5	400.0
2011-08-10 06:00:00	MSFT	Stock	25.62	25.62	25.62	25.62	200.0
2011-08-10 07:00:00	MSFT	Stock	25.44	25.58	25.4	25.4	5993.0
2011-08-10 08:00:00	MSFT	Stock	25.4	25.58	25.16	25.22	46574.0
2011-08-10 09:00:00	MSFT	Stock	25.2	25.2	24.4	24.4	12868707.0
2011-08-10 10:00:00	MSFT	Stock	24.4	24.63	24.17	24.31	22387244.0
2011-08-10 11:00:00	MSFT	Stock	24.31	24.62	24.1	24.579	16327228.0
2011-08-10 12:00:00	MSFT	Stock	24.57	24.86	24.47	24.855	15241528.0
2011-08-10 13:00:00	MSFT	Stock	24.85	25.05	24.65	25.05	10913984.0
2011-08-10 14:00:00	MSFT	Stock	25.05	25.09	24.61	24.61	10525917.0
2011-08-10 15:00:00	MSFT	Stock	24.62	24.679	24.15	24.17	28622732.0
2011-08-10 16:00:00	MSFT	Stock	24.19	25.03	24.12	24.2	9426952.0
2011-08-10 17:00:00	MSFT	Stock	25.58	25.58	24.2	24.55	278649.0
2011-08-10 18:00:00	MSFT	Stock	24.47	24.5	24.2	24.4	14735.0
2011-08-10 19:00:00	MSFT	Stock	24.4	24.55	24.36	24.55	30715.0
2011-08-10 07:00:00	NVDA	Stock	0.335	0.335	0.335	0.335	18000.0
2011-08-10 08:00:00	NVDA	Stock	0.3322	0.3322	0.315	0.317	488000.0
2011-08-10 09:00:00	NVDA	Stock	0.3173	0.3185	0.3068	0.3095	96297520.0
2011-08-10 10:00:00	NVDA	Stock	0.3095	0.3168	0.309	0.3118	201674880.0
2011-08-10 11:00:00	NVDA	Stock	0.3118	0.315	0.3088	0.3135	131153200.0
2011-08-10 12:00:00	NVDA	Stock	0.3133	0.3168	0.311	0.3135	80261160.0
2011-08-10 13:00:00	NVDA	Stock	0.3133	0.3203	0.3115	0.3195	92884120.0
2011-08-10 14:00:00	NVDA	Stock	0.3193	0.3228	0.3158	0.317	187550480.0
2011-08-10 15:00:00	NVDA	Stock	0.317	0.318	0.3075	0.3083	322971360.0
2011-08-10 16:00:00	NVDA	Stock	0.3062	0.3148	0.3062	0.3113	5905760.0
2011-08-10 17:00:00	NVDA	Stock	0.3233	0.3233	0.3115	0.3125	247320.0
2011-08-10 18:00:00	NVDA	Stock	0.3123	0.3138	0.3113	0.3138	660240.0
2011-08-10 19:00:00	NVDA	Stock	0.3138	0.3178	0.3138	0.3178	186000.0
2011-08-10 04:00:00	AMZN	Stock	10.21	10.21	10.2	10.2	16000.0
2011-08-10 05:00:00	AMZN	Stock	10.285	10.285	10.285	10.285	2000.0
2011-08-10 06:00:00	AMZN	Stock	10.275	10.275	10.235	10.235	14000.0
2011-08-10 07:00:00	AMZN	Stock	10.2145	10.221	10.177	10.209	77800.0
2011-08-10 08:00:00	AMZN	Stock	10.1635	10.2245	10.1265	10.1505	425160.0

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

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