PREVIEW / stock_1hour / 2002-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-07.parquet
  size:    416 KB
  rows:    19,319
  symbols: 1,427

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-06-07 08:00:00	AAPL	Stock	0.3866	0.3982	0.384	0.3893	4418400.0
2002-06-07 09:00:00	AAPL	Stock	0.3893	0.3918	0.3788	0.3811	52998400.0
2002-06-07 10:00:00	AAPL	Stock	0.3811	0.3846	0.3738	0.3836	140229600.0
2002-06-07 11:00:00	AAPL	Stock	0.3836	0.3845	0.3816	0.3821	83636000.0
2002-06-07 12:00:00	AAPL	Stock	0.3821	0.3827	0.3795	0.3806	58755200.0
2002-06-07 13:00:00	AAPL	Stock	0.3805	0.3854	0.3804	0.3827	47801600.0
2002-06-07 14:00:00	AAPL	Stock	0.3827	0.3848	0.3811	0.3834	60166400.0
2002-06-07 15:00:00	AAPL	Stock	0.3832	0.3834	0.3811	0.382	94018400.0
2002-06-07 16:00:00	AAPL	Stock	0.3821	0.3846	0.3819	0.3821	21632800.0
2002-06-07 08:00:00	MSFT	Stock	24.85	25.997	24.75	24.9425	2483200.0
2002-06-07 09:00:00	MSFT	Stock	24.9475	25.92	24.925	25.08	17415200.0
2002-06-07 10:00:00	MSFT	Stock	25.085	25.4	25.07	25.224	15717000.0
2002-06-07 11:00:00	MSFT	Stock	25.23	25.78	25.174	25.605	12131800.0
2002-06-07 12:00:00	MSFT	Stock	25.6	25.88	25.595	25.7055	7621000.0
2002-06-07 13:00:00	MSFT	Stock	25.705	25.991	25.675	25.85	7960200.0
2002-06-07 14:00:00	MSFT	Stock	25.8443	26.3	25.835	25.87	12515400.0
2002-06-07 15:00:00	MSFT	Stock	25.85	26.03	25.72	25.97	12533600.0
2002-06-07 16:00:00	MSFT	Stock	25.98	26.024	25.5765	25.92	2461200.0
2002-06-07 17:00:00	MSFT	Stock	25.89	25.99	25.89	25.91	264800.0
2002-06-07 18:00:00	MSFT	Stock	25.885	25.895	25.83	25.83	21200.0
2002-06-07 08:00:00	NVDA	Stock	0.2546	0.2732	0.2461	0.2501	23220000.0
2002-06-07 09:00:00	NVDA	Stock	0.2501	0.2716	0.2492	0.2546	227208000.0
2002-06-07 10:00:00	NVDA	Stock	0.2543	0.2596	0.2533	0.2585	317328000.0
2002-06-07 11:00:00	NVDA	Stock	0.2583	0.2663	0.258	0.2627	194316000.0
2002-06-07 12:00:00	NVDA	Stock	0.2628	0.265	0.2617	0.2632	70272000.0
2002-06-07 13:00:00	NVDA	Stock	0.2635	0.2672	0.2629	0.266	82068000.0
2002-06-07 14:00:00	NVDA	Stock	0.266	0.2725	0.2652	0.2667	169248000.0
2002-06-07 15:00:00	NVDA	Stock	0.2669	0.2725	0.2657	0.2693	174216000.0
2002-06-07 16:00:00	NVDA	Stock	0.2692	0.2717	0.2619	0.2704	23136000.0
2002-06-07 17:00:00	NVDA	Stock	0.2725	0.2737	0.2692	0.2692	4224000.0
2002-06-07 18:00:00	NVDA	Stock	0.2708	0.2708	0.2708	0.2708	24000.0
2002-06-07 08:00:00	AMZN	Stock	0.897	0.912	0.8775	0.895	11628000.0
2002-06-07 09:00:00	AMZN	Stock	0.891	0.9175	0.8875	0.898	13426000.0
2002-06-07 10:00:00	AMZN	Stock	0.898	0.906	0.896	0.8996	16318000.0
2002-06-07 11:00:00	AMZN	Stock	0.8995	0.908	0.898	0.9045	8546000.0
2002-06-07 12:00:00	AMZN	Stock	0.903	0.9065	0.901	0.9025	7440000.0
2002-06-07 13:00:00	AMZN	Stock	0.9015	0.912	0.901	0.91	7508000.0
2002-06-07 14:00:00	AMZN	Stock	0.9105	0.9175	0.91	0.9155	10580000.0
2002-06-07 15:00:00	AMZN	Stock	0.915	0.9325	0.913	0.9315	23606000.0
2002-06-07 16:00:00	AMZN	Stock	0.929	0.9315	0.9255	0.926	1766000.0
2002-06-07 17:00:00	AMZN	Stock	0.929	0.929	0.927	0.929	360000.0
2002-06-07 18:00:00	AMZN	Stock	0.9305	0.9305	0.9305	0.9305	8000.0
2002-06-07 09:00:00	CL	Stock	27.5	27.5	27.33	27.425	423600.0
2002-06-07 10:00:00	CL	Stock	27.425	27.45	27.25	27.32	780000.0
2002-06-07 11:00:00	CL	Stock	27.325	27.475	27.175	27.4	606800.0
2002-06-07 12:00:00	CL	Stock	27.405	27.475	27.385	27.45	366600.0
2002-06-07 13:00:00	CL	Stock	27.45	27.5	27.41	27.48	257400.0
2002-06-07 14:00:00	CL	Stock	27.48	27.725	27.48	27.585	501200.0
2002-06-07 15:00:00	CL	Stock	27.58	27.625	27.505	27.57	496200.0
2002-06-07 16:00:00	CL	Stock	27.575	27.575	27.575	27.575	53400.0

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

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