PREVIEW / stock_1hour / 2002-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-29.parquet
  size:    388 KB
  rows:    18,506
  symbols: 1,473

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-08-29 08:00:00	AAPL	Stock	0.2626	0.2626	0.2589	0.2589	140000.0
2002-08-29 09:00:00	AAPL	Stock	0.262	0.2625	0.2591	0.2602	18517632.0
2002-08-29 10:00:00	AAPL	Stock	0.26	0.2661	0.2599	0.2641	31113992.0
2002-08-29 11:00:00	AAPL	Stock	0.2639	0.2652	0.2634	0.2645	13926976.0
2002-08-29 12:00:00	AAPL	Stock	0.2645	0.2682	0.263	0.2673	20458984.0
2002-08-29 13:00:00	AAPL	Stock	0.2675	0.2693	0.2643	0.2652	14932904.0
2002-08-29 14:00:00	AAPL	Stock	0.2652	0.2663	0.2614	0.2625	21189840.0
2002-08-29 15:00:00	AAPL	Stock	0.2625	0.265	0.2623	0.2623	26363400.0
2002-08-29 16:00:00	AAPL	Stock	0.2623	0.2632	0.2589	0.2611	7856128.0
2002-08-29 17:00:00	AAPL	Stock	0.2625	0.2625	0.2591	0.2591	1926400.0
2002-08-29 18:00:00	AAPL	Stock	0.2617	0.2617	0.2617	0.2617	392000.0
2002-08-29 08:00:00	MSFT	Stock	24.66	24.75	24.441	24.481	143288.0
2002-08-29 09:00:00	MSFT	Stock	24.5	24.7	24.26	24.375	9978948.0
2002-08-29 10:00:00	MSFT	Stock	24.375	24.975	24.35	24.925	17991978.0
2002-08-29 11:00:00	MSFT	Stock	24.925	25.115	24.91	25.075	10391058.0
2002-08-29 12:00:00	MSFT	Stock	25.0805	25.39	25.025	25.33	10091692.0
2002-08-29 13:00:00	MSFT	Stock	25.33	25.475	25.155	25.24	12789674.0
2002-08-29 14:00:00	MSFT	Stock	25.235	25.38	24.95	25.328	14903906.0
2002-08-29 15:00:00	MSFT	Stock	25.33	25.5	25.175	25.315	13596100.0
2002-08-29 16:00:00	MSFT	Stock	25.3	25.4745	24.775	25.185	2179710.0
2002-08-29 17:00:00	MSFT	Stock	25.215	25.29	25.0278	25.175	312800.0
2002-08-29 18:00:00	MSFT	Stock	25.1755	25.2514	25.175	25.22	62400.0
2002-08-29 08:00:00	NVDA	Stock	0.0858	0.0858	0.0833	0.0846	2269800.0
2002-08-29 09:00:00	NVDA	Stock	0.0846	0.0853	0.0836	0.0843	93613680.0
2002-08-29 10:00:00	NVDA	Stock	0.0842	0.0903	0.0842	0.0881	219574800.0
2002-08-29 11:00:00	NVDA	Stock	0.0882	0.0898	0.0877	0.0894	67737600.0
2002-08-29 12:00:00	NVDA	Stock	0.0894	0.0902	0.0887	0.0893	75409080.0
2002-08-29 13:00:00	NVDA	Stock	0.0895	0.0897	0.0875	0.0881	75236520.0
2002-08-29 14:00:00	NVDA	Stock	0.0881	0.0892	0.0866	0.0879	94432080.0
2002-08-29 15:00:00	NVDA	Stock	0.0879	0.0887	0.0862	0.0867	116122080.0
2002-08-29 16:00:00	NVDA	Stock	0.0865	0.0867	0.0843	0.0857	23305200.0
2002-08-29 17:00:00	NVDA	Stock	0.0865	0.0865	0.0857	0.0862	2687040.0
2002-08-29 18:00:00	NVDA	Stock	0.0858	0.0863	0.0858	0.0858	701760.0
2002-08-29 08:00:00	AMZN	Stock	0.729	0.7401	0.724	0.725	138000.0
2002-08-29 09:00:00	AMZN	Stock	0.725	0.7295	0.7105	0.719	13059800.0
2002-08-29 10:00:00	AMZN	Stock	0.7187	0.7375	0.7185	0.721	26405740.0
2002-08-29 11:00:00	AMZN	Stock	0.7215	0.7295	0.7175	0.7261	11622920.0
2002-08-29 12:00:00	AMZN	Stock	0.726	0.7495	0.7255	0.7435	13815200.0
2002-08-29 13:00:00	AMZN	Stock	0.7435	0.7595	0.738	0.7481	20347560.0
2002-08-29 14:00:00	AMZN	Stock	0.749	0.7535	0.7455	0.75	10657480.0
2002-08-29 15:00:00	AMZN	Stock	0.75	0.7545	0.7455	0.7525	13472900.0
2002-08-29 16:00:00	AMZN	Stock	0.753	0.7585	0.717	0.7535	19544000.0
2002-08-29 17:00:00	AMZN	Stock	0.7585	0.7585	0.749	0.755	388000.0
2002-08-29 18:00:00	AMZN	Stock	0.756	0.7565	0.756	0.7565	70000.0
2002-08-29 09:00:00	CL	Stock	26.6	26.605	26.5	26.575	288000.0
2002-08-29 10:00:00	CL	Stock	26.575	26.79	26.565	26.73	851000.0
2002-08-29 11:00:00	CL	Stock	26.73	26.87	26.725	26.8	295600.0
2002-08-29 12:00:00	CL	Stock	26.8	27.1	26.775	27.01	481800.0
2002-08-29 13:00:00	CL	Stock	27.01	27.025	26.795	26.82	310800.0
2002-08-29 14:00:00	CL	Stock	26.82	26.915	26.755	26.915	314600.0

> showing 50 of 18,506 rows — these rows as CSV

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