PREVIEW / stock_daily / 2002-07-31

all stock daily files

  file:    by_date/stock_daily/2002/2002-07-31.parquet
  size:    108 KB
  rows:    3,159
  symbols: 1,957

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
2002-07-31	AAPL	Stock	0.275	0.2754	0.2661	0.2725	310699200.0
2002-07-31	MSFT	Stock	23.805	24.0	23.18	23.99	93875600.0
2002-07-31	NVDA	Stock	0.0985	0.1005	0.0912	0.0922	4837140000.0
2002-07-31	AMZN	Stock	0.7225	0.733	0.707	0.7225	76020000.0
2002-07-31	CL	Stock	25.65	25.715	24.94	25.675	6566000.0
2002-07-31	A	Stock	13.3405	13.5193	12.7682	13.505	2289085.0
2002-07-31	AABA-DELISTED	Stock	6.57999992370605	6.73999977111816	6.46500015258789	6.58500003814697	14406800.0
2002-07-31	AAI-DELISTED	Stock	4.04	4.04	3.85	3.89	146100.0
2002-07-31	AAIC-DELISTED	Stock	203.0	215.0	193.2	215.0	233600.0
2002-07-31	AAME	Stock	1.92	2.2	1.92	2.2	1100.0
2002-07-31	AAON	Stock	2.265	2.265	2.2005	2.2176	63028.0
2002-07-31	AAP	Stock	16.35	16.8333	15.9333	16.7533	2108700.0
2002-07-31	AAXN-DELISTED	Stock	0.384166657924652	0.415833324193954	0.384166657924652	0.403333336114883	417600.0
2002-07-31	ABAX-DELISTED	Stock	3.71	3.71	3.5	3.6495	7600.0
2002-07-31	ABB-DELISTED	Stock	5.4	5.55	5.24	5.52	21100.0
2002-07-31	ABC-DELISTED	Stock	17.12	17.62	16.44	16.74	10812000.0
2002-07-31	ABCB	Stock	12.0364	12.1175	11.7527	11.7527	9623.0
2002-07-31	ABCO-DELISTED	Stock	16.55	16.939	16.55	16.915	49908.0
2002-07-31	ABCW-DELISTED	Stock	21.95	21.96	21.26	21.68	41300.0
2002-07-31	ABE-DELISTED	Stock	6.62	6.62	6.4	6.4	19500.0
2002-07-31	ABFS-DELISTED	Stock	21.34	21.74	20.94	21.51	102102.0
2002-07-31	ABG	Stock	11.21	11.95	11.15	11.35	73200.0
2002-07-31	ABK-DELISTED	Stock	62.5	63.28	62.05	62.98	674200.0
2002-07-31	ABM	Stock	16.3	16.85	16.06	16.5	126700.0
2002-07-31	ABMD-DELISTED	Stock	6.11	6.63	5.82	6.62	31099.0
2002-07-31	ABP-DELISTED	Stock	0.52	0.59	0.5	0.56	38600.0
2002-07-31	ABT	Stock	18.2478	18.589	17.9111	18.589	9463559.0
2002-07-31	ABTL-DELISTED	Stock	10.7	11.35	10.4	11.35	29900.0
2002-07-31	ABV-DELISTED	Stock	11.84	12.35	11.42	12.09	923300.0
2002-07-31	ABX-DELISTED	Stock	15.57	15.57	15.26	15.35	4959894.0
2002-07-31	ACAP-DELISTED	Stock	15.99	16.0	15.6	15.75	56600.0
2002-07-31	ACAS-DELISTED	Stock	25.21	25.73	25.05	25.41	490036.0
2002-07-31	ACAT-DELISTED	Stock	14.76	15.39	14.76	14.83	46200.0
2002-07-31	ACCL-DELISTED	Stock	5.12671995162964	5.28601980209351	4.90223979949951	5.28601980209351	169200.0
2002-07-31	ACE-DELISTED	Stock	31.31	32.0	30.35	31.64	3258700.0
2002-07-31	ACF-DELISTED	Stock	19.9	19.95	19.02	19.21	1689300.0
2002-07-31	ACG-DELISTED	Stock	7.88	7.89	7.79	7.82	557400.0
2002-07-31	ACGL	Stock	2.9867	2.9933	2.9344	2.9933	468000.0
2002-07-31	ACGN-DELISTED	Stock	1144.6712	1144.6712	974.6712	1133.3288	9800.0
2002-07-31	ACH	Stock	10.02	10.06	9.82	9.8333	312600.0
2002-07-31	ACH-DELISTED	Stock	3.988	3.993	3.9805	3.993	3600.0
2002-07-31	ACLS	Stock	34.52	35.36	31.6	32.0	428975.0
2002-07-31	ACO-DELISTED	Stock	5.23	5.3	5.1	5.14	21200.0
2002-07-31	ACPW-DELISTED	Stock	12.0	13.0	11.15	11.25	91153.0
2002-07-31	ACS-DELISTED	Stock	46.0	47.0	45.41	46.98	2907200.0
2002-07-31	ACTA-DELISTED	Stock	4.8	5.0	4.6	4.6	18600.0
2002-07-31	ACTT-DELISTED	Stock	2.221	2.221	1.99	1.99	59400.0
2002-07-31	ACTU-DELISTED	Stock	2.1	2.15	1.94	2.0	384380.0
2002-07-31	ACXM-DELISTED	Stock	15.43	15.86	15.0	15.86	435728.0
2002-07-31	AD	Stock	17.3333	17.4	16.8	17.4	177150.0

> showing 50 of 3,159 rows — these rows as CSV

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