PREVIEW / stock_daily / 2007-11-13

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-13.parquet
  size:    180 KB
  rows:    5,591
  symbols: 3,395

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-13	AAPL	Stock	5.7446	6.1064	5.4914	6.07	1739446800.0
2007-11-13	MSFT	Stock	33.54	34.67	33.38	34.46	104311500.0
2007-11-13	NVDA	Stock	0.763	0.8178	0.7508	0.817	726696000.0
2007-11-13	AMZN	Stock	3.8955	4.0025	3.89	3.993	189926000.0
2007-11-13	TLT	Stock	91.42	91.49	91.17	91.23	1116502.0
2007-11-13	CL	Stock	38.635	38.8	37.975	38.75	5515600.0
2007-11-13	A	Stock	24.1202	24.3276	23.877	24.2561	2565190.0
2007-11-13	AABA-DELISTED	Stock	25.53	26.24	25.3	26.14	34123220.0
2007-11-13	AACC-DELISTED	Stock	10.76	11.06	10.54	10.77	189100.0
2007-11-13	AAI-DELISTED	Stock	9.22	9.55	9.16	9.53	1466508.0
2007-11-13	AAIC-DELISTED	Stock	74.2	77.8	74.2	77.0	1804900.0
2007-11-13	AAME	Stock	1.57	1.96	1.57	1.96	11000.0
2007-11-13	AAON	Stock	3.6523	3.7037	3.5773	3.6622	1185637.0
2007-11-13	AAP	Stock	34.9	35.78	34.67	35.69	1589300.0
2007-11-13	AATI-DELISTED	Stock	10.35	11.13	10.35	11.1	512887.0
2007-11-13	AAU-DELISTED	Stock	2.95	2.95	2.62	2.76	113400.0
2007-11-13	AAUAF-DELISTED	Stock	2.95	2.95	2.62	2.7599	113700.0
2007-11-13	AAV-DELISTED	Stock	11.15	11.15	10.22	10.96	2163487.0
2007-11-13	AAWW-DELISTED	Stock	55.66	56.0	55.42	55.74	153777.0
2007-11-13	AAXN-DELISTED	Stock	13.55	14.3	13.46	14.27	2211955.0
2007-11-13	AB	Stock	75.01	82.35	75.01	81.71	522600.0
2007-11-13	ABAX-DELISTED	Stock	32.18	32.9	31.66	32.81	309802.0
2007-11-13	ABB-DELISTED	Stock	27.94	29.04	27.92	28.99	7262101.0
2007-11-13	ABBC-DELISTED	Stock	9.03	9.09	8.85	9.08	75121.0
2007-11-13	ABBNY-DELISTED	Stock	27.94	29.04	27.92	28.97	7262101.0
2007-11-13	ABC-DELISTED	Stock	22.08	22.32	21.94	22.26	2695600.0
2007-11-13	ABCB	Stock	14.5799	15.0954	14.4048	15.0662	79474.0
2007-11-13	ABCO-DELISTED	Stock	32.45	32.64	31.97	32.16	445882.0
2007-11-13	ABCW-DELISTED	Stock	24.29	25.31	23.15	25.3	108120.0
2007-11-13	ABD-DELISTED	Stock	19.99	20.5	19.7	20.41	217620.0
2007-11-13	ABE-DELISTED	Stock	23.4	24.9	23.4	24.9	36300.0
2007-11-13	ABEO	Stock	3812.5	3825.0	3750.0	3825.0	3.0
2007-11-13	ABFS-DELISTED	Stock	25.58	26.0	25.3	25.92	482985.0
2007-11-13	ABG	Stock	17.5	18.23	17.38	18.04	372900.0
2007-11-13	ABK-DELISTED	Stock	27.78	29.5	26.0	28.96	11141100.0
2007-11-13	ABM	Stock	21.89	22.03	21.31	21.93	329700.0
2007-11-13	ABMD-DELISTED	Stock	12.35	12.68	12.0	12.61	195132.0
2007-11-13	ABP-DELISTED	Stock	3.65	3.88	3.51	3.8	415100.0
2007-11-13	ABR	Stock	18.6	18.72	17.6	18.58	430000.0
2007-11-13	ABT	Stock	26.3986	26.4898	25.7365	26.4418	13307211.0
2007-11-13	ABTL-DELISTED	Stock	14.236	15.7	14.236	15.65	57068.0
2007-11-13	ABV-DELISTED	Stock	71.06	82.17	71.06	72.45	825735.0
2007-11-13	ABVA-DELISTED	Stock	8.19	8.19	7.4	7.45	8359.0
2007-11-13	ABVT-DELISTED	Stock	89.0	89.0	86.0	86.0	2062.0
2007-11-13	ABX-DELISTED	Stock	42.29	43.11	41.97	42.4	7618361.0
2007-11-13	ACAD	Stock	11.73	11.73	11.2	11.25	436900.0
2007-11-13	ACAP-DELISTED	Stock	40.87	41.06	39.66	40.2	96179.0
2007-11-13	ACAS-DELISTED	Stock	38.52	40.78	38.5	40.71	2456374.0
2007-11-13	ACAT-DELISTED	Stock	13.09	13.35	12.98	13.24	59807.0
2007-11-13	ACC-DELISTED	Stock	26.55	28.35	26.55	28.15	192100.0

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

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