PREVIEW / stock_daily / 2005-11-02

all stock daily files

  file:    by_date/stock_daily/2005/2005-11-02.parquet
  size:    141 KB
  rows:    4,227
  symbols: 2,659

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
2005-11-02	AAPL	Stock	2.0614	2.1429	2.0571	2.1411	857060400.0
2005-11-02	MSFT	Stock	25.93	26.5	25.93	26.46	75067100.0
2005-11-02	NVDA	Stock	0.2762	0.2925	0.275	0.2922	523668000.0
2005-11-02	AMZN	Stock	2.0145	2.0615	1.99	2.0375	97236000.0
2005-11-02	CL	Stock	26.235	26.405	26.015	26.145	4223200.0
2005-11-02	A	Stock	22.9614	23.5122	22.9328	23.3763	2457684.0
2005-11-02	AABA-DELISTED	Stock	37.4900016784668	38.0400009155273	37.4300003051758	37.9900016784668	17886200.0
2005-11-02	AACC-DELISTED	Stock	19.13	19.19	18.43	18.51	1022066.0
2005-11-02	AACQ-DELISTED	Stock	5.16	5.16	5.16	5.16	100.0
2005-11-02	AACQW-DELISTED	Stock	0.42	0.43	0.42	0.42	44000.0
2005-11-02	AAI-DELISTED	Stock	14.85	15.0	14.6	14.97	2342000.0
2005-11-02	AAIC-DELISTED	Stock	175.0	183.0	173.6	181.4	1895800.0
2005-11-02	AAME	Stock	2.7	2.7	2.7	2.7	300.0
2005-11-02	AAON	Stock	2.2426	2.2979	2.2202	2.2795	88087.0
2005-11-02	AAP	Stock	37.5	39.05	37.45	38.7	1934800.0
2005-11-02	AATI-DELISTED	Stock	10.29	10.44	9.7	9.99	117703.0
2005-11-02	AAV-DELISTED	Stock	16.3	16.38	16.05	16.3	28500.0
2005-11-02	AAXN-DELISTED	Stock	6.30999994277954	6.55000019073486	6.21000003814697	6.53000020980835	1993900.0
2005-11-02	ABAX-DELISTED	Stock	17.2	17.53	16.84	17.14	353856.0
2005-11-02	ABB-DELISTED	Stock	7.63	7.77	7.63	7.77	1916100.0
2005-11-02	ABBC-DELISTED	Stock	12.1	12.1	12.01	12.08	900.0
2005-11-02	ABC-DELISTED	Stock	18.94	19.39	18.91	19.07	5448000.0
2005-11-02	ABCB	Stock	18.5678	18.9665	18.4899	18.9568	32180.0
2005-11-02	ABCO-DELISTED	Stock	24.29	24.75	24.29	24.72	140920.0
2005-11-02	ABCW-DELISTED	Stock	31.58	32.0	31.34	32.0	46310.0
2005-11-02	ABD-DELISTED	Stock	23.85	24.12	23.58	23.9	161010.0
2005-11-02	ABE-DELISTED	Stock	11.0	11.24	10.99	11.23	36700.0
2005-11-02	ABFS-DELISTED	Stock	38.88	40.37	38.38	39.83	404380.0
2005-11-02	ABG	Stock	16.9	17.2	16.85	16.95	65800.0
2005-11-02	ABK-DELISTED	Stock	71.77	74.98	71.36	74.44	1370900.0
2005-11-02	ABM	Stock	19.5	20.14	19.5	20.08	212100.0
2005-11-02	ABMD-DELISTED	Stock	8.5	8.56	7.99	8.31	199840.0
2005-11-02	ABP-DELISTED	Stock	6.02	6.68	6.02	6.6	872600.0
2005-11-02	ABR	Stock	26.6	27.34	26.3	27.34	72300.0
2005-11-02	ABT	Stock	20.3579	20.5354	20.2236	20.4587	9639433.0
2005-11-02	ABTL-DELISTED	Stock	22.33	22.48	21.82	22.22	49516.0
2005-11-02	ABV-DELISTED	Stock	36.05	36.05	35.5	35.55	272600.0
2005-11-02	ABVA-DELISTED	Stock	16.85	16.89	16.55	16.78	440.0
2005-11-02	ABVT-DELISTED	Stock	28.0	28.0	28.0	28.0	600.0
2005-11-02	ABX-DELISTED	Stock	25.22	25.48	25.1	25.38	4779512.0
2005-11-02	ACAD	Stock	10.35	10.38	10.06	10.32	83600.0
2005-11-02	ACAP-DELISTED	Stock	44.77	45.44	43.2	45.44	91424.0
2005-11-02	ACAS-DELISTED	Stock	37.7	38.63	37.7	38.33	926107.0
2005-11-02	ACAT-DELISTED	Stock	19.61	19.83	19.36	19.71	69871.0
2005-11-02	ACC-DELISTED	Stock	24.31	25.12	24.18	25.04	84400.0
2005-11-02	ACCL-DELISTED	Stock	6.52	6.92	6.43	6.87	85627.0
2005-11-02	ACCO	Stock	23.85	24.12	23.58	23.9	161000.0
2005-11-02	ACE-DELISTED	Stock	51.89	52.85	51.86	52.81	2169777.0
2005-11-02	ACF-DELISTED	Stock	22.31	22.73	22.25	22.61	1220200.0
2005-11-02	ACFC-DELISTED	Stock	72.96	73.42	72.91	73.42	1338.0

> showing 50 of 4,227 rows — these rows as CSV

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