PREVIEW / stock_daily / 2002-04-01

all stock daily files

  file:    by_date/stock_daily/2002/2002-04-01.parquet
  size:    106 KB
  rows:    3,108
  symbols: 1,936

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-04-01	AAPL	Stock	0.4175	0.4411	0.4157	0.4368	199046400.0
2002-04-01	MSFT	Stock	29.915	30.2	29.6	30.19	47010000.0
2002-04-01	NVDA	Stock	0.3492	0.3664	0.338	0.3636	2365344000.0
2002-04-01	AMZN	Stock	0.714	0.74	0.707	0.74	95358000.0
2002-04-01	CL	Stock	28.45	28.495	28.125	28.3	8098600.0
2002-04-01	A	Stock	24.9857	26.3233	24.8212	26.1302	3609356.0
2002-04-01	AABA-DELISTED	Stock	9.375	9.42500019073486	9.0	9.34000015258789	12873600.0
2002-04-01	AAI-DELISTED	Stock	6.05	6.27	5.88	6.11	334400.0
2002-04-01	AAIC-DELISTED	Stock	141.2	157.0	140.0	156.0	29800.0
2002-04-01	AAME	Stock	2.25	2.25	2.25	2.25	200.0
2002-04-01	AAON	Stock	2.3967	2.3967	2.3045	2.3484	510300.0
2002-04-01	AAP	Stock	15.3333	15.36	15.2067	15.3367	524700.0
2002-04-01	AAXN-DELISTED	Stock	1.61500000953674	1.63750004768372	1.58749997615814	1.62083327770233	892800.0
2002-04-01	ABAX-DELISTED	Stock	6.25	6.49	6.23	6.4106	75100.0
2002-04-01	ABB-DELISTED	Stock	7.88	7.9	7.84	7.84	14900.0
2002-04-01	ABC-DELISTED	Stock	17.08	17.48	17.0	17.28	2270400.0
2002-04-01	ABCB	Stock	11.5502	12.3202	11.5502	12.3202	13448.0
2002-04-01	ABCO-DELISTED	Stock	16.225	16.5	15.88	16.44	62000.0
2002-04-01	ABCW-DELISTED	Stock	19.92	20.53	19.91	20.0	36200.0
2002-04-01	ABE-DELISTED	Stock	7.4	7.41	7.37	7.4	32200.0
2002-04-01	ABFS-DELISTED	Stock	27.7	28.07	26.72	26.79	92500.0
2002-04-01	ABK-DELISTED	Stock	59.0	59.0	57.85	58.16	652300.0
2002-04-01	ABM	Stock	18.325	18.475	18.325	18.375	145000.0
2002-04-01	ABMD-DELISTED	Stock	11.09	11.27	10.8	11.26	126000.0
2002-04-01	ABP-DELISTED	Stock	1.38	1.5	1.36	1.41	212300.0
2002-04-01	ABT	Stock	23.6122	24.0386	23.4551	23.8995	11091758.0
2002-04-01	ABTL-DELISTED	Stock	17.75	20.2	17.05	19.5	78700.0
2002-04-01	ABV-DELISTED	Stock	19.54	20.3	19.5	20.16	471700.0
2002-04-01	ABVA-DELISTED	Stock	8.0	8.125	8.0	8.0	7800.0
2002-04-01	ABX-DELISTED	Stock	18.4	19.0	18.35	18.92	2986500.0
2002-04-01	ACAP-DELISTED	Stock	19.41	19.61	19.3	19.55	112300.0
2002-04-01	ACAS-DELISTED	Stock	30.99	30.99	30.51	30.51	250500.0
2002-04-01	ACAT-DELISTED	Stock	19.33	20.31	18.3	18.59	133900.0
2002-04-01	ACCL-DELISTED	Stock	9.63070011138916	10.1231002807617	9.63070011138916	10.1231002807617	204100.0
2002-04-01	ACE-DELISTED	Stock	41.9	41.91	41.04	41.8	986700.0
2002-04-01	ACF-DELISTED	Stock	37.75	38.5	36.6	38.07	1158600.0
2002-04-01	ACG-DELISTED	Stock	7.72	7.72	7.66	7.69	592900.0
2002-04-01	ACGL	Stock	2.8644	2.8644	2.8167	2.8333	305100.0
2002-04-01	ACGN-DELISTED	Stock	1507.3288	1552.6712	1507.3288	1534.5288	28700.0
2002-04-01	ACH	Stock	13.1667	13.3	12.8533	13.1267	119400.0
2002-04-01	ACH-DELISTED	Stock	5.537	5.537	5.512	5.537	53205.0
2002-04-01	ACLS	Stock	56.6	57.72	54.88	57.24	110600.0
2002-04-01	ACO-DELISTED	Stock	6.05	6.3	6.05	6.3	29000.0
2002-04-01	ACPW-DELISTED	Stock	26.3	26.3	24.05	25.7	60800.0
2002-04-01	ACS-DELISTED	Stock	55.5	56.4	54.74	56.25	707700.0
2002-04-01	ACTA-DELISTED	Stock	12.8	12.8	11.2	12.0	39400.0
2002-04-01	ACTT-DELISTED	Stock	5.3	5.3	4.91	5.01	11700.0
2002-04-01	ACTU-DELISTED	Stock	7.19	7.2	6.85	7.04	601700.0
2002-04-01	ACXM-DELISTED	Stock	17.06	17.15	16.6	16.98	736200.0
2002-04-01	AD	Stock	27.2	27.3933	26.7733	27.3467	121650.0

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

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