PREVIEW / stock_1hour / 2002-09-03

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-03.parquet
  size:    401 KB
  rows:    19,311
  symbols: 1,470

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
2002-09-03 08:00:00	AAPL	Stock	0.2633	0.2634	0.2616	0.2634	1864800.0
2002-09-03 09:00:00	AAPL	Stock	0.2605	0.2634	0.257	0.2571	37172072.0
2002-09-03 10:00:00	AAPL	Stock	0.257	0.2575	0.2539	0.2552	46419296.0
2002-09-03 11:00:00	AAPL	Stock	0.2548	0.2554	0.2521	0.253	27453720.0
2002-09-03 12:00:00	AAPL	Stock	0.2529	0.2543	0.2513	0.2538	23459352.0
2002-09-03 13:00:00	AAPL	Stock	0.2539	0.255	0.2529	0.2541	21834400.0
2002-09-03 14:00:00	AAPL	Stock	0.2541	0.2548	0.2525	0.2527	32737152.0
2002-09-03 15:00:00	AAPL	Stock	0.2527	0.2531	0.2509	0.2518	63270704.0
2002-09-03 16:00:00	AAPL	Stock	0.2518	0.2527	0.2509	0.2509	6687744.0
2002-09-03 17:00:00	AAPL	Stock	0.2509	0.2509	0.2509	0.2509	56000.0
2002-09-03 18:00:00	AAPL	Stock	0.2511	0.2539	0.2511	0.2539	61600.0
2002-09-03 08:00:00	MSFT	Stock	24.25	24.6095	24.2	24.306	215756.0
2002-09-03 09:00:00	MSFT	Stock	24.339	24.545	23.98	24.025	10694724.0
2002-09-03 10:00:00	MSFT	Stock	24.03	24.055	23.705	23.75	16600578.0
2002-09-03 11:00:00	MSFT	Stock	23.755	23.935	23.685	23.75	8948740.0
2002-09-03 12:00:00	MSFT	Stock	23.7564	23.91	23.705	23.85	5551956.0
2002-09-03 13:00:00	MSFT	Stock	23.845	23.875	23.725	23.755	5052018.0
2002-09-03 14:00:00	MSFT	Stock	23.745	23.75	23.575	23.685	9230654.0
2002-09-03 15:00:00	MSFT	Stock	23.675	23.735	23.5	23.505	11853844.0
2002-09-03 16:00:00	MSFT	Stock	23.51	23.595	23.49	23.51	4803208.0
2002-09-03 17:00:00	MSFT	Stock	23.545	23.8241	23.545	23.56	194896.0
2002-09-03 18:00:00	MSFT	Stock	23.53	23.535	23.525	23.535	7300.0
2002-09-03 08:00:00	NVDA	Stock	0.0836	0.0837	0.0812	0.0813	1866000.0
2002-09-03 09:00:00	NVDA	Stock	0.0813	0.0892	0.0796	0.0798	178959840.0
2002-09-03 10:00:00	NVDA	Stock	0.0798	0.0802	0.0777	0.0797	197947680.0
2002-09-03 11:00:00	NVDA	Stock	0.0797	0.0799	0.0792	0.0796	65465880.0
2002-09-03 12:00:00	NVDA	Stock	0.0797	0.0805	0.0794	0.0797	87751080.0
2002-09-03 13:00:00	NVDA	Stock	0.08	0.0806	0.0792	0.0805	103663920.0
2002-09-03 14:00:00	NVDA	Stock	0.0805	0.0805	0.0792	0.0792	65869680.0
2002-09-03 15:00:00	NVDA	Stock	0.0792	0.0794	0.0783	0.0789	109767840.0
2002-09-03 16:00:00	NVDA	Stock	0.0791	0.0792	0.0787	0.0788	23617920.0
2002-09-03 17:00:00	NVDA	Stock	0.079	0.0792	0.0786	0.0791	996000.0
2002-09-03 18:00:00	NVDA	Stock	0.0791	0.0791	0.0787	0.0787	48000.0
2002-09-03 08:00:00	AMZN	Stock	0.7325	0.7375	0.7325	0.7375	68000.0
2002-09-03 09:00:00	AMZN	Stock	0.734	0.997	0.734	0.7395	17364740.0
2002-09-03 10:00:00	AMZN	Stock	0.738	0.7395	0.726	0.7295	16884480.0
2002-09-03 11:00:00	AMZN	Stock	0.728	0.74	0.7245	0.74	17654740.0
2002-09-03 12:00:00	AMZN	Stock	0.7395	0.74	0.73	0.7305	5106600.0
2002-09-03 13:00:00	AMZN	Stock	0.7305	0.7395	0.725	0.737	7558420.0
2002-09-03 14:00:00	AMZN	Stock	0.7375	0.7385	0.7305	0.732	7912560.0
2002-09-03 15:00:00	AMZN	Stock	0.7315	0.7355	0.7271	0.73	16411060.0
2002-09-03 16:00:00	AMZN	Stock	0.73	0.735	0.73	0.73	2106000.0
2002-09-03 17:00:00	AMZN	Stock	0.7301	0.7301	0.73	0.73	142000.0
2002-09-03 18:00:00	AMZN	Stock	0.73	0.73	0.73	0.73	34000.0
2002-09-03 09:00:00	CL	Stock	26.775	27.055	26.755	27.0	872000.0
2002-09-03 10:00:00	CL	Stock	26.99	26.99	26.635	26.64	554600.0
2002-09-03 11:00:00	CL	Stock	26.635	26.65	26.525	26.525	408600.0
2002-09-03 12:00:00	CL	Stock	26.525	26.79	26.505	26.705	371000.0
2002-09-03 13:00:00	CL	Stock	26.71	26.79	26.56	26.72	279400.0
2002-09-03 14:00:00	CL	Stock	26.715	26.715	26.58	26.595	399800.0

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

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