PREVIEW / stock_1hour / 2003-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-24.parquet
  size:    448 KB
  rows:    20,982
  symbols: 1,588

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-07-24 08:00:00	AAPL	Stock	0.3715	0.3736	0.3715	0.3736	5479600.0
2003-07-24 09:00:00	AAPL	Stock	0.3723	0.3763	0.3704	0.3736	14735336.0
2003-07-24 10:00:00	AAPL	Stock	0.3736	0.3805	0.3736	0.3779	44694776.0
2003-07-24 11:00:00	AAPL	Stock	0.378	0.3839	0.3779	0.3802	25978624.0
2003-07-24 12:00:00	AAPL	Stock	0.38	0.3805	0.3782	0.3791	8738744.0
2003-07-24 13:00:00	AAPL	Stock	0.3795	0.3807	0.3786	0.3798	10321864.0
2003-07-24 14:00:00	AAPL	Stock	0.38	0.38	0.368	0.3714	38407992.0
2003-07-24 15:00:00	AAPL	Stock	0.3714	0.3721	0.3639	0.3661	55113800.0
2003-07-24 16:00:00	AAPL	Stock	0.3663	0.3664	0.3652	0.3654	705600.0
2003-07-24 17:00:00	AAPL	Stock	0.3643	0.3643	0.3627	0.3627	84000.0
2003-07-24 08:00:00	MSFT	Stock	26.51	26.85	26.48	26.81	150457.0
2003-07-24 09:00:00	MSFT	Stock	26.8	28.0	26.64	26.74	5973897.0
2003-07-24 10:00:00	MSFT	Stock	26.74	26.9	26.71	26.74	7181448.0
2003-07-24 11:00:00	MSFT	Stock	26.735	26.92	26.72	26.81	5131552.0
2003-07-24 12:00:00	MSFT	Stock	26.81	26.82	26.648	26.81	3913558.0
2003-07-24 13:00:00	MSFT	Stock	26.8	26.89	26.78	26.81	2474789.0
2003-07-24 14:00:00	MSFT	Stock	26.81	26.81	26.3	26.35	10741654.0
2003-07-24 15:00:00	MSFT	Stock	26.35	26.4	25.98	26.0	11486194.0
2003-07-24 16:00:00	MSFT	Stock	26.0	26.15	25.99	26.02	1037891.0
2003-07-24 17:00:00	MSFT	Stock	26.03	26.13	26.0	26.06	73200.0
2003-07-24 18:00:00	MSFT	Stock	26.08	26.15	26.01	26.1	15000.0
2003-07-24 08:00:00	NVDA	Stock	0.1797	0.1805	0.1785	0.1785	5952000.0
2003-07-24 09:00:00	NVDA	Stock	0.1787	0.1843	0.1787	0.1807	110607360.0
2003-07-24 10:00:00	NVDA	Stock	0.1807	0.1824	0.1786	0.1792	146808240.0
2003-07-24 11:00:00	NVDA	Stock	0.1793	0.1808	0.1765	0.1773	151410480.0
2003-07-24 12:00:00	NVDA	Stock	0.1774	0.1774	0.1757	0.1767	143448120.0
2003-07-24 13:00:00	NVDA	Stock	0.1767	0.177	0.175	0.1759	84880920.0
2003-07-24 14:00:00	NVDA	Stock	0.1759	0.1759	0.1724	0.175	145368840.0
2003-07-24 15:00:00	NVDA	Stock	0.175	0.1752	0.1712	0.1729	183609840.0
2003-07-24 16:00:00	NVDA	Stock	0.1733	0.1741	0.1721	0.1725	7520400.0
2003-07-24 17:00:00	NVDA	Stock	0.1717	0.1725	0.1717	0.1722	552000.0
2003-07-24 18:00:00	NVDA	Stock	0.1717	0.176	0.1717	0.176	1104000.0
2003-07-24 08:00:00	AMZN	Stock	2.0095	2.04	2.0	2.038	1488260.0
2003-07-24 09:00:00	AMZN	Stock	2.038	2.1	2.029	2.094	85916240.0
2003-07-24 10:00:00	AMZN	Stock	2.094	2.155	2.093	2.1255	135501580.0
2003-07-24 11:00:00	AMZN	Stock	2.1255	2.1275	2.098	2.108	55424920.0
2003-07-24 12:00:00	AMZN	Stock	2.1081	2.1105	2.0705	2.0845	36690540.0
2003-07-24 13:00:00	AMZN	Stock	2.084	2.093	2.078	2.0855	16187160.0
2003-07-24 14:00:00	AMZN	Stock	2.086	2.0975	2.0619	2.0658	37831640.0
2003-07-24 15:00:00	AMZN	Stock	2.0656	2.0695	2.046	2.066	45001020.0
2003-07-24 16:00:00	AMZN	Stock	2.0655	2.075	2.0055	2.0315	10659040.0
2003-07-24 17:00:00	AMZN	Stock	2.0314	2.0655	2.025	2.035	719000.0
2003-07-24 18:00:00	AMZN	Stock	2.035	2.044	2.0325	2.042	247700.0
2003-07-24 09:00:00	CL	Stock	28.145	28.215	28.0	28.115	272000.0
2003-07-24 10:00:00	CL	Stock	28.105	28.345	28.095	28.285	453200.0
2003-07-24 11:00:00	CL	Stock	28.275	28.325	28.055	28.11	255000.0
2003-07-24 12:00:00	CL	Stock	28.11	28.135	28.025	28.115	164800.0
2003-07-24 13:00:00	CL	Stock	28.11	28.135	28.025	28.06	140400.0
2003-07-24 14:00:00	CL	Stock	28.045	28.09	27.955	28.065	363200.0
2003-07-24 15:00:00	CL	Stock	28.065	28.105	27.915	27.97	609400.0

> showing 50 of 20,982 rows — these rows as CSV

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