PREVIEW / stock_daily / 2003-07-28

all stock daily files

  file:    by_date/stock_daily/2003/2003-07-28.parquet
  size:    116 KB
  rows:    3,410
  symbols: 2,097

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-07-28	AAPL	Stock	0.3839	0.3839	0.3725	0.3748	170357600.0
2003-07-28	MSFT	Stock	26.94	27.0	26.49	26.61	52658300.0
2003-07-28	NVDA	Stock	0.1769	0.1773	0.1693	0.1701	703752000.0
2003-07-28	AMZN	Stock	2.0745	2.109	2.0435	2.104	149064000.0
2003-07-28	CL	Stock	27.825	27.885	27.675	27.775	2903600.0
2003-07-28	A	Stock	15.4864	15.8441	15.3934	15.7153	1997742.0
2003-07-28	AABA-DELISTED	Stock	16.4599990844727	16.4899997711182	16.0750007629395	16.2800006866455	13811800.0
2003-07-28	AAI-DELISTED	Stock	11.61	11.9	11.52	11.75	428000.0
2003-07-28	AAIC-DELISTED	Stock	306.8	309.8	303.0	303.6	427200.0
2003-07-28	AAME	Stock	2.35	2.35	2.2	2.2	6900.0
2003-07-28	AAON	Stock	2.2835	2.4626	2.2716	2.3704	331087.0
2003-07-28	AAP	Stock	22.6333	23.0	22.5733	22.6167	956400.0
2003-07-28	AAXN-DELISTED	Stock	1.41666662693024	1.53333330154419	1.39999997615814	1.53250002861023	3128400.0
2003-07-28	ABAX-DELISTED	Stock	7.07	7.84	7.07	7.44	99800.0
2003-07-28	ABB-DELISTED	Stock	3.3	3.5	3.25	3.48	129400.0
2003-07-28	ABC-DELISTED	Stock	16.1	16.24	15.94	16.2	5035600.0
2003-07-28	ABCB	Stock	12.6444	12.6849	12.4417	12.6201	15669.0
2003-07-28	ABCO-DELISTED	Stock	20.99	21.15	20.56	20.98	173882.0
2003-07-28	ABCW-DELISTED	Stock	24.85	24.85	24.55	24.55	29500.0
2003-07-28	ABE-DELISTED	Stock	6.19	6.38	6.19	6.27	21900.0
2003-07-28	ABFS-DELISTED	Stock	27.05	27.56	26.74	27.25	308793.0
2003-07-28	ABG	Stock	14.9	15.3	14.9	15.08	44100.0
2003-07-28	ABK-DELISTED	Stock	64.02	64.7	63.75	64.3	920900.0
2003-07-28	ABM	Stock	15.74	16.2	15.74	16.03	87600.0
2003-07-28	ABMD-DELISTED	Stock	5.74	5.74	5.211	5.26	58920.0
2003-07-28	ABP-DELISTED	Stock	0.81	0.87	0.8	0.84	81600.0
2003-07-28	ABT	Stock	18.0593	18.0593	17.5745	17.6642	12802381.0
2003-07-28	ABTL-DELISTED	Stock	31.05	32.0	31.0	32.0	52000.0
2003-07-28	ABV-DELISTED	Stock	20.5	20.57	20.35	20.47	229000.0
2003-07-28	ABVA-DELISTED	Stock	18.75	18.94	18.75	18.75	600.0
2003-07-28	ABX-DELISTED	Stock	18.73	18.73	18.16	18.36	2091500.0
2003-07-28	ACAP-DELISTED	Stock	25.71	25.72	24.96	24.97	8800.0
2003-07-28	ACAS-DELISTED	Stock	27.73	28.3	27.57	28.12	353517.0
2003-07-28	ACAT-DELISTED	Stock	19.59	20.02	19.59	19.62	14011.0
2003-07-28	ACCL-DELISTED	Stock	7.63215017318726	7.94352006912231	7.63215017318726	7.94352006912231	124400.0
2003-07-28	ACE-DELISTED	Stock	32.15	32.9	32.1	32.57	1545900.0
2003-07-28	ACF-DELISTED	Stock	8.36	8.37	8.13	8.15	1521600.0
2003-07-28	ACG-DELISTED	Stock	8.55	8.58	8.5	8.52	748700.0
2003-07-28	ACGL	Stock	3.7833	3.8333	3.7778	3.8078	1209600.0
2003-07-28	ACGN-DELISTED	Stock	1054.0	1110.6712	1020.0	1110.6712	17600.0
2003-07-28	ACH	Stock	16.64	17.06	16.5133	17.02	502950.0
2003-07-28	ACH-DELISTED	Stock	7.231	7.531	7.231	7.531	39173.0
2003-07-28	ACLS	Stock	35.6	36.72	35.28	36.4	255675.0
2003-07-28	ACO-DELISTED	Stock	9.05	9.1	8.87	9.01	114800.0
2003-07-28	ACPW-DELISTED	Stock	8.4	8.9	8.4	8.5	14629.0
2003-07-28	ACS-DELISTED	Stock	43.73	45.95	43.73	45.66	2640700.0
2003-07-28	ACTA-DELISTED	Stock	11.6	12.4	11.2	12.2	508100.0
2003-07-28	ACTG	Stock	1.72	2.12	1.72	2.12	359500.0
2003-07-28	ACTI-DELISTED	Stock	9.25	9.39	9.25	9.3	81300.0
2003-07-28	ACTT-DELISTED	Stock	2.34	2.5	2.29	2.35	73450.0

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

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