PREVIEW / stock_daily / 2009-01-07

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-07.parquet
  size:    177 KB
  rows:    5,742
  symbols: 3,443

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-01-07	AAPL	Stock	3.2789	3.3036	3.2236	3.2504	753048800.0
2009-01-07	MSFT	Stock	20.19	20.29	19.48	19.51	72709900.0
2009-01-07	NVDA	Stock	0.224	0.224	0.2078	0.2155	870096000.0
2009-01-07	AMZN	Stock	2.8145	2.8475	2.7675	2.81	158854000.0
2009-01-07	TLT	Stock	111.96	112.68	111.4	112.65	2548854.0
2009-01-07	CL	Stock	32.925	33.23	32.79	32.96	6319000.0
2009-01-07	A	Stock	12.7682	13.2046	12.6538	13.0401	9974171.0
2009-01-07	AABA-DELISTED	Stock	12.75	13.16	12.45	12.72	23451445.0
2009-01-07	AACC-DELISTED	Stock	5.58	5.58	5.33	5.47	58244.0
2009-01-07	AACG	Stock	5.1	5.1	4.52	4.62	61600.0
2009-01-07	AAI-DELISTED	Stock	4.48	4.75	4.48	4.67	2060183.0
2009-01-07	AAIC-DELISTED	Stock	6.0	6.0	5.0	5.2	481718.0
2009-01-07	AAME	Stock	0.72	0.85	0.65	0.66	6300.0
2009-01-07	AAON	Stock	4.0889	4.0889	3.9486	4.0099	883406.0
2009-01-07	AAP	Stock	33.29	33.5	31.84	32.39	1919100.0
2009-01-07	AATI-DELISTED	Stock	3.03	3.44	3.0	3.28	546004.0
2009-01-07	AAU-DELISTED	Stock	0.75	0.75	0.7	0.701	66887.0
2009-01-07	AAUAF-DELISTED	Stock	0.75	0.75	0.7	0.701	68645.0
2009-01-07	AAV-DELISTED	Stock	5.07	5.07	4.7	4.72	900280.0
2009-01-07	AAWW-DELISTED	Stock	22.57	24.78	22.56	22.95	371702.0
2009-01-07	AAXJ	Stock	35.5	35.5	33.9301	34.29	27336.0
2009-01-07	AAXN-DELISTED	Stock	5.45	5.47	5.25	5.38	1051435.0
2009-01-07	AB	Stock	22.16	22.16	20.7	20.85	634100.0
2009-01-07	ABAX-DELISTED	Stock	17.03	17.03	15.45	15.45	724984.0
2009-01-07	ABB-DELISTED	Stock	15.07	15.08	14.57	14.72	5227979.0
2009-01-07	ABBC-DELISTED	Stock	9.08	9.08	8.75	8.8	128391.0
2009-01-07	ABBNY-DELISTED	Stock	15.07	15.08	14.57	14.71	5235806.0
2009-01-07	ABC-DELISTED	Stock	17.89	18.2	17.65	17.98	2922026.0
2009-01-07	ABCB	Stock	10.7575	11.0979	10.7575	10.7964	25395.0
2009-01-07	ABCO-DELISTED	Stock	11.002	11.192	10.858	10.978	125666.0
2009-01-07	ABCW-DELISTED	Stock	2.4	2.65	2.39	2.56	111260.0
2009-01-07	ABD-DELISTED	Stock	4.47	4.7	4.05	4.17	553510.0
2009-01-07	ABE-DELISTED	Stock	14.45	14.45	13.62	13.62	30460.0
2009-01-07	ABEO	Stock	1125.0	1125.0	1125.0	1125.0	2.0
2009-01-07	ABFS-DELISTED	Stock	29.87	29.87	28.3	28.52	563694.0
2009-01-07	ABG	Stock	4.73	5.03	4.52	4.73	384400.0
2009-01-07	ABII-DELISTED	Stock	68.54	70.2	68.1	69.5	27801.0
2009-01-07	ABK-DELISTED	Stock	1.42	1.45	1.33	1.34	7612794.0
2009-01-07	ABM	Stock	18.54	18.95	18.29	18.49	370300.0
2009-01-07	ABMD-DELISTED	Stock	14.93	15.09	14.54	14.71	229972.0
2009-01-07	ABR	Stock	3.29	3.3	2.94	3.01	232000.0
2009-01-07	ABT	Stock	24.1675	24.6521	24.11	24.2971	22917674.0
2009-01-07	ABTL-DELISTED	Stock	2.5	2.75	2.425	2.5	4844.0
2009-01-07	ABV-DELISTED	Stock	46.06	46.06	44.24	45.2	855606.0
2009-01-07	ABVA-DELISTED	Stock	1.485	1.79	1.45	1.45	2600.0
2009-01-07	ABVT-DELISTED	Stock	30.25	30.25	30.25	30.25	1000.0
2009-01-07	ABX-DELISTED	Stock	33.47	33.5	30.79	31.21	14892918.0
2009-01-07	ACAD	Stock	1.17	1.21	1.13	1.16	60900.0
2009-01-07	ACAP-DELISTED	Stock	45.5	45.97	44.85	45.13	65475.0
2009-01-07	ACAS-DELISTED	Stock	6.65	6.99	5.9	6.23	12360556.0

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

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