PREVIEW / stock_daily / 2004-08-20

all stock daily files

  file:    by_date/stock_daily/2004/2004-08-20.parquet
  size:    127 KB
  rows:    3,802
  symbols: 2,373

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-08-20	AAPL	Stock	0.5484	0.5534	0.5445	0.55	316780800.0
2004-08-20	MSFT	Stock	27.13	27.37	27.04	27.2	46494800.0
2004-08-20	NVDA	Stock	0.0967	0.1043	0.0963	0.1029	1199040000.0
2004-08-20	AMZN	Stock	1.923	1.9955	1.9055	1.9755	135816000.0
2004-08-20	CL	Stock	25.965	26.38	25.895	26.33	2292400.0
2004-08-20	A	Stock	15.5794	15.9728	15.4578	15.8798	2047930.0
2004-08-20	AABA-DELISTED	Stock	27.8799991607666	28.8299999237061	27.8299999237061	28.6100006103516	17228700.0
2004-08-20	AACC-DELISTED	Stock	17.97	18.1	17.92	18.0	43335.0
2004-08-20	AAI-DELISTED	Stock	10.97	11.49	10.9	11.24	1761900.0
2004-08-20	AAIC-DELISTED	Stock	339.8	358.4	339.4	358.4	2002300.0
2004-08-20	AAME	Stock	3.0	3.01	3.0	3.01	12000.0
2004-08-20	AAON	Stock	2.3098	2.3177	2.2637	2.2637	88847.0
2004-08-20	AAP	Stock	24.0	24.1467	23.9667	24.06	874350.0
2004-08-20	AAV-DELISTED	Stock	14.79	14.79	14.57	14.79	19500.0
2004-08-20	AAXN-DELISTED	Stock	13.6450004577637	13.875	13.5699996948242	13.7200002670288	3593000.0
2004-08-20	ABAX-DELISTED	Stock	14.29	14.5	13.96	14.21	101393.0
2004-08-20	ABB-DELISTED	Stock	5.48	5.53	5.45	5.53	595300.0
2004-08-20	ABC-DELISTED	Stock	13.13	13.23	13.08	13.17	4170800.0
2004-08-20	ABCB	Stock	14.3707	14.3707	14.1277	14.3383	12831.0
2004-08-20	ABCO-DELISTED	Stock	15.203	15.257	14.993	15.257	286115.0
2004-08-20	ABCW-DELISTED	Stock	25.26	25.74	25.03	25.74	33900.0
2004-08-20	ABE-DELISTED	Stock	7.65	7.68	7.6	7.63	2400.0
2004-08-20	ABFS-DELISTED	Stock	36.1	36.87	35.6	36.66	193611.0
2004-08-20	ABG	Stock	13.15	13.45	13.1	13.28	15700.0
2004-08-20	ABK-DELISTED	Stock	72.78	74.52	72.74	74.25	649200.0
2004-08-20	ABM	Stock	17.55	18.05	17.55	18.04	61500.0
2004-08-20	ABMD-DELISTED	Stock	9.62	10.0	9.58	9.67	53041.0
2004-08-20	ABP-DELISTED	Stock	1.87	1.88	1.7	1.72	129500.0
2004-08-20	ABR	Stock	19.99	20.1	19.9	20.1	151600.0
2004-08-20	ABT	Stock	19.5327	19.7486	19.4751	19.6766	7164235.0
2004-08-20	ABTL-DELISTED	Stock	32.0	33.35	31.5	33.3	415900.0
2004-08-20	ABV-DELISTED	Stock	22.3	22.56	22.3	22.36	337000.0
2004-08-20	ABVT-DELISTED	Stock	23.9	23.9	23.9	23.9	10100.0
2004-08-20	ABX-DELISTED	Stock	20.13	20.46	19.9	20.29	2339300.0
2004-08-20	ACAD	Stock	5.5	5.73	5.0	5.7	1005000.0
2004-08-20	ACAP-DELISTED	Stock	27.52	28.0	27.1	27.41	95803.0
2004-08-20	ACAS-DELISTED	Stock	31.36	31.64	30.96	30.99	793327.0
2004-08-20	ACAT-DELISTED	Stock	26.05	26.37	25.93	26.32	45488.0
2004-08-20	ACC-DELISTED	Stock	17.07	17.5	17.07	17.42	131684.0
2004-08-20	ACCL-DELISTED	Stock	6.32	6.7	6.25	6.7	102340.0
2004-08-20	ACE-DELISTED	Stock	39.43	39.66	39.14	39.21	668400.0
2004-08-20	ACF-DELISTED	Stock	20.36	21.1	20.2	20.94	2135200.0
2004-08-20	ACG-DELISTED	Stock	8.35	8.37	8.32	8.36	345900.0
2004-08-20	ACGL	Stock	4.1944	4.1944	4.17	4.1889	397800.0
2004-08-20	ACGN-DELISTED	Stock	623.3288	623.3288	600.6712	623.3288	20100.0
2004-08-20	ACH	Stock	16.5933	16.66	16.3333	16.6067	107550.0
2004-08-20	ACH-DELISTED	Stock	11.936	12.176	11.918	12.176	360878.0
2004-08-20	ACLS	Stock	34.64	35.12	34.2	34.76	131050.0
2004-08-20	ACO-DELISTED	Stock	17.65	17.71	16.9	16.97	260200.0
2004-08-20	ACPW-DELISTED	Stock	14.1	14.55	14.1	14.3	14046.0

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

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