PREVIEW / stock_daily / 2009-09-23

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-23.parquet
  size:    186 KB
  rows:    5,849
  symbols: 3,482

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
2009-09-23	AAPL	Stock	6.6214	6.7464	6.6082	6.625	593563600.0
2009-09-23	MSFT	Stock	25.92	26.25	25.64	25.71	60599900.0
2009-09-23	NVDA	Stock	0.3818	0.385	0.373	0.3735	478936000.0
2009-09-23	AMZN	Stock	4.641	4.725	4.611	4.619	113706000.0
2009-09-23	TLT	Stock	95.94	96.58	95.2	96.47	5711910.0
2009-09-23	ES	Stock	24.03	24.11	23.65	23.78	1262100.0
2009-09-23	CL	Stock	37.75	38.72	37.75	38.18	5430000.0
2009-09-23	A	Stock	20.4506	20.6223	20.1359	20.2217	6227810.0
2009-09-23	AABA-DELISTED	Stock	17.1	17.6	16.97	17.21	34301046.0
2009-09-23	AACC-DELISTED	Stock	7.71	7.77	7.4	7.6	56242.0
2009-09-23	AACG	Stock	6.48	6.89	6.48	6.62	1500.0
2009-09-23	AAI-DELISTED	Stock	6.8	6.82	6.44	6.47	2751673.0
2009-09-23	AAIC-DELISTED	Stock	11.2	12.4	10.0	10.0	2223655.0
2009-09-23	AAME	Stock	1.03	1.03	1.02	1.03	39200.0
2009-09-23	AAON	Stock	4.0988	4.1402	4.0691	4.0691	619650.0
2009-09-23	AAP	Stock	39.69	39.87	38.53	38.63	4892900.0
2009-09-23	AATI-DELISTED	Stock	4.33	4.35	4.22	4.23	113773.0
2009-09-23	AAU-DELISTED	Stock	0.73	0.74	0.7	0.7	213851.0
2009-09-23	AAUAF-DELISTED	Stock	0.73	0.74	0.7	0.7	219351.0
2009-09-23	AAV-DELISTED	Stock	7.1	7.19	6.97	7.01	799687.0
2009-09-23	AAWW-DELISTED	Stock	33.62	34.59	33.15	33.9	340144.0
2009-09-23	AAXJ	Stock	52.61	53.25	52.48	52.72	134776.0
2009-09-23	AAXN-DELISTED	Stock	4.64	4.7	4.56	4.57	325763.0
2009-09-23	AB	Stock	27.38	27.81	26.16	26.33	830400.0
2009-09-23	ABAX-DELISTED	Stock	28.42	28.64	27.74	27.82	84685.0
2009-09-23	ABB-DELISTED	Stock	20.92	21.29	20.8109	20.85	3904562.0
2009-09-23	ABBC-DELISTED	Stock	7.84	8.01	7.69	7.83	28565.0
2009-09-23	ABBNY-DELISTED	Stock	20.92	21.29	20.8109	20.86	4001968.0
2009-09-23	ABC-DELISTED	Stock	21.97	22.12	21.63	21.7	2465212.0
2009-09-23	ABCB	Stock	7.285	7.285	6.9738	6.9738	15833.0
2009-09-23	ABCO-DELISTED	Stock	13.12	13.455	13.04	13.245	96190.0
2009-09-23	ABCW-DELISTED	Stock	1.33	1.43	1.3	1.41	83840.0
2009-09-23	ABD-DELISTED	Stock	7.39	7.42	7.3	7.34	601600.0
2009-09-23	ABE-DELISTED	Stock	17.52	17.52	17.211	17.36	9478.0
2009-09-23	ABEO	Stock	4187.5	4362.5	3937.5	4362.5	16.0
2009-09-23	ABFS-DELISTED	Stock	31.92	32.59	31.18	31.38	611543.0
2009-09-23	ABG	Stock	13.66	13.74	12.9	13.05	309100.0
2009-09-23	ABII-DELISTED	Stock	30.07	32.04	30.07	30.53	78201.0
2009-09-23	ABK-DELISTED	Stock	1.89	1.95	1.75	1.76	40701096.0
2009-09-23	ABM	Stock	20.68	20.93	20.31	20.4	180600.0
2009-09-23	ABMD-DELISTED	Stock	9.71	10.0	9.37	9.5	471326.0
2009-09-23	ABR	Stock	3.21	3.6	3.05	3.14	1203900.0
2009-09-23	ABT	Stock	22.4882	22.4882	22.114	22.1332	12867028.0
2009-09-23	ABTL-DELISTED	Stock	2.9941	3.1927	2.8435	2.9059	21882.0
2009-09-23	ABV-DELISTED	Stock	80.65	81.39	79.97	80.19	619967.0
2009-09-23	ABVA-DELISTED	Stock	2.55	2.9605	2.55	2.56	9200.0
2009-09-23	ABVT-DELISTED	Stock	46.37	49.06	45.34	48.49	478657.0
2009-09-23	ABX-DELISTED	Stock	37.47	37.9	36.49	36.51	15940786.0
2009-09-23	ACAD	Stock	1.88	1.92	1.85	1.85	1002800.0
2009-09-23	ACAP-DELISTED	Stock	29.5	30.235	29.32	29.82	56818.0

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

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