PREVIEW / stock_1hour / 2002-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-04.parquet
  size:    391 KB
  rows:    18,655
  symbols: 1,469

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-04 08:00:00	AAPL	Stock	0.251	0.251	0.251	0.251	95200.0
2002-09-04 09:00:00	AAPL	Stock	0.252	0.262	0.252	0.2616	65489088.0
2002-09-04 10:00:00	AAPL	Stock	0.2618	0.2639	0.2546	0.2561	62684048.0
2002-09-04 11:00:00	AAPL	Stock	0.2561	0.2566	0.2546	0.2561	25936736.0
2002-09-04 12:00:00	AAPL	Stock	0.2563	0.2563	0.2538	0.2559	73367168.0
2002-09-04 13:00:00	AAPL	Stock	0.2561	0.2586	0.2555	0.2561	50795248.0
2002-09-04 14:00:00	AAPL	Stock	0.2557	0.2598	0.2557	0.2596	29126720.0
2002-09-04 15:00:00	AAPL	Stock	0.2596	0.2602	0.2559	0.2575	68922000.0
2002-09-04 16:00:00	AAPL	Stock	0.2573	0.2586	0.2539	0.2557	27977600.0
2002-09-04 17:00:00	AAPL	Stock	0.2586	0.2586	0.2554	0.2586	2648800.0
2002-09-04 08:00:00	MSFT	Stock	23.63	23.7	23.45	23.674	86948.0
2002-09-04 09:00:00	MSFT	Stock	23.66	24.145	23.6505	24.1335	14516076.0
2002-09-04 10:00:00	MSFT	Stock	24.1325	24.175	23.85	23.9	13042446.0
2002-09-04 11:00:00	MSFT	Stock	23.9	23.95	23.7	23.785	9840536.0
2002-09-04 12:00:00	MSFT	Stock	23.785	23.81	23.575	23.77	7589308.0
2002-09-04 13:00:00	MSFT	Stock	23.77	24.015	23.66	23.835	7745232.0
2002-09-04 14:00:00	MSFT	Stock	23.845	24.15	23.845	24.06	9382890.0
2002-09-04 15:00:00	MSFT	Stock	24.055	24.3	24.0345	24.13	12817046.0
2002-09-04 16:00:00	MSFT	Stock	24.12	24.175	24.04	24.075	2355840.0
2002-09-04 17:00:00	MSFT	Stock	24.09	24.105	23.963	24.085	892200.0
2002-09-04 18:00:00	MSFT	Stock	24.095	24.095	24.095	24.095	800.0
2002-09-04 08:00:00	NVDA	Stock	0.0791	0.0794	0.0791	0.0794	483240.0
2002-09-04 09:00:00	NVDA	Stock	0.0795	0.0812	0.0776	0.0808	117616440.0
2002-09-04 10:00:00	NVDA	Stock	0.0808	0.0813	0.0785	0.0788	170069880.0
2002-09-04 11:00:00	NVDA	Stock	0.0788	0.079	0.0773	0.0773	101182800.0
2002-09-04 12:00:00	NVDA	Stock	0.0773	0.0777	0.0751	0.0762	172608480.0
2002-09-04 13:00:00	NVDA	Stock	0.0762	0.0766	0.0757	0.0759	102863640.0
2002-09-04 14:00:00	NVDA	Stock	0.0759	0.079	0.0758	0.0788	107410440.0
2002-09-04 15:00:00	NVDA	Stock	0.0787	0.0798	0.0783	0.0786	129258840.0
2002-09-04 16:00:00	NVDA	Stock	0.0787	0.0787	0.0782	0.0782	17952000.0
2002-09-04 17:00:00	NVDA	Stock	0.0785	0.0789	0.0782	0.0786	2892000.0
2002-09-04 18:00:00	NVDA	Stock	0.0783	0.0788	0.0783	0.0788	258000.0
2002-09-04 09:00:00	AMZN	Stock	0.7345	0.7355	0.7225	0.732	9814100.0
2002-09-04 10:00:00	AMZN	Stock	0.732	0.735	0.717	0.7195	14667580.0
2002-09-04 11:00:00	AMZN	Stock	0.7195	0.73	0.719	0.724	9078240.0
2002-09-04 12:00:00	AMZN	Stock	0.724	0.7245	0.7145	0.7185	6165000.0
2002-09-04 13:00:00	AMZN	Stock	0.719	0.73	0.713	0.723	12052000.0
2002-09-04 14:00:00	AMZN	Stock	0.723	0.7385	0.7225	0.7385	8538020.0
2002-09-04 15:00:00	AMZN	Stock	0.7375	0.748	0.725	0.7395	22509740.0
2002-09-04 16:00:00	AMZN	Stock	0.74	0.7435	0.7375	0.738	1260000.0
2002-09-04 17:00:00	AMZN	Stock	0.738	0.744	0.738	0.7415	342000.0
2002-09-04 09:00:00	CL	Stock	26.465	26.675	26.43	26.65	411800.0
2002-09-04 10:00:00	CL	Stock	26.65	26.74	26.55	26.68	441200.0
2002-09-04 11:00:00	CL	Stock	26.675	26.875	26.62	26.84	420000.0
2002-09-04 12:00:00	CL	Stock	26.84	26.975	26.8	26.955	393800.0
2002-09-04 13:00:00	CL	Stock	26.955	27.075	26.875	26.975	649600.0
2002-09-04 14:00:00	CL	Stock	26.995	27.13	26.95	27.13	475000.0
2002-09-04 15:00:00	CL	Stock	27.135	27.31	27.105	27.255	1228600.0
2002-09-04 16:00:00	CL	Stock	27.25	27.255	27.25	27.255	200400.0

> showing 49 of 18,655 rows — these rows as CSV

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