PREVIEW / stock_daily / 2006-06-29

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-29.parquet
  size:    147 KB
  rows:    4,415
  symbols: 2,781

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-06-29	AAPL	Stock	2.0271	2.1104	2.0139	2.1061	873398400.0
2006-06-29	MSFT	Stock	23.32	23.63	23.22	23.47	121395500.0
2006-06-29	NVDA	Stock	0.3333	0.3582	0.3322	0.3582	687666000.0
2006-06-29	AMZN	Stock	1.841	1.9285	1.835	1.926	127450000.0
2006-06-29	CL	Stock	29.65	30.13	29.62	30.075	4018400.0
2006-06-29	A	Stock	21.9385	22.5608	21.8169	22.5393	3764395.0
2006-06-29	AABA-DELISTED	Stock	32.2599983215332	33.0	32.2000007629395	32.9700012207031	15745900.0
2006-06-29	AACC-DELISTED	Stock	19.55	20.03	19.37	19.89	438510.0
2006-06-29	AACQ-DELISTED	Stock	5.31	5.31	5.31	5.31	1500.0
2006-06-29	AAI-DELISTED	Stock	13.97	14.41	13.87	14.41	792500.0
2006-06-29	AAIC-DELISTED	Stock	238.2	239.0	228.6	235.8	1999400.0
2006-06-29	AAME	Stock	3.05	3.08	2.99	3.05	2800.0
2006-06-29	AAON	Stock	3.0775	3.3883	3.0775	3.3475	188325.0
2006-06-29	AAP	Stock	29.27	30.27	28.9	29.91	14007700.0
2006-06-29	AATI-DELISTED	Stock	10.01	10.42	9.96	10.39	229992.0
2006-06-29	AAU-DELISTED	Stock	2.19	2.26	2.0999	2.13	61400.0
2006-06-29	AAUAF-DELISTED	Stock	2.19	2.26	2.0999	2.13	61400.0
2006-06-29	AAV-DELISTED	Stock	17.66	17.77	17.44	17.55	270400.0
2006-06-29	AAWW-DELISTED	Stock	50.0	50.54	49.96	50.18	217416.0
2006-06-29	AAXN-DELISTED	Stock	7.86999988555908	7.98000001907349	7.71999979019165	7.92000007629395	1109800.0
2006-06-29	AB	Stock	58.25	60.48	58.19	60.43	293600.0
2006-06-29	ABAX-DELISTED	Stock	20.63	22.0	20.63	21.98	342044.0
2006-06-29	ABB-DELISTED	Stock	12.19	12.63	12.15	12.5901	1782000.0
2006-06-29	ABBC-DELISTED	Stock	15.52	15.52	15.3	15.31	26153.0
2006-06-29	ABC-DELISTED	Stock	20.52	20.75	20.43	20.72	3808200.0
2006-06-29	ABCB	Stock	20.4644	21.8358	20.4644	21.8261	29713.0
2006-06-29	ABCO-DELISTED	Stock	23.44	24.21	23.31	24.15	209118.0
2006-06-29	ABCW-DELISTED	Stock	28.88	29.85	28.68	29.79	80090.0
2006-06-29	ABD-DELISTED	Stock	21.96	22.95	21.95	22.7	221100.0
2006-06-29	ABE-DELISTED	Stock	11.41	12.19	11.41	11.9	43400.0
2006-06-29	ABFS-DELISTED	Stock	47.17	49.35	46.73	49.31	816646.0
2006-06-29	ABG	Stock	20.35	20.97	20.33	20.92	161200.0
2006-06-29	ABK-DELISTED	Stock	79.57	80.87	79.4	80.81	714000.0
2006-06-29	ABM	Stock	17.0	17.41	16.95	17.41	264000.0
2006-06-29	ABMD-DELISTED	Stock	12.1	13.09	12.03	13.02	101010.0
2006-06-29	ABP-DELISTED	Stock	4.34	4.42	4.28	4.36	134300.0
2006-06-29	ABR	Stock	24.37	24.79	24.13	24.75	93400.0
2006-06-29	ABT	Stock	20.3387	20.6218	20.2476	20.5834	10874531.0
2006-06-29	ABTL-DELISTED	Stock	15.55	16.3	15.45	16.25	53250.0
2006-06-29	ABV-DELISTED	Stock	38.65	40.76	38.49	40.5	618400.0
2006-06-29	ABVA-DELISTED	Stock	16.4	16.57	16.4	16.57	2005.0
2006-06-29	ABX-DELISTED	Stock	28.38	29.31	28.18	29.29	5451200.0
2006-06-29	ACAD	Stock	7.82	8.25	7.8	8.18	223300.0
2006-06-29	ACAP-DELISTED	Stock	48.01	49.41	47.72	49.37	34679.0
2006-06-29	ACAS-DELISTED	Stock	33.01	33.58	32.94	33.49	598938.0
2006-06-29	ACAT-DELISTED	Stock	17.42	19.2	17.42	18.99	119162.0
2006-06-29	ACC-DELISTED	Stock	24.1	24.2	23.9	24.1	68700.0
2006-06-29	ACCL-DELISTED	Stock	6.81	7.25	6.79	7.18	79421.0
2006-06-29	ACCO	Stock	21.96	22.95	21.95	22.7	235300.0
2006-06-29	ACE-DELISTED	Stock	49.28	50.46	49.08	50.42	1185927.0

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

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