PREVIEW / stock_daily / 2009-01-20

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-20.parquet
  size:    176 KB
  rows:    5,720
  symbols: 3,419

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-20	AAPL	Stock	2.9261	2.9286	2.7929	2.7929	919914800.0
2009-01-20	MSFT	Stock	19.46	19.62	18.37	18.48	89873000.0
2009-01-20	NVDA	Stock	0.1992	0.2	0.1788	0.1803	705788000.0
2009-01-20	AMZN	Stock	2.5375	2.585	2.4135	2.422	135344000.0
2009-01-20	TLT	Stock	112.29	114.63	112.23	114.28	3268419.0
2009-01-20	CL	Stock	31.73	32.155	31.25	31.28	8358400.0
2009-01-20	A	Stock	14.3133	14.3348	13.1974	13.269	7537457.0
2009-01-20	AABA-DELISTED	Stock	11.72	11.8	11.02	11.02	18002806.0
2009-01-20	AACC-DELISTED	Stock	4.81	4.81	4.37	4.37	58591.0
2009-01-20	AACG	Stock	3.61	3.84	3.5	3.84	7300.0
2009-01-20	AAI-DELISTED	Stock	4.48	4.48	4.17	4.23	1932172.0
2009-01-20	AAIC-DELISTED	Stock	4.0	4.0	3.4	3.4	317045.0
2009-01-20	AAME	Stock	0.75	0.75	0.75	0.75	5000.0
2009-01-20	AAON	Stock	3.676	3.6938	3.3719	3.3837	592819.0
2009-01-20	AAP	Stock	31.24	31.63	30.01	30.16	753400.0
2009-01-20	AATI-DELISTED	Stock	2.92	2.93	2.67	2.68	111717.0
2009-01-20	AAU-DELISTED	Stock	0.69	0.72	0.61	0.65	85535.0
2009-01-20	AAUAF-DELISTED	Stock	0.69	0.72	0.61	0.65	86435.0
2009-01-20	AAV-DELISTED	Stock	4.39	4.47	4.2	4.22	817848.0
2009-01-20	AAWW-DELISTED	Stock	17.75	17.8	16.28	16.48	225898.0
2009-01-20	AAXJ	Stock	30.84	30.84	29.29	29.51	38584.0
2009-01-20	AAXN-DELISTED	Stock	5.24	5.24	4.94	5.06	906853.0
2009-01-20	AB	Stock	17.94	18.4	16.46	16.55	569900.0
2009-01-20	ABAX-DELISTED	Stock	14.86	15.09	13.92	14.1	284857.0
2009-01-20	ABB-DELISTED	Stock	12.12	12.18	11.62	11.65	5081131.0
2009-01-20	ABBC-DELISTED	Stock	7.45	7.45	6.84	6.9	74433.0
2009-01-20	ABBNY-DELISTED	Stock	12.12	12.18	11.62	11.69	5082717.0
2009-01-20	ABC-DELISTED	Stock	18.8	18.96	18.14	18.3	6064206.0
2009-01-20	ABCB	Stock	9.2304	9.2304	7.4699	7.4699	45340.0
2009-01-20	ABCO-DELISTED	Stock	10.315	10.83	10.035	10.045	199336.0
2009-01-20	ABCW-DELISTED	Stock	2.36	2.53	2.15	2.15	155580.0
2009-01-20	ABD-DELISTED	Stock	2.85	2.89	2.37	2.41	361780.0
2009-01-20	ABE-DELISTED	Stock	12.53	12.53	11.8	11.8	9891.0
2009-01-20	ABEO	Stock	1212.5	1250.0	962.5	962.5	11.0
2009-01-20	ABFS-DELISTED	Stock	23.62	23.86	22.55	22.65	544917.0
2009-01-20	ABG	Stock	3.58	3.58	3.1	3.26	300800.0
2009-01-20	ABII-DELISTED	Stock	68.51	70.0	67.956	69.65	6957.0
2009-01-20	ABK-DELISTED	Stock	1.15	1.17	1.02	1.03	14689961.0
2009-01-20	ABM	Stock	17.67	17.67	16.38	16.45	489500.0
2009-01-20	ABMD-DELISTED	Stock	12.83	13.02	12.19	12.24	257630.0
2009-01-20	ABR	Stock	2.85	2.85	2.38	2.38	117700.0
2009-01-20	ABT	Stock	24.2011	24.537	23.5774	23.6062	20162359.0
2009-01-20	ABTL-DELISTED	Stock	2.0	2.398	1.9	2.0	4921.0
2009-01-20	ABV-DELISTED	Stock	41.86	41.86	38.73	39.0	727479.0
2009-01-20	ABVA-DELISTED	Stock	1.62	1.62	1.6199	1.6199	1600.0
2009-01-20	ABVT-DELISTED	Stock	30.25	30.25	30.0	30.0	7416.0
2009-01-20	ABX-DELISTED	Stock	34.42	36.4	33.98	34.8	22954620.0
2009-01-20	ACAD	Stock	1.16	1.19	1.03	1.05	48200.0
2009-01-20	ACAP-DELISTED	Stock	42.51	43.042	39.75	39.93	92640.0
2009-01-20	ACAS-DELISTED	Stock	4.35	4.53	3.62	3.66	3804312.0

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

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