PREVIEW / stock_daily / 2001-03-20

all stock daily files

  file:    by_date/stock_daily/2001/2001-03-20.parquet
  size:    99 KB
  rows:    2,911
  symbols: 1,809

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
2001-03-20	AAPL	Stock	0.37	0.3739	0.3516	0.3516	499206400.0
2001-03-20	MSFT	Stock	27.2812	28.0625	26.3125	26.3438	91822800.0
2001-03-20	NVDA	Stock	0.2596	0.276	0.2354	0.2383	1990560000.0
2001-03-20	AMZN	Stock	0.5281	0.575	0.5062	0.5125	125894000.0
2001-03-20	CL	Stock	26.725	27.49	26.7	26.83	4046600.0
2001-03-20	A	Stock	25.9299	25.9299	24.5351	24.5351	4223218.0
2001-03-20	AABA-DELISTED	Stock	7.625	7.8125	6.875	6.96875	23528400.0
2001-03-20	AAI-DELISTED	Stock	7.05	7.58	7.01	7.15	320000.0
2001-03-20	AAIC-DELISTED	Stock	127.0	129.0	124.0	124.0	12800.0
2001-03-20	AAME	Stock	1.9375	1.9375	1.9375	1.9375	3000.0
2001-03-20	AAON	Stock	1.1852	1.1852	1.1413	1.1449	404937.0
2001-03-20	ABAX-DELISTED	Stock	5.0	5.15625	5.0	5.125	24600.0
2001-03-20	ABC-DELISTED	Stock	11.4250001907349	11.5	11.25	11.3725004196167	8051200.0
2001-03-20	ABCB	Stock	9.0172	9.3212	9.0172	9.3212	7156.0
2001-03-20	ABCW-DELISTED	Stock	14.06	14.06	13.75	13.75	18100.0
2001-03-20	ABE-DELISTED	Stock	8.0	8.03	7.8	7.8	53200.0
2001-03-20	ABFS-DELISTED	Stock	16.6875	18.0	16.375	17.125	339700.0
2001-03-20	ABK-DELISTED	Stock	59.6	60.4	59.21	59.21	629400.0
2001-03-20	ABM	Stock	15.425	15.625	15.305	15.305	103400.0
2001-03-20	ABMD-DELISTED	Stock	17.0625	18.3125	16.0	16.25	66100.0
2001-03-20	ABP-DELISTED	Stock	5.23	5.25	5.06	5.08	101900.0
2001-03-20	ABT	Stock	20.1108	20.1108	19.3925	19.4374	7943402.0
2001-03-20	ABTL-DELISTED	Stock	9.219	10.0	8.906	10.0	4500.0
2001-03-20	ABV-DELISTED	Stock	24.04	24.9	24.04	24.43	256300.0
2001-03-20	ABX-DELISTED	Stock	15.0	15.09	14.76	14.87	1521000.0
2001-03-20	ACAP-DELISTED	Stock	18.88	19.0	18.63	19.0	48000.0
2001-03-20	ACAS-DELISTED	Stock	25.25	25.56	24.75	25.44	187199.0
2001-03-20	ACAT-DELISTED	Stock	13.09375	13.1875	13.0	13.0	148000.0
2001-03-20	ACCL-DELISTED	Stock	13.3100004196167	13.6450004577637	12.581000328064	12.9440002441406	175100.0
2001-03-20	ACE-DELISTED	Stock	36.1	36.1	34.55	34.61	1473500.0
2001-03-20	ACF-DELISTED	Stock	32.15	32.68	30.4	30.5	693200.0
2001-03-20	ACG-DELISTED	Stock	8.4	8.4	8.17	8.26	389000.0
2001-03-20	ACGL	Stock	1.7569	1.7569	1.75	1.75	900000.0
2001-03-20	ACGN-DELISTED	Stock	600.6712	651.6712	600.6712	634.6712	42900.0
2001-03-20	ACH	Stock	11.1667	11.1667	10.7133	10.7133	136050.0
2001-03-20	ACLS	Stock	39.5	42.25	39.5	40.75	172925.0
2001-03-20	ACO-DELISTED	Stock	4.01	4.01	3.9	3.92	13600.0
2001-03-20	ACPW-DELISTED	Stock	91.13	93.79	87.54	92.54	52129.0
2001-03-20	ACS-DELISTED	Stock	30.75	30.75	29.9	29.905	734600.0
2001-03-20	ACTA-DELISTED	Stock	50.62	56.25	45.62	46.25	97100.0
2001-03-20	ACTT-DELISTED	Stock	7.0625	7.25	7.0625	7.25	6200.0
2001-03-20	ACTU-DELISTED	Stock	9.97	11.56	9.38	10.06	608900.0
2001-03-20	ACXM-DELISTED	Stock	22.8125	23.0	22.1875	22.53125	941300.0
2001-03-20	AD	Stock	39.0333	39.5333	38.0	38.1733	168750.0
2001-03-20	ADAT-DELISTED	Stock	67.78	69.19	54.0	61.88	6600.0
2001-03-20	ADBE	Stock	16.3125	17.0625	15.75	16.4062	16440400.0
2001-03-20	ADC	Stock	16.95	17.05	16.85	17.05	8300.0
2001-03-20	ADEP-DELISTED	Stock	73.67	80.31	72.19	77.19	55000.0
2001-03-20	ADGF-DELISTED	Stock	1.09	1.09	1.0	1.0	20000.0
2001-03-20	ADI	Stock	39.9	41.2	38.25	38.45	4346500.0

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

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