PREVIEW / stock_daily / 2000-07-31

all stock daily files

  file:    by_date/stock_daily/2000/2000-07-31.parquet
  size:    88 KB
  rows:    2,811
  symbols: 1,754

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-31	AAPL	Stock	0.8778	0.9219	0.8705	0.9074	155299200.0
2000-07-31	MSFT	Stock	35.0938	35.5625	34.625	34.9062	70283800.0
2000-07-31	NVDA	Stock	0.2375	0.2505	0.225	0.25	371232000.0
2000-07-31	AMZN	Stock	1.5031	1.5125	1.3938	1.5062	189576000.0
2000-07-31	CL	Stock	28.0	28.8125	27.8438	27.8438	2217000.0
2000-07-31	A	Stock	29.3723	30.177	28.7017	29.1488	8053179.0
2000-07-31	AABA-DELISTED	Stock	63.09375	64.875	61.375	64.34375	11073200.0
2000-07-31	AAI-DELISTED	Stock	4.19	4.38	4.13	4.31	60800.0
2000-07-31	AAIC-DELISTED	Stock	135.0	145.0	133.75	145.0	17700.0
2000-07-31	AAME	Stock	2.25	2.375	2.0625	2.0625	6400.0
2000-07-31	AAON	Stock	1.4339	1.4339	1.3955	1.3973	109350.0
2000-07-31	ABAX-DELISTED	Stock	5.65625	5.6875	5.53125	5.625	15400.0
2000-07-31	ABC-DELISTED	Stock	8.5	8.734375	8.4375	8.734375	2343600.0
2000-07-31	ABCB	Stock	7.4975	7.4975	7.2948	7.3454	16039.0
2000-07-31	ABCW-DELISTED	Stock	15.13	16.5	15.06	16.5	27700.0
2000-07-31	ABE-DELISTED	Stock	13.75	13.875	13.6875	13.875	11400.0
2000-07-31	ABFS-DELISTED	Stock	13.9375	14.25	13.8125	14.1875	313900.0
2000-07-31	ABK-DELISTED	Stock	62.38	64.75	62.25	64.5	294900.0
2000-07-31	ABM	Stock	12.5625	13.0	12.5625	13.0	43000.0
2000-07-31	ABMD-DELISTED	Stock	20.2	20.8	19.38	19.88	109400.0
2000-07-31	ABT	Stock	18.8538	18.938	18.6013	18.6294	5687224.0
2000-07-31	ABTL-DELISTED	Stock	27.5	27.5	24.38	26.56	23100.0
2000-07-31	ABV-DELISTED	Stock	20.37	21.31	20.19	21.19	163500.0
2000-07-31	ABX-DELISTED	Stock	16.063	16.063	15.813	15.938	1234375.0
2000-07-31	ACAS-DELISTED	Stock	25.25	25.875	25.0625	25.625	94800.0
2000-07-31	ACAT-DELISTED	Stock	12.375	12.375	12.125	12.25	40800.0
2000-07-31	ACCL-DELISTED	Stock	26.8799991607666	29.2360000610352	25.4340000152588	29.0100002288818	306400.0
2000-07-31	ACE-DELISTED	Stock	35.69	36.0	35.13	35.94	1205600.0
2000-07-31	ACF-DELISTED	Stock	20.0	20.88	19.88	20.88	366300.0
2000-07-31	ACG-DELISTED	Stock	7.5	7.5625	7.4375	7.5625	60200.0
2000-07-31	ACGL	Stock	1.7222	1.75	1.6944	1.7222	360900.0
2000-07-31	ACGN-DELISTED	Stock	991.6712	1027.14	991.6712	991.6712	18700.0
2000-07-31	ACH	Stock	10.25	10.75	10.0833	10.6667	253500.0
2000-07-31	ACLS	Stock	61.5	78.5	59.5	74.0	500475.0
2000-07-31	ACO-DELISTED	Stock	3.375	3.6875	3.3125	3.625	74200.0
2000-07-31	ACS-DELISTED	Stock	23.0625	23.375	22.375	22.5313	258700.0
2000-07-31	ACTA-DELISTED	Stock	648.75	676.25	600.0	676.25	189100.0
2000-07-31	ACTT-DELISTED	Stock	5.625	6.0	5.625	5.875	4900.0
2000-07-31	ACTU-DELISTED	Stock	41.75	49.75	41.0	49.0	379700.0
2000-07-31	ACXM-DELISTED	Stock	20.88	21.5	20.81	21.31	1151088.0
2000-07-31	ACY-DELISTED	Stock	6.38	6.62	6.38	6.62	1100.0
2000-07-31	AD	Stock	45.25	45.5833	44.7917	45.3333	211800.0
2000-07-31	ADAT-DELISTED	Stock	85.5	90.0	81.0	88.88	5900.0
2000-07-31	ADBE	Stock	28.0234	28.8125	25.75	28.625	11458000.0
2000-07-31	ADC	Stock	16.4375	16.6875	16.375	16.4375	7200.0
2000-07-31	ADEP-DELISTED	Stock	140.16	148.44	134.69	134.69	48100.0
2000-07-31	ADGF-DELISTED	Stock	1.25	1.31	1.25	1.25	26800.0
2000-07-31	ADI	Stock	65.0625	67.5	62.4375	66.625	2733900.0
2000-07-31	ADM	Stock	8.7302	8.9002	8.4467	8.5034	1613839.0
2000-07-31	ADMP-DELISTED	Stock	1508.75	1535.3125	1498.125	1530.0	200.0

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

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