PREVIEW / stock_daily / 2001-07-17

all stock daily files

  file:    by_date/stock_daily/2001/2001-07-17.parquet
  size:    101 KB
  rows:    2,939
  symbols: 1,827

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-17	AAPL	Stock	0.4282	0.4504	0.4109	0.4482	647830400.0
2001-07-17	MSFT	Stock	35.33	36.005	35.07	35.91	63241000.0
2001-07-17	NVDA	Stock	0.305	0.3306	0.3021	0.3275	1169904000.0
2001-07-17	AMZN	Stock	0.792	0.8245	0.7915	0.8175	74124000.0
2001-07-17	CL	Stock	28.175	28.275	27.945	28.15	3210600.0
2001-07-17	A	Stock	20.2074	21.4163	20.0358	21.1016	2932165.0
2001-07-17	AABA-DELISTED	Stock	8.92000007629395	9.35000038146973	8.77000045776367	9.23999977111816	15734200.0
2001-07-17	AAI-DELISTED	Stock	9.4	9.75	9.25	9.48	484500.0
2001-07-17	AAIC-DELISTED	Stock	134.0	137.8	131.2	137.8	12300.0
2001-07-17	AAON	Stock	1.6446	1.6534	1.6388	1.6505	1614621.0
2001-07-17	AAXN-DELISTED	Stock	0.483333319425583	0.483333319425583	0.483333319425583	0.483333319425583	3600.0
2001-07-17	ABAX-DELISTED	Stock	5.35	5.41	5.35	5.41	2100.0
2001-07-17	ABB-DELISTED	Stock	13.5	13.75	13.5	13.75	77700.0
2001-07-17	ABC-DELISTED	Stock	14.0124998092651	14.4724998474121	14.0	14.3824996948242	2363600.0
2001-07-17	ABCB	Stock	9.8075	9.8075	9.7832	9.7832	6169.0
2001-07-17	ABCW-DELISTED	Stock	15.44	15.63	15.35	15.63	154700.0
2001-07-17	ABE-DELISTED	Stock	7.8	7.8	7.71	7.8	6800.0
2001-07-17	ABFS-DELISTED	Stock	24.4	26.6	24.4	26.5	815800.0
2001-07-17	ABK-DELISTED	Stock	58.6	58.85	57.99	58.73	331700.0
2001-07-17	ABM	Stock	18.45	19.0	18.45	19.0	83800.0
2001-07-17	ABMD-DELISTED	Stock	19.16	20.25	19.12	19.85	196400.0
2001-07-17	ABP-DELISTED	Stock	3.65	3.7	3.65	3.66	130200.0
2001-07-17	ABT	Stock	22.445	22.6785	22.1443	22.5124	8055899.0
2001-07-17	ABTL-DELISTED	Stock	7.25	7.25	6.05	6.2	51100.0
2001-07-17	ABV-DELISTED	Stock	19.73	20.45	19.67	20.45	443200.0
2001-07-17	ABX-DELISTED	Stock	14.95	15.25	14.91	15.18	921100.0
2001-07-17	ACAP-DELISTED	Stock	19.58	19.58	19.4	19.42	90800.0
2001-07-17	ACAS-DELISTED	Stock	27.0	27.15	26.7	27.15	183300.0
2001-07-17	ACAT-DELISTED	Stock	14.5	14.73	14.5	14.72	32358.0
2001-07-17	ACCL-DELISTED	Stock	12.4909000396729	12.7444000244141	12.4909000396729	12.7444000244141	269300.0
2001-07-17	ACE-DELISTED	Stock	35.99	36.0	34.45	35.64	748400.0
2001-07-17	ACF-DELISTED	Stock	59.0	60.25	58.8	60.21	815500.0
2001-07-17	ACG-DELISTED	Stock	8.37	8.42	8.34	8.38	223500.0
2001-07-17	ACGL	Stock	1.92	1.92	1.9011	1.9011	51300.0
2001-07-17	ACGN-DELISTED	Stock	1235.3288	1235.3288	1224.0	1224.0	15500.0
2001-07-17	ACH	Stock	12.5	12.7267	12.5	12.6667	54900.0
2001-07-17	ACLS	Stock	50.76	53.36	49.6	53.24	176850.0
2001-07-17	ACO-DELISTED	Stock	5.98	6.03	5.95	6.0	36000.0
2001-07-17	ACPW-DELISTED	Stock	70.2	74.25	69.35	70.75	90200.0
2001-07-17	ACS-DELISTED	Stock	37.95	38.3	37.95	38.025	412600.0
2001-07-17	ACTA-DELISTED	Stock	33.2	33.6	32.0	33.4	46800.0
2001-07-17	ACTT-DELISTED	Stock	6.33	6.33	6.1	6.2	14200.0
2001-07-17	ACTU-DELISTED	Stock	7.98	8.77	7.98	8.77	1471300.0
2001-07-17	ACXM-DELISTED	Stock	10.3	10.45	10.24	10.33	660900.0
2001-07-17	ACY-DELISTED	Stock	4.98	4.98	4.96	4.96	1100.0
2001-07-17	AD	Stock	39.6667	39.8333	38.6667	39.66	295050.0
2001-07-17	ADAT-DELISTED	Stock	91.8	95.4	89.1	94.14	2554.0
2001-07-17	ADBE	Stock	19.53	21.0	19.495	20.585	9421600.0
2001-07-17	ADC	Stock	18.65	19.02	18.65	18.65	16400.0
2001-07-17	ADEP-DELISTED	Stock	47.55	50.7	46.5	50.7	16500.0

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

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