PREVIEW / stock_1hour / 2003-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-31.parquet
  size:    472 KB
  rows:    22,298
  symbols: 1,608

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-31 08:00:00	AAPL	Stock	0.3627	0.3627	0.3627	0.3627	5600.0
2003-07-31 09:00:00	AAPL	Stock	0.3659	0.3716	0.3646	0.3716	20039096.0
2003-07-31 10:00:00	AAPL	Stock	0.3716	0.3768	0.3673	0.3763	44284912.0
2003-07-31 11:00:00	AAPL	Stock	0.3763	0.3811	0.3759	0.377	44623600.0
2003-07-31 12:00:00	AAPL	Stock	0.3771	0.3796	0.3754	0.3761	18723040.0
2003-07-31 13:00:00	AAPL	Stock	0.3759	0.3775	0.3757	0.3771	22866312.0
2003-07-31 14:00:00	AAPL	Stock	0.3771	0.3784	0.3755	0.378	19607392.0
2003-07-31 15:00:00	AAPL	Stock	0.378	0.3813	0.3754	0.3777	49812784.0
2003-07-31 16:00:00	AAPL	Stock	0.3777	0.3793	0.3757	0.3791	37559200.0
2003-07-31 17:00:00	AAPL	Stock	0.3789	0.3791	0.3759	0.3759	6876800.0
2003-07-31 08:00:00	MSFT	Stock	26.33	26.55	26.32	26.48	300064.0
2003-07-31 09:00:00	MSFT	Stock	26.49	26.66	26.42	26.659	6562229.0
2003-07-31 10:00:00	MSFT	Stock	26.66	26.88	26.33	26.85	12511260.0
2003-07-31 11:00:00	MSFT	Stock	26.85	26.98	26.81	26.87	7692391.0
2003-07-31 12:00:00	MSFT	Stock	26.87	26.921	26.77	26.8379	2798663.0
2003-07-31 13:00:00	MSFT	Stock	26.839	26.95	26.8	26.84	3089090.0
2003-07-31 14:00:00	MSFT	Stock	26.85	26.95	26.58	26.66	6123902.0
2003-07-31 15:00:00	MSFT	Stock	26.66	26.77	26.31	26.41	11497447.0
2003-07-31 16:00:00	MSFT	Stock	26.41	26.44	26.352	26.42	2334975.0
2003-07-31 17:00:00	MSFT	Stock	26.43	26.44	26.4	26.4	3075008.0
2003-07-31 18:00:00	MSFT	Stock	26.42	26.44	26.42	26.44	6063.0
2003-07-31 08:00:00	NVDA	Stock	0.1583	0.1596	0.1583	0.1596	1548000.0
2003-07-31 09:00:00	NVDA	Stock	0.1595	0.1609	0.1589	0.1599	95809920.0
2003-07-31 10:00:00	NVDA	Stock	0.1599	0.16	0.1577	0.1593	148609080.0
2003-07-31 11:00:00	NVDA	Stock	0.1592	0.1599	0.1589	0.1595	106754400.0
2003-07-31 12:00:00	NVDA	Stock	0.1594	0.1597	0.1593	0.1595	20208120.0
2003-07-31 13:00:00	NVDA	Stock	0.1594	0.1628	0.1593	0.1628	82193760.0
2003-07-31 14:00:00	NVDA	Stock	0.1627	0.1632	0.16	0.1607	137056800.0
2003-07-31 15:00:00	NVDA	Stock	0.1608	0.162	0.159	0.1594	143604720.0
2003-07-31 16:00:00	NVDA	Stock	0.1593	0.1599	0.1584	0.1592	83084160.0
2003-07-31 17:00:00	NVDA	Stock	0.1593	0.1593	0.1593	0.1593	156000.0
2003-07-31 08:00:00	AMZN	Stock	2.015	2.0625	2.01	2.061	730300.0
2003-07-31 09:00:00	AMZN	Stock	2.0575	2.081	2.055	2.063	24847560.0
2003-07-31 10:00:00	AMZN	Stock	2.063	2.07	2.0335	2.068	27139840.0
2003-07-31 11:00:00	AMZN	Stock	2.0685	2.0725	2.058	2.0625	12790160.0
2003-07-31 12:00:00	AMZN	Stock	2.0625	2.067	2.0575	2.066	10808400.0
2003-07-31 13:00:00	AMZN	Stock	2.0655	2.08	2.0645	2.0755	17537520.0
2003-07-31 14:00:00	AMZN	Stock	2.076	2.0875	2.0755	2.086	25239060.0
2003-07-31 15:00:00	AMZN	Stock	2.085	2.0985	2.0615	2.086	31072200.0
2003-07-31 16:00:00	AMZN	Stock	2.0825	2.0935	2.069	2.086	3017820.0
2003-07-31 17:00:00	AMZN	Stock	2.071	2.086	2.0705	2.0775	2026000.0
2003-07-31 18:00:00	AMZN	Stock	2.0775	2.0775	2.0775	2.0775	3620.0
2003-07-31 09:00:00	CL	Stock	27.7	27.725	27.615	27.725	263800.0
2003-07-31 10:00:00	CL	Stock	27.725	27.79	27.5	27.77	692200.0
2003-07-31 11:00:00	CL	Stock	27.76	27.795	27.74	27.745	257600.0
2003-07-31 12:00:00	CL	Stock	27.745	27.835	27.745	27.805	272200.0
2003-07-31 13:00:00	CL	Stock	27.805	27.83	27.75	27.82	179400.0
2003-07-31 14:00:00	CL	Stock	27.815	27.84	27.665	27.7	234200.0
2003-07-31 15:00:00	CL	Stock	27.695	27.695	27.31	27.315	968000.0
2003-07-31 16:00:00	CL	Stock	27.305	27.5816	27.295	27.3	501000.0

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

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