PREVIEW / stock_daily / 2001-06-20

all stock daily files

  file:    by_date/stock_daily/2001/2001-06-20.parquet
  size:    101 KB
  rows:    2,949
  symbols: 1,841

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-06-20	AAPL	Stock	0.3571	0.3902	0.3568	0.387	431620000.0
2001-06-20	MSFT	Stock	33.57	34.795	33.55	34.705	64108400.0
2001-06-20	NVDA	Stock	0.353	0.3792	0.3456	0.375	1759200000.0
2001-06-20	AMZN	Stock	0.5635	0.635	0.56	0.6265	213046000.0
2001-06-20	CL	Stock	28.975	29.89	28.975	29.6	2976000.0
2001-06-20	A	Stock	20.9728	21.03	19.4921	20.329	4626122.0
2001-06-20	AABA-DELISTED	Stock	7.65500020980835	9.25500011444092	7.65000009536743	9.24499988555908	21971600.0
2001-06-20	AAI-DELISTED	Stock	11.03	11.2	10.75	11.02	507300.0
2001-06-20	AAIC-DELISTED	Stock	114.2	119.0	114.2	119.0	48800.0
2001-06-20	AAME	Stock	1.85	1.85	1.85	1.85	2100.0
2001-06-20	AAON	Stock	1.3315	1.4164	1.3315	1.4041	100807.0
2001-06-20	AAXN-DELISTED	Stock	0.458333343267441	0.458333343267441	0.445833325386047	0.445833325386047	56400.0
2001-06-20	ABAX-DELISTED	Stock	5.69	5.7	5.64	5.65	15600.0
2001-06-20	ABB-DELISTED	Stock	15.52	15.8	15.47	15.6	37000.0
2001-06-20	ABC-DELISTED	Stock	14.6575002670288	15.2250003814697	14.6549997329712	15.1774997711182	2720800.0
2001-06-20	ABCB	Stock	9.1185	9.1185	9.1185	9.1185	494.0
2001-06-20	ABCW-DELISTED	Stock	14.09	14.5	14.09	14.5	107200.0
2001-06-20	ABE-DELISTED	Stock	8.0	8.05	8.0	8.02	28000.0
2001-06-20	ABFS-DELISTED	Stock	20.0	20.25	19.75	20.25	51500.0
2001-06-20	ABK-DELISTED	Stock	56.55	56.8	56.02	56.22	333900.0
2001-06-20	ABM	Stock	17.9	18.475	17.9	18.31	100800.0
2001-06-20	ABMD-DELISTED	Stock	23.29	24.25	23.01	23.86	124800.0
2001-06-20	ABP-DELISTED	Stock	3.6	3.6	3.29	3.4	138000.0
2001-06-20	ABT	Stock	23.4102	23.6481	23.2531	23.4551	11741790.0
2001-06-20	ABTL-DELISTED	Stock	7.25	7.25	6.85	7.0	4300.0
2001-06-20	ABV-DELISTED	Stock	19.4	20.2	19.39	20.15	433600.0
2001-06-20	ABX-DELISTED	Stock	16.59	16.59	16.13	16.18	1744600.0
2001-06-20	ACAP-DELISTED	Stock	19.6	20.1	19.45	20.08	71200.0
2001-06-20	ACAS-DELISTED	Stock	25.55	26.1	25.47	25.84	231100.0
2001-06-20	ACAT-DELISTED	Stock	14.75	14.85	14.73	14.81	32900.0
2001-06-20	ACCL-DELISTED	Stock	15.9305000305176	16.6546001434326	15.858099937439	16.6546001434326	233800.0
2001-06-20	ACE-DELISTED	Stock	36.45	37.3	36.45	36.85	2180400.0
2001-06-20	ACF-DELISTED	Stock	49.53	50.25	49.26	49.95	1488700.0
2001-06-20	ACG-DELISTED	Stock	8.67	8.71	8.62	8.7	290000.0
2001-06-20	ACGL	Stock	1.7611	1.7744	1.7222	1.7333	97200.0
2001-06-20	ACGN-DELISTED	Stock	1190.0	1246.6712	1133.3288	1156.0	42200.0
2001-06-20	ACH	Stock	13.1333	13.3333	12.6267	13.0	396000.0
2001-06-20	ACLS	Stock	55.4	58.12	54.56	57.76	371275.0
2001-06-20	ACO-DELISTED	Stock	6.05	6.1	6.05	6.1	70400.0
2001-06-20	ACPW-DELISTED	Stock	90.5	90.5	73.4	77.5	491200.0
2001-06-20	ACS-DELISTED	Stock	37.45	37.71	37.175	37.65	534900.0
2001-06-20	ACTA-DELISTED	Stock	30.6	32.8	29.0	32.6	79600.0
2001-06-20	ACTT-DELISTED	Stock	6.47	6.47	6.43	6.43	2300.0
2001-06-20	ACTU-DELISTED	Stock	7.92	7.94	7.2	7.83	404400.0
2001-06-20	ACXM-DELISTED	Stock	15.18	15.93	14.95	15.56	586700.0
2001-06-20	AD	Stock	37.32	38.8333	37.1333	38.8333	71550.0
2001-06-20	ADAT-DELISTED	Stock	73.8	77.4	73.8	75.96	2998.0
2001-06-20	ADBE	Stock	21.0	22.84	20.975	22.65	10851000.0
2001-06-20	ADC	Stock	19.73	19.85	19.4	19.4	8500.0
2001-06-20	ADEP-DELISTED	Stock	38.75	40.2	38.25	38.35	51700.0

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

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