PREVIEW / stock_daily / 2008-09-23

all stock daily files

  file:    by_date/stock_daily/2008/2008-09-23.parquet
  size:    183 KB
  rows:    5,771
  symbols: 3,483

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
2008-09-23	AAPL	Stock	4.7089	4.85	4.5236	4.53	1280364400.0
2008-09-23	MSFT	Stock	25.66	26.17	25.34	25.44	92181300.0
2008-09-23	NVDA	Stock	0.277	0.2872	0.2703	0.2712	821468000.0
2008-09-23	AMZN	Stock	3.7895	3.8145	3.5385	3.588	171884000.0
2008-09-23	TLT	Stock	93.61	94.1	93.13	93.6	2235943.0
2008-09-23	CL	Stock	36.745	37.555	36.515	36.825	6069800.0
2008-09-23	A	Stock	22.3677	22.5823	21.8455	22.0744	4292140.0
2008-09-23	AABA-DELISTED	Stock	18.71	19.13	18.67	18.91	17180501.0
2008-09-23	AACC-DELISTED	Stock	11.31	12.12	10.99	11.65	96978.0
2008-09-23	AACG	Stock	10.06	10.19	8.22	9.29	87000.0
2008-09-23	AAI-DELISTED	Stock	2.55	2.65	2.51	2.56	2527408.0
2008-09-23	AAIC-DELISTED	Stock	37.0	38.2	32.8	34.2	311840.0
2008-09-23	AAME	Stock	1.4	1.4	1.35	1.35	2900.0
2008-09-23	AAON	Stock	4.1442	4.1442	3.8084	3.844	877837.0
2008-09-23	AAP	Stock	39.0	39.73	38.55	39.07	1317600.0
2008-09-23	AATI-DELISTED	Stock	4.89	4.95	4.5	4.59	324451.0
2008-09-23	AAU-DELISTED	Stock	1.34	1.39	1.28	1.28	89170.0
2008-09-23	AAUAF-DELISTED	Stock	1.34	1.3899	1.28	1.28	94520.0
2008-09-23	AAV-DELISTED	Stock	9.8	10.1	9.74	10.0	602438.0
2008-09-23	AAWW-DELISTED	Stock	50.1	50.57	47.69	47.69	134605.0
2008-09-23	AAXJ	Stock	43.42	43.9	43.42	43.426	6925.0
2008-09-23	AAXN-DELISTED	Stock	7.09	7.14	6.8	7.09	873059.0
2008-09-23	AB	Stock	40.53	41.22	39.99	41.08	396100.0
2008-09-23	ABAX-DELISTED	Stock	19.61	19.9695	18.94	19.69	311225.0
2008-09-23	ABB-DELISTED	Stock	21.29	21.47	20.62	20.82	6918157.0
2008-09-23	ABBC-DELISTED	Stock	10.22	10.22	9.78	9.93	30153.0
2008-09-23	ABBNY-DELISTED	Stock	21.29	21.47	20.62	20.85	6945194.0
2008-09-23	ABC-DELISTED	Stock	19.06	19.76	19.05	19.18	3344918.0
2008-09-23	ABCB	Stock	13.9963	14.5896	13.6753	14.0838	37321.0
2008-09-23	ABCO-DELISTED	Stock	16.29	16.55	15.8	15.8	209752.0
2008-09-23	ABCW-DELISTED	Stock	8.9	8.9	8.34	8.55	59840.0
2008-09-23	ABD-DELISTED	Stock	8.73	9.03	8.58	8.61	292980.0
2008-09-23	ABE-DELISTED	Stock	16.43	16.43	15.48	15.54	16555.0
2008-09-23	ABEO	Stock	3725.0	3875.0	3725.0	3750.0	44.0
2008-09-23	ABFS-DELISTED	Stock	38.51	39.24	36.3401	36.3401	986196.0
2008-09-23	ABG	Stock	12.75	12.99	12.33	12.34	300200.0
2008-09-23	ABII-DELISTED	Stock	67.1	67.62	63.29	66.0	36781.0
2008-09-23	ABK-DELISTED	Stock	3.76	3.89	3.05	3.34	20086591.0
2008-09-23	ABM	Stock	22.12	22.67	21.97	22.07	422500.0
2008-09-23	ABMD-DELISTED	Stock	18.3799	18.6499	17.78	18.42	206934.0
2008-09-23	ABR	Stock	9.4	9.55	8.85	9.23	128000.0
2008-09-23	ABT	Stock	27.5741	28.3946	27.5741	28.0731	19099000.0
2008-09-23	ABTL-DELISTED	Stock	5.1943	5.6571	5.0914	5.4	8762.0
2008-09-23	ABV-DELISTED	Stock	57.7	57.79	54.29	54.48	533024.0
2008-09-23	ABVA-DELISTED	Stock	3.88	3.89	3.586	3.615	2320.0
2008-09-23	ABX-DELISTED	Stock	38.35	38.81	36.39	37.25	21333784.0
2008-09-23	ACAD	Stock	2.66	3.14	2.58	2.63	371700.0
2008-09-23	ACAP-DELISTED	Stock	44.12	44.6	42.53	43.93	27864.0
2008-09-23	ACAS-DELISTED	Stock	26.06	28.49	25.9	28.17	5825775.0
2008-09-23	ACAT-DELISTED	Stock	9.78	9.88	9.3	9.3	124363.0

> showing 50 of 5,771 rows — these rows as CSV

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