PREVIEW / stock_daily / 2002-07-09

all stock daily files

  file:    by_date/stock_daily/2002/2002-07-09.parquet
  size:    108 KB
  rows:    3,153
  symbols: 1,963

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-09	AAPL	Stock	0.323	0.3266	0.3118	0.313	226749600.0
2002-07-09	MSFT	Stock	26.655	27.365	26.485	26.605	85277200.0
2002-07-09	NVDA	Stock	0.1634	0.1655	0.1515	0.155	1075080000.0
2002-07-09	AMZN	Stock	0.7525	0.8015	0.749	0.78	150572000.0
2002-07-09	CL	Stock	25.45	25.625	24.925	25.02	3587800.0
2002-07-09	A	Stock	16.3805	16.9886	16.0944	16.2017	2677869.0
2002-07-09	AABA-DELISTED	Stock	6.48999977111816	6.55999994277954	6.27500009536743	6.34999990463257	18565400.0
2002-07-09	AAI-DELISTED	Stock	5.04	5.07	4.4	4.5	517500.0
2002-07-09	AAIC-DELISTED	Stock	200.0	213.0	196.0	213.0	251000.0
2002-07-09	AAME	Stock	2.21	2.35	2.1	2.2	6000.0
2002-07-09	AAON	Stock	2.3651	2.4191	2.3638	2.3928	237684.0
2002-07-09	AAP	Stock	17.2533	17.4	16.6333	16.7467	968400.0
2002-07-09	AAXN-DELISTED	Stock	0.995833337306976	1.0	0.975000023841858	0.991666674613953	38400.0
2002-07-09	ABAX-DELISTED	Stock	3.98	4.0	3.92	4.0	12400.0
2002-07-09	ABB-DELISTED	Stock	9.07	9.07	9.03	9.03	400.0
2002-07-09	ABC-DELISTED	Stock	17.45	17.55	15.7	15.7	12690800.0
2002-07-09	ABCB	Stock	11.7527	11.8581	11.5907	11.5907	39480.0
2002-07-09	ABCO-DELISTED	Stock	17.998	18.728	17.878	18.342	174615.0
2002-07-09	ABCW-DELISTED	Stock	23.35	24.03	23.13	23.42	68000.0
2002-07-09	ABE-DELISTED	Stock	6.75	6.81	6.75	6.8	9200.0
2002-07-09	ABFS-DELISTED	Stock	23.2	23.25	23.0	23.18	156500.0
2002-07-09	ABG	Stock	13.6	13.8	13.4	13.4	45400.0
2002-07-09	ABK-DELISTED	Stock	65.95	66.38	64.15	64.34	550500.0
2002-07-09	ABM	Stock	17.45	17.85	17.44	17.48	127000.0
2002-07-09	ABMD-DELISTED	Stock	7.0	7.7	6.94	7.135	58300.0
2002-07-09	ABP-DELISTED	Stock	0.7	0.7	0.63	0.67	24600.0
2002-07-09	ABT	Stock	16.6093	16.744	15.8327	15.8956	11252818.0
2002-07-09	ABTL-DELISTED	Stock	11.8	12.4	11.75	12.0	2500.0
2002-07-09	ABV-DELISTED	Stock	15.9	16.2	15.8	16.0	255200.0
2002-07-09	ABVA-DELISTED	Stock	8.2	8.2	8.2	8.2	100.0
2002-07-09	ABX-DELISTED	Stock	18.7	19.63	18.69	19.53	3908500.0
2002-07-09	ACAP-DELISTED	Stock	17.26	17.5	17.0	17.18	20500.0
2002-07-09	ACAS-DELISTED	Stock	27.1	27.4	26.4	26.51	522200.0
2002-07-09	ACAT-DELISTED	Stock	16.1	17.09	16.1	16.6	27900.0
2002-07-09	ACCL-DELISTED	Stock	5.99565982818604	6.20564985275269	5.99565982818604	6.20564985275269	167900.0
2002-07-09	ACE-DELISTED	Stock	30.02	31.0	29.64	29.78	2295003.0
2002-07-09	ACF-DELISTED	Stock	22.0	23.3	20.6	21.29	9981300.0
2002-07-09	ACG-DELISTED	Stock	7.84	7.88	7.8	7.84	723100.0
2002-07-09	ACGL	Stock	3.0489	3.2144	3.0344	3.1478	224100.0
2002-07-09	ACGN-DELISTED	Stock	1099.3288	1303.3288	1099.3288	1212.6712	38700.0
2002-07-09	ACH	Stock	12.7667	12.9	12.4	12.4	173100.0
2002-07-09	ACH-DELISTED	Stock	4.8505	4.8505	4.813	4.813	36798.0
2002-07-09	ACLS	Stock	43.8	43.8	41.48	41.84	162250.0
2002-07-09	ACO-DELISTED	Stock	6.5	6.77	6.46	6.55	12600.0
2002-07-09	ACPW-DELISTED	Stock	16.4	16.85	15.95	16.25	34160.0
2002-07-09	ACS-DELISTED	Stock	46.4	47.25	45.3	45.5	1657800.0
2002-07-09	ACTA-DELISTED	Stock	5.0	5.4	4.8	5.2	61500.0
2002-07-09	ACTT-DELISTED	Stock	2.449	2.75	1.9	2.05	268700.0
2002-07-09	ACTU-DELISTED	Stock	3.81	3.93	3.64	3.78	164000.0
2002-07-09	ACXM-DELISTED	Stock	16.96	17.2	16.85	17.02	565800.0

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

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