PREVIEW / stock_1hour / 2003-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-17.parquet
  size:    469 KB
  rows:    22,218
  symbols: 1,584

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-17 08:00:00	AAPL	Stock	0.3552	0.3594	0.3552	0.357	254520.0
2003-07-17 09:00:00	AAPL	Stock	0.357	0.3723	0.357	0.3698	139608840.0
2003-07-17 10:00:00	AAPL	Stock	0.3698	0.3707	0.3625	0.3679	119856856.0
2003-07-17 11:00:00	AAPL	Stock	0.3677	0.3704	0.3661	0.3668	75718160.0
2003-07-17 12:00:00	AAPL	Stock	0.367	0.3684	0.3635	0.3646	53405072.0
2003-07-17 13:00:00	AAPL	Stock	0.3645	0.3705	0.3645	0.3682	55050856.0
2003-07-17 14:00:00	AAPL	Stock	0.368	0.3693	0.3659	0.3666	92961008.0
2003-07-17 15:00:00	AAPL	Stock	0.3664	0.3741	0.3657	0.3734	121182936.0
2003-07-17 16:00:00	AAPL	Stock	0.3734	0.375	0.3552	0.3746	17021536.0
2003-07-17 17:00:00	AAPL	Stock	0.3746	0.3752	0.3714	0.3725	568344.0
2003-07-17 18:00:00	AAPL	Stock	0.3747	0.3747	0.3718	0.3718	55720.0
2003-07-17 08:00:00	MSFT	Stock	27.01	27.24	26.93	27.13	255260.0
2003-07-17 09:00:00	MSFT	Stock	27.15	27.27	27.08	27.22	7095949.0
2003-07-17 10:00:00	MSFT	Stock	27.22	27.23	26.81	26.87	10648675.0
2003-07-17 11:00:00	MSFT	Stock	26.861	26.98	26.82	26.931	4322965.0
2003-07-17 12:00:00	MSFT	Stock	26.93	27.02	26.65	26.68	6923551.0
2003-07-17 13:00:00	MSFT	Stock	26.68	26.807	26.66	26.72	4962857.0
2003-07-17 14:00:00	MSFT	Stock	26.7251	26.89	26.59	26.63	8840022.0
2003-07-17 15:00:00	MSFT	Stock	26.63	26.82	26.54	26.69	12804774.0
2003-07-17 16:00:00	MSFT	Stock	26.69	27.52	26.52	27.2	7739772.0
2003-07-17 17:00:00	MSFT	Stock	27.2	27.2	26.701	27.07	1356776.0
2003-07-17 18:00:00	MSFT	Stock	27.089	27.1	26.7	26.76	363287.0
2003-07-17 08:00:00	NVDA	Stock	0.189	0.1892	0.1864	0.1883	1347000.0
2003-07-17 09:00:00	NVDA	Stock	0.1883	0.1892	0.1862	0.189	73723080.0
2003-07-17 10:00:00	NVDA	Stock	0.1891	0.1896	0.1842	0.1848	139519200.0
2003-07-17 11:00:00	NVDA	Stock	0.1848	0.1865	0.1847	0.1858	99840960.0
2003-07-17 12:00:00	NVDA	Stock	0.1857	0.1862	0.1818	0.182	136910640.0
2003-07-17 13:00:00	NVDA	Stock	0.1818	0.183	0.1811	0.1828	104313240.0
2003-07-17 14:00:00	NVDA	Stock	0.1828	0.183	0.1808	0.1811	61220400.0
2003-07-17 15:00:00	NVDA	Stock	0.181	0.1842	0.181	0.1833	108675240.0
2003-07-17 16:00:00	NVDA	Stock	0.1833	0.1842	0.1827	0.1842	13619640.0
2003-07-17 17:00:00	NVDA	Stock	0.1833	0.1837	0.1823	0.1823	456000.0
2003-07-17 18:00:00	NVDA	Stock	0.1821	0.1821	0.1812	0.1812	144000.0
2003-07-17 08:00:00	AMZN	Stock	1.855	1.884	1.85	1.8815	384000.0
2003-07-17 09:00:00	AMZN	Stock	1.8525	1.8815	1.825	1.8615	30366960.0
2003-07-17 10:00:00	AMZN	Stock	1.8625	1.863	1.827	1.8395	27022720.0
2003-07-17 11:00:00	AMZN	Stock	1.8395	1.8405	1.833	1.8365	9380220.0
2003-07-17 12:00:00	AMZN	Stock	1.8355	1.8398	1.802	1.8055	21157580.0
2003-07-17 13:00:00	AMZN	Stock	1.805	1.8145	1.805	1.8095	14288380.0
2003-07-17 14:00:00	AMZN	Stock	1.809	1.82	1.8055	1.8075	14886860.0
2003-07-17 15:00:00	AMZN	Stock	1.807	1.824	1.8055	1.815	20393580.0
2003-07-17 16:00:00	AMZN	Stock	1.815	1.835	1.8125	1.8125	442000.0
2003-07-17 17:00:00	AMZN	Stock	1.8245	1.8245	1.81	1.81	53340.0
2003-07-17 18:00:00	AMZN	Stock	1.8215	1.822	1.81	1.81	186000.0
2003-07-17 09:00:00	CL	Stock	28.225	28.25	28.095	28.23	324800.0
2003-07-17 10:00:00	CL	Stock	28.225	28.225	27.9	28.07	807000.0
2003-07-17 11:00:00	CL	Stock	28.075	28.075	27.925	27.975	455000.0
2003-07-17 12:00:00	CL	Stock	27.99	28.0	27.88	27.91	561200.0
2003-07-17 13:00:00	CL	Stock	27.905	27.98	27.865	27.93	545000.0
2003-07-17 14:00:00	CL	Stock	27.93	28.02	27.875	27.93	607000.0

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

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