PREVIEW / stock_daily / 2001-07-19

all stock daily files

  file:    by_date/stock_daily/2001/2001-07-19.parquet
  size:    101 KB
  rows:    2,951
  symbols: 1,834

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-07-19	AAPL	Stock	0.3791	0.3825	0.3527	0.3564	861140000.0
2001-07-19	MSFT	Stock	35.61	36.5	35.61	36.285	76549400.0
2001-07-19	NVDA	Stock	0.3208	0.3347	0.3159	0.3213	840024000.0
2001-07-19	AMZN	Stock	0.8075	0.84	0.807	0.8245	104256000.0
2001-07-19	CL	Stock	27.9	28.03	27.505	27.7	3554000.0
2001-07-19	A	Stock	20.4864	21.8169	20.4864	20.7153	1882267.0
2001-07-19	AABA-DELISTED	Stock	8.78499984741211	8.94499969482422	8.375	8.71500015258789	16326400.0
2001-07-19	AAI-DELISTED	Stock	9.24	9.24	8.9	9.0	1635000.0
2001-07-19	AAIC-DELISTED	Stock	137.0	139.8	137.0	138.0	269500.0
2001-07-19	AAME	Stock	1.55	1.55	1.45	1.55	20900.0
2001-07-19	AAON	Stock	1.6569	1.7119	1.6569	1.6973	902137.0
2001-07-19	AAXN-DELISTED	Stock	0.470833331346512	0.470833331346512	0.466666668653488	0.466666668653488	164400.0
2001-07-19	ABAX-DELISTED	Stock	5.5	5.5	5.29	5.43	16200.0
2001-07-19	ABB-DELISTED	Stock	13.85	14.2	13.85	14.15	25800.0
2001-07-19	ABC-DELISTED	Stock	14.5600004196167	14.6750001907349	14.2224998474121	14.3000001907349	2367600.0
2001-07-19	ABCB	Stock	9.7832	10.1317	9.7832	9.929	6909.0
2001-07-19	ABCW-DELISTED	Stock	15.5	15.7	15.5	15.61	216100.0
2001-07-19	ABE-DELISTED	Stock	7.65	7.7	7.61	7.7	4300.0
2001-07-19	ABFS-DELISTED	Stock	26.02	27.49	25.5	27.25	805500.0
2001-07-19	ABK-DELISTED	Stock	60.45	60.56	57.27	57.93	647800.0
2001-07-19	ABM	Stock	18.845	18.885	18.65	18.74	93200.0
2001-07-19	ABMD-DELISTED	Stock	19.15	20.2	18.55	19.62	72900.0
2001-07-19	ABP-DELISTED	Stock	3.69	3.69	3.35	3.39	38700.0
2001-07-19	ABT	Stock	23.1588	23.298	22.9388	23.1633	7549774.0
2001-07-19	ABTL-DELISTED	Stock	5.5	5.65	5.3	5.45	12300.0
2001-07-19	ABV-DELISTED	Stock	20.55	20.55	20.0	20.32	138300.0
2001-07-19	ABX-DELISTED	Stock	15.53	15.57	15.35	15.51	1400207.0
2001-07-19	ACAP-DELISTED	Stock	19.26	19.39	19.15	19.23	59400.0
2001-07-19	ACAS-DELISTED	Stock	26.49	27.39	26.46	27.38	213264.0
2001-07-19	ACAT-DELISTED	Stock	14.58	14.6	14.5	14.59	13400.0
2001-07-19	ACCL-DELISTED	Stock	12.5699996948242	12.7810001373291	12.1429996490479	12.4399995803833	131500.0
2001-07-19	ACE-DELISTED	Stock	34.5	34.7	33.5	33.85	2912300.0
2001-07-19	ACF-DELISTED	Stock	60.3	60.5	57.5	58.72	1221800.0
2001-07-19	ACG-DELISTED	Stock	8.67	8.72	8.61	8.72	260600.0
2001-07-19	ACGL	Stock	1.9178	1.9778	1.8356	1.9778	96300.0
2001-07-19	ACGN-DELISTED	Stock	1167.3288	1190.0	1156.0	1167.3288	13300.0
2001-07-19	ACH	Stock	12.7733	12.9333	12.2333	12.2333	204900.0
2001-07-19	ACLS	Stock	56.16	58.4	55.4	55.48	173850.0
2001-07-19	ACO-DELISTED	Stock	5.95	6.05	5.7	5.86	61700.0
2001-07-19	ACPW-DELISTED	Stock	65.05	69.0	45.0	46.0	623440.0
2001-07-19	ACS-DELISTED	Stock	38.6	40.425	38.415	40.4	829200.0
2001-07-19	ACTA-DELISTED	Stock	31.6	32.4	29.0	30.6	56300.0
2001-07-19	ACTT-DELISTED	Stock	6.15	6.15	6.05	6.05	5100.0
2001-07-19	ACTU-DELISTED	Stock	8.3	8.76	8.26	8.47	299800.0
2001-07-19	ACXM-DELISTED	Stock	10.09	11.92	10.09	10.87	1317500.0
2001-07-19	ACY-DELISTED	Stock	5.0	5.0	5.0	5.0	1000.0
2001-07-19	AD	Stock	38.3333	38.5667	36.7	38.1	333000.0
2001-07-19	ADAT-DELISTED	Stock	92.7	92.7	89.82	91.62	1062.0
2001-07-19	ADBE	Stock	20.45	21.45	20.41	20.94	7171600.0
2001-07-19	ADC	Stock	19.12	19.31	19.12	19.31	7700.0

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

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