PREVIEW / stock_daily / 2003-07-31

all stock daily files

  file:    by_date/stock_daily/2003/2003-07-31.parquet
  size:    117 KB
  rows:    3,433
  symbols: 2,116

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-31	AAPL	Stock	0.3704	0.3813	0.3673	0.3764	301464800.0
2003-07-31	MSFT	Stock	26.6	26.99	26.31	26.41	64504800.0
2003-07-31	NVDA	Stock	0.1608	0.1632	0.1574	0.1591	897600000.0
2003-07-31	AMZN	Stock	2.0675	2.0985	2.0335	2.082	179414000.0
2003-07-31	CL	Stock	27.7	27.84	27.3	27.3	3489000.0
2003-07-31	A	Stock	15.5222	15.8155	15.3791	15.5436	2180321.0
2003-07-31	AABA-DELISTED	Stock	15.5950002670288	15.9399995803833	15.4250001907349	15.5649995803833	17567000.0
2003-07-31	AAI-DELISTED	Stock	13.24	13.25	12.85	13.03	1074100.0
2003-07-31	AAIC-DELISTED	Stock	321.0	339.0	320.2	331.6	1333700.0
2003-07-31	AAME	Stock	2.2	2.35	2.2	2.35	1800.0
2003-07-31	AAON	Stock	2.2966	2.3875	2.2966	2.3572	150356.0
2003-07-31	AAP	Stock	22.5767	22.8167	22.5167	22.6433	1267500.0
2003-07-31	AAXN-DELISTED	Stock	1.65416669845581	1.72500002384186	1.61333334445953	1.69166672229767	4454400.0
2003-07-31	ABAX-DELISTED	Stock	7.8	7.85	7.09	7.3	68514.0
2003-07-31	ABB-DELISTED	Stock	4.24	4.37	4.21	4.24	1214600.0
2003-07-31	ABC-DELISTED	Stock	16.04	16.06	15.4	15.8	16458000.0
2003-07-31	ABCB	Stock	12.5389	12.8308	12.5389	12.8227	17765.0
2003-07-31	ABCO-DELISTED	Stock	20.46	20.85	20.46	20.7	107436.0
2003-07-31	ABCW-DELISTED	Stock	24.5	24.59	24.15	24.15	25370.0
2003-07-31	ABE-DELISTED	Stock	6.23	6.24	6.12	6.21	19400.0
2003-07-31	ABFS-DELISTED	Stock	27.569	27.99	27.32	27.929	240744.0
2003-07-31	ABG	Stock	14.35	15.42	14.35	15.29	177700.0
2003-07-31	ABK-DELISTED	Stock	65.79	66.92	65.63	65.9	714500.0
2003-07-31	ABM	Stock	16.15	16.72	16.12	16.22	84400.0
2003-07-31	ABMD-DELISTED	Stock	5.79	5.79	5.44	5.62	11300.0
2003-07-31	ABP-DELISTED	Stock	0.97	0.98	0.9	0.9	21200.0
2003-07-31	ABT	Stock	17.8887	18.0009	17.4533	17.6194	9133865.0
2003-07-31	ABTL-DELISTED	Stock	32.0	33.15	31.85	32.9	66100.0
2003-07-31	ABV-DELISTED	Stock	19.98	20.04	19.75	19.85	617000.0
2003-07-31	ABVA-DELISTED	Stock	19.101	19.69	19.101	19.69	200.0
2003-07-31	ABX-DELISTED	Stock	17.07	17.29	16.88	17.13	2972400.0
2003-07-31	ACAP-DELISTED	Stock	25.32	25.5	25.26	25.5	19000.0
2003-07-31	ACAS-DELISTED	Stock	28.32	28.35	27.81	28.15	395134.0
2003-07-31	ACAT-DELISTED	Stock	21.17	21.5	20.92	21.42	43600.0
2003-07-31	ACCL-DELISTED	Stock	7.96000003814697	8.26900005340576	7.76200008392334	8.25500011444092	107500.0
2003-07-31	ACE-DELISTED	Stock	33.58	33.62	32.6	32.95	2299100.0
2003-07-31	ACF-DELISTED	Stock	7.55	7.85	7.38	7.43	3458500.0
2003-07-31	ACG-DELISTED	Stock	8.23	8.25	7.85	8.0	2954000.0
2003-07-31	ACGL	Stock	3.7667	3.8311	3.7544	3.8111	853200.0
2003-07-31	ACH	Stock	17.0	17.0	16.6	16.6667	379650.0
2003-07-31	ACH-DELISTED	Stock	7.313	7.373	7.238	7.238	11200.0
2003-07-31	ACLS	Stock	32.0	32.0	29.36	29.44	377975.0
2003-07-31	ACO-DELISTED	Stock	9.3	9.59	9.3	9.49	172400.0
2003-07-31	ACPW-DELISTED	Stock	8.7	8.9	8.45	8.45	11620.0
2003-07-31	ACS-DELISTED	Stock	48.8	49.94	48.64	49.55	1641400.0
2003-07-31	ACTA-DELISTED	Stock	11.6	12.0	11.4	12.0	204700.0
2003-07-31	ACTG	Stock	1.77	2.23	1.77	2.08	250700.0
2003-07-31	ACTI-DELISTED	Stock	8.54	8.55	8.2	8.23	313097.0
2003-07-31	ACTT-DELISTED	Stock	2.61	2.61	2.38	2.45	77700.0
2003-07-31	ACTU-DELISTED	Stock	2.87	2.89	2.78	2.8	217486.0

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

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