PREVIEW / stock_1hour / 2004-09-03

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-03.parquet
  size:    481 KB
  rows:    22,908
  symbols: 1,806

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
2004-09-03 08:00:00	AAPL	Stock	0.633	0.635	0.6255	0.6255	152600.0
2004-09-03 09:00:00	AAPL	Stock	0.6268	0.6366	0.6252	0.6355	43482320.0
2004-09-03 10:00:00	AAPL	Stock	0.6355	0.6414	0.6341	0.635	61330472.0
2004-09-03 11:00:00	AAPL	Stock	0.635	0.6384	0.6311	0.6354	40565112.0
2004-09-03 12:00:00	AAPL	Stock	0.6354	0.6355	0.633	0.6345	20000176.0
2004-09-03 13:00:00	AAPL	Stock	0.6343	0.6382	0.6339	0.6346	24019520.0
2004-09-03 14:00:00	AAPL	Stock	0.6346	0.6361	0.632	0.6323	25044880.0
2004-09-03 15:00:00	AAPL	Stock	0.6323	0.633	0.6284	0.6289	59872792.0
2004-09-03 16:00:00	AAPL	Stock	0.6286	0.6313	0.6284	0.6291	6407968.0
2004-09-03 17:00:00	AAPL	Stock	0.6291	0.6291	0.6286	0.6286	29680.0
2004-09-03 08:00:00	MSFT	Stock	27.52	27.52	27.35	27.46	28114.0
2004-09-03 09:00:00	MSFT	Stock	27.44	27.62	27.4	27.5	5479850.0
2004-09-03 10:00:00	MSFT	Stock	27.49	27.495	27.21	27.21	9168798.0
2004-09-03 11:00:00	MSFT	Stock	27.21	27.31	27.15	27.29	8711324.0
2004-09-03 12:00:00	MSFT	Stock	27.28	27.301	27.19	27.21	4372815.0
2004-09-03 13:00:00	MSFT	Stock	27.22	27.24	27.18	27.21	2813816.0
2004-09-03 14:00:00	MSFT	Stock	27.21	27.24	27.1	27.11	6039726.0
2004-09-03 15:00:00	MSFT	Stock	27.11	27.21	27.11	27.13	6714009.0
2004-09-03 16:00:00	MSFT	Stock	27.12	27.165	27.1	27.16	1489137.0
2004-09-03 17:00:00	MSFT	Stock	27.16	27.2576	27.16	27.2576	60325.0
2004-09-03 18:00:00	MSFT	Stock	27.15	27.15	27.15	27.15	600.0
2004-09-03 08:00:00	NVDA	Stock	0.106	0.1075	0.106	0.1075	468000.0
2004-09-03 09:00:00	NVDA	Stock	0.1082	0.1084	0.1065	0.108	135271080.0
2004-09-03 10:00:00	NVDA	Stock	0.1081	0.1081	0.1071	0.1073	125365320.0
2004-09-03 11:00:00	NVDA	Stock	0.1073	0.109	0.1059	0.1089	184808760.0
2004-09-03 12:00:00	NVDA	Stock	0.1087	0.1089	0.1074	0.1078	90483480.0
2004-09-03 13:00:00	NVDA	Stock	0.1077	0.1078	0.1073	0.1075	46640400.0
2004-09-03 14:00:00	NVDA	Stock	0.1074	0.1075	0.1067	0.1069	39124560.0
2004-09-03 15:00:00	NVDA	Stock	0.107	0.1073	0.1068	0.1069	77267520.0
2004-09-03 16:00:00	NVDA	Stock	0.1069	0.107	0.1067	0.1068	4776960.0
2004-09-03 17:00:00	NVDA	Stock	0.1063	0.1063	0.1063	0.1063	39000.0
2004-09-03 08:00:00	AMZN	Stock	1.926	1.95	1.926	1.95	14300.0
2004-09-03 09:00:00	AMZN	Stock	1.938	2.0005	1.938	1.99	21556480.0
2004-09-03 10:00:00	AMZN	Stock	1.99	1.9905	1.945	1.955	27687540.0
2004-09-03 11:00:00	AMZN	Stock	1.955	1.9615	1.945	1.9525	17032640.0
2004-09-03 12:00:00	AMZN	Stock	1.9525	1.9665	1.948	1.9505	5644100.0
2004-09-03 13:00:00	AMZN	Stock	1.9505	1.9595	1.9475	1.948	4551460.0
2004-09-03 14:00:00	AMZN	Stock	1.9475	1.948	1.932	1.9425	10894140.0
2004-09-03 15:00:00	AMZN	Stock	1.942	1.955	1.936	1.939	12792560.0
2004-09-03 16:00:00	AMZN	Stock	1.939	1.939	1.9335	1.937	893680.0
2004-09-03 17:00:00	AMZN	Stock	1.9325	1.937	1.9325	1.936	45640.0
2004-09-03 09:00:00	CL	Stock	27.44	27.625	27.405	27.595	383800.0
2004-09-03 10:00:00	CL	Stock	27.575	27.58	27.43	27.43	333600.0
2004-09-03 11:00:00	CL	Stock	27.41	27.5	27.39	27.49	235200.0
2004-09-03 12:00:00	CL	Stock	27.49	27.5	27.48	27.495	145800.0
2004-09-03 13:00:00	CL	Stock	27.495	27.515	27.49	27.505	157200.0
2004-09-03 14:00:00	CL	Stock	27.495	27.51	27.45	27.495	198000.0
2004-09-03 15:00:00	CL	Stock	27.49	27.5	27.42	27.435	297600.0
2004-09-03 16:00:00	CL	Stock	27.425	27.425	27.425	27.425	112600.0

> showing 49 of 22,908 rows — these rows as CSV

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