PREVIEW / stock_daily / 2000-04-18

all stock daily files

  file:    by_date/stock_daily/2000/2000-04-18.parquet
  size:    86 KB
  rows:    2,755
  symbols: 1,722

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-04-18	AAPL	Stock	1.1027	1.1328	1.0658	1.1328	390924800.0
2000-04-18	MSFT	Stock	38.25	40.9688	37.9375	40.2812	91794600.0
2000-04-18	NVDA	Stock	0.1658	0.187	0.1609	0.1773	477504000.0
2000-04-18	AMZN	Stock	2.3812	2.8125	2.3562	2.7469	214700000.0
2000-04-18	CL	Stock	28.5	28.5	27.3125	27.625	4614000.0
2000-04-18	A	Stock	55.794	62.9471	53.7375	62.2318	3758243.0
2000-04-18	AABA-DELISTED	Stock	58.46875	63.75	57.75	63.34375	24866000.0
2000-04-18	AAI-DELISTED	Stock	4.05	4.31	4.0	4.19	384300.0
2000-04-18	AAIC-DELISTED	Stock	145.0	153.75	135.0	138.75	238200.0
2000-04-18	AAME	Stock	2.5	2.75	2.5	2.75	111100.0
2000-04-18	AAON	Stock	1.1706	1.1962	1.1706	1.1888	1050785.0
2000-04-18	ABAX-DELISTED	Stock	7.25	7.25	6.875	7.0	65300.0
2000-04-18	ABC-DELISTED	Stock	4.296875	4.5625	4.265625	4.484375	484000.0
2000-04-18	ABCW-DELISTED	Stock	14.84	15.13	14.69	14.69	38000.0
2000-04-18	ABE-DELISTED	Stock	15.25	15.6875	15.25	15.6875	32100.0
2000-04-18	ABFS-DELISTED	Stock	13.375	14.125	13.25	14.0625	202200.0
2000-04-18	ABK-DELISTED	Stock	48.75	50.25	48.75	50.19	413100.0
2000-04-18	ABM	Stock	11.625	11.9375	11.5625	11.9375	57400.0
2000-04-18	ABMD-DELISTED	Stock	15.26567	16.6563	14.0	16.0313	147400.0
2000-04-18	ABT	Stock	16.918	17.3388	16.6654	17.1424	6324559.0
2000-04-18	ABTL-DELISTED	Stock	30.31	34.84	30.0	32.5	88800.0
2000-04-18	ABV-DELISTED	Stock	13.88	14.75	13.75	14.37	129000.0
2000-04-18	ABX-DELISTED	Stock	16.8439	16.9065	16.5	16.7186	1035179.0
2000-04-18	ACAS-DELISTED	Stock	22.875	25.125	22.8125	25.0	65400.0
2000-04-18	ACAT-DELISTED	Stock	9.938	10.126	9.938	9.938	39998.0
2000-04-18	ACCL-DELISTED	Stock	24.25	28.9200000762939	22.0849990844727	25.7970008850098	422900.0
2000-04-18	ACE-DELISTED	Stock	20.5	21.38	20.5	20.81	536400.0
2000-04-18	ACF-DELISTED	Stock	16.75	17.88	16.75	17.31	551300.0
2000-04-18	ACG-DELISTED	Stock	6.8125	6.875	6.75	6.75	128800.0
2000-04-18	ACGN-DELISTED	Stock	2691.6712	3647.9824	2550.0	3258.3424	54000.0
2000-04-18	ACH	Stock	7.5833	8.0	7.5833	8.0	81600.0
2000-04-18	ACO-DELISTED	Stock	12.6875	13.25	12.6875	12.9375	15100.0
2000-04-18	ACS-DELISTED	Stock	17.5313	18.75	17.4375	18.75	246400.0
2000-04-18	ACTA-DELISTED	Stock	780.0	888.75	765.0	820.0	376600.0
2000-04-18	ACTT-DELISTED	Stock	8.8125	8.875	8.5	8.6875	32800.0
2000-04-18	ACTU-DELISTED	Stock	32.0	36.0	29.25	30.56	294000.0
2000-04-18	ACXM-DELISTED	Stock	26.375	32.0	26.0	29.3125	401500.0
2000-04-18	AD	Stock	38.0	40.8333	37.9167	39.8333	782100.0
2000-04-18	ADAT-DELISTED	Stock	147.38	180.0	144.0	169.88	19600.0
2000-04-18	ADBE	Stock	28.8906	30.4062	28.3281	29.25	8886000.0
2000-04-18	ADC	Stock	13.75	14.0625	13.625	13.8125	6700.0
2000-04-18	ADEP-DELISTED	Stock	52.5	55.0	50.0	55.0	8900.0
2000-04-18	ADGF-DELISTED	Stock	1.5	1.56	1.44	1.56	68100.0
2000-04-18	ADI	Stock	63.75	69.5625	62.0	65.5625	2627000.0
2000-04-18	ADM	Stock	9.4671	9.5238	9.0136	9.127	1921437.0
2000-04-18	ADMP-DELISTED	Stock	850.0	1115.625	828.75	1115.625	700.0
2000-04-18	ADPI-DELISTED	Stock	7.06	7.06	7.0	7.0	1200.0
2000-04-18	ADSK	Stock	9.4219	9.875	9.25	9.7969	2175600.0
2000-04-18	ADTN	Stock	30.5	31.75	29.625	31.375	373600.0
2000-04-18	ADVNB-DELISTED	Stock	11.0	11.94	10.88	11.75	38700.0

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

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