PREVIEW / stock_daily / 2001-07-18

all stock daily files

  file:    by_date/stock_daily/2001/2001-07-18.parquet
  size:    101 KB
  rows:    2,955
  symbols: 1,837

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-18	AAPL	Stock	0.3889	0.4068	0.3646	0.3713	1137012800.0
2001-07-18	MSFT	Stock	35.3	35.75	34.935	35.285	57590800.0
2001-07-18	NVDA	Stock	0.3198	0.3286	0.3095	0.3162	840984000.0
2001-07-18	AMZN	Stock	0.8035	0.8325	0.794	0.798	73462000.0
2001-07-18	CL	Stock	27.9	28.14	27.5	27.64	4192800.0
2001-07-18	A	Stock	20.1001	20.9156	20.1001	20.3791	1461190.0
2001-07-18	AABA-DELISTED	Stock	8.97500038146973	9.125	8.39999961853027	8.51500034332275	20664000.0
2001-07-18	AAI-DELISTED	Stock	9.25	9.45	9.16	9.24	672400.0
2001-07-18	AAIC-DELISTED	Stock	137.8	138.0	136.0	137.0	15600.0
2001-07-18	AAME	Stock	1.56	1.56	1.55	1.55	700.0
2001-07-18	AAON	Stock	1.6417	1.6622	1.6394	1.6534	247746.0
2001-07-18	AAXN-DELISTED	Stock	0.483333319425583	0.483333319425583	0.479166656732559	0.479166656732559	96000.0
2001-07-18	ABAX-DELISTED	Stock	5.3	5.5	5.3	5.5	8400.0
2001-07-18	ABB-DELISTED	Stock	13.6	13.85	13.45	13.8	63200.0
2001-07-18	ABC-DELISTED	Stock	14.3374996185303	14.5950002670288	14.25	14.5375003814697	2328800.0
2001-07-18	ABCB	Stock	9.7265	9.7832	9.7265	9.7832	1851.0
2001-07-18	ABCW-DELISTED	Stock	15.64	15.65	15.3	15.56	63900.0
2001-07-18	ABE-DELISTED	Stock	7.78	7.78	7.67	7.68	5700.0
2001-07-18	ABFS-DELISTED	Stock	26.0	27.08	25.8	26.85	520500.0
2001-07-18	ABK-DELISTED	Stock	58.73	60.5	58.73	60.35	1188200.0
2001-07-18	ABM	Stock	18.9	19.025	18.775	18.775	86000.0
2001-07-18	ABMD-DELISTED	Stock	19.67	20.69	19.01	19.17	94300.0
2001-07-18	ABP-DELISTED	Stock	3.69	3.7	3.58	3.6	108800.0
2001-07-18	ABT	Stock	22.4899	23.1633	22.445	23.1408	8562692.0
2001-07-18	ABTL-DELISTED	Stock	6.2	6.2	5.25	5.6	41200.0
2001-07-18	ABV-DELISTED	Stock	20.5	20.85	20.1	20.3	393400.0
2001-07-18	ABX-DELISTED	Stock	15.25	15.63	15.2	15.51	1975700.0
2001-07-18	ACAP-DELISTED	Stock	19.5	19.5	19.2	19.26	71200.0
2001-07-18	ACAS-DELISTED	Stock	27.01	27.2	26.3	26.39	385400.0
2001-07-18	ACAT-DELISTED	Stock	14.77	14.77	14.55	14.58	16800.0
2001-07-18	ACCL-DELISTED	Stock	12.4184999465942	12.6212997436523	12.4184999465942	12.6212997436523	196400.0
2001-07-18	ACE-DELISTED	Stock	35.85	35.95	34.74	34.85	1028100.0
2001-07-18	ACF-DELISTED	Stock	60.4	60.5	59.29	60.26	457600.0
2001-07-18	ACG-DELISTED	Stock	8.41	8.62	8.4	8.6	327700.0
2001-07-18	ACGL	Stock	1.8889	1.9178	1.8722	1.8889	34200.0
2001-07-18	ACGN-DELISTED	Stock	1156.0	1235.3288	1156.0	1190.0	28800.0
2001-07-18	ACH	Stock	12.6667	12.7467	12.2667	12.7467	188550.0
2001-07-18	ACLS	Stock	51.92	56.2	51.52	55.76	257125.0
2001-07-18	ACO-DELISTED	Stock	6.0	6.1	5.9	6.0	48700.0
2001-07-18	ACPW-DELISTED	Stock	71.3	71.35	60.2	61.95	174440.0
2001-07-18	ACS-DELISTED	Stock	37.9	38.1	37.755	38.05	579200.0
2001-07-18	ACTA-DELISTED	Stock	32.2	32.8	30.6	31.2	51900.0
2001-07-18	ACTT-DELISTED	Stock	6.2	6.2	6.14	6.14	2300.0
2001-07-18	ACTU-DELISTED	Stock	8.65	8.86	8.09	8.15	704000.0
2001-07-18	ACXM-DELISTED	Stock	10.45	10.45	9.99	10.12	599100.0
2001-07-18	ACY-DELISTED	Stock	4.96	4.96	4.96	4.96	900.0
2001-07-18	AD	Stock	38.6667	38.9	38.2667	38.4667	155400.0
2001-07-18	ADAT-DELISTED	Stock	93.42	93.6	90.0	93.6	1728.0
2001-07-18	ADBE	Stock	20.365	20.585	19.95	20.025	6385600.0
2001-07-18	ADC	Stock	18.72	19.1	18.72	19.1	32300.0

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

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