PREVIEW / stock_1hour / 2006-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-23.parquet
  size:    600 KB
  rows:    29,331
  symbols: 2,319

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
2006-08-23 07:00:00	AAPL	Stock	2.4179	2.4429	2.3768	2.425	106400.0
2006-08-23 08:00:00	AAPL	Stock	2.4232	2.4321	2.4221	2.4286	1347528.0
2006-08-23 09:00:00	AAPL	Stock	2.4275	2.4518	2.4109	2.445	87868508.0
2006-08-23 10:00:00	AAPL	Stock	2.4443	2.4482	2.4182	2.4229	120788808.0
2006-08-23 11:00:00	AAPL	Stock	2.4229	2.4304	2.3907	2.4054	124235608.0
2006-08-23 12:00:00	AAPL	Stock	2.405	2.4129	2.3968	2.4068	42764204.0
2006-08-23 13:00:00	AAPL	Stock	2.4071	2.4089	2.3929	2.3982	43682408.0
2006-08-23 14:00:00	AAPL	Stock	2.3975	2.4029	2.3932	2.3977	42096684.0
2006-08-23 15:00:00	AAPL	Stock	2.3975	2.4082	2.3961	2.4043	61750080.0
2006-08-23 16:00:00	AAPL	Stock	2.4032	2.4079	2.3964	2.4054	1904196.0
2006-08-23 17:00:00	AAPL	Stock	2.4	2.4046	2.3964	2.3968	322140.0
2006-08-23 18:00:00	AAPL	Stock	2.3968	2.4039	2.3964	2.3982	213360.0
2006-08-23 07:00:00	MSFT	Stock	25.61	25.61	25.61	25.61	3000.0
2006-08-23 08:00:00	MSFT	Stock	25.61	25.64	25.59	25.63	33511.0
2006-08-23 09:00:00	MSFT	Stock	25.63	25.85	25.52	25.833	7392590.0
2006-08-23 10:00:00	MSFT	Stock	25.83	25.95	25.68	25.731	10635729.0
2006-08-23 11:00:00	MSFT	Stock	25.732	25.76	25.61	25.698	5499401.0
2006-08-23 12:00:00	MSFT	Stock	25.7	25.73	25.57	25.65	3430650.0
2006-08-23 13:00:00	MSFT	Stock	25.65	25.69	25.55	25.59	3281045.0
2006-08-23 14:00:00	MSFT	Stock	25.6	25.66	25.56	25.57	4068625.0
2006-08-23 15:00:00	MSFT	Stock	25.57	25.74	25.56	25.7	7322849.0
2006-08-23 16:00:00	MSFT	Stock	25.71	25.74	25.61	25.67	282899.0
2006-08-23 17:00:00	MSFT	Stock	25.67	25.7	25.67	25.7	2325.0
2006-08-23 18:00:00	MSFT	Stock	25.69	25.69	25.69	25.69	16020.0
2006-08-23 08:00:00	NVDA	Stock	0.4383	0.4402	0.4383	0.4402	90000.0
2006-08-23 09:00:00	NVDA	Stock	0.4408	0.4463	0.434	0.4362	63304560.0
2006-08-23 10:00:00	NVDA	Stock	0.4362	0.4373	0.4297	0.4327	102207300.0
2006-08-23 11:00:00	NVDA	Stock	0.4327	0.4352	0.4285	0.4342	72575400.0
2006-08-23 12:00:00	NVDA	Stock	0.4342	0.4343	0.4307	0.4328	33592560.0
2006-08-23 13:00:00	NVDA	Stock	0.4328	0.4348	0.4305	0.432	59964180.0
2006-08-23 14:00:00	NVDA	Stock	0.432	0.4348	0.4308	0.4313	33405660.0
2006-08-23 15:00:00	NVDA	Stock	0.4313	0.4393	0.4313	0.4382	66476820.0
2006-08-23 16:00:00	NVDA	Stock	0.4382	0.4425	0.4375	0.4387	478680.0
2006-08-23 17:00:00	NVDA	Stock	0.4392	0.4413	0.4392	0.4413	30000.0
2006-08-23 18:00:00	NVDA	Stock	0.4415	0.4415	0.4382	0.4382	42000.0
2006-08-23 05:00:00	AMZN	Stock	1.4275	1.4275	1.4275	1.4275	2000.0
2006-08-23 08:00:00	AMZN	Stock	1.415	1.42	1.415	1.42	38000.0
2006-08-23 09:00:00	AMZN	Stock	1.422	1.44	1.4215	1.4355	8720040.0
2006-08-23 10:00:00	AMZN	Stock	1.4355	1.4445	1.4245	1.428	16789500.0
2006-08-23 11:00:00	AMZN	Stock	1.428	1.429	1.401	1.405	20343680.0
2006-08-23 12:00:00	AMZN	Stock	1.4045	1.408	1.401	1.402	7757600.0
2006-08-23 13:00:00	AMZN	Stock	1.402	1.406	1.3905	1.3955	9810240.0
2006-08-23 14:00:00	AMZN	Stock	1.3955	1.3975	1.3885	1.3925	8756160.0
2006-08-23 15:00:00	AMZN	Stock	1.392	1.4105	1.391	1.407	19031800.0
2006-08-23 16:00:00	AMZN	Stock	1.4065	1.4228	1.4055	1.407	270020.0
2006-08-23 18:00:00	AMZN	Stock	1.407	1.407	1.407	1.407	11000.0
2006-08-23 09:00:00	CL	Stock	29.43	29.72	29.4	29.685	253600.0
2006-08-23 10:00:00	CL	Stock	29.67	29.685	29.58	29.61	426000.0
2006-08-23 11:00:00	CL	Stock	29.61	29.655	29.575	29.645	288800.0
2006-08-23 12:00:00	CL	Stock	29.635	29.665	29.6	29.62	250800.0

> showing 50 of 29,331 rows — these rows as CSV

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