PREVIEW / stock_daily / 2001-07-23

all stock daily files

  file:    by_date/stock_daily/2001/2001-07-23.parquet
  size:    101 KB
  rows:    2,961
  symbols: 1,843

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-23	AAPL	Stock	0.3588	0.3661	0.3484	0.3489	241360000.0
2001-07-23	MSFT	Stock	34.62	34.62	33.175	33.545	79999400.0
2001-07-23	NVDA	Stock	0.3125	0.3129	0.2821	0.2825	1547976000.0
2001-07-23	AMZN	Stock	0.851	0.8565	0.798	0.8015	173278000.0
2001-07-23	CL	Stock	27.25	27.475	26.6	27.325	5614600.0
2001-07-23	A	Stock	20.7368	20.9943	19.7067	19.8212	2068481.0
2001-07-23	AABA-DELISTED	Stock	9.11499977111816	9.14500045776367	8.71000003814697	8.77999973297119	11828200.0
2001-07-23	AAI-DELISTED	Stock	9.0	9.2	9.0	9.0	283100.0
2001-07-23	AAIC-DELISTED	Stock	137.6	140.0	136.6	140.0	189500.0
2001-07-23	AAON	Stock	1.7529	1.7699	1.7266	1.75	2043478.0
2001-07-23	AAXN-DELISTED	Stock	0.479166656732559	0.487500011920929	0.467500001192093	0.470833331346512	67200.0
2001-07-23	ABAX-DELISTED	Stock	5.34	5.45	5.28	5.4	17400.0
2001-07-23	ABB-DELISTED	Stock	13.79	13.79	13.61	13.61	1700.0
2001-07-23	ABC-DELISTED	Stock	14.4650001525879	14.5	14.0375003814697	14.1499996185303	1413200.0
2001-07-23	ABCB	Stock	10.1236	10.1236	9.8561	9.8561	4688.0
2001-07-23	ABCW-DELISTED	Stock	15.7	15.75	15.6	15.75	30400.0
2001-07-23	ABE-DELISTED	Stock	7.63	7.68	7.6	7.63	12100.0
2001-07-23	ABFS-DELISTED	Stock	27.42	27.65	26.38	27.25	382000.0
2001-07-23	ABK-DELISTED	Stock	57.08	57.6	56.76	56.85	285700.0
2001-07-23	ABM	Stock	19.02	19.02	18.69	18.74	70800.0
2001-07-23	ABMD-DELISTED	Stock	18.4	19.7	18.15	18.7	106100.0
2001-07-23	ABP-DELISTED	Stock	3.38	3.38	3.2	3.3	38000.0
2001-07-23	ABT	Stock	23.3788	23.4551	23.0151	23.078	4636881.0
2001-07-23	ABTL-DELISTED	Stock	5.75	5.75	5.25	5.55	7100.0
2001-07-23	ABV-DELISTED	Stock	20.75	21.12	20.75	20.78	169000.0
2001-07-23	ABX-DELISTED	Stock	15.52	15.52	15.24	15.31	1578100.0
2001-07-23	ACAP-DELISTED	Stock	19.01	19.05	18.8	18.95	38300.0
2001-07-23	ACAS-DELISTED	Stock	27.54	27.55	26.6	26.84	103900.0
2001-07-23	ACAT-DELISTED	Stock	14.68	14.7	14.55	14.6	7800.0
2001-07-23	ACCL-DELISTED	Stock	12.2817001342773	12.7227001190186	12.0920000076294	12.7227001190186	186800.0
2001-07-23	ACE-DELISTED	Stock	33.7	34.05	33.4	33.59	1814700.0
2001-07-23	ACF-DELISTED	Stock	59.1	59.75	58.64	58.84	595000.0
2001-07-23	ACG-DELISTED	Stock	8.75	8.76	8.65	8.67	280100.0
2001-07-23	ACGL	Stock	1.9833	2.0044	1.8944	1.96	80100.0
2001-07-23	ACGN-DELISTED	Stock	1133.3288	1133.3288	997.3288	1031.3288	43000.0
2001-07-23	ACH	Stock	12.8667	12.96	12.3333	12.3867	72150.0
2001-07-23	ACLS	Stock	55.92	58.4	55.92	57.16	118025.0
2001-07-23	ACO-DELISTED	Stock	5.85	5.94	5.85	5.85	20300.0
2001-07-23	ACPW-DELISTED	Stock	41.25	42.65	40.0	42.0	358840.0
2001-07-23	ACS-DELISTED	Stock	40.375	40.45	38.885	39.5	770400.0
2001-07-23	ACTA-DELISTED	Stock	32.4	32.6	28.0	28.6	48400.0
2001-07-23	ACTT-DELISTED	Stock	5.7	5.7	4.25	4.8	133600.0
2001-07-23	ACTU-DELISTED	Stock	8.99	9.06	8.57	9.06	394600.0
2001-07-23	ACXM-DELISTED	Stock	11.05	11.14	10.38	10.47	788800.0
2001-07-23	ACY-DELISTED	Stock	5.0	5.1	4.95	5.1	3100.0
2001-07-23	AD	Stock	37.8	38.06	37.2	37.9133	51000.0
2001-07-23	ADAT-DELISTED	Stock	90.54	91.44	85.68	86.4	1051.0
2001-07-23	ADBE	Stock	20.525	21.05	20.15	20.295	5834800.0
2001-07-23	ADC	Stock	19.55	19.75	19.55	19.75	5400.0
2001-07-23	ADEP-DELISTED	Stock	49.25	50.9	46.25	47.75	8200.0

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

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