PREVIEW / stock_daily / 2009-02-23

all stock daily files

  file:    by_date/stock_daily/2009/2009-02-23.parquet
  size:    175 KB
  rows:    5,770
  symbols: 3,455

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-02-23	AAPL	Stock	3.2732	3.2857	3.0896	3.1054	786982000.0
2009-02-23	MSFT	Stock	18.02	18.15	17.16	17.21	70803400.0
2009-02-23	NVDA	Stock	0.1935	0.1945	0.1803	0.1815	679548000.0
2009-02-23	AMZN	Stock	3.208	3.2455	3.076	3.0855	146720000.0
2009-02-23	TLT	Stock	103.6	104.88	103.17	104.88	2688638.0
2009-02-23	CL	Stock	29.755	30.045	29.175	29.2	6735800.0
2009-02-23	A	Stock	10.9657	11.0443	10.1788	10.2146	6631553.0
2009-02-23	AABA-DELISTED	Stock	12.2	12.35	11.8301	11.99	16407429.0
2009-02-23	AACC-DELISTED	Stock	3.85	3.85	3.43	3.45	36874.0
2009-02-23	AACG	Stock	4.85	5.53	4.85	4.91	18000.0
2009-02-23	AAI-DELISTED	Stock	3.41	3.65	3.38	3.46	2536163.0
2009-02-23	AAIC-DELISTED	Stock	3.0	3.4	2.6	2.6	188518.0
2009-02-23	AAME	Stock	0.66	0.67	0.65	0.65	18600.0
2009-02-23	AAON	Stock	3.1249	3.2	3.0262	3.0281	269325.0
2009-02-23	AAP	Stock	37.29	37.81	36.36	36.47	3021500.0
2009-02-23	AATI-DELISTED	Stock	2.93	3.05	2.78	2.81	151312.0
2009-02-23	AAU-DELISTED	Stock	0.82	0.89	0.8	0.85	67572.0
2009-02-23	AAUAF-DELISTED	Stock	0.82	0.89	0.8	0.85	67672.0
2009-02-23	AAV-DELISTED	Stock	2.38	2.45	2.17	2.21	992320.0
2009-02-23	AAWW-DELISTED	Stock	13.86	14.37	12.81	12.99	144782.0
2009-02-23	AAXJ	Stock	29.71	29.71	28.32	28.62	451243.0
2009-02-23	AAXN-DELISTED	Stock	4.33	4.47	4.03	4.06	745241.0
2009-02-23	AB	Stock	12.79	12.88	11.8	11.99	663600.0
2009-02-23	ABAX-DELISTED	Stock	17.1	17.15	16.4	16.45	211215.0
2009-02-23	ABB-DELISTED	Stock	11.87	11.88	10.96	11.0	4558964.0
2009-02-23	ABBC-DELISTED	Stock	6.8001	6.91	6.75	6.89	87527.0
2009-02-23	ABBNY-DELISTED	Stock	11.87	11.88	10.96	10.99	4560664.0
2009-02-23	ABC-DELISTED	Stock	17.95	17.98	17.27	17.32	3756522.0
2009-02-23	ABCB	Stock	5.7483	5.7483	4.7659	4.9799	42564.0
2009-02-23	ABCO-DELISTED	Stock	8.025	8.13	7.895	7.94	271124.0
2009-02-23	ABCW-DELISTED	Stock	0.86	0.93	0.79	0.81	161570.0
2009-02-23	ABD-DELISTED	Stock	1.1383	1.1383	0.9601	0.97	209280.0
2009-02-23	ABE-DELISTED	Stock	11.47	11.55	11.0	11.01	25872.0
2009-02-23	ABEO	Stock	1500.0	1762.5	1262.5	1750.0	13.0
2009-02-23	ABFS-DELISTED	Stock	20.55	20.85	19.5	19.51	506678.0
2009-02-23	ABG	Stock	3.59	3.99	3.59	3.86	181400.0
2009-02-23	ABII-DELISTED	Stock	71.09	73.6	71.09	72.25	7467.0
2009-02-23	ABK-DELISTED	Stock	1.11	1.12	0.98	0.98	10028738.0
2009-02-23	ABM	Stock	12.37	12.59	12.22	12.28	430800.0
2009-02-23	ABMD-DELISTED	Stock	7.72	7.89	7.11	7.23	500602.0
2009-02-23	ABR	Stock	0.94	0.99	0.87	0.87	181500.0
2009-02-23	ABT	Stock	25.6405	26.1443	25.5589	25.6213	14229054.0
2009-02-23	ABTL-DELISTED	Stock	2.25	2.25	1.85	1.9	1820.0
2009-02-23	ABV-DELISTED	Stock	42.31	42.31	40.0	40.45	610483.0
2009-02-23	ABX-DELISTED	Stock	35.87	36.29	35.28	35.62	14146074.0
2009-02-23	ACAD	Stock	0.84	0.97	0.8	0.81	82900.0
2009-02-23	ACAP-DELISTED	Stock	45.04	46.62	42.52	42.71	45974.0
2009-02-23	ACAS-DELISTED	Stock	1.52	1.54	1.32	1.32	4256570.0
2009-02-23	ACAT-DELISTED	Stock	3.49	3.52	3.34	3.34	29673.0
2009-02-23	ACC-DELISTED	Stock	19.01	19.24	17.61	17.66	964334.0

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

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