PREVIEW / stock_daily / 2009-03-20

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-20.parquet
  size:    174 KB
  rows:    5,704
  symbols: 3,400

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-03-20	AAPL	Stock	3.6461	3.6825	3.5918	3.6282	695587200.0
2009-03-20	MSFT	Stock	17.32	17.65	16.88	17.06	81725500.0
2009-03-20	NVDA	Stock	0.2558	0.256	0.2318	0.2382	1093672000.0
2009-03-20	AMZN	Stock	3.5195	3.5445	3.454	3.498	169362000.0
2009-03-20	TLT	Stock	104.62	105.0	103.7801	103.92	3479670.0
2009-03-20	ES	Stock	21.66	22.03	21.58	21.68	4792200.0
2009-03-20	CL	Stock	28.685	29.275	28.675	28.685	7520800.0
2009-03-20	A	Stock	10.5508	10.6938	10.2217	10.3219	5937026.0
2009-03-20	AABA-DELISTED	Stock	13.63	13.87	13.51	13.59	21655603.0
2009-03-20	AACC-DELISTED	Stock	5.26	5.33	4.9	5.08	73633.0
2009-03-20	AACG	Stock	4.4	4.49	3.8	3.92	2800.0
2009-03-20	AAI-DELISTED	Stock	3.7	3.9	3.6	3.6	1935423.0
2009-03-20	AAIC-DELISTED	Stock	4.0	4.0	3.6	3.6	854954.0
2009-03-20	AAON	Stock	3.676	3.676	3.4627	3.5062	431831.0
2009-03-20	AAP	Stock	41.4	41.4	39.54	40.01	1727600.0
2009-03-20	AATI-DELISTED	Stock	3.63	3.71	3.29	3.36	290450.0
2009-03-20	AAU-DELISTED	Stock	0.8462	0.8462	0.75	0.819	92426.0
2009-03-20	AAUAF-DELISTED	Stock	0.8462	0.8462	0.75	0.819	93976.0
2009-03-20	AAV-DELISTED	Stock	2.44	2.45	2.07	2.22	2734399.0
2009-03-20	AAWW-DELISTED	Stock	17.16	17.17	15.89	16.27	368825.0
2009-03-20	AAXJ	Stock	32.13	32.13	31.04	31.14	43717.0
2009-03-20	AAXN-DELISTED	Stock	4.27	4.3	4.01	4.1	674475.0
2009-03-20	AB	Stock	13.12	13.39	12.4	12.52	368000.0
2009-03-20	ABAX-DELISTED	Stock	18.0	18.09	17.41	17.47	171157.0
2009-03-20	ABB-DELISTED	Stock	13.66	13.88	13.45	13.52	3574264.0
2009-03-20	ABBC-DELISTED	Stock	8.73	8.95	8.63	8.78	137555.0
2009-03-20	ABBNY-DELISTED	Stock	13.62	13.88	13.45	13.51	3574501.0
2009-03-20	ABC-DELISTED	Stock	15.36	15.4	15.145	15.28	4994188.0
2009-03-20	ABCB	Stock	6.4389	6.4389	5.1745	5.1745	47705.0
2009-03-20	ABCO-DELISTED	Stock	7.75	7.885	7.515	7.58	178330.0
2009-03-20	ABCW-DELISTED	Stock	0.83	0.85	0.7	0.85	226770.0
2009-03-20	ABD-DELISTED	Stock	1.25	1.52	1.19	1.27	669210.0
2009-03-20	ABE-DELISTED	Stock	11.94	12.11	11.94	12.03	15719.0
2009-03-20	ABEO	Stock	1937.5	2000.0	1812.5	2000.0	16.0
2009-03-20	ABFS-DELISTED	Stock	19.9	19.9	18.39	18.61	835724.0
2009-03-20	ABG	Stock	3.95	4.2	3.7	3.93	664400.0
2009-03-20	ABII-DELISTED	Stock	47.51	50.1	46.56	49.99	17717.0
2009-03-20	ABK-DELISTED	Stock	0.86	0.88	0.68	0.74	10833719.0
2009-03-20	ABM	Stock	16.47	16.71	16.01	16.09	419600.0
2009-03-20	ABMD-DELISTED	Stock	5.4	5.55	4.87	5.04	541387.0
2009-03-20	ABR	Stock	1.2	1.37	1.01	1.01	417100.0
2009-03-20	ABT	Stock	23.0304	23.1456	22.6801	22.8097	19830763.0
2009-03-20	ABTL-DELISTED	Stock	1.2005	1.425	1.15	1.1995	28183.0
2009-03-20	ABV-DELISTED	Stock	45.98	47.13	45.53	46.6	937012.0
2009-03-20	ABVA-DELISTED	Stock	1.65	1.65	1.641	1.6499	4015.0
2009-03-20	ABVT-DELISTED	Stock	46.0	46.0	45.0	45.0	3063.0
2009-03-20	ABX-DELISTED	Stock	32.97	33.96	32.8	33.31	13486576.0
2009-03-20	ACAD	Stock	1.02	1.02	0.91	0.93	122900.0
2009-03-20	ACAP-DELISTED	Stock	43.1	43.15	41.57	42.23	133924.0
2009-03-20	ACAS-DELISTED	Stock	1.06	1.22	1.055	1.19	4863113.0

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

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