PREVIEW / stock_daily / 2006-08-02

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-02.parquet
  size:    149 KB
  rows:    4,460
  symbols: 2,812

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-08-02	AAPL	Stock	2.4161	2.4529	2.4111	2.4343	550768400.0
2006-08-02	MSFT	Stock	24.12	24.4	24.03	24.3	46462000.0
2006-08-02	NVDA	Stock	0.362	0.3832	0.3612	0.3813	756774000.0
2006-08-02	AMZN	Stock	1.3075	1.315	1.2945	1.3045	156208000.0
2006-08-02	CL	Stock	29.155	29.62	29.025	29.5	4511800.0
2006-08-02	A	Stock	20.0286	20.4363	19.8856	20.1216	3397140.0
2006-08-02	AABA-DELISTED	Stock	27.0100002288818	27.1000003814697	26.4500007629395	26.6299991607666	18116200.0
2006-08-02	AACC-DELISTED	Stock	18.29	18.51	18.0	18.06	66707.0
2006-08-02	AACQ-DELISTED	Stock	5.35	5.35	5.35	5.35	11000.0
2006-08-02	AACQW-DELISTED	Stock	0.37	0.37	0.37	0.37	65400.0
2006-08-02	AAI-DELISTED	Stock	12.2	12.86	12.2	12.76	1492600.0
2006-08-02	AAIC-DELISTED	Stock	182.6	184.2	180.0	182.0	1126500.0
2006-08-02	AAON	Stock	2.9972	3.1131	2.9972	3.0512	155672.0
2006-08-02	AAP	Stock	29.99	30.43	29.85	30.22	720900.0
2006-08-02	AATI-DELISTED	Stock	8.81	8.96	8.45	8.64	206310.0
2006-08-02	AAU-DELISTED	Stock	2.6	2.65	2.5301	2.61	45800.0
2006-08-02	AAUAF-DELISTED	Stock	2.6	2.65	2.5301	2.61	45800.0
2006-08-02	AAV-DELISTED	Stock	16.56	16.7	16.46	16.58	443500.0
2006-08-02	AAWW-DELISTED	Stock	40.99	41.5	40.25	41.0	34256.0
2006-08-02	AAXN-DELISTED	Stock	7.01000022888184	7.36999988555908	6.92999982833862	7.34999990463257	2259700.0
2006-08-02	AB	Stock	65.27	67.13	65.1	66.51	217000.0
2006-08-02	ABAX-DELISTED	Stock	22.26	22.84	22.16	22.37	163619.0
2006-08-02	ABB-DELISTED	Stock	12.85	12.99	12.8101	12.84	3939100.0
2006-08-02	ABBC-DELISTED	Stock	14.77	15.15	14.65	14.84	20674.0
2006-08-02	ABC-DELISTED	Stock	21.5	21.67	21.4	21.59	1906000.0
2006-08-02	ABCB	Stock	24.851	25.2498	24.851	25.2498	49967.0
2006-08-02	ABCO-DELISTED	Stock	23.08	26.28	23.08	25.52	731624.0
2006-08-02	ABCW-DELISTED	Stock	29.57	30.21	29.51	29.97	31810.0
2006-08-02	ABD-DELISTED	Stock	19.11	19.69	19.11	19.66	217900.0
2006-08-02	ABE-DELISTED	Stock	12.6	12.8	12.3	12.65	10300.0
2006-08-02	ABFS-DELISTED	Stock	44.0	44.72	43.09	43.53	465334.0
2006-08-02	ABG	Stock	19.55	19.89	19.52	19.85	146700.0
2006-08-02	ABK-DELISTED	Stock	82.3	82.4	81.56	81.78	711700.0
2006-08-02	ABM	Stock	16.35	16.55	16.23	16.41	199000.0
2006-08-02	ABMD-DELISTED	Stock	13.55	14.19	13.49	13.68	277469.0
2006-08-02	ABP-DELISTED	Stock	4.39	4.53	4.27	4.36	181900.0
2006-08-02	ABR	Stock	25.85	25.95	25.75	25.87	110400.0
2006-08-02	ABT	Stock	22.6945	22.7809	22.5074	22.6226	9574406.0
2006-08-02	ABTL-DELISTED	Stock	15.95	15.95	15.55	15.75	33307.0
2006-08-02	ABV-DELISTED	Stock	39.91	41.27	39.91	41.16	407500.0
2006-08-02	ABVA-DELISTED	Stock	16.6	17.0	16.6	16.71	2600.0
2006-08-02	ABX-DELISTED	Stock	31.6	32.35	31.6	32.18	6501700.0
2006-08-02	ACAD	Stock	6.2	6.42	6.18	6.32	106800.0
2006-08-02	ACAP-DELISTED	Stock	45.83	45.83	44.96	45.12	90263.0
2006-08-02	ACAS-DELISTED	Stock	35.17	35.42	35.01	35.39	1201000.0
2006-08-02	ACAT-DELISTED	Stock	17.53	18.19	17.39	17.9	130084.0
2006-08-02	ACC-DELISTED	Stock	25.34	25.77	25.1	25.3	71479.0
2006-08-02	ACCL-DELISTED	Stock	6.27	6.39	6.16	6.39	42057.0
2006-08-02	ACCO	Stock	19.11	19.69	19.11	19.66	229500.0
2006-08-02	ACCP-DELISTED	Stock	0.86	1.01	0.86	1.01	1370.0

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

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