PREVIEW / stock_daily / 2001-04-23

all stock daily files

  file:    by_date/stock_daily/2001/2001-04-23.parquet
  size:    99 KB
  rows:    2,908
  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-04-23	AAPL	Stock	0.4346	0.4464	0.4286	0.433	541525600.0
2001-04-23	MSFT	Stock	34.055	34.235	33.45	34.125	92171200.0
2001-04-23	NVDA	Stock	0.3545	0.3548	0.3396	0.3432	1239000000.0
2001-04-23	AMZN	Stock	0.8195	0.873	0.801	0.81	233792000.0
2001-04-23	CL	Stock	26.75	26.985	26.425	26.52	3262600.0
2001-04-23	A	Stock	28.2546	28.6123	27.3391	28.6123	2869954.0
2001-04-23	AABA-DELISTED	Stock	9.55500030517578	9.58500003814697	8.9350004196167	8.97999954223633	20566200.0
2001-04-23	AAI-DELISTED	Stock	9.5	9.5	9.08	9.49	765700.0
2001-04-23	AAIC-DELISTED	Stock	108.0	109.8	108.0	109.0	8600.0
2001-04-23	AAME	Stock	1.95	1.95	1.95	1.95	5500.0
2001-04-23	AAON	Stock	1.0892	1.1208	1.0892	1.119	365639.0
2001-04-23	ABAX-DELISTED	Stock	5.04	5.06	4.89	4.95	48500.0
2001-04-23	ABB-DELISTED	Stock	17.3	17.5	17.04	17.04	47800.0
2001-04-23	ABC-DELISTED	Stock	12.8000001907349	13.0500001907349	12.7875003814697	12.9750003814697	1925600.0
2001-04-23	ABCB	Stock	9.3212	9.5238	9.3212	9.5238	617.0
2001-04-23	ABCW-DELISTED	Stock	13.28	13.5	13.25	13.35	29400.0
2001-04-23	ABE-DELISTED	Stock	8.25	8.25	8.05	8.1	16500.0
2001-04-23	ABFS-DELISTED	Stock	17.04	18.23	16.85	18.13	207600.0
2001-04-23	ABK-DELISTED	Stock	54.0	54.55	54.0	54.55	1096500.0
2001-04-23	ABM	Stock	15.2	15.235	14.93	15.125	77400.0
2001-04-23	ABMD-DELISTED	Stock	20.1	20.35	19.6	20.2	64600.0
2001-04-23	ABP-DELISTED	Stock	4.3	4.34	4.1	4.24	75200.0
2001-04-23	ABT	Stock	20.3801	20.4474	19.8639	19.994	8077284.0
2001-04-23	ABTL-DELISTED	Stock	6.35	6.35	5.9	6.0	11500.0
2001-04-23	ABV-DELISTED	Stock	21.2	21.25	20.8	21.25	233100.0
2001-04-23	ABX-DELISTED	Stock	15.75	15.75	15.4	15.57	1084100.0
2001-04-23	ACAP-DELISTED	Stock	18.04	18.04	17.7	17.81	13400.0
2001-04-23	ACAS-DELISTED	Stock	26.07	26.13	25.89	26.13	179634.0
2001-04-23	ACAT-DELISTED	Stock	13.04	13.09	13.0	13.05	26100.0
2001-04-23	ACCL-DELISTED	Stock	14.2299995422363	14.4460000991821	13.5410003662109	13.6569995880127	186200.0
2001-04-23	ACE-DELISTED	Stock	35.0	35.7	34.91	35.7	1130000.0
2001-04-23	ACF-DELISTED	Stock	43.8	43.8	42.15	42.49	733300.0
2001-04-23	ACG-DELISTED	Stock	7.93	7.93	7.85	7.91	365000.0
2001-04-23	ACGL	Stock	1.73	1.7333	1.7222	1.7278	1903500.0
2001-04-23	ACGN-DELISTED	Stock	578.0	634.6712	476.0	589.3288	150200.0
2001-04-23	ACH	Stock	11.04	11.08	10.6667	10.8	65850.0
2001-04-23	ACLS	Stock	59.52	60.08	54.48	59.6	465450.0
2001-04-23	ACO-DELISTED	Stock	4.55	4.6	4.47	4.49	28300.0
2001-04-23	ACPW-DELISTED	Stock	101.25	106.0	95.75	105.0	160120.0
2001-04-23	ACS-DELISTED	Stock	32.875	32.875	31.95	32.495	294300.0
2001-04-23	ACTA-DELISTED	Stock	49.8	50.0	41.6	41.8	109100.0
2001-04-23	ACTT-DELISTED	Stock	5.93	5.93	5.65	5.65	7700.0
2001-04-23	ACTU-DELISTED	Stock	10.7	10.79	9.9	10.09	352700.0
2001-04-23	ACXM-DELISTED	Stock	15.7	15.94	15.08	15.23	496200.0
2001-04-23	ACY-DELISTED	Stock	4.7	4.7	4.65	4.65	1400.0
2001-04-23	AD	Stock	42.6667	42.8333	42.16	42.7333	156450.0
2001-04-23	ADAT-DELISTED	Stock	107.1	113.4	107.1	111.24	1285.0
2001-04-23	ADBE	Stock	22.535	22.62	21.05	21.49	6175400.0
2001-04-23	ADC	Stock	16.35	16.5	16.25	16.35	8300.0
2001-04-23	ADEP-DELISTED	Stock	57.55	65.0	57.5	59.9	20600.0

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

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