PREVIEW / stock_daily / 2006-09-22

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-22.parquet
  size:    149 KB
  rows:    4,483
  symbols: 2,825

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-09-22	AAPL	Stock	2.6536	2.655	2.5921	2.6071	665112000.0
2006-09-22	MSFT	Stock	26.83	26.85	26.48	26.66	47712500.0
2006-09-22	NVDA	Stock	0.5105	0.5137	0.4912	0.4968	653334000.0
2006-09-22	AMZN	Stock	1.511	1.5475	1.495	1.542	144980000.0
2006-09-22	CL	Stock	30.85	30.97	30.7	30.8	2792800.0
2006-09-22	A	Stock	23.5694	23.5908	23.0258	23.2332	3529810.0
2006-09-22	AABA-DELISTED	Stock	25.3400001525879	25.6900005340576	25.1800003051758	25.5200004577637	20667400.0
2006-09-22	AACC-DELISTED	Stock	14.91	15.08	14.8	15.08	210936.0
2006-09-22	AAI-DELISTED	Stock	10.0	10.1	9.89	9.9899	1001100.0
2006-09-22	AAIC-DELISTED	Stock	163.4	164.6	160.2	162.6	847600.0
2006-09-22	AAME	Stock	2.49	2.62	2.4	2.62	15200.0
2006-09-22	AAON	Stock	2.9353	2.9353	2.8576	2.8589	91884.0
2006-09-22	AAP	Stock	32.78	33.31	32.5	33.31	1038000.0
2006-09-22	AATI-DELISTED	Stock	6.3	6.42	5.35	5.59	3667895.0
2006-09-22	AAU-DELISTED	Stock	2.28	2.3	2.26	2.27	38700.0
2006-09-22	AAUAF-DELISTED	Stock	2.28	2.3	2.26	2.27	38700.0
2006-09-22	AAV-DELISTED	Stock	13.65	13.79	13.1	13.13	728000.0
2006-09-22	AAWW-DELISTED	Stock	43.85	44.26	43.27	43.9	105458.0
2006-09-22	AAXN-DELISTED	Stock	7.26000022888184	7.36999988555908	7.17999982833862	7.26999998092651	589600.0
2006-09-22	AB	Stock	67.85	68.17	67.41	67.89	122700.0
2006-09-22	ABAX-DELISTED	Stock	23.11	23.11	21.85	22.3	142931.0
2006-09-22	ABB-DELISTED	Stock	13.24	13.24	13.05	13.17	3707800.0
2006-09-22	ABBC-DELISTED	Stock	15.0	15.09	15.0	15.02	3125.0
2006-09-22	ABC-DELISTED	Stock	21.66	22.48	21.66	22.23	1987000.0
2006-09-22	ABCB	Stock	27.0006	27.3507	26.1641	26.3586	22516.0
2006-09-22	ABCO-DELISTED	Stock	25.09	25.13	24.68	24.72	138045.0
2006-09-22	ABCW-DELISTED	Stock	28.51	28.81	28.44	28.68	125310.0
2006-09-22	ABD-DELISTED	Stock	21.73	22.0	21.19	21.34	2050510.0
2006-09-22	ABE-DELISTED	Stock	13.48	13.65	13.44	13.5544	11300.0
2006-09-22	ABFS-DELISTED	Stock	42.98	43.08	41.88	42.5	421783.0
2006-09-22	ABG	Stock	19.6	19.75	19.4	19.7	491300.0
2006-09-22	ABK-DELISTED	Stock	82.56	82.71	82.05	82.41	600900.0
2006-09-22	ABM	Stock	18.88	18.95	18.56	18.81	164200.0
2006-09-22	ABMD-DELISTED	Stock	15.21	15.31	14.39	14.73	121595.0
2006-09-22	ABP-DELISTED	Stock	3.48	3.52	3.36	3.41	180200.0
2006-09-22	ABR	Stock	25.7	25.8	25.61	25.72	73400.0
2006-09-22	ABT	Stock	23.0352	23.1264	22.8769	22.9824	6069821.0
2006-09-22	ABTL-DELISTED	Stock	15.45	15.55	15.2	15.45	10325.0
2006-09-22	ABV-DELISTED	Stock	42.85	43.88	42.57	43.71	480300.0
2006-09-22	ABVA-DELISTED	Stock	16.72	16.8	16.6	16.7	1992.0
2006-09-22	ABVT-DELISTED	Stock	50.0	52.0	50.0	52.0	700.0
2006-09-22	ABX-DELISTED	Stock	29.79	29.84	29.05	29.25	3609600.0
2006-09-22	ACAD	Stock	7.99	8.0	7.75	7.88	142100.0
2006-09-22	ACAP-DELISTED	Stock	50.05	50.07	48.68	49.07	31844.0
2006-09-22	ACAS-DELISTED	Stock	38.51	38.64	38.38	38.61	481359.0
2006-09-22	ACAT-DELISTED	Stock	16.25	16.28	15.63	16.07	81905.0
2006-09-22	ACC-DELISTED	Stock	25.4	25.96	25.12	25.8	385941.0
2006-09-22	ACCL-DELISTED	Stock	5.63	5.64	5.46	5.52	24068.0
2006-09-22	ACCO	Stock	21.66	21.93	21.12	21.41	2231500.0
2006-09-22	ACCP-DELISTED	Stock	0.85	0.85	0.8	0.85	7480.0

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

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