PREVIEW / stock_1hour / 2003-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-24.parquet
  size:    491 KB
  rows:    22,414
  symbols: 1,615

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-09-24 08:00:00	AAPL	Stock	0.4	0.4	0.4	0.4	56000.0
2003-09-24 09:00:00	AAPL	Stock	0.4	0.4	0.3923	0.3936	24375400.0
2003-09-24 10:00:00	AAPL	Stock	0.3934	0.3945	0.3889	0.3891	29399216.0
2003-09-24 11:00:00	AAPL	Stock	0.3889	0.3896	0.383	0.383	41098232.0
2003-09-24 12:00:00	AAPL	Stock	0.3829	0.3829	0.377	0.3777	50854608.0
2003-09-24 13:00:00	AAPL	Stock	0.3779	0.3809	0.3765	0.3786	21554120.0
2003-09-24 14:00:00	AAPL	Stock	0.3784	0.3832	0.3779	0.382	31657136.0
2003-09-24 15:00:00	AAPL	Stock	0.3825	0.3843	0.3793	0.3795	59767064.0
2003-09-24 16:00:00	AAPL	Stock	0.3802	0.3814	0.3793	0.3804	1360800.0
2003-09-24 17:00:00	AAPL	Stock	0.3768	0.3807	0.3759	0.3759	193760.0
2003-09-24 08:00:00	MSFT	Stock	29.72	29.81	29.72	29.751	35372.0
2003-09-24 09:00:00	MSFT	Stock	29.76	29.76	29.37	29.403	6649995.0
2003-09-24 10:00:00	MSFT	Stock	29.403	29.5	29.27	29.29	6653087.0
2003-09-24 11:00:00	MSFT	Stock	29.29	29.38	29.11	29.13	6017598.0
2003-09-24 12:00:00	MSFT	Stock	29.13	29.13	28.65	28.82	9357873.0
2003-09-24 13:00:00	MSFT	Stock	28.821	28.84	28.56	28.6	5887237.0
2003-09-24 14:00:00	MSFT	Stock	28.6	28.79	28.52	28.55	6444785.0
2003-09-24 15:00:00	MSFT	Stock	28.55	28.63	28.419	28.48	11001666.0
2003-09-24 16:00:00	MSFT	Stock	28.47	28.54	28.4	28.46	4610105.0
2003-09-24 17:00:00	MSFT	Stock	28.42	28.46	28.38	28.4	173727.0
2003-09-24 18:00:00	MSFT	Stock	28.4	28.43	28.4	28.43	3807.0
2003-09-24 08:00:00	NVDA	Stock	0.1604	0.1605	0.1579	0.1585	8892000.0
2003-09-24 09:00:00	NVDA	Stock	0.1587	0.1598	0.1545	0.1554	188159160.0
2003-09-24 10:00:00	NVDA	Stock	0.1555	0.1555	0.1518	0.1527	327327600.0
2003-09-24 11:00:00	NVDA	Stock	0.1527	0.153	0.1482	0.1493	306346680.0
2003-09-24 12:00:00	NVDA	Stock	0.1493	0.151	0.149	0.1503	99459840.0
2003-09-24 13:00:00	NVDA	Stock	0.1503	0.1523	0.1502	0.1516	119802600.0
2003-09-24 14:00:00	NVDA	Stock	0.1515	0.1518	0.1492	0.1497	84624360.0
2003-09-24 15:00:00	NVDA	Stock	0.1496	0.1499	0.1479	0.1482	213049440.0
2003-09-24 16:00:00	NVDA	Stock	0.1482	0.1491	0.1479	0.1487	16090080.0
2003-09-24 17:00:00	NVDA	Stock	0.1487	0.1488	0.1485	0.1485	240000.0
2003-09-24 18:00:00	NVDA	Stock	0.1486	0.1488	0.1483	0.1488	648000.0
2003-09-24 08:00:00	AMZN	Stock	2.5218	2.5255	2.515	2.52	567060.0
2003-09-24 09:00:00	AMZN	Stock	2.5175	2.527	2.5	2.502	30827560.0
2003-09-24 10:00:00	AMZN	Stock	2.502	2.522	2.4925	2.5135	36728280.0
2003-09-24 11:00:00	AMZN	Stock	2.5135	2.565	2.4945	2.525	69519240.0
2003-09-24 12:00:00	AMZN	Stock	2.527	2.527	2.494	2.507	42579340.0
2003-09-24 13:00:00	AMZN	Stock	2.5065	2.5115	2.496	2.4975	28167640.0
2003-09-24 14:00:00	AMZN	Stock	2.4975	2.5175	2.497	2.505	25306240.0
2003-09-24 15:00:00	AMZN	Stock	2.505	2.508	2.48	2.481	36637400.0
2003-09-24 16:00:00	AMZN	Stock	2.4805	2.487	2.4795	2.4795	2373320.0
2003-09-24 17:00:00	AMZN	Stock	2.48	2.4865	2.4795	2.481	188000.0
2003-09-24 09:00:00	CL	Stock	27.925	28.0	27.84	27.885	449400.0
2003-09-24 10:00:00	CL	Stock	27.885	27.935	27.84	27.92	553800.0
2003-09-24 11:00:00	CL	Stock	27.925	28.07	27.92	28.05	538600.0
2003-09-24 12:00:00	CL	Stock	28.035	28.04	27.785	27.975	597800.0
2003-09-24 13:00:00	CL	Stock	27.965	27.975	27.835	27.885	396600.0
2003-09-24 14:00:00	CL	Stock	27.885	27.92	27.805	27.845	372200.0
2003-09-24 15:00:00	CL	Stock	27.84	27.88	27.775	27.775	1596200.0
2003-09-24 16:00:00	CL	Stock	27.785	27.785	27.785	27.785	26000.0

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

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