PREVIEW / stock_daily / 2009-09-16

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-16.parquet
  size:    186 KB
  rows:    5,847
  symbols: 3,476

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-16	AAPL	Stock	6.3568	6.5268	6.3529	6.4954	754023200.0
2009-09-16	MSFT	Stock	25.25	25.35	24.95	25.2	50055800.0
2009-09-16	NVDA	Stock	0.4085	0.4093	0.3925	0.3985	707064000.0
2009-09-16	AMZN	Stock	4.2955	4.549	4.295	4.535	262286000.0
2009-09-16	TLT	Stock	95.34	95.95	94.6	95.42	3734217.0
2009-09-16	ES	Stock	24.48	24.75	24.22	24.72	1080800.0
2009-09-16	CL	Stock	37.31	37.79	37.2	37.755	5084400.0
2009-09-16	A	Stock	20.2647	20.5794	20.2647	20.4793	4520014.0
2009-09-16	AABA-DELISTED	Stock	16.57	17.11	16.52	16.99	51737292.0
2009-09-16	AACC-DELISTED	Stock	7.71	7.81	7.31	7.81	39949.0
2009-09-16	AACG	Stock	6.66	6.81	6.66	6.77	6500.0
2009-09-16	AAI-DELISTED	Stock	6.93	7.07	6.74	6.77	2824464.0
2009-09-16	AAIC-DELISTED	Stock	10.4	10.6	9.4	10.2	659036.0
2009-09-16	AAON	Stock	4.0672	4.1264	4.0217	4.1165	2706412.0
2009-09-16	AAP	Stock	39.22	39.34	38.48	38.78	1918700.0
2009-09-16	AATI-DELISTED	Stock	4.53	4.58	4.36	4.49	282651.0
2009-09-16	AAU-DELISTED	Stock	0.72	0.72	0.69	0.69	424420.0
2009-09-16	AAUAF-DELISTED	Stock	0.72	0.72	0.69	0.69	450862.0
2009-09-16	AAV-DELISTED	Stock	6.59	6.98	6.59	6.92	1726178.0
2009-09-16	AAWW-DELISTED	Stock	29.57	31.19	29.5428	30.92	753921.0
2009-09-16	AAXJ	Stock	52.58	53.42	52.45	53.42	458164.0
2009-09-16	AAXN-DELISTED	Stock	4.84	4.9	4.77	4.79	340956.0
2009-09-16	AB	Stock	25.12	25.7	24.94	25.69	714800.0
2009-09-16	ABAX-DELISTED	Stock	28.26	29.43	27.95	29.21	278549.0
2009-09-16	ABB-DELISTED	Stock	20.8	21.03	20.68	20.98	2962978.0
2009-09-16	ABBC-DELISTED	Stock	7.74	7.86	7.62	7.7	23828.0
2009-09-16	ABBNY-DELISTED	Stock	20.8	21.03	20.68	21.02	3013016.0
2009-09-16	ABC-DELISTED	Stock	21.64	21.77	21.29	21.75	2351441.0
2009-09-16	ABCB	Stock	6.2055	6.3903	6.0401	6.361	28890.0
2009-09-16	ABCO-DELISTED	Stock	13.575	13.575	13.3	13.51	94946.0
2009-09-16	ABCW-DELISTED	Stock	1.23	1.35	1.22	1.31	54820.0
2009-09-16	ABD-DELISTED	Stock	6.48	6.69	6.41	6.57	604520.0
2009-09-16	ABE-DELISTED	Stock	16.96	17.19	16.96	17.09	12065.0
2009-09-16	ABEO	Stock	4250.0	4625.0	4250.0	4550.0	22.0
2009-09-16	ABFS-DELISTED	Stock	33.98	34.15	32.83	33.45	466808.0
2009-09-16	ABG	Stock	14.81	14.92	14.68	14.86	345000.0
2009-09-16	ABII-DELISTED	Stock	28.16	29.1	28.11	28.3	70999.0
2009-09-16	ABK-DELISTED	Stock	1.65	1.75	1.62	1.64	18231630.0
2009-09-16	ABM	Stock	20.53	20.99	20.45	20.97	85900.0
2009-09-16	ABMD-DELISTED	Stock	8.65	9.03	8.44	8.91	442583.0
2009-09-16	ABR	Stock	2.1	2.13	1.99	2.13	285400.0
2009-09-16	ABT	Stock	22.6849	22.6849	22.2147	22.4163	15908295.0
2009-09-16	ABTL-DELISTED	Stock	3.0	3.0	2.95	3.0	12129.0
2009-09-16	ABV-DELISTED	Stock	79.54	80.33	78.78	80.27	751886.0
2009-09-16	ABVA-DELISTED	Stock	2.67	2.68	2.67	2.68	5587.0
2009-09-16	ABVT-DELISTED	Stock	44.26	45.35	44.11	45.17	62033.0
2009-09-16	ABX-DELISTED	Stock	38.73	39.02	38.35	38.55	18235909.0
2009-09-16	ACAD	Stock	1.88	1.98	1.85	1.94	1610300.0
2009-09-16	ACAP-DELISTED	Stock	30.7	31.01	30.62	30.7	50230.0
2009-09-16	ACAS-DELISTED	Stock	3.07	3.52	2.93	3.4	32576429.0

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

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