PREVIEW / stock_daily / 2002-08-27

all stock daily files

  file:    by_date/stock_daily/2002/2002-08-27.parquet
  size:    107 KB
  rows:    3,157
  symbols: 1,951

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-08-27	AAPL	Stock	0.2805	0.2811	0.2627	0.2652	262231200.0
2002-08-27	MSFT	Stock	26.165	26.225	25.325	25.42	65470200.0
2002-08-27	NVDA	Stock	0.0982	0.0987	0.0904	0.091	686712000.0
2002-08-27	AMZN	Stock	0.752	0.7635	0.725	0.726	71578000.0
2002-08-27	CL	Stock	26.75	27.12	26.505	27.035	3762400.0
2002-08-27	A	Stock	11.5951	11.6595	10.7296	10.9514	4642898.0
2002-08-27	AABA-DELISTED	Stock	5.7649998664856	5.7649998664856	5.28000020980835	5.34999990463257	25004800.0
2002-08-27	AAI-DELISTED	Stock	3.52	3.65	3.5	3.51	195800.0
2002-08-27	AAIC-DELISTED	Stock	215.0	215.0	207.0	210.2	32800.0
2002-08-27	AAME	Stock	2.1	2.1	2.0	2.0	1100.0
2002-08-27	AAON	Stock	2.4046	2.4099	2.3835	2.3835	197437.0
2002-08-27	AAP	Stock	18.0	18.0033	17.7667	17.83	910500.0
2002-08-27	AAXN-DELISTED	Stock	0.581666648387909	0.581666648387909	0.555833339691162	0.555833339691162	126000.0
2002-08-27	ABAX-DELISTED	Stock	3.2	3.23	3.17	3.1804	24300.0
2002-08-27	ABB-DELISTED	Stock	6.0	6.0	5.65	5.9	50500.0
2002-08-27	ABC-DELISTED	Stock	18.35	18.4	17.8	17.88	2473600.0
2002-08-27	ABCB	Stock	11.2989	11.5096	11.1449	11.1449	17765.0
2002-08-27	ABCO-DELISTED	Stock	16.15	16.16	15.585	15.65	52200.0
2002-08-27	ABCW-DELISTED	Stock	21.41	21.6	21.33	21.33	71260.0
2002-08-27	ABE-DELISTED	Stock	6.28	6.35	6.2	6.27	12500.0
2002-08-27	ABFS-DELISTED	Stock	22.74	22.85	22.06	22.07	100800.0
2002-08-27	ABG	Stock	11.2	11.75	11.2	11.39	57800.0
2002-08-27	ABK-DELISTED	Stock	60.2	60.23	58.0	58.2	401600.0
2002-08-27	ABM	Stock	17.5	17.55	16.85	16.86	53500.0
2002-08-27	ABMD-DELISTED	Stock	4.8	5.45	4.8	5.15	87900.0
2002-08-27	ABP-DELISTED	Stock	0.9	0.9	0.75	0.76	179700.0
2002-08-27	ABT	Stock	18.4498	18.6967	18.1176	18.2972	6815090.0
2002-08-27	ABTL-DELISTED	Stock	11.5	11.5	10.45	10.6	10300.0
2002-08-27	ABV-DELISTED	Stock	14.75	14.8	14.3	14.39	491800.0
2002-08-27	ABVA-DELISTED	Stock	9.25	9.25	9.25	9.25	1000.0
2002-08-27	ABX-DELISTED	Stock	15.29	15.86	15.16	15.7	3309316.0
2002-08-27	ACAP-DELISTED	Stock	17.91	17.99	17.41	17.7	9100.0
2002-08-27	ACAS-DELISTED	Stock	23.54	23.88	22.94	23.01	663474.0
2002-08-27	ACAT-DELISTED	Stock	15.72	15.72	15.0	15.0	21100.0
2002-08-27	ACCL-DELISTED	Stock	5.96999979019165	6.22700023651123	5.5460000038147	5.56099987030029	127200.0
2002-08-27	ACE-DELISTED	Stock	33.99	34.24	32.3	32.58	1274800.0
2002-08-27	ACF-DELISTED	Stock	16.35	16.86	15.2	15.38	1784700.0
2002-08-27	ACG-DELISTED	Stock	8.15	8.17	8.11	8.15	524300.0
2002-08-27	ACGL	Stock	3.1222	3.1222	3.1	3.1189	121500.0
2002-08-27	ACH	Stock	9.9933	9.9933	9.7667	9.8	887850.0
2002-08-27	ACH-DELISTED	Stock	3.6255	3.6255	3.588	3.588	32396.0
2002-08-27	ACLS	Stock	30.84	30.96	28.48	28.52	103125.0
2002-08-27	ACO-DELISTED	Stock	5.9	5.98	5.85	5.9	16000.0
2002-08-27	ACPW-DELISTED	Stock	12.224	12.224	11.226	11.276	21487.0
2002-08-27	ACS-DELISTED	Stock	47.4	47.52	45.67	45.7	811000.0
2002-08-27	ACTA-DELISTED	Stock	6.2	6.6	5.4	5.6	52600.0
2002-08-27	ACTT-DELISTED	Stock	2.41	2.54	2.31	2.41	18500.0
2002-08-27	ACTU-DELISTED	Stock	2.1	2.25	2.05	2.2	298500.0
2002-08-27	ACXM-DELISTED	Stock	17.11	17.31	17.0	17.25	1318041.0
2002-08-27	AD	Stock	21.8333	22.1667	21.4667	21.9333	160500.0

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

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