PREVIEW / stock_daily / 2002-07-19

all stock daily files

  file:    by_date/stock_daily/2002/2002-07-19.parquet
  size:    107 KB
  rows:    3,149
  symbols: 1,956

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
2002-07-19	AAPL	Stock	0.2625	0.2709	0.2595	0.2671	385207200.0
2002-07-19	MSFT	Stock	24.935	25.445	24.405	24.78	112543400.0
2002-07-19	NVDA	Stock	0.1534	0.1595	0.15	0.1511	845772000.0
2002-07-19	AMZN	Stock	0.768	0.7855	0.7535	0.7645	122116000.0
2002-07-19	CL	Stock	22.5	22.825	22.025	22.18	6525400.0
2002-07-19	A	Stock	15.3648	15.5293	14.578	14.8426	4639403.0
2002-07-19	AABA-DELISTED	Stock	6.67000007629395	6.73999977111816	6.48999977111816	6.68499994277954	19755600.0
2002-07-19	AAI-DELISTED	Stock	3.75	3.79	3.55	3.6	232200.0
2002-07-19	AAIC-DELISTED	Stock	192.0	192.0	182.0	185.0	179600.0
2002-07-19	AAME	Stock	2.1	2.34	1.96	2.15	10800.0
2002-07-19	AAON	Stock	2.0872	2.1109	2.0016	2.0517	310584.0
2002-07-19	AAP	Stock	15.8833	15.9167	15.1467	15.27	1290000.0
2002-07-19	AAXN-DELISTED	Stock	0.683333337306976	0.708333313465118	0.658333361148834	0.691666662693024	493200.0
2002-07-19	ABAX-DELISTED	Stock	3.5	4.15	3.5	3.81	29900.0
2002-07-19	ABB-DELISTED	Stock	8.57	8.57	8.4	8.47	26300.0
2002-07-19	ABC-DELISTED	Stock	15.56	15.79	15.28	15.3	4907200.0
2002-07-19	ABCB	Stock	11.3475	11.7365	11.307	11.3718	16902.0
2002-07-19	ABCO-DELISTED	Stock	14.35	14.35	13.405	13.72	164200.0
2002-07-19	ABCW-DELISTED	Stock	20.08	20.08	18.88	19.72	71400.0
2002-07-19	ABE-DELISTED	Stock	6.54	6.54	6.48	6.49	10800.0
2002-07-19	ABFS-DELISTED	Stock	21.41	21.41	20.27	21.2	117300.0
2002-07-19	ABG	Stock	11.9	12.11	11.27	11.58	56200.0
2002-07-19	ABK-DELISTED	Stock	54.0	56.8	53.91	55.85	1021400.0
2002-07-19	ABM	Stock	15.6	16.35	15.27	15.82	166400.0
2002-07-19	ABMD-DELISTED	Stock	6.27	6.48	5.87	6.29	34600.0
2002-07-19	ABP-DELISTED	Stock	0.67	0.67	0.55	0.58	104800.0
2002-07-19	ABT	Stock	14.4097	14.9394	14.3514	14.4277	11111362.0
2002-07-19	ABTL-DELISTED	Stock	11.75	12.5	11.55	12.45	8300.0
2002-07-19	ABV-DELISTED	Stock	15.55	15.55	15.25	15.31	173200.0
2002-07-19	ABX-DELISTED	Stock	17.3	17.74	16.89	16.9	46881781.0
2002-07-19	ACAP-DELISTED	Stock	16.5	16.82	16.25	16.26	27800.0
2002-07-19	ACAS-DELISTED	Stock	26.3	26.3	25.51	25.52	442800.0
2002-07-19	ACAT-DELISTED	Stock	16.445	16.445	15.45	15.45	72100.0
2002-07-19	ACCL-DELISTED	Stock	5.45980978012085	5.55394983291626	5.15568017959595	5.55394983291626	188400.0
2002-07-19	ACE-DELISTED	Stock	24.79	26.3	24.79	25.8	3588893.0
2002-07-19	ACF-DELISTED	Stock	17.0	17.49	16.23	16.88	2218900.0
2002-07-19	ACG-DELISTED	Stock	8.06	8.06	7.99	8.02	588400.0
2002-07-19	ACGL	Stock	2.6111	2.6856	2.5389	2.6667	1135800.0
2002-07-19	ACGN-DELISTED	Stock	1144.6712	1178.6712	1020.0	1178.6712	28900.0
2002-07-19	ACH	Stock	9.92	9.9667	9.42	9.5333	272250.0
2002-07-19	ACH-DELISTED	Stock	4.288	4.3805	4.288	4.363	17199.0
2002-07-19	ACLS	Stock	39.24	40.12	37.68	39.12	215050.0
2002-07-19	ACO-DELISTED	Stock	5.55	5.55	4.9	4.9	66800.0
2002-07-19	ACPW-DELISTED	Stock	10.65	10.745	9.8	10.0	62460.0
2002-07-19	ACS-DELISTED	Stock	41.2	41.98	40.27	41.25	1313600.0
2002-07-19	ACTA-DELISTED	Stock	5.6	5.8	5.0	5.4	14300.0
2002-07-19	ACTT-DELISTED	Stock	2.7	2.84	2.6	2.74	26500.0
2002-07-19	ACTU-DELISTED	Stock	2.2	2.23	2.1	2.19	1183500.0
2002-07-19	ACXM-DELISTED	Stock	13.99	14.17	13.32	13.49	1338491.0
2002-07-19	ACY-DELISTED	Stock	4.11	4.11	4.06	4.06	1200.0

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

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