PREVIEW / stock_1hour / 2005-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-07.parquet
  size:    559 KB
  rows:    26,296
  symbols: 1,945

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
2005-03-07 08:00:00	AAPL	Stock	1.5357	1.5357	1.5143	1.5254	1391880.0
2005-03-07 09:00:00	AAPL	Stock	1.525	1.5361	1.5125	1.5286	84708652.0
2005-03-07 10:00:00	AAPL	Stock	1.5286	1.5446	1.5264	1.53	106340640.0
2005-03-07 11:00:00	AAPL	Stock	1.53	1.5354	1.5229	1.5282	55955424.0
2005-03-07 12:00:00	AAPL	Stock	1.5282	1.5321	1.5232	1.5236	34188532.0
2005-03-07 13:00:00	AAPL	Stock	1.5229	1.5304	1.5164	1.5271	57339212.0
2005-03-07 14:00:00	AAPL	Stock	1.5271	1.5304	1.5143	1.5257	39208960.0
2005-03-07 15:00:00	AAPL	Stock	1.5264	1.5286	1.5193	1.525	60436236.0
2005-03-07 16:00:00	AAPL	Stock	1.5214	1.5268	1.5189	1.5214	3357844.0
2005-03-07 17:00:00	AAPL	Stock	1.5207	1.5268	1.52	1.5218	1175020.0
2005-03-07 18:00:00	AAPL	Stock	1.5225	1.5268	1.5204	1.5239	313488.0
2005-03-07 08:00:00	MSFT	Stock	25.18	25.25	25.18	25.2	19574.0
2005-03-07 09:00:00	MSFT	Stock	25.2	25.43	25.16	25.39	11865446.0
2005-03-07 10:00:00	MSFT	Stock	25.39	25.5	25.37	25.42	13704721.0
2005-03-07 11:00:00	MSFT	Stock	25.43	25.5	25.4	25.48	9247524.0
2005-03-07 12:00:00	MSFT	Stock	25.48	25.79	25.48	25.66	15144376.0
2005-03-07 13:00:00	MSFT	Stock	25.67	25.68	25.46	25.56	9064788.0
2005-03-07 14:00:00	MSFT	Stock	25.56	25.6	25.48	25.54	5267414.0
2005-03-07 15:00:00	MSFT	Stock	25.53	25.58	25.45	25.46	10694067.0
2005-03-07 16:00:00	MSFT	Stock	25.46	25.515	25.4	25.41	1988071.0
2005-03-07 17:00:00	MSFT	Stock	25.47	25.47	25.4	25.41	1160809.0
2005-03-07 18:00:00	MSFT	Stock	25.44	25.47	25.43	25.45	7200.0
2005-03-07 08:00:00	NVDA	Stock	0.2285	0.2285	0.2285	0.2285	36000.0
2005-03-07 09:00:00	NVDA	Stock	0.2296	0.2308	0.2292	0.2302	57934560.0
2005-03-07 10:00:00	NVDA	Stock	0.2302	0.2361	0.2301	0.2347	125705880.0
2005-03-07 11:00:00	NVDA	Stock	0.2347	0.2355	0.2335	0.2342	56842920.0
2005-03-07 12:00:00	NVDA	Stock	0.2343	0.2352	0.2337	0.2347	45354120.0
2005-03-07 13:00:00	NVDA	Stock	0.2347	0.2367	0.2347	0.2367	51611760.0
2005-03-07 14:00:00	NVDA	Stock	0.2367	0.2369	0.2337	0.2343	72747360.0
2005-03-07 15:00:00	NVDA	Stock	0.2342	0.235	0.2317	0.2321	92985720.0
2005-03-07 16:00:00	NVDA	Stock	0.2318	0.2321	0.2304	0.2304	5233440.0
2005-03-07 17:00:00	NVDA	Stock	0.2321	0.2321	0.2309	0.2309	57480.0
2005-03-07 18:00:00	NVDA	Stock	0.2312	0.2312	0.2307	0.2307	396000.0
2005-03-07 09:00:00	AMZN	Stock	1.7925	1.812	1.7905	1.81	8659840.0
2005-03-07 10:00:00	AMZN	Stock	1.8105	1.8185	1.8075	1.809	17085800.0
2005-03-07 11:00:00	AMZN	Stock	1.809	1.82	1.8085	1.811	10934660.0
2005-03-07 12:00:00	AMZN	Stock	1.811	1.817	1.8105	1.815	6877840.0
2005-03-07 13:00:00	AMZN	Stock	1.8145	1.817	1.8125	1.816	4201140.0
2005-03-07 14:00:00	AMZN	Stock	1.816	1.817	1.811	1.814	6140900.0
2005-03-07 15:00:00	AMZN	Stock	1.8135	1.8195	1.812	1.814	16661240.0
2005-03-07 16:00:00	AMZN	Stock	1.8155	1.819	1.8125	1.816	401340.0
2005-03-07 17:00:00	AMZN	Stock	1.8125	1.82	1.8125	1.82	293820.0
2005-03-07 09:00:00	CL	Stock	26.495	26.575	26.385	26.425	196400.0
2005-03-07 10:00:00	CL	Stock	26.425	26.495	26.415	26.435	242400.0
2005-03-07 11:00:00	CL	Stock	26.43	26.495	26.395	26.435	402800.0
2005-03-07 12:00:00	CL	Stock	26.44	26.455	26.39	26.43	286200.0
2005-03-07 13:00:00	CL	Stock	26.44	26.51	26.4	26.505	351800.0
2005-03-07 14:00:00	CL	Stock	26.505	26.535	26.41	26.52	480600.0
2005-03-07 15:00:00	CL	Stock	26.525	26.53	26.405	26.43	606600.0
2005-03-07 16:00:00	CL	Stock	26.465	26.47	26.465	26.47	7800.0

> showing 50 of 26,296 rows — these rows as CSV

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