PREVIEW / stock_1hour / 2003-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-29.parquet
  size:    414 KB
  rows:    19,651
  symbols: 1,527

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
2003-01-29 08:00:00	AAPL	Stock	0.2604	0.2604	0.257	0.257	95200.0
2003-01-29 09:00:00	AAPL	Stock	0.2578	0.2598	0.2554	0.2571	40314792.0
2003-01-29 10:00:00	AAPL	Stock	0.2571	0.2604	0.257	0.2593	65450224.0
2003-01-29 11:00:00	AAPL	Stock	0.2593	0.26	0.2591	0.2594	20669824.0
2003-01-29 12:00:00	AAPL	Stock	0.2593	0.2645	0.2591	0.2632	34502776.0
2003-01-29 13:00:00	AAPL	Stock	0.2632	0.2641	0.2611	0.2625	27814416.0
2003-01-29 14:00:00	AAPL	Stock	0.2625	0.2661	0.2616	0.2661	34302464.0
2003-01-29 15:00:00	AAPL	Stock	0.2661	0.2695	0.265	0.2666	103404168.0
2003-01-29 16:00:00	AAPL	Stock	0.2666	0.267	0.2647	0.2666	22330112.0
2003-01-29 17:00:00	AAPL	Stock	0.2661	0.2723	0.2659	0.2691	756112.0
2003-01-29 08:00:00	MSFT	Stock	24.435	24.435	24.012	24.275	220350.0
2003-01-29 09:00:00	MSFT	Stock	24.275	24.49	24.055	24.13	14006970.0
2003-01-29 10:00:00	MSFT	Stock	24.13	24.345	23.965	24.0305	18350606.0
2003-01-29 11:00:00	MSFT	Stock	24.04	24.325	24.02	24.265	9938826.0
2003-01-29 12:00:00	MSFT	Stock	24.265	24.585	24.225	24.535	12122492.0
2003-01-29 13:00:00	MSFT	Stock	24.535	24.69	24.47	24.5145	10750936.0
2003-01-29 14:00:00	MSFT	Stock	24.515	24.7	24.445	24.67	13680996.0
2003-01-29 15:00:00	MSFT	Stock	24.6755	25.0245	24.66	24.921	16797732.0
2003-01-29 16:00:00	MSFT	Stock	24.95	24.965	24.6024	24.8755	1576562.0
2003-01-29 17:00:00	MSFT	Stock	24.8755	24.955	24.87	24.875	142764.0
2003-01-29 18:00:00	MSFT	Stock	24.87	24.875	24.86	24.86	10400.0
2003-01-29 08:00:00	NVDA	Stock	0.0854	0.0879	0.0842	0.0846	3969600.0
2003-01-29 09:00:00	NVDA	Stock	0.0845	0.0875	0.0836	0.0869	189506040.0
2003-01-29 10:00:00	NVDA	Stock	0.0868	0.0889	0.086	0.0871	272774040.0
2003-01-29 11:00:00	NVDA	Stock	0.0871	0.0877	0.0867	0.0871	79999800.0
2003-01-29 12:00:00	NVDA	Stock	0.0872	0.0887	0.0865	0.0882	106824600.0
2003-01-29 13:00:00	NVDA	Stock	0.0882	0.0889	0.087	0.0873	68717760.0
2003-01-29 14:00:00	NVDA	Stock	0.0874	0.0886	0.0864	0.0883	92456520.0
2003-01-29 15:00:00	NVDA	Stock	0.0883	0.0888	0.0873	0.0884	121544640.0
2003-01-29 16:00:00	NVDA	Stock	0.0884	0.0887	0.0875	0.0883	11765160.0
2003-01-29 17:00:00	NVDA	Stock	0.0879	0.0882	0.0879	0.0879	2364000.0
2003-01-29 18:00:00	NVDA	Stock	0.0881	0.0881	0.0881	0.0881	120000.0
2003-01-29 08:00:00	AMZN	Stock	1.065	1.079	1.063	1.079	122000.0
2003-01-29 09:00:00	AMZN	Stock	1.079	1.087	1.0665	1.081	19758880.0
2003-01-29 10:00:00	AMZN	Stock	1.08	1.085	1.0775	1.0795	22046280.0
2003-01-29 11:00:00	AMZN	Stock	1.08	1.0865	1.0785	1.0845	12029120.0
2003-01-29 12:00:00	AMZN	Stock	1.0845	1.089	1.0825	1.0875	10840580.0
2003-01-29 13:00:00	AMZN	Stock	1.0875	1.093	1.084	1.093	10290340.0
2003-01-29 14:00:00	AMZN	Stock	1.092	1.096	1.0876	1.094	11644540.0
2003-01-29 15:00:00	AMZN	Stock	1.095	1.1175	1.093	1.105	27837760.0
2003-01-29 16:00:00	AMZN	Stock	1.1045	1.1175	1.104	1.115	12329000.0
2003-01-29 17:00:00	AMZN	Stock	1.1125	1.1125	1.1	1.103	1077000.0
2003-01-29 18:00:00	AMZN	Stock	1.1006	1.1006	1.1	1.1005	42000.0
2003-01-29 09:00:00	CL	Stock	25.6	25.62	25.495	25.52	282600.0
2003-01-29 10:00:00	CL	Stock	25.505	25.515	25.14	25.27	846400.0
2003-01-29 11:00:00	CL	Stock	25.24	25.43	25.22	25.39	389000.0
2003-01-29 12:00:00	CL	Stock	25.385	25.5	25.275	25.455	234600.0
2003-01-29 13:00:00	CL	Stock	25.46	25.525	25.41	25.45	226200.0
2003-01-29 14:00:00	CL	Stock	25.445	25.505	25.32	25.425	662200.0
2003-01-29 15:00:00	CL	Stock	25.43	25.525	25.405	25.425	782200.0

> showing 50 of 19,651 rows — these rows as CSV

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