PREVIEW / stock_daily / 2006-08-31

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-31.parquet
  size:    149 KB
  rows:    4,480
  symbols: 2,823

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-31	AAPL	Stock	2.4029	2.4393	2.3807	2.4232	574697200.0
2006-08-31	MSFT	Stock	25.87	25.98	25.68	25.7	26380500.0
2006-08-31	NVDA	Stock	0.4858	0.488	0.4747	0.4852	511278000.0
2006-08-31	AMZN	Stock	1.5375	1.5495	1.5235	1.5415	118940000.0
2006-08-31	CL	Stock	29.765	30.035	29.72	29.93	2771600.0
2006-08-31	A	Stock	23.0186	23.0687	22.6252	23.0043	2546038.0
2006-08-31	AABA-DELISTED	Stock	28.9899997711182	29.0200004577637	28.5900001525879	28.8299999237061	8879300.0
2006-08-31	AACC-DELISTED	Stock	15.35	15.59	14.77	14.78	270749.0
2006-08-31	AACQ-DELISTED	Stock	5.3	5.3	5.3	5.3	3000.0
2006-08-31	AAI-DELISTED	Stock	11.67	11.71	11.42	11.43	940000.0
2006-08-31	AAIC-DELISTED	Stock	166.0	166.0	163.6	165.0	1267200.0
2006-08-31	AAON	Stock	3.1526	3.254	3.1078	3.2013	249834.0
2006-08-31	AAP	Stock	30.24	30.46	30.1	30.12	447700.0
2006-08-31	AATI-DELISTED	Stock	9.23	9.56	9.19	9.51	226905.0
2006-08-31	AAU-DELISTED	Stock	2.61	2.67	2.6	2.64	46500.0
2006-08-31	AAUAF-DELISTED	Stock	2.61	2.67	2.6	2.64	46500.0
2006-08-31	AAV-DELISTED	Stock	16.07	16.17	16.0	16.17	244400.0
2006-08-31	AAWW-DELISTED	Stock	43.88	44.33	43.84	43.84	65309.0
2006-08-31	AAXN-DELISTED	Stock	7.78000020980835	7.8899998664856	7.73999977111816	7.76999998092651	366500.0
2006-08-31	AB	Stock	66.42	66.95	66.42	66.7	66400.0
2006-08-31	ABAX-DELISTED	Stock	24.49	24.49	24.02	24.02	134576.0
2006-08-31	ABB-DELISTED	Stock	13.4	13.42	13.26	13.34	2306400.0
2006-08-31	ABBC-DELISTED	Stock	15.0	15.25	14.96	15.19	34374.0
2006-08-31	ABC-DELISTED	Stock	22.16	22.2	21.98	22.07	1488200.0
2006-08-31	ABCB	Stock	26.2029	26.2516	25.561	25.561	50173.0
2006-08-31	ABCO-DELISTED	Stock	26.28	26.33	25.39	25.39	105010.0
2006-08-31	ABCW-DELISTED	Stock	29.38	29.53	29.05	29.22	44200.0
2006-08-31	ABD-DELISTED	Stock	21.97	21.99	21.58	21.66	142400.0
2006-08-31	ABE-DELISTED	Stock	13.54	13.59	13.47	13.52	10300.0
2006-08-31	ABFS-DELISTED	Stock	44.82	45.12	44.1	44.15	302665.0
2006-08-31	ABG	Stock	20.71	20.71	20.4	20.49	78300.0
2006-08-31	ABK-DELISTED	Stock	86.82	87.17	86.36	86.51	707600.0
2006-08-31	ABM	Stock	18.0	18.12	17.87	17.99	108700.0
2006-08-31	ABMD-DELISTED	Stock	14.5	14.97	14.27	14.91	204780.0
2006-08-31	ABP-DELISTED	Stock	4.09	4.16	4.04	4.1	267700.0
2006-08-31	ABR	Stock	25.24	25.28	25.11	25.15	57800.0
2006-08-31	ABT	Stock	23.1887	23.3903	23.1024	23.3663	9971238.0
2006-08-31	ABTL-DELISTED	Stock	14.025	14.025	13.825	13.975	22662.0
2006-08-31	ABV-DELISTED	Stock	45.0	45.2	44.58	44.87	325600.0
2006-08-31	ABVA-DELISTED	Stock	17.02	17.02	16.9	16.93	12239.0
2006-08-31	ABX-DELISTED	Stock	33.13	33.74	33.13	33.47	3888800.0
2006-08-31	ACAD	Stock	8.75	8.81	8.63	8.66	145100.0
2006-08-31	ACAP-DELISTED	Stock	49.68	49.7	48.92	49.25	47020.0
2006-08-31	ACAS-DELISTED	Stock	38.61	38.9	38.51	38.73	1191557.0
2006-08-31	ACAT-DELISTED	Stock	16.75	16.83	16.44	16.61	77400.0
2006-08-31	ACC-DELISTED	Stock	26.05	26.27	25.97	25.97	38300.0
2006-08-31	ACCL-DELISTED	Stock	5.61	5.67	5.5	5.54	75015.0
2006-08-31	ACCO	Stock	21.97	21.99	21.58	21.66	154700.0
2006-08-31	ACCP-DELISTED	Stock	0.85	0.85	0.85	0.85	5110.0
2006-08-31	ACE-DELISTED	Stock	52.92	53.9	52.85	53.87	1398400.0

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

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