PREVIEW / stock_daily / 2000-07-27

all stock daily files

  file:    by_date/stock_daily/2000/2000-07-27.parquet
  size:    87 KB
  rows:    2,762
  symbols: 1,711

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
2000-07-27	AAPL	Stock	0.8929	0.9509	0.8906	0.9286	294985600.0
2000-07-27	MSFT	Stock	33.9375	35.0625	33.75	34.6875	74337600.0
2000-07-27	NVDA	Stock	0.2292	0.2323	0.2167	0.2198	331560000.0
2000-07-27	AMZN	Stock	1.5719	1.6	1.4875	1.5688	471586000.0
2000-07-27	CL	Stock	27.9062	28.3125	27.375	28.1875	2564200.0
2000-07-27	A	Stock	31.6524	32.1441	28.8805	29.1488	9849609.0
2000-07-27	AABA-DELISTED	Stock	67.09375	68.3125	65.65625	67.03125	11889800.0
2000-07-27	AAI-DELISTED	Stock	4.38	4.56	4.19	4.31	60400.0
2000-07-27	AAIC-DELISTED	Stock	146.25	146.25	137.5	140.0	31200.0
2000-07-27	AAME	Stock	2.1875	2.1875	2.1562	2.1875	8300.0
2000-07-27	AAON	Stock	1.4266	1.4339	1.4193	1.4193	30755.0
2000-07-27	ABAX-DELISTED	Stock	5.875	6.03125	5.875	5.90625	26300.0
2000-07-27	ABC-DELISTED	Stock	8.0	8.28125	7.875	8.25	1282000.0
2000-07-27	ABCB	Stock	7.7001	7.7001	7.7001	7.7001	4935.0
2000-07-27	ABCW-DELISTED	Stock	15.34	15.38	15.06	15.25	26600.0
2000-07-27	ABE-DELISTED	Stock	14.8125	14.8125	14.1875	14.1875	26300.0
2000-07-27	ABFS-DELISTED	Stock	13.5	13.75	13.0	13.75	160400.0
2000-07-27	ABK-DELISTED	Stock	66.25	67.38	65.25	65.56	340200.0
2000-07-27	ABM	Stock	12.5312	12.625	12.2812	12.5	24000.0
2000-07-27	ABMD-DELISTED	Stock	23.8	23.8	21.688	21.938	202600.0
2000-07-27	ABT	Stock	17.8999	18.0963	17.8999	17.956	3954993.0
2000-07-27	ABTL-DELISTED	Stock	26.25	26.88	25.0	26.88	19100.0
2000-07-27	ABV-DELISTED	Stock	19.94	20.75	19.94	20.69	210400.0
2000-07-27	ABX-DELISTED	Stock	16.375	16.5625	16.0625	16.25	687300.0
2000-07-27	ACAS-DELISTED	Stock	25.0	25.06	24.75	25.06	35700.0
2000-07-27	ACAT-DELISTED	Stock	12.156	12.156	12.031	12.0937	10476.0
2000-07-27	ACCL-DELISTED	Stock	30.1299991607666	34.0330009460449	28.511999130249	29.0100002288818	368000.0
2000-07-27	ACE-DELISTED	Stock	33.56	37.25	33.56	36.69	4757000.0
2000-07-27	ACF-DELISTED	Stock	19.63	20.5	19.56	20.38	313600.0
2000-07-27	ACG-DELISTED	Stock	7.5	7.5	7.4375	7.5	70900.0
2000-07-27	ACGL	Stock	1.6667	1.6944	1.6667	1.6944	112500.0
2000-07-27	ACGN-DELISTED	Stock	991.6712	1133.3288	991.6712	1133.3288	41000.0
2000-07-27	ACH	Stock	10.5833	11.0	10.5	10.5	178350.0
2000-07-27	ACLS	Stock	71.5	72.5	65.25	66.25	373525.0
2000-07-27	ACO-DELISTED	Stock	3.5	3.75	3.5	3.625	47600.0
2000-07-27	ACS-DELISTED	Stock	21.4688	22.0	21.4375	21.875	208000.0
2000-07-27	ACTA-DELISTED	Stock	711.25	712.5	656.25	667.5	149300.0
2000-07-27	ACTT-DELISTED	Stock	6.0	6.0	5.625	5.625	14600.0
2000-07-27	ACTU-DELISTED	Stock	45.0	45.75	43.5	45.13	178100.0
2000-07-27	ACXM-DELISTED	Stock	25.28125	25.4375	19.75	20.125	8365000.0
2000-07-27	ACY-DELISTED	Stock	6.5	6.5	6.5	6.5	200.0
2000-07-27	AD	Stock	45.2917	45.2917	44.5833	45.0729	226050.0
2000-07-27	ADAT-DELISTED	Stock	99.0	101.25	92.25	93.38	3400.0
2000-07-27	ADBE	Stock	30.7578	32.0625	27.4375	28.375	12136400.0
2000-07-27	ADC	Stock	16.625	16.875	16.375	16.5625	15100.0
2000-07-27	ADEP-DELISTED	Stock	180.78	181.56	160.0	161.25	15800.0
2000-07-27	ADGF-DELISTED	Stock	1.25	1.31	0.97	1.31	159900.0
2000-07-27	ADI	Stock	65.25	65.25	58.5	63.5	6652100.0
2000-07-27	ADM	Stock	8.6735	9.4671	8.6168	8.7868	1584182.0
2000-07-27	ADMP-DELISTED	Stock	1498.125	1551.25	1487.5	1530.0	600.0

> showing 50 of 2,762 rows — these rows as CSV

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