PREVIEW / stock_daily / 2002-04-09

all stock daily files

  file:    by_date/stock_daily/2002/2002-04-09.parquet
  size:    107 KB
  rows:    3,101
  symbols: 1,929

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-04-09	AAPL	Stock	0.4391	0.4464	0.4288	0.4304	191531200.0
2002-04-09	MSFT	Stock	28.665	28.715	27.4	27.435	63413000.0
2002-04-09	NVDA	Stock	0.3662	0.3692	0.3388	0.3397	1380768000.0
2002-04-09	AMZN	Stock	0.7035	0.7295	0.678	0.68	129180000.0
2002-04-09	CL	Stock	28.75	28.82	28.45	28.675	2373800.0
2002-04-09	A	Stock	24.3777	24.628	23.2976	23.4621	2935101.0
2002-04-09	AABA-DELISTED	Stock	9.47500038146973	9.57499980926514	9.19499969482422	9.22999954223633	21637800.0
2002-04-09	AAI-DELISTED	Stock	5.79	5.89	5.7	5.88	86300.0
2002-04-09	AAIC-DELISTED	Stock	162.0	170.0	162.0	168.2	135500.0
2002-04-09	AAME	Stock	2.31	2.31	2.11	2.11	7900.0
2002-04-09	AAON	Stock	2.3309	2.3309	2.2659	2.2826	220978.0
2002-04-09	AAP	Stock	15.05	15.5833	15.05	15.5667	594600.0
2002-04-09	AAXN-DELISTED	Stock	1.55583333969116	1.55583333969116	1.49166667461395	1.51083338260651	300000.0
2002-04-09	ABAX-DELISTED	Stock	6.17	6.5	6.17	6.5	32900.0
2002-04-09	ABB-DELISTED	Stock	8.89	9.0	8.7	8.8	13100.0
2002-04-09	ABC-DELISTED	Stock	16.8	17.0	16.75	16.87	2657600.0
2002-04-09	ABCB	Stock	12.6282	13.3577	12.547	12.9767	39727.0
2002-04-09	ABCO-DELISTED	Stock	16.14	16.55	15.905	16.5	56400.0
2002-04-09	ABCW-DELISTED	Stock	20.3	20.98	20.11	20.6	98200.0
2002-04-09	ABE-DELISTED	Stock	7.32	7.39	7.3	7.37	13000.0
2002-04-09	ABFS-DELISTED	Stock	25.95	26.85	25.68	26.67	173900.0
2002-04-09	ABK-DELISTED	Stock	60.75	61.52	60.39	61.45	775600.0
2002-04-09	ABM	Stock	18.75	19.175	18.75	19.025	192800.0
2002-04-09	ABMD-DELISTED	Stock	8.9	9.44	8.75	9.14	70200.0
2002-04-09	ABP-DELISTED	Stock	1.06	1.14	1.02	1.14	104200.0
2002-04-09	ABT	Stock	23.7244	23.8995	23.2082	23.6391	11642659.0
2002-04-09	ABTL-DELISTED	Stock	19.0	19.5	18.5	18.95	11800.0
2002-04-09	ABV-DELISTED	Stock	20.0	20.0	19.63	19.8	171000.0
2002-04-09	ABX-DELISTED	Stock	17.57	17.57	17.23	17.24	2599600.0
2002-04-09	ACAP-DELISTED	Stock	19.71	19.85	19.5	19.85	36800.0
2002-04-09	ACAS-DELISTED	Stock	30.84	31.01	30.64	30.72	248300.0
2002-04-09	ACAT-DELISTED	Stock	19.3	19.4	18.915	19.2	23300.0
2002-04-09	ACCL-DELISTED	Stock	8.7183198928833	9.37726020812988	8.7183198928833	9.37726020812988	266300.0
2002-04-09	ACE-DELISTED	Stock	43.85	44.68	43.65	44.2	1321400.0
2002-04-09	ACF-DELISTED	Stock	43.36	44.74	43.36	44.04	1606600.0
2002-04-09	ACG-DELISTED	Stock	7.77	7.8	7.75	7.79	542000.0
2002-04-09	ACGL	Stock	3.1111	3.1167	2.9833	3.0189	9703800.0
2002-04-09	ACGN-DELISTED	Stock	1541.3288	1632.0	1530.0	1632.0	43200.0
2002-04-09	ACH	Stock	12.76	13.0867	12.76	12.8733	102000.0
2002-04-09	ACH-DELISTED	Stock	5.6125	5.6125	5.6	5.6	16400.0
2002-04-09	ACLS	Stock	53.4	53.48	51.84	52.4	360825.0
2002-04-09	ACO-DELISTED	Stock	6.3	6.47	6.26	6.26	11300.0
2002-04-09	ACPW-DELISTED	Stock	23.0	23.7	23.0	23.5	10240.0
2002-04-09	ACS-DELISTED	Stock	55.0	55.4	53.41	53.63	524700.0
2002-04-09	ACTA-DELISTED	Stock	12.6	12.6	11.6	12.2	31200.0
2002-04-09	ACTT-DELISTED	Stock	5.19	5.2	5.01	5.09	13500.0
2002-04-09	ACTU-DELISTED	Stock	6.15	6.23	6.0	6.04	355400.0
2002-04-09	ACXM-DELISTED	Stock	15.88	16.28	15.46	15.46	318100.0
2002-04-09	ACY-DELISTED	Stock	4.75	4.75	4.75	4.75	200.0
2002-04-09	AD	Stock	27.8	27.8	27.5333	27.6	116250.0

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

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