PREVIEW / stock_daily / 2001-07-31

all stock daily files

  file:    by_date/stock_daily/2001/2001-07-31.parquet
  size:    103 KB
  rows:    2,995
  symbols: 1,867

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2001-07-31	AAPL	Stock	0.3441	0.3468	0.3305	0.3355	235026400.0
2001-07-31	MSFT	Stock	33.005	33.695	32.925	33.095	59031600.0
2001-07-31	NVDA	Stock	0.3299	0.3385	0.3179	0.3371	1187760000.0
2001-07-31	AMZN	Stock	0.632	0.643	0.6115	0.6245	87578000.0
2001-07-31	CL	Stock	27.05	27.5	27.04	27.1	5643800.0
2001-07-31	A	Stock	20.7797	21.6738	20.3362	20.4649	2143274.0
2001-07-31	AABA-DELISTED	Stock	8.97500038146973	9.125	8.75	8.8100004196167	9468400.0
2001-07-31	AAI-DELISTED	Stock	8.51	8.61	8.45	8.6	156300.0
2001-07-31	AAIC-DELISTED	Stock	136.2	138.0	133.0	138.0	116700.0
2001-07-31	AAME	Stock	1.5	1.6	1.5	1.6	12700.0
2001-07-31	AAON	Stock	1.7558	1.7617	1.7441	1.7558	504035.0
2001-07-31	AAXN-DELISTED	Stock	0.504166662693024	0.520833313465118	0.501666665077209	0.520833313465118	224400.0
2001-07-31	ABAX-DELISTED	Stock	5.11	5.25	5.0	5.25	13200.0
2001-07-31	ABB-DELISTED	Stock	10.98	11.05	10.93	11.05	7600.0
2001-07-31	ABC-DELISTED	Stock	14.9250001907349	15.0625	14.4875001907349	14.5349998474121	4086400.0
2001-07-31	ABCB	Stock	10.1722	10.1722	10.0344	10.0344	3084.0
2001-07-31	ABCW-DELISTED	Stock	16.02	16.21	16.0	16.16	49400.0
2001-07-31	ABE-DELISTED	Stock	7.6	7.65	7.6	7.65	11000.0
2001-07-31	ABFS-DELISTED	Stock	27.98	28.25	27.6	27.6	1871100.0
2001-07-31	ABK-DELISTED	Stock	57.04	58.1	56.98	57.55	340400.0
2001-07-31	ABM	Stock	17.8	18.275	17.725	18.275	135200.0
2001-07-31	ABMD-DELISTED	Stock	19.24	19.45	18.79	19.0	54000.0
2001-07-31	ABP-DELISTED	Stock	3.43	3.47	3.4	3.42	83100.0
2001-07-31	ABT	Stock	23.3428	24.1598	23.3428	24.0566	7943179.0
2001-07-31	ABTL-DELISTED	Stock	4.6	4.9	3.95	4.2	37900.0
2001-07-31	ABV-DELISTED	Stock	20.75	20.75	20.23	20.35	177800.0
2001-07-31	ABX-DELISTED	Stock	15.0	15.32	14.85	14.86	915370.0
2001-07-31	ACAP-DELISTED	Stock	20.4	20.5	20.2	20.4	46900.0
2001-07-31	ACAS-DELISTED	Stock	27.19	28.0	26.88	27.3	259900.0
2001-07-31	ACAT-DELISTED	Stock	14.69	15.0	14.45	14.55	57800.0
2001-07-31	ACCL-DELISTED	Stock	11.4048004150391	12.078200340271	11.4048004150391	12.078200340271	337400.0
2001-07-31	ACE-DELISTED	Stock	33.8	35.4	33.8	34.95	2079800.0
2001-07-31	ACF-DELISTED	Stock	61.25	63.3	61.0	61.35	974600.0
2001-07-31	ACG-DELISTED	Stock	8.77	8.8	8.75	8.78	295500.0
2001-07-31	ACGL	Stock	1.9756	1.9756	1.8722	1.8722	9000.0
2001-07-31	ACGN-DELISTED	Stock	1042.6712	1167.3288	1020.0	1167.3288	97500.0
2001-07-31	ACH	Stock	12.2667	12.28	11.9867	12.2	88500.0
2001-07-31	ACLS	Stock	56.24	58.4	54.64	56.68	163975.0
2001-07-31	ACO-DELISTED	Stock	6.2	6.24	6.05	6.06	12600.0
2001-07-31	ACPW-DELISTED	Stock	47.5	48.55	44.5	44.5	62640.0
2001-07-31	ACS-DELISTED	Stock	43.0	43.0	41.0	41.42	813300.0
2001-07-31	ACTA-DELISTED	Stock	27.0	27.8	25.8	26.2	41300.0
2001-07-31	ACTT-DELISTED	Stock	4.17	5.43	4.07	5.16	93700.0
2001-07-31	ACTU-DELISTED	Stock	10.38	11.05	9.97	10.22	359400.0
2001-07-31	ACXM-DELISTED	Stock	11.31	11.96	11.31	11.69	575000.0
2001-07-31	ACY-DELISTED	Stock	5.18	5.2	5.11	5.2	4800.0
2001-07-31	AD	Stock	37.1333	37.9	36.9667	37.5333	185550.0
2001-07-31	ADAT-DELISTED	Stock	86.76	90.0	84.6	90.0	1766.0
2001-07-31	ADBE	Stock	20.075	20.075	18.73	18.745	11909000.0
2001-07-31	ADC	Stock	19.7	19.7	19.5	19.5	5300.0

> showing 50 of 2,995 rows — these rows as CSV

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