PREVIEW / stock_daily / 2002-07-02

all stock daily files

  file:    by_date/stock_daily/2002/2002-07-02.parquet
  size:    106 KB
  rows:    3,134
  symbols: 1,945

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-02	AAPL	Stock	0.3041	0.3064	0.3005	0.3025	305188800.0
2002-07-02	MSFT	Stock	26.19	26.46	25.665	25.72	82814200.0
2002-07-02	NVDA	Stock	0.1412	0.1417	0.1302	0.1338	1368180000.0
2002-07-02	AMZN	Stock	0.68	0.708	0.65	0.666	173398000.0
2002-07-02	CL	Stock	25.6	25.65	25.2	25.275	5780200.0
2002-07-02	A	Stock	16.3448	16.5522	15.3863	15.701	4059093.0
2002-07-02	AABA-DELISTED	Stock	6.78999996185303	6.79500007629395	5.82999992370605	5.94000005722046	34056000.0
2002-07-02	AAI-DELISTED	Stock	5.5	5.54	5.2	5.21	144600.0
2002-07-02	AAIC-DELISTED	Stock	241.0	241.0	209.6	210.8	143400.0
2002-07-02	AAME	Stock	2.2	2.2	2.0	2.0	300.0
2002-07-02	AAON	Stock	2.3572	2.4626	2.2914	2.4612	455625.0
2002-07-02	AAP	Stock	17.45	17.5333	16.5333	16.8667	3132900.0
2002-07-02	AAXN-DELISTED	Stock	1.01250004768372	1.04083335399628	0.970833361148834	0.970833361148834	216000.0
2002-07-02	ABAX-DELISTED	Stock	4.18	4.18	3.55	3.84	58300.0
2002-07-02	ABB-DELISTED	Stock	9.0	9.05	8.85	8.88	17600.0
2002-07-02	ABC-DELISTED	Stock	17.94	18.24	16.95	17.62	10198800.0
2002-07-02	ABCB	Stock	11.8419	11.8419	11.3475	11.4042	35902.0
2002-07-02	ABCO-DELISTED	Stock	17.03	17.63	16.36	17.37	59200.0
2002-07-02	ABCW-DELISTED	Stock	24.2	24.2	23.5	23.6	139620.0
2002-07-02	ABE-DELISTED	Stock	6.7	6.75	6.56	6.57	18900.0
2002-07-02	ABFS-DELISTED	Stock	24.0	24.4	22.58	22.73	177400.0
2002-07-02	ABG	Stock	13.5	13.5	12.2	12.55	150800.0
2002-07-02	ABK-DELISTED	Stock	67.5	67.75	65.45	65.45	515600.0
2002-07-02	ABM	Stock	17.05	17.78	17.02	17.58	74600.0
2002-07-02	ABMD-DELISTED	Stock	8.0	8.0	7.0	7.0	98700.0
2002-07-02	ABP-DELISTED	Stock	0.6	0.74	0.56	0.63	12700.0
2002-07-02	ABT	Stock	16.8562	16.9146	16.3175	16.5106	11167944.0
2002-07-02	ABTL-DELISTED	Stock	13.9	14.4	11.9	12.5	11500.0
2002-07-02	ABV-DELISTED	Stock	15.05	15.5	14.89	15.2	348700.0
2002-07-02	ABX-DELISTED	Stock	19.18	19.18	18.45	18.45	3261000.0
2002-07-02	ACAP-DELISTED	Stock	18.29	18.3	17.76	17.76	94100.0
2002-07-02	ACAS-DELISTED	Stock	27.55	27.56	26.95	26.95	476400.0
2002-07-02	ACAT-DELISTED	Stock	16.34	16.53	15.74	16.35	47900.0
2002-07-02	ACCL-DELISTED	Stock	6.09999990463257	6.41599988937378	5.59700012207031	6.09000015258789	133300.0
2002-07-02	ACE-DELISTED	Stock	30.25	30.4	28.88	29.24	1856500.0
2002-07-02	ACF-DELISTED	Stock	23.65	24.5	22.43	23.2	4419700.0
2002-07-02	ACG-DELISTED	Stock	7.91	7.92	7.87	7.91	716200.0
2002-07-02	ACGL	Stock	3.1444	3.15	2.9556	2.9867	329400.0
2002-07-02	ACGN-DELISTED	Stock	1326.0	1394.0	1190.0	1190.0	50300.0
2002-07-02	ACH	Stock	12.7	12.7	12.0733	12.54	196800.0
2002-07-02	ACH-DELISTED	Stock	4.6975	4.7	4.665	4.67	76800.0
2002-07-02	ACLS	Stock	41.84	42.4	40.12	40.56	283425.0
2002-07-02	ACO-DELISTED	Stock	6.35	6.38	6.2	6.2	8400.0
2002-07-02	ACPW-DELISTED	Stock	17.3	17.6	15.25	16.05	29760.0
2002-07-02	ACS-DELISTED	Stock	45.65	45.65	41.13	43.48	3698000.0
2002-07-02	ACTA-DELISTED	Stock	5.0	5.0	4.0	4.8	93100.0
2002-07-02	ACTT-DELISTED	Stock	2.4515	2.51	1.82	2.0	156400.0
2002-07-02	ACTU-DELISTED	Stock	4.5	4.5	3.93	4.16	264700.0
2002-07-02	ACXM-DELISTED	Stock	16.51	17.25	15.8	15.83	1257200.0
2002-07-02	AD	Stock	16.6	16.6	15.9333	15.94	302400.0

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

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