PREVIEW / stock_daily / 2007-11-20

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-20.parquet
  size:    180 KB
  rows:    5,623
  symbols: 3,400

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
2007-11-20	AAPL	Stock	5.9168	6.1354	5.8404	6.0304	1543642800.0
2007-11-20	MSFT	Stock	34.23	34.97	34.1	34.58	100009400.0
2007-11-20	NVDA	Stock	0.7708	0.772	0.7278	0.7508	622628000.0
2007-11-20	AMZN	Stock	3.993	4.1	3.9155	4.0195	232200000.0
2007-11-20	TLT	Stock	93.09	93.29	92.8	92.91	1367727.0
2007-11-20	CL	Stock	38.73	39.7	38.73	39.435	9569800.0
2007-11-20	A	Stock	25.6009	26.4092	25.6009	26.1159	3978568.0
2007-11-20	AABA-DELISTED	Stock	26.97	27.25	25.98	26.71	25723120.0
2007-11-20	AACC-DELISTED	Stock	10.55	10.87	10.49	10.71	241755.0
2007-11-20	AAI-DELISTED	Stock	8.75	8.75	8.23	8.42	1787150.0
2007-11-20	AAIC-DELISTED	Stock	60.8	63.2	54.6	58.6	3581901.0
2007-11-20	AAME	Stock	2.14	2.16	2.0	2.02	10200.0
2007-11-20	AAON	Stock	3.5477	3.601	3.4884	3.5852	708750.0
2007-11-20	AAP	Stock	34.97	35.39	34.07	34.59	1095000.0
2007-11-20	AATI-DELISTED	Stock	10.5	10.77	10.3	10.7	553929.0
2007-11-20	AAU-DELISTED	Stock	2.7	2.9	2.7	2.9	60200.0
2007-11-20	AAUAF-DELISTED	Stock	2.7	2.9	2.7	2.9	60400.0
2007-11-20	AAV-DELISTED	Stock	10.75	10.98	10.75	10.91	627602.0
2007-11-20	AAWW-DELISTED	Stock	54.05	54.66	53.5	54.39	139155.0
2007-11-20	AAXN-DELISTED	Stock	13.33	13.46	12.93	13.44	2132917.0
2007-11-20	AB	Stock	74.5	75.38	71.94	73.73	505500.0
2007-11-20	ABAX-DELISTED	Stock	32.32	33.24	32.15	32.47	349534.0
2007-11-20	ABB-DELISTED	Stock	27.06	27.69	26.22	26.62	11204311.0
2007-11-20	ABBC-DELISTED	Stock	8.94	9.06	8.58	9.05	43352.0
2007-11-20	ABBNY-DELISTED	Stock	27.06	27.69	26.22	26.6	11204311.0
2007-11-20	ABC-DELISTED	Stock	21.9	22.26	21.75	22.14	3283200.0
2007-11-20	ABCB	Stock	13.792	13.9866	13.2669	13.724	39891.0
2007-11-20	ABCO-DELISTED	Stock	31.34	31.94	30.91	31.57	148885.0
2007-11-20	ABCW-DELISTED	Stock	24.0	24.28	23.25	24.28	102520.0
2007-11-20	ABD-DELISTED	Stock	18.88	18.91	17.74	18.0	385850.0
2007-11-20	ABE-DELISTED	Stock	23.88	25.4499	23.88	24.168	13390.0
2007-11-20	ABEO	Stock	3625.0	3750.0	3625.0	3687.5	3.0
2007-11-20	ABFS-DELISTED	Stock	22.67	22.87	21.5	22.19	900921.0
2007-11-20	ABG	Stock	17.45	17.59	17.02	17.49	534900.0
2007-11-20	ABII-DELISTED	Stock	57.4301	58.53	56.5	57.15	104054.0
2007-11-20	ABK-DELISTED	Stock	23.58	25.75	23.0	24.95	11603614.0
2007-11-20	ABM	Stock	20.9	20.92	19.93	20.4	378500.0
2007-11-20	ABMD-DELISTED	Stock	12.02	12.24	11.84	12.17	171319.0
2007-11-20	ABP-DELISTED	Stock	3.53	3.53	3.27	3.44	304870.0
2007-11-20	ABR	Stock	17.55	17.61	16.6	16.92	211700.0
2007-11-20	ABT	Stock	26.3986	26.7728	26.293	26.6673	13701959.0
2007-11-20	ABTL-DELISTED	Stock	15.6	16.2	14.6	15.0	20130.0
2007-11-20	ABV-DELISTED	Stock	71.78	73.51	70.51	71.87	368442.0
2007-11-20	ABVA-DELISTED	Stock	7.66	7.86	7.4	7.74	10550.0
2007-11-20	ABVT-DELISTED	Stock	81.25	82.0	80.0	81.5	31400.0
2007-11-20	ABX-DELISTED	Stock	39.9	42.4	39.56	42.24	10685677.0
2007-11-20	ACAD	Stock	10.96	11.05	10.26	10.52	543100.0
2007-11-20	ACAP-DELISTED	Stock	40.1	42.48	40.1	41.26	81251.0
2007-11-20	ACAS-DELISTED	Stock	37.7	38.1832	36.39	37.48	2622873.0
2007-11-20	ACAT-DELISTED	Stock	12.12	12.46	11.55	11.84	268860.0

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

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