PREVIEW / stock_daily / 2009-02-09

all stock daily files

  file:    by_date/stock_daily/2009/2009-02-09.parquet
  size:    177 KB
  rows:    5,730
  symbols: 3,429

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-09	AAPL	Stock	3.5714	3.6786	3.5536	3.6611	715010800.0
2009-02-09	MSFT	Stock	19.64	19.77	19.26	19.44	52196400.0
2009-02-09	NVDA	Stock	0.2458	0.2493	0.2368	0.2435	716128000.0
2009-02-09	AMZN	Stock	3.328	3.368	3.269	3.3355	188752000.0
2009-02-09	TLT	Stock	101.69	102.67	101.06	102.62	2257935.0
2009-02-09	CL	Stock	32.71	32.995	31.81	32.075	7440800.0
2009-02-09	A	Stock	13.691	13.8841	13.3691	13.6195	4673234.0
2009-02-09	AABA-DELISTED	Stock	13.59	14.0	13.47	13.9	15653048.0
2009-02-09	AACC-DELISTED	Stock	4.87	5.04	4.72	4.93	20246.0
2009-02-09	AACG	Stock	4.39	4.57	3.75	3.75	6300.0
2009-02-09	AAI-DELISTED	Stock	4.5	4.54	4.35	4.37	1842269.0
2009-02-09	AAIC-DELISTED	Stock	4.6	5.0	4.224	4.8	111223.0
2009-02-09	AAON	Stock	3.7551	3.8479	3.7116	3.7274	120487.0
2009-02-09	AAP	Stock	33.7	34.25	33.26	34.25	1603900.0
2009-02-09	AATI-DELISTED	Stock	2.84	2.97	2.75	2.86	181842.0
2009-02-09	AAU-DELISTED	Stock	0.68	0.7	0.65	0.67	94577.0
2009-02-09	AAUAF-DELISTED	Stock	0.68	0.7	0.65	0.67	94857.0
2009-02-09	AAV-DELISTED	Stock	3.7	3.8	3.61	3.63	902142.0
2009-02-09	AAWW-DELISTED	Stock	16.74	17.52	16.01	17.38	250805.0
2009-02-09	AAXJ	Stock	33.13	33.13	32.4	32.84	1602599.0
2009-02-09	AAXN-DELISTED	Stock	5.64	5.83	5.6	5.73	661227.0
2009-02-09	AB	Stock	17.58	17.95	17.15	17.56	274800.0
2009-02-09	ABAX-DELISTED	Stock	18.82	18.91	18.36	18.5	152078.0
2009-02-09	ABB-DELISTED	Stock	14.38	14.65	14.22	14.42	4750847.0
2009-02-09	ABBC-DELISTED	Stock	6.98	7.33	6.86	7.18	426282.0
2009-02-09	ABBNY-DELISTED	Stock	14.38	14.65	14.22	14.43	4761747.0
2009-02-09	ABC-DELISTED	Stock	19.38	19.38	19.06	19.32	2213826.0
2009-02-09	ABCB	Stock	8.3356	8.6468	8.1702	8.248	15113.0
2009-02-09	ABCO-DELISTED	Stock	8.203	8.432	8.168	8.392	242824.0
2009-02-09	ABCW-DELISTED	Stock	2.25	2.25	1.936	2.0	323180.0
2009-02-09	ABD-DELISTED	Stock	1.985	2.0251	1.9148	1.965	93540.0
2009-02-09	ABE-DELISTED	Stock	12.8	13.29	12.8	12.86	24565.0
2009-02-09	ABEO	Stock	1250.0	1250.0	1125.0	1250.0	2.0
2009-02-09	ABFS-DELISTED	Stock	25.93	26.35	25.08	25.29	633622.0
2009-02-09	ABG	Stock	4.29	4.45	4.16	4.42	155500.0
2009-02-09	ABII-DELISTED	Stock	71.87	71.87	69.13	71.7	6898.0
2009-02-09	ABK-DELISTED	Stock	1.35	1.49	1.27	1.44	19884140.0
2009-02-09	ABM	Stock	14.94	15.04	14.55	14.59	210500.0
2009-02-09	ABMD-DELISTED	Stock	9.4	9.59	8.89	9.02	682640.0
2009-02-09	ABR	Stock	1.62	1.73	1.59	1.73	110300.0
2009-02-09	ABT	Stock	27.4446	27.5213	27.0031	27.4686	23365777.0
2009-02-09	ABTL-DELISTED	Stock	1.85	2.2	1.85	2.0	1839.0
2009-02-09	ABV-DELISTED	Stock	44.62	45.66	44.04	44.63	618866.0
2009-02-09	ABVA-DELISTED	Stock	1.41	1.47	1.2	1.25	6267.0
2009-02-09	ABVT-DELISTED	Stock	40.0	44.0	39.9	44.0	6250.0
2009-02-09	ABX-DELISTED	Stock	38.45	39.04	37.33	37.78	12348730.0
2009-02-09	ACAD	Stock	1.01	1.01	0.95	0.97	32700.0
2009-02-09	ACAP-DELISTED	Stock	42.97	44.73	42.41	44.38	55482.0
2009-02-09	ACAS-DELISTED	Stock	2.65	3.43	2.65	3.33	6826137.0
2009-02-09	ACAT-DELISTED	Stock	4.3	4.448	4.16	4.26	30317.0

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

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