PREVIEW / stock_daily / 2007-11-15

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-15.parquet
  size:    179 KB
  rows:    5,591
  symbols: 3,387

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-15	AAPL	Stock	5.9425	6.0568	5.725	5.8679	1487410400.0
2007-11-15	MSFT	Stock	33.76	34.1	33.55	33.76	64014100.0
2007-11-15	NVDA	Stock	0.799	0.8065	0.775	0.7935	496436000.0
2007-11-15	AMZN	Stock	3.9715	3.9865	3.835	3.8925	156630000.0
2007-11-15	TLT	Stock	91.61	92.56	91.4899	92.28	1312847.0
2007-11-15	CL	Stock	38.985	39.33	38.8	38.95	4768600.0
2007-11-15	A	Stock	24.113	25.0	24.0057	24.1059	3405668.0
2007-11-15	AABA-DELISTED	Stock	24.94	25.75	24.9	25.43	27925355.0
2007-11-15	AACC-DELISTED	Stock	11.2	11.2	10.49	10.61	238102.0
2007-11-15	AAI-DELISTED	Stock	9.45	9.59	9.08	9.21	1446700.0
2007-11-15	AAIC-DELISTED	Stock	74.6	75.0	70.6	71.6	1282829.0
2007-11-15	AAME	Stock	1.87	2.19	1.87	2.15	2900.0
2007-11-15	AAON	Stock	3.6563	3.6681	3.5911	3.599	508275.0
2007-11-15	AAP	Stock	35.54	35.73	35.08	35.27	1158800.0
2007-11-15	AATI-DELISTED	Stock	11.22	11.4	10.99	11.14	1066338.0
2007-11-15	AAU-DELISTED	Stock	2.51	2.79	2.51	2.72	126600.0
2007-11-15	AAUAF-DELISTED	Stock	2.51	2.79	2.51	2.72	126700.0
2007-11-15	AAV-DELISTED	Stock	11.05	11.2	10.54	10.67	854110.0
2007-11-15	AAWW-DELISTED	Stock	56.01	57.1	55.17	56.02	97634.0
2007-11-15	AAXN-DELISTED	Stock	14.23	14.5	13.71	13.88	1316923.0
2007-11-15	AB	Stock	80.52	80.52	76.27	76.7	342400.0
2007-11-15	ABAX-DELISTED	Stock	32.8	33.0	31.78	32.2	302706.0
2007-11-15	ABB-DELISTED	Stock	28.06	28.17	27.43	27.73	3447497.0
2007-11-15	ABBC-DELISTED	Stock	9.06	9.08	8.96	9.03	93363.0
2007-11-15	ABBNY-DELISTED	Stock	28.06	28.17	27.43	27.75	3448497.0
2007-11-15	ABC-DELISTED	Stock	22.0	22.42	22.0	22.16	3063400.0
2007-11-15	ABCB	Stock	14.7745	15.1149	14.3853	14.3853	17581.0
2007-11-15	ABCO-DELISTED	Stock	31.87	32.03	31.06	31.4	282966.0
2007-11-15	ABCW-DELISTED	Stock	25.3	25.3	24.69	24.98	184430.0
2007-11-15	ABD-DELISTED	Stock	19.65	19.71	18.98	19.29	265290.0
2007-11-15	ABE-DELISTED	Stock	25.75	25.75	23.7	24.25	20100.0
2007-11-15	ABFS-DELISTED	Stock	25.76	25.9	24.73	24.93	590910.0
2007-11-15	ABG	Stock	17.79	17.79	17.33	17.53	301100.0
2007-11-15	ABII-DELISTED	Stock	49.0	90.0	47.69	59.55	393015.0
2007-11-15	ABK-DELISTED	Stock	30.27	30.27	27.51	28.43	8380109.0
2007-11-15	ABM	Stock	21.6	21.68	21.25	21.43	280000.0
2007-11-15	ABMD-DELISTED	Stock	12.14	12.32	11.78	12.08	253160.0
2007-11-15	ABP-DELISTED	Stock	3.95	3.95	3.75	3.84	140800.0
2007-11-15	ABR	Stock	17.71	18.14	17.55	17.66	350100.0
2007-11-15	ABT	Stock	26.0052	26.365	26.0052	26.1395	11977699.0
2007-11-15	ABTL-DELISTED	Stock	16.361	17.479	15.599	15.65	46944.0
2007-11-15	ABV-DELISTED	Stock	74.15	76.17	72.53	73.57	473000.0
2007-11-15	ABVA-DELISTED	Stock	7.84	8.09	7.84	8.0	12600.0
2007-11-15	ABVT-DELISTED	Stock	81.05	82.25	81.01	82.25	47878.0
2007-11-15	ABX-DELISTED	Stock	42.14	42.14	39.91	40.46	9242736.0
2007-11-15	ACAD	Stock	10.98	11.41	10.9	11.21	422100.0
2007-11-15	ACAP-DELISTED	Stock	41.7	42.01	40.84	41.07	48632.0
2007-11-15	ACAS-DELISTED	Stock	40.3	40.48	39.4	40.01	1913133.0
2007-11-15	ACAT-DELISTED	Stock	12.77	13.02	12.73	12.94	96552.0
2007-11-15	ACC-DELISTED	Stock	27.76	28.09	26.91	28.01	236860.0

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

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