PREVIEW / stock_1hour / 2003-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-10-20.parquet
  size:    471 KB
  rows:    22,428
  symbols: 1,635

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
2003-10-20 08:00:00	AAPL	Stock	0.4091	0.4107	0.4089	0.4089	143640.0
2003-10-20 09:00:00	AAPL	Stock	0.4093	0.4093	0.3996	0.4039	50684648.0
2003-10-20 10:00:00	AAPL	Stock	0.4038	0.4061	0.4015	0.4046	38514672.0
2003-10-20 11:00:00	AAPL	Stock	0.4046	0.4059	0.4036	0.4045	12518632.0
2003-10-20 12:00:00	AAPL	Stock	0.4045	0.4086	0.4034	0.408	41469064.0
2003-10-20 13:00:00	AAPL	Stock	0.408	0.412	0.4073	0.4111	34336344.0
2003-10-20 14:00:00	AAPL	Stock	0.4112	0.4139	0.4096	0.4118	31349024.0
2003-10-20 15:00:00	AAPL	Stock	0.4118	0.4168	0.4109	0.4161	50533952.0
2003-10-20 16:00:00	AAPL	Stock	0.4168	0.4196	0.4143	0.4195	4423104.0
2003-10-20 17:00:00	AAPL	Stock	0.4195	0.4196	0.4161	0.4171	403200.0
2003-10-20 18:00:00	AAPL	Stock	0.4193	0.4196	0.4163	0.4163	84000.0
2003-10-20 08:00:00	MSFT	Stock	29.0	29.09	28.93	28.962	93225.0
2003-10-20 09:00:00	MSFT	Stock	28.95	29.05	28.82	28.95	4379398.0
2003-10-20 10:00:00	MSFT	Stock	28.96	29.003	28.8	28.89	6496587.0
2003-10-20 11:00:00	MSFT	Stock	28.89	29.07	28.88	29.04	4281788.0
2003-10-20 12:00:00	MSFT	Stock	29.03	29.231	29.02	29.219	4602363.0
2003-10-20 13:00:00	MSFT	Stock	29.22	29.27	29.13	29.21	4695153.0
2003-10-20 14:00:00	MSFT	Stock	29.21	29.23	29.05	29.17	3646451.0
2003-10-20 15:00:00	MSFT	Stock	29.18	29.37	29.17	29.37	7535745.0
2003-10-20 16:00:00	MSFT	Stock	29.37	29.46	29.18	29.46	661892.0
2003-10-20 17:00:00	MSFT	Stock	29.46	29.51	29.0872	29.51	153309.0
2003-10-20 18:00:00	MSFT	Stock	29.51	29.52	29.5	29.52	11905.0
2003-10-20 08:00:00	NVDA	Stock	0.1389	0.1402	0.1388	0.1396	384000.0
2003-10-20 09:00:00	NVDA	Stock	0.1392	0.141	0.1387	0.1402	38226120.0
2003-10-20 10:00:00	NVDA	Stock	0.1403	0.1412	0.1381	0.1401	116948040.0
2003-10-20 11:00:00	NVDA	Stock	0.1401	0.1405	0.1397	0.1402	61144080.0
2003-10-20 12:00:00	NVDA	Stock	0.1402	0.1409	0.1402	0.1407	66120720.0
2003-10-20 13:00:00	NVDA	Stock	0.1407	0.141	0.14	0.1402	32811600.0
2003-10-20 14:00:00	NVDA	Stock	0.1403	0.1408	0.14	0.1407	30991320.0
2003-10-20 15:00:00	NVDA	Stock	0.1406	0.1421	0.1406	0.1421	101938080.0
2003-10-20 16:00:00	NVDA	Stock	0.1421	0.1437	0.1417	0.1429	5846160.0
2003-10-20 17:00:00	NVDA	Stock	0.1426	0.1433	0.142	0.1427	2814000.0
2003-10-20 18:00:00	NVDA	Stock	0.1427	0.1427	0.1426	0.1427	348000.0
2003-10-20 08:00:00	AMZN	Stock	2.97	2.985	2.97	2.985	140000.0
2003-10-20 09:00:00	AMZN	Stock	2.9825	3.0	2.975	2.995	25571360.0
2003-10-20 10:00:00	AMZN	Stock	2.995	3.012	2.9565	2.9805	64632940.0
2003-10-20 11:00:00	AMZN	Stock	2.9805	2.991	2.975	2.9785	28657780.0
2003-10-20 12:00:00	AMZN	Stock	2.9784	2.982	2.9665	2.979	17280700.0
2003-10-20 13:00:00	AMZN	Stock	2.9793	2.985	2.955	2.958	21424480.0
2003-10-20 14:00:00	AMZN	Stock	2.9585	2.966	2.946	2.954	22202820.0
2003-10-20 15:00:00	AMZN	Stock	2.954	2.985	2.9515	2.9835	30109080.0
2003-10-20 16:00:00	AMZN	Stock	2.985	3.019	2.9745	3.0125	2820020.0
2003-10-20 17:00:00	AMZN	Stock	3.0125	3.019	2.9751	3.01	684660.0
2003-10-20 18:00:00	AMZN	Stock	3.01	3.0165	3.0	3.005	312000.0
2003-10-20 09:00:00	CL	Stock	28.65	28.69	28.53	28.68	180200.0
2003-10-20 10:00:00	CL	Stock	28.68	28.705	28.485	28.505	334800.0
2003-10-20 11:00:00	CL	Stock	28.505	28.685	28.44	28.675	313000.0
2003-10-20 12:00:00	CL	Stock	28.675	28.75	28.665	28.725	378000.0
2003-10-20 13:00:00	CL	Stock	28.72	28.775	28.56	28.57	307000.0
2003-10-20 14:00:00	CL	Stock	28.57	28.615	28.5	28.575	553800.0

> showing 50 of 22,428 rows — these rows as CSV

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