PREVIEW / stock_daily / 2003-08-21

all stock daily files

  file:    by_date/stock_daily/2003/2003-08-21.parquet
  size:    117 KB
  rows:    3,426
  symbols: 2,109

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
2003-08-21	AAPL	Stock	0.3755	0.3877	0.3741	0.3871	255326400.0
2003-08-21	MSFT	Stock	26.65	26.73	26.13	26.24	63802700.0
2003-08-21	NVDA	Stock	0.1507	0.1525	0.1483	0.1511	644748000.0
2003-08-21	AMZN	Stock	2.211	2.2955	2.1935	2.285	231850000.0
2003-08-21	CL	Stock	27.24	27.395	27.075	27.175	2953400.0
2003-08-21	A	Stock	17.475	18.083	17.4678	17.804	2594408.0
2003-08-21	AABA-DELISTED	Stock	16.1499996185303	16.4950008392334	15.9899997711182	16.4099998474121	25279000.0
2003-08-21	AAI-DELISTED	Stock	13.73	13.92	13.7	13.84	947500.0
2003-08-21	AAIC-DELISTED	Stock	332.0	335.0	328.8	334.0	467800.0
2003-08-21	AAME	Stock	2.51	2.75	2.45	2.75	33600.0
2003-08-21	AAON	Stock	2.4349	2.4691	2.4296	2.4507	52397.0
2003-08-21	AAP	Stock	24.0833	24.78	24.0667	24.6833	1967700.0
2003-08-21	AAXN-DELISTED	Stock	2.01666665077209	2.02083325386047	1.91666662693024	2.0	1878000.0
2003-08-21	ABAX-DELISTED	Stock	8.81	9.35	8.8	9.25	71538.0
2003-08-21	ABB-DELISTED	Stock	5.46	5.5	5.24	5.33	481700.0
2003-08-21	ABC-DELISTED	Stock	15.04	15.09	14.9	15.03	6131200.0
2003-08-21	ABCB	Stock	13.3739	13.8602	13.2927	13.8602	8760.0
2003-08-21	ABCO-DELISTED	Stock	21.66	21.84	21.23	21.6	43944.0
2003-08-21	ABCW-DELISTED	Stock	25.28	25.28	25.15	25.28	19590.0
2003-08-21	ABE-DELISTED	Stock	6.33	6.39	6.31	6.39	14100.0
2003-08-21	ABFS-DELISTED	Stock	27.9	28.23	27.8	27.95	87121.0
2003-08-21	ABG	Stock	17.15	17.47	17.14	17.3	31600.0
2003-08-21	ABK-DELISTED	Stock	66.41	66.84	65.5	65.57	384000.0
2003-08-21	ABM	Stock	16.2	16.57	16.16	16.4	155200.0
2003-08-21	ABMD-DELISTED	Stock	5.25	5.31	5.15	5.31	13612.0
2003-08-21	ABP-DELISTED	Stock	1.0	1.02	0.98	1.02	75100.0
2003-08-21	ABT	Stock	17.5251	17.579	17.2153	17.3276	10437939.0
2003-08-21	ABTL-DELISTED	Stock	38.5	38.5	35.75	36.05	50900.0
2003-08-21	ABV-DELISTED	Stock	19.7	20.41	19.68	20.35	1312800.0
2003-08-21	ABVA-DELISTED	Stock	19.55	19.676	19.55	19.676	700.0
2003-08-21	ABX-DELISTED	Stock	19.78	19.79	19.32	19.35	3217400.0
2003-08-21	ACAP-DELISTED	Stock	28.29	28.3	28.18	28.25	27100.0
2003-08-21	ACAS-DELISTED	Stock	24.61	24.66	24.16	24.16	568014.0
2003-08-21	ACAT-DELISTED	Stock	22.13	22.13	21.71	22.0	15522.0
2003-08-21	ACCL-DELISTED	Stock	7.91454982757568	9.16003036499023	7.91454982757568	9.16003036499023	287300.0
2003-08-21	ACE-DELISTED	Stock	34.13	34.39	33.42	33.61	1607200.0
2003-08-21	ACF-DELISTED	Stock	8.25	9.03	8.21	8.96	3410800.0
2003-08-21	ACG-DELISTED	Stock	8.17	8.18	8.11	8.11	474200.0
2003-08-21	ACGL	Stock	3.8889	3.89	3.8278	3.8722	914400.0
2003-08-21	ACGN-DELISTED	Stock	1020.0	1042.6712	1008.6712	1008.6712	14700.0
2003-08-21	ACH	Stock	15.8267	15.8267	15.66	15.7067	218250.0
2003-08-21	ACH-DELISTED	Stock	7.545	7.565	7.488	7.5	64400.0
2003-08-21	ACLS	Stock	34.08	35.6	34.08	35.32	249025.0
2003-08-21	ACO-DELISTED	Stock	11.25	11.35	11.05	11.18	119800.0
2003-08-21	ACPW-DELISTED	Stock	9.6	11.05	9.49	11.0	64474.0
2003-08-21	ACS-DELISTED	Stock	47.2	48.28	46.95	48.22	1766700.0
2003-08-21	ACTA-DELISTED	Stock	8.6	9.2	8.4	8.4	385400.0
2003-08-21	ACTG	Stock	1.72	1.86	1.72	1.79	127000.0
2003-08-21	ACTI-DELISTED	Stock	8.71	8.96	8.71	8.96	306253.0
2003-08-21	ACTT-DELISTED	Stock	2.3	2.3	2.16	2.27	89300.0

> showing 50 of 3,426 rows — these rows as CSV

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