PREVIEW / stock_1hour / 2002-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-26.parquet
  size:    393 KB
  rows:    18,639
  symbols: 1,467

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-26 08:00:00	AAPL	Stock	0.28	0.28	0.28	0.28	61600.0
2002-08-26 09:00:00	AAPL	Stock	0.2802	0.2848	0.2789	0.2789	18607568.0
2002-08-26 10:00:00	AAPL	Stock	0.2788	0.2809	0.2711	0.272	50781584.0
2002-08-26 11:00:00	AAPL	Stock	0.2723	0.2732	0.2707	0.272	20220424.0
2002-08-26 12:00:00	AAPL	Stock	0.272	0.2743	0.2716	0.2734	15650264.0
2002-08-26 13:00:00	AAPL	Stock	0.2732	0.2757	0.2729	0.2748	16958144.0
2002-08-26 14:00:00	AAPL	Stock	0.2748	0.2777	0.2741	0.2761	27486536.0
2002-08-26 15:00:00	AAPL	Stock	0.2761	0.2796	0.2757	0.2777	31700256.0
2002-08-26 16:00:00	AAPL	Stock	0.2779	0.2786	0.277	0.2786	2447200.0
2002-08-26 17:00:00	AAPL	Stock	0.2786	0.2786	0.2773	0.2773	95648.0
2002-08-26 08:00:00	MSFT	Stock	26.39	26.435	26.17	26.325	54750.0
2002-08-26 09:00:00	MSFT	Stock	26.325	26.345	26.16	26.215	5259496.0
2002-08-26 10:00:00	MSFT	Stock	26.2105	26.3145	25.7	25.79	11612276.0
2002-08-26 11:00:00	MSFT	Stock	25.79	25.875	25.59	25.6505	7454956.0
2002-08-26 12:00:00	MSFT	Stock	25.6695	25.91	25.63	25.875	5374174.0
2002-08-26 13:00:00	MSFT	Stock	25.875	26.075	25.825	25.955	5931118.0
2002-08-26 14:00:00	MSFT	Stock	25.965	26.08	25.81	25.875	7304218.0
2002-08-26 15:00:00	MSFT	Stock	25.875	26.245	25.875	26.055	9742578.0
2002-08-26 16:00:00	MSFT	Stock	26.055	26.065	25.9664	26.01	1308868.0
2002-08-26 17:00:00	MSFT	Stock	26.01	26.05	26.01	26.01	46000.0
2002-08-26 18:00:00	MSFT	Stock	26.015	26.025	26.01	26.01	14300.0
2002-08-26 08:00:00	NVDA	Stock	0.0897	0.0983	0.0897	0.0982	4312920.0
2002-08-26 09:00:00	NVDA	Stock	0.0979	0.0982	0.0962	0.0972	81928440.0
2002-08-26 10:00:00	NVDA	Stock	0.0971	0.0977	0.092	0.093	143047440.0
2002-08-26 11:00:00	NVDA	Stock	0.093	0.0943	0.0928	0.0935	82021560.0
2002-08-26 12:00:00	NVDA	Stock	0.0934	0.0957	0.0933	0.0952	81025440.0
2002-08-26 13:00:00	NVDA	Stock	0.0952	0.098	0.0948	0.0967	86104920.0
2002-08-26 14:00:00	NVDA	Stock	0.0967	0.0977	0.0952	0.0958	75854880.0
2002-08-26 15:00:00	NVDA	Stock	0.0958	0.0971	0.0952	0.0964	108941880.0
2002-08-26 16:00:00	NVDA	Stock	0.0965	0.0968	0.0961	0.0961	7251840.0
2002-08-26 17:00:00	NVDA	Stock	0.0966	0.0971	0.0965	0.0967	1944000.0
2002-08-26 18:00:00	NVDA	Stock	0.0967	0.0971	0.0967	0.0971	943200.0
2002-08-26 08:00:00	AMZN	Stock	0.765	0.7655	0.765	0.7655	50000.0
2002-08-26 09:00:00	AMZN	Stock	0.7651	0.772	0.7565	0.7615	19100060.0
2002-08-26 10:00:00	AMZN	Stock	0.7615	0.767	0.7405	0.744	41111780.0
2002-08-26 11:00:00	AMZN	Stock	0.745	0.75	0.742	0.748	9686060.0
2002-08-26 12:00:00	AMZN	Stock	0.747	0.757	0.746	0.75	7216500.0
2002-08-26 13:00:00	AMZN	Stock	0.7505	0.7575	0.748	0.751	9036360.0
2002-08-26 14:00:00	AMZN	Stock	0.751	0.751	0.7405	0.742	15760340.0
2002-08-26 15:00:00	AMZN	Stock	0.743	0.7535	0.734	0.7445	19195700.0
2002-08-26 16:00:00	AMZN	Stock	0.744	0.7625	0.744	0.7525	1059240.0
2002-08-26 17:00:00	AMZN	Stock	0.7465	0.747	0.7465	0.7465	482000.0
2002-08-26 09:00:00	CL	Stock	26.8	26.85	26.8	26.82	427800.0
2002-08-26 10:00:00	CL	Stock	26.81	26.83	26.425	26.465	650600.0
2002-08-26 11:00:00	CL	Stock	26.465	26.59	26.405	26.51	417400.0
2002-08-26 12:00:00	CL	Stock	26.53	26.53	26.41	26.41	356600.0
2002-08-26 13:00:00	CL	Stock	26.43	26.52	26.38	26.495	267400.0
2002-08-26 14:00:00	CL	Stock	26.5	26.715	26.47	26.505	476600.0
2002-08-26 15:00:00	CL	Stock	26.51	26.79	26.495	26.63	408800.0
2002-08-26 16:00:00	CL	Stock	26.625	26.63	26.625	26.63	103400.0

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

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