PREVIEW / stock_daily / 2004-07-27

all stock daily files

  file:    by_date/stock_daily/2004/2004-07-27.parquet
  size:    127 KB
  rows:    3,782
  symbols: 2,364

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
2004-07-27	AAPL	Stock	0.5679	0.5848	0.5638	0.5791	425006400.0
2004-07-27	MSFT	Stock	28.7	28.76	28.13	28.44	72968400.0
2004-07-27	NVDA	Stock	0.119	0.1227	0.1153	0.1223	789888000.0
2004-07-27	AMZN	Stock	1.96	1.9955	1.94	1.9555	210698000.0
2004-07-27	CL	Stock	26.445	26.64	26.215	26.53	3479400.0
2004-07-27	A	Stock	16.4878	16.7668	16.3233	16.6309	4616615.0
2004-07-27	AABA-DELISTED	Stock	28.6000003814697	30.2199993133545	28.4500007629395	30.0	25597200.0
2004-07-27	AACC-DELISTED	Stock	16.73	16.73	16.14	16.39	64083.0
2004-07-27	AAI-DELISTED	Stock	11.73	11.95	11.25	11.3	2307100.0
2004-07-27	AAIC-DELISTED	Stock	330.0	339.0	328.2	335.8	930000.0
2004-07-27	AAME	Stock	2.84	2.98	2.84	2.98	2600.0
2004-07-27	AAON	Stock	2.3177	2.402	2.3177	2.402	81253.0
2004-07-27	AAP	Stock	24.06	24.4667	24.0133	24.3333	691350.0
2004-07-27	AAV-DELISTED	Stock	14.7	14.7	14.47	14.7	17100.0
2004-07-27	AAXN-DELISTED	Stock	13.3850002288818	15.0050001144409	13.0100002288818	14.9949998855591	25391600.0
2004-07-27	ABAX-DELISTED	Stock	14.3	15.24	13.88	15.12	360240.0
2004-07-27	ABB-DELISTED	Stock	4.91	4.97	4.87	4.95	421500.0
2004-07-27	ABC-DELISTED	Stock	13.65	13.65	13.33	13.34	5981200.0
2004-07-27	ABCB	Stock	13.9412	14.5896	13.9412	14.5896	5921.0
2004-07-27	ABCO-DELISTED	Stock	15.187	15.463	15.057	15.463	500337.0
2004-07-27	ABCW-DELISTED	Stock	26.01	26.18	25.7	25.83	94810.0
2004-07-27	ABE-DELISTED	Stock	7.53	7.65	7.52	7.55	15500.0
2004-07-27	ABFS-DELISTED	Stock	33.89	34.53	33.65	34.33	304361.0
2004-07-27	ABG	Stock	12.81	14.15	12.81	14.12	105700.0
2004-07-27	ABK-DELISTED	Stock	70.8	71.3	70.7	70.75	695100.0
2004-07-27	ABM	Stock	17.96	18.27	17.81	18.27	55000.0
2004-07-27	ABMD-DELISTED	Stock	9.1	9.81	9.1	9.73	59977.0
2004-07-27	ABP-DELISTED	Stock	1.25	1.34	1.25	1.28	82800.0
2004-07-27	ABR	Stock	18.52	18.95	18.05	18.93	87600.0
2004-07-27	ABT	Stock	18.5491	18.8322	18.3907	18.8034	6266153.0
2004-07-27	ABTL-DELISTED	Stock	33.15	34.7	32.4	34.3	54000.0
2004-07-27	ABV-DELISTED	Stock	20.3	20.3	19.93	20.21	268000.0
2004-07-27	ABVA-DELISTED	Stock	16.25	16.25	15.05	15.05	6029.0
2004-07-27	ABVT-DELISTED	Stock	26.75	28.97	26.75	27.0	4000.0
2004-07-27	ABX-DELISTED	Stock	19.06	19.0649	18.65	18.97	2066450.0
2004-07-27	ACAD	Stock	6.29	6.3	6.11	6.3	32200.0
2004-07-27	ACAP-DELISTED	Stock	23.68	23.88	23.11	23.49	43500.0
2004-07-27	ACAS-DELISTED	Stock	28.49	28.81	28.2	28.57	437106.0
2004-07-27	ACAT-DELISTED	Stock	26.71	27.1	26.71	27.0	98228.0
2004-07-27	ACCL-DELISTED	Stock	6.63	7.35	6.46	7.24	185061.0
2004-07-27	ACE-DELISTED	Stock	39.7	39.73	39.28	39.52	1047300.0
2004-07-27	ACF-DELISTED	Stock	18.57	19.25	18.5	19.09	1129000.0
2004-07-27	ACG-DELISTED	Stock	8.18	8.19	8.11	8.12	539600.0
2004-07-27	ACGL	Stock	4.0933	4.1678	4.05	4.1111	1084500.0
2004-07-27	ACGN-DELISTED	Stock	555.3288	566.6712	510.0	555.3288	92100.0
2004-07-27	ACH	Stock	16.9667	17.1	16.78	17.0733	237150.0
2004-07-27	ACH-DELISTED	Stock	12.722	13.199	12.72	13.137	399601.0
2004-07-27	ACLS	Stock	35.32	36.28	34.84	35.6	332200.0
2004-07-27	ACO-DELISTED	Stock	18.07	18.54	17.84	18.37	176100.0
2004-07-27	ACPW-DELISTED	Stock	13.75	14.0	12.75	14.0	19310.0

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

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