PREVIEW / stock_daily / 2001-10-18

all stock daily files

  file:    by_date/stock_daily/2001/2001-10-18.parquet
  size:    100 KB
  rows:    2,952
  symbols: 1,824

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-10-18	AAPL	Stock	0.3088	0.3255	0.3088	0.3214	612572800.0
2001-10-18	MSFT	Stock	28.17	28.79	27.75	28.375	78348000.0
2001-10-18	NVDA	Stock	0.3475	0.3656	0.3467	0.3622	1020864000.0
2001-10-18	AMZN	Stock	0.4455	0.4615	0.419	0.4235	87066000.0
2001-10-18	CL	Stock	28.13	28.95	28.05	28.8	2299800.0
2001-10-18	A	Stock	16.3448	16.6667	16.1159	16.2375	1391010.0
2001-10-18	AABA-DELISTED	Stock	5.74499988555908	5.92000007629395	5.53999996185303	5.63500022888184	14633600.0
2001-10-18	AAI-DELISTED	Stock	4.05	4.15	3.7	3.85	261600.0
2001-10-18	AAIC-DELISTED	Stock	109.0	109.0	102.2	103.4	27300.0
2001-10-18	AAME	Stock	1.48	1.5	1.41	1.44	6000.0
2001-10-18	AAON	Stock	1.5144	1.5311	1.4889	1.517	371334.0
2001-10-18	AAXN-DELISTED	Stock	0.840833306312561	0.902499973773956	0.840833306312561	0.865833342075348	1580400.0
2001-10-18	ABAX-DELISTED	Stock	3.88	3.98	3.8	3.85	17700.0
2001-10-18	ABB-DELISTED	Stock	7.1	7.36	7.1	7.15	117000.0
2001-10-18	ABC-DELISTED	Stock	17.42	17.54	17.37	17.5	3102800.0
2001-10-18	ABCB	Stock	10.537	10.537	10.537	10.537	123.0
2001-10-18	ABCW-DELISTED	Stock	15.67	15.67	15.27	15.32	14500.0
2001-10-18	ABE-DELISTED	Stock	6.58	6.6	6.4	6.42	9400.0
2001-10-18	ABFS-DELISTED	Stock	22.0	23.4	21.14	22.49	253700.0
2001-10-18	ABK-DELISTED	Stock	51.1	51.65	49.29	49.98	685400.0
2001-10-18	ABM	Stock	13.155	13.155	12.95	13.025	124400.0
2001-10-18	ABMD-DELISTED	Stock	18.84	20.4	18.25	19.75	117000.0
2001-10-18	ABP-DELISTED	Stock	1.7	1.75	1.63	1.65	60500.0
2001-10-18	ABT	Stock	23.7917	23.9623	23.3428	23.5942	4933829.0
2001-10-18	ABTL-DELISTED	Stock	5.9	5.95	5.0	5.0	25800.0
2001-10-18	ABV-DELISTED	Stock	15.9	15.9	15.6	15.68	134300.0
2001-10-18	ABX-DELISTED	Stock	16.56	16.69	16.16	16.24	1337115.0
2001-10-18	ACAP-DELISTED	Stock	22.2	22.47	22.1	22.47	5500.0
2001-10-18	ACAS-DELISTED	Stock	26.99	27.24	26.24	26.99	341310.0
2001-10-18	ACAT-DELISTED	Stock	13.95	14.0	13.45	13.45	32200.0
2001-10-18	ACCL-DELISTED	Stock	10.1400003433228	10.746000289917	10.1379995346069	10.5649995803833	70200.0
2001-10-18	ACE-DELISTED	Stock	38.0	38.5	36.35	36.86	3353800.0
2001-10-18	ACF-DELISTED	Stock	24.01	24.01	22.85	23.45	1005700.0
2001-10-18	ACG-DELISTED	Stock	8.55	8.59	8.52	8.59	176800.0
2001-10-18	ACGL	Stock	1.8611	1.8611	1.8611	1.8611	42300.0
2001-10-18	ACGN-DELISTED	Stock	1110.6712	1314.6712	1031.3288	1314.6712	19700.0
2001-10-18	ACH	Stock	12.3333	12.3333	11.6667	11.9667	241800.0
2001-10-18	ACLS	Stock	42.8	43.2	39.92	40.2	142375.0
2001-10-18	ACO-DELISTED	Stock	5.6	5.72	5.5	5.6	16400.0
2001-10-18	ACPW-DELISTED	Stock	25.2	27.28	23.16	27.0	60942.0
2001-10-18	ACS-DELISTED	Stock	45.69	46.22	44.65	44.865	525800.0
2001-10-18	ACTA-DELISTED	Stock	18.4	19.8	18.0	18.6	153700.0
2001-10-18	ACTT-DELISTED	Stock	9.22	9.22	8.57	8.57	97200.0
2001-10-18	ACTU-DELISTED	Stock	4.53	4.6	4.05	4.22	667500.0
2001-10-18	ACXM-DELISTED	Stock	12.32	12.43	11.25	11.64	1624200.0
2001-10-18	AD	Stock	28.8667	29.2	27.7	27.7	491400.0
2001-10-18	ADAT-DELISTED	Stock	72.9	73.8	70.2	72.9	3760.0
2001-10-18	ADBE	Stock	14.315	15.045	14.185	14.59	4903400.0
2001-10-18	ADC	Stock	18.8	18.8	18.7	18.75	2700.0
2001-10-18	ADEP-DELISTED	Stock	19.6	21.0	18.75	19.15	7700.0

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

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