PREVIEW / stock_daily / 2001-01-18

all stock daily files

  file:    by_date/stock_daily/2001/2001-01-18.parquet
  size:    92 KB
  rows:    2,905
  symbols: 1,812

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-01-18	AAPL	Stock	0.3181	0.3348	0.3147	0.3337	1227010400.0
2001-01-18	MSFT	Stock	26.8438	28.0938	26.3125	27.75	109788800.0
2001-01-18	NVDA	Stock	0.187	0.2281	0.1828	0.2229	948168000.0
2001-01-18	AMZN	Stock	0.9188	0.975	0.8969	0.975	82316000.0
2001-01-18	CL	Stock	28.265	29.045	27.8	28.44	3026200.0
2001-01-18	A	Stock	44.3044	48.6409	43.1867	48.328	6978536.0
2001-01-18	AABA-DELISTED	Stock	15.5	17.375	14.84375	17.21875	57925400.0
2001-01-18	AAI-DELISTED	Stock	7.31	7.5	7.13	7.13	164000.0
2001-01-18	AAIC-DELISTED	Stock	146.25	153.75	142.5	153.75	76800.0
2001-01-18	AAME	Stock	1.9688	2.0	1.9688	2.0	7400.0
2001-01-18	AAON	Stock	1.2876	1.2876	1.251	1.2547	145230.0
2001-01-18	ABAX-DELISTED	Stock	5.84375	6.125	5.84375	5.96875	35700.0
2001-01-18	ABC-DELISTED	Stock	12.1875	12.21875	11.0625	11.234375	4550400.0
2001-01-18	ABCB	Stock	8.5106	8.7133	8.156	8.156	11352.0
2001-01-18	ABCW-DELISTED	Stock	14.5	15.0	14.5	14.69	38370.0
2001-01-18	ABE-DELISTED	Stock	8.875	9.0625	8.875	9.0625	24700.0
2001-01-18	ABFS-DELISTED	Stock	25.15625	25.625	23.875	24.375	170500.0
2001-01-18	ABK-DELISTED	Stock	46.81	47.25	46.44	47.06	1001000.0
2001-01-18	ABM	Stock	15.75	15.9375	15.75	15.7812	78200.0
2001-01-18	ABMD-DELISTED	Stock	22.5	23.0	21.75	22.0625	149200.0
2001-01-18	ABP-DELISTED	Stock	3.88	4.0	3.81	3.94	239600.0
2001-01-18	ABT	Stock	20.2005	20.5933	19.948	20.2286	8587196.0
2001-01-18	ABTL-DELISTED	Stock	11.719	12.032	10.938	11.563	29400.0
2001-01-18	ABV-DELISTED	Stock	25.1875	25.75	25.1875	25.75	128000.0
2001-01-18	ABX-DELISTED	Stock	15.42	15.43	15.05	15.13	1579935.0
2001-01-18	ACAS-DELISTED	Stock	24.9375	25.0625	24.25	25.0	121500.0
2001-01-18	ACAT-DELISTED	Stock	13.04	13.071	12.883	13.071	40779.0
2001-01-18	ACCL-DELISTED	Stock	18.6800003051758	19.4610004425049	18.1030006408691	18.9169998168945	179300.0
2001-01-18	ACE-DELISTED	Stock	34.5	36.5	33.0	36.5	2922200.0
2001-01-18	ACF-DELISTED	Stock	33.19	33.19	31.06	32.0	1190700.0
2001-01-18	ACG-DELISTED	Stock	8.0	8.0	7.875	7.9375	225000.0
2001-01-18	ACGN-DELISTED	Stock	668.6712	668.6712	521.3288	657.3288	8100.0
2001-01-18	ACH	Stock	10.9583	11.0833	10.9167	10.9583	555600.0
2001-01-18	ACLS	Stock	48.0	52.0	44.25	51.5	492950.0
2001-01-18	ACO-DELISTED	Stock	4.0625	4.375	4.0625	4.1875	35000.0
2001-01-18	ACPW-DELISTED	Stock	120.0	138.12	116.25	133.75	105920.0
2001-01-18	ACS-DELISTED	Stock	28.2188	28.75	26.8125	27.9063	660900.0
2001-01-18	ACTA-DELISTED	Stock	112.5	113.75	105.0	105.62	137000.0
2001-01-18	ACTT-DELISTED	Stock	7.125	8.125	7.0781	7.875	19900.0
2001-01-18	ACTU-DELISTED	Stock	21.25	22.31	20.47	21.0	631500.0
2001-01-18	ACXM-DELISTED	Stock	31.09	32.06	30.87	31.19	979300.0
2001-01-18	ACY-DELISTED	Stock	5.0	5.0	5.0	5.0	600.0
2001-01-18	AD	Stock	40.3333	40.3333	39.3667	40.2667	326100.0
2001-01-18	ADAT-DELISTED	Stock	81.28	86.62	78.75	81.0	4300.0
2001-01-18	ADBE	Stock	26.8438	29.1875	26.0625	28.0	12529400.0
2001-01-18	ADC	Stock	15.1875	15.25	14.9375	15.0625	5200.0
2001-01-18	ADEP-DELISTED	Stock	112.5	116.88	108.13	114.69	48100.0
2001-01-18	ADGF-DELISTED	Stock	1.81	1.91	1.5	1.56	389400.0
2001-01-18	ADI	Stock	53.875	60.0	51.0	58.5	14827800.0
2001-01-18	ADLR-DELISTED	Stock	18.1875	19.25	18.1875	18.625	104400.0

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

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