PREVIEW / stock_daily / 2006-05-02

all stock daily files

  file:    by_date/stock_daily/2006/2006-05-02.parquet
  size:    149 KB
  rows:    4,425
  symbols: 2,798

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
2006-05-02	AAPL	Stock	2.5054	2.5707	2.5039	2.5579	771663200.0
2006-05-02	MSFT	Stock	24.49	25.0	23.9	24.01	190533500.0
2006-05-02	NVDA	Stock	0.5188	0.525	0.5055	0.5143	539700000.0
2006-05-02	AMZN	Stock	1.732	1.747	1.7115	1.719	117140000.0
2006-05-02	CL	Stock	29.475	29.845	29.445	29.69	4697200.0
2006-05-02	A	Stock	27.7182	27.9685	27.6967	27.9185	2400925.0
2006-05-02	AABA-DELISTED	Stock	32.2000007629395	32.9099998474121	31.7199993133545	31.8500003814697	16276000.0
2006-05-02	AACC-DELISTED	Stock	20.85	21.4	20.51	20.96	151818.0
2006-05-02	AACQW-DELISTED	Stock	0.67	0.67	0.67	0.67	500.0
2006-05-02	AAI-DELISTED	Stock	13.4	14.21	13.38	13.85	2593400.0
2006-05-02	AAIC-DELISTED	Stock	214.0	215.6	211.4	214.8	1601200.0
2006-05-02	AAME	Stock	3.04	3.1	3.04	3.1	700.0
2006-05-02	AAON	Stock	3.5819	3.6464	3.5503	3.6464	143522.0
2006-05-02	AAP	Stock	39.45	39.72	38.45	38.6	1223100.0
2006-05-02	AATI-DELISTED	Stock	11.06	11.43	10.94	11.25	235770.0
2006-05-02	AAU-DELISTED	Stock	3.04	3.07	2.97	3.0	139100.0
2006-05-02	AAUAF-DELISTED	Stock	3.04	3.07	2.97	3.0	139100.0
2006-05-02	AAV-DELISTED	Stock	19.6	19.86	19.56	19.64	211000.0
2006-05-02	AAWW-DELISTED	Stock	47.5	50.0	47.5	50.0	486600.0
2006-05-02	AAXN-DELISTED	Stock	10.6999998092651	10.6999998092651	10.3900003433228	10.5299997329712	1405700.0
2006-05-02	AB	Stock	66.35	66.41	64.5	65.13	332900.0
2006-05-02	ABAX-DELISTED	Stock	24.25	24.78	24.03	24.56	440005.0
2006-05-02	ABB-DELISTED	Stock	14.23	14.39	14.22	14.39	1192200.0
2006-05-02	ABBC-DELISTED	Stock	13.55	13.61	13.55	13.6	5500.0
2006-05-02	ABC-DELISTED	Stock	21.82	21.92	21.72	21.86	3654000.0
2006-05-02	ABCB	Stock	21.0966	21.437	20.6979	21.3592	12646.0
2006-05-02	ABCO-DELISTED	Stock	26.98	27.67	26.67	27.5	108360.0
2006-05-02	ABCW-DELISTED	Stock	28.84	29.07	28.47	28.84	37710.0
2006-05-02	ABD-DELISTED	Stock	21.43	21.68	21.34	21.57	301340.0
2006-05-02	ABE-DELISTED	Stock	14.11	14.79	14.1	14.79	214400.0
2006-05-02	ABFS-DELISTED	Stock	42.29	42.29	41.17	41.47	281420.0
2006-05-02	ABG	Stock	19.74	19.88	19.43	19.75	173000.0
2006-05-02	ABK-DELISTED	Stock	81.88	81.94	80.57	81.11	1086100.0
2006-05-02	ABM	Stock	17.37	17.45	17.12	17.29	186100.0
2006-05-02	ABMD-DELISTED	Stock	12.94	13.23	12.75	13.19	40434.0
2006-05-02	ABP-DELISTED	Stock	6.25	6.29	6.03	6.1	241200.0
2006-05-02	ABR	Stock	25.18	25.38	24.58	24.8	88800.0
2006-05-02	ABT	Stock	20.3003	20.5114	20.1324	20.2236	8367862.0
2006-05-02	ABTL-DELISTED	Stock	22.35	22.6	22.1	22.6	28477.0
2006-05-02	ABV-DELISTED	Stock	46.33	47.57	46.15	47.5	409600.0
2006-05-02	ABVA-DELISTED	Stock	18.75	18.926	18.72	18.76	39600.0
2006-05-02	ABX-DELISTED	Stock	31.1	31.58	30.53	31.19	4886100.0
2006-05-02	ACAD	Stock	11.85	11.99	11.61	11.86	307200.0
2006-05-02	ACAP-DELISTED	Stock	46.72	46.95	46.1	46.69	38428.0
2006-05-02	ACAS-DELISTED	Stock	34.42	34.42	33.47	33.67	1540675.0
2006-05-02	ACAT-DELISTED	Stock	21.5	22.78	21.5	22.63	62705.0
2006-05-02	ACC-DELISTED	Stock	23.83	23.83	23.41	23.75	73603.0
2006-05-02	ACCL-DELISTED	Stock	6.83	7.0	6.73	6.96	133708.0
2006-05-02	ACCO	Stock	21.4	21.7	21.36	21.6	307500.0
2006-05-02	ACCP-DELISTED	Stock	1.2	1.2	1.2	1.2	9800.0

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

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