PREVIEW / stock_daily / 2002-09-05

all stock daily files

  file:    by_date/stock_daily/2002/2002-09-05.parquet
  size:    107 KB
  rows:    3,162
  symbols: 1,955

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-09-05	AAPL	Stock	0.2539	0.2564	0.2509	0.2532	226178400.0
2002-09-05	MSFT	Stock	23.75	23.76	22.94	22.955	90438800.0
2002-09-05	NVDA	Stock	0.0777	0.0781	0.075	0.0755	714312000.0
2002-09-05	AMZN	Stock	0.729	0.736	0.712	0.7125	106404000.0
2002-09-05	CL	Stock	27.5	28.625	27.26	28.07	11297000.0
2002-09-05	A	Stock	9.5136	9.8212	9.3705	9.814	7068428.0
2002-09-05	AABA-DELISTED	Stock	4.81500005722046	4.81500005722046	4.57000017166138	4.59499979019165	19218400.0
2002-09-05	AAI-DELISTED	Stock	3.4	3.4	3.21	3.22	272200.0
2002-09-05	AAIC-DELISTED	Stock	214.0	220.0	214.0	215.8	57500.0
2002-09-05	AAME	Stock	1.92	1.92	1.77	1.77	600.0
2002-09-05	AAON	Stock	2.1728	2.244	2.0938	2.1004	185287.0
2002-09-05	AAP	Stock	16.3	16.5667	16.2333	16.4167	873600.0
2002-09-05	AAXN-DELISTED	Stock	0.550000011920929	0.550000011920929	0.537500023841858	0.538333356380463	43200.0
2002-09-05	ABAX-DELISTED	Stock	3.01	3.1	2.701	3.0	29350.0
2002-09-05	ABB-DELISTED	Stock	5.7	5.8	5.35	5.42	85000.0
2002-09-05	ABC-DELISTED	Stock	17.84	18.2	17.6	18.12	3195600.0
2002-09-05	ABCB	Stock	10.5451	11.0638	10.4559	10.4721	9254.0
2002-09-05	ABCO-DELISTED	Stock	16.63	17.145	16.455	16.825	45200.0
2002-09-05	ABCW-DELISTED	Stock	21.7	21.89	21.65	21.75	44800.0
2002-09-05	ABE-DELISTED	Stock	6.0	6.0	5.92	6.0	6600.0
2002-09-05	ABFS-DELISTED	Stock	26.0	26.5	25.89	26.211	509640.0
2002-09-05	ABG	Stock	11.8	11.8	11.45	11.65	62200.0
2002-09-05	ABK-DELISTED	Stock	55.95	57.39	55.26	56.75	823000.0
2002-09-05	ABM	Stock	16.8	16.8	16.21	16.4	71200.0
2002-09-05	ABMD-DELISTED	Stock	5.32	5.39	5.11	5.25	31530.0
2002-09-05	ABP-DELISTED	Stock	0.78	0.84	0.71	0.73	51500.0
2002-09-05	ABT	Stock	17.1031	17.3276	16.7171	16.9685	8597221.0
2002-09-05	ABTL-DELISTED	Stock	11.25	11.75	10.75	11.0	9900.0
2002-09-05	ABV-DELISTED	Stock	13.5	13.57	13.2	13.25	80300.0
2002-09-05	ABVA-DELISTED	Stock	10.05	10.05	9.8	10.02	2900.0
2002-09-05	ABX-DELISTED	Stock	16.2	16.47	16.0	16.42	4317709.0
2002-09-05	ACAP-DELISTED	Stock	18.15	18.22	17.72	17.76	63400.0
2002-09-05	ACAS-DELISTED	Stock	20.91	21.44	20.65	21.04	1030450.0
2002-09-05	ACAT-DELISTED	Stock	15.0	15.0	14.29	14.29	36229.0
2002-09-05	ACCL-DELISTED	Stock	6.00290012359619	6.01013994216919	5.76393985748291	6.01013994216919	100700.0
2002-09-05	ACE-DELISTED	Stock	30.61	31.04	30.02	30.69	704300.0
2002-09-05	ACF-DELISTED	Stock	12.65	13.78	12.18	12.43	2406700.0
2002-09-05	ACG-DELISTED	Stock	8.1	8.12	8.05	8.09	531400.0
2002-09-05	ACGL	Stock	3.1156	3.1156	2.9444	2.9956	425700.0
2002-09-05	ACGN-DELISTED	Stock	736.6712	793.3288	736.6712	770.6712	33800.0
2002-09-05	ACH	Stock	9.7467	9.8333	9.6467	9.6467	104700.0
2002-09-05	ACH-DELISTED	Stock	3.5455	3.5455	3.503	3.503	4400.0
2002-09-05	ACLS	Stock	25.56	25.56	24.2	24.68	187025.0
2002-09-05	ACO-DELISTED	Stock	5.35	5.4	5.27	5.35	30700.0
2002-09-05	ACPW-DELISTED	Stock	10.5	10.75	9.55	10.0	17840.0
2002-09-05	ACS-DELISTED	Stock	44.25	45.76	43.16	45.23	1747200.0
2002-09-05	ACTA-DELISTED	Stock	5.0	5.4	4.8	5.0	15600.0
2002-09-05	ACTT-DELISTED	Stock	2.0	2.0	1.83	1.83	11200.0
2002-09-05	ACTU-DELISTED	Stock	2.0	2.03	1.9	1.91	110800.0
2002-09-05	ACXM-DELISTED	Stock	17.98	17.98	17.1	17.62	711130.0

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

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