PREVIEW / stock_daily / 2002-07-23

all stock daily files

  file:    by_date/stock_daily/2002/2002-07-23.parquet
  size:    108 KB
  rows:    3,189
  symbols: 1,985

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-23	AAPL	Stock	0.2661	0.2702	0.2579	0.2584	399890400.0
2002-07-23	MSFT	Stock	23.245	23.4	21.485	21.505	168061600.0
2002-07-23	NVDA	Stock	0.1449	0.1458	0.1284	0.1333	1409652000.0
2002-07-23	AMZN	Stock	0.777	0.794	0.72	0.7275	225828000.0
2002-07-23	CL	Stock	23.025	24.1	22.695	23.6	7528200.0
2002-07-23	A	Stock	14.3419	14.6066	13.8984	14.1202	4120325.0
2002-07-23	AABA-DELISTED	Stock	6.76999998092651	6.84499979019165	6.32499980926514	6.32999992370605	24089400.0
2002-07-23	AAI-DELISTED	Stock	3.89	4.08	3.65	3.65	368100.0
2002-07-23	AAIC-DELISTED	Stock	185.8	187.4	158.0	162.0	121300.0
2002-07-23	AAME	Stock	2.2	2.2	2.2	2.2	1500.0
2002-07-23	AAON	Stock	2.107	2.1821	2.1057	2.1623	332606.0
2002-07-23	AAP	Stock	14.4667	14.6	13.8667	14.3167	1994100.0
2002-07-23	AAXN-DELISTED	Stock	0.583333313465118	0.607500016689301	0.5	0.507499992847443	1648800.0
2002-07-23	ABAX-DELISTED	Stock	3.58	3.59	3.0	3.0	24800.0
2002-07-23	ABB-DELISTED	Stock	7.55	7.57	7.25	7.28	122400.0
2002-07-23	ABC-DELISTED	Stock	14.75	15.2	14.65	14.78	5927200.0
2002-07-23	ABCB	Stock	10.537	11.1449	8.9564	9.2887	38000.0
2002-07-23	ABCO-DELISTED	Stock	13.525	13.594	13.18	13.495	94307.0
2002-07-23	ABCW-DELISTED	Stock	19.511	19.511	17.832	17.99	59030.0
2002-07-23	ABE-DELISTED	Stock	6.35	6.4	6.31	6.31	23400.0
2002-07-23	ABFS-DELISTED	Stock	20.3	20.77	19.28	19.41	111962.0
2002-07-23	ABG	Stock	11.45	11.47	10.25	10.65	66300.0
2002-07-23	ABK-DELISTED	Stock	53.79	55.43	52.75	52.95	1481400.0
2002-07-23	ABM	Stock	15.25	15.55	14.67	14.7	129400.0
2002-07-23	ABMD-DELISTED	Stock	6.3	6.395	5.75	5.99	51488.0
2002-07-23	ABP-DELISTED	Stock	0.59	0.63	0.57	0.58	77600.0
2002-07-23	ABT	Stock	14.2302	14.4322	13.7364	13.9159	17626831.0
2002-07-23	ABTL-DELISTED	Stock	11.75	11.95	11.25	11.25	40800.0
2002-07-23	ABV-DELISTED	Stock	14.72	14.85	14.33	14.43	649900.0
2002-07-23	ABVA-DELISTED	Stock	8.02	8.2	8.02	8.2	1000.0
2002-07-23	ABX-DELISTED	Stock	16.09	16.09	14.15	14.4	10974300.0
2002-07-23	ACAP-DELISTED	Stock	16.47	16.57	15.89	15.9	38400.0
2002-07-23	ACAS-DELISTED	Stock	23.76	24.84	21.89	22.41	1595865.0
2002-07-23	ACAT-DELISTED	Stock	15.92	15.92	14.32	14.74	24500.0
2002-07-23	ACCL-DELISTED	Stock	5.06878995895386	5.39391994476318	4.72845983505249	5.39391994476318	149400.0
2002-07-23	ACE-DELISTED	Stock	24.49	25.44	23.25	23.38	1554959.0
2002-07-23	ACF-DELISTED	Stock	15.9	16.79	14.63	15.11	1889600.0
2002-07-23	ACG-DELISTED	Stock	7.94	7.95	7.8	7.86	686000.0
2002-07-23	ACGL	Stock	2.6167	2.7767	2.6167	2.68	576000.0
2002-07-23	ACGN-DELISTED	Stock	1054.0	1122.0	940.6712	1054.0	56900.0
2002-07-23	ACH	Stock	9.3933	9.5667	9.2667	9.32	228450.0
2002-07-23	ACH-DELISTED	Stock	4.1375	4.1375	4.1	4.1	70000.0
2002-07-23	ACLS	Stock	36.8	37.0	31.08	33.76	502925.0
2002-07-23	ACO-DELISTED	Stock	4.73	5.4	4.73	5.34	63600.0
2002-07-23	ACPW-DELISTED	Stock	9.403	9.898	8.809	9.7	65583.0
2002-07-23	ACS-DELISTED	Stock	38.25	38.7	35.0	35.75	2756800.0
2002-07-23	ACTA-DELISTED	Stock	5.4	5.4	4.4	4.6	43400.0
2002-07-23	ACTT-DELISTED	Stock	2.61	2.61	2.55	2.6	19000.0
2002-07-23	ACTU-DELISTED	Stock	2.12	2.12	1.75	1.78	705800.0
2002-07-23	ACXM-DELISTED	Stock	12.87	13.51	12.63	12.67	651400.0

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

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