PREVIEW / stock_daily / 2009-01-21

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-21.parquet
  size:    176 KB
  rows:    5,710
  symbols: 3,420

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-21	AAPL	Stock	2.8354	2.96	2.8325	2.9582	1089270000.0
2009-01-21	MSFT	Stock	18.87	19.45	18.46	19.38	68340900.0
2009-01-21	NVDA	Stock	0.1838	0.1903	0.177	0.189	648472000.0
2009-01-21	AMZN	Stock	2.4655	2.5345	2.4125	2.527	116590000.0
2009-01-21	TLT	Stock	111.93	113.04	110.4	110.67	2838093.0
2009-01-21	CL	Stock	31.505	31.785	30.98	31.715	6846800.0
2009-01-21	A	Stock	13.4549	13.8126	13.2904	13.7768	5641629.0
2009-01-21	AABA-DELISTED	Stock	11.17	11.58	11.08	11.56	15770042.0
2009-01-21	AACC-DELISTED	Stock	4.41	4.455	4.0	4.32	38897.0
2009-01-21	AACG	Stock	3.72	3.93	3.51	3.7	16100.0
2009-01-21	AAI-DELISTED	Stock	4.28	4.38	3.78	4.13	2547517.0
2009-01-21	AAIC-DELISTED	Stock	3.4	4.0	3.4	4.0	179516.0
2009-01-21	AAON	Stock	3.439	3.6504	3.2988	3.6385	676856.0
2009-01-21	AAP	Stock	30.22	31.55	29.79	31.48	1600800.0
2009-01-21	AATI-DELISTED	Stock	2.71	3.03	2.49	2.99	157582.0
2009-01-21	AAU-DELISTED	Stock	0.65	0.66	0.62	0.62	78444.0
2009-01-21	AAUAF-DELISTED	Stock	0.65	0.66	0.62	0.62	79144.0
2009-01-21	AAV-DELISTED	Stock	4.39	4.41	4.24	4.39	752912.0
2009-01-21	AAWW-DELISTED	Stock	16.71	17.7695	16.11	17.52	158285.0
2009-01-21	AAXJ	Stock	30.59	30.59	29.33	30.252	51741.0
2009-01-21	AAXN-DELISTED	Stock	5.02	5.15	4.76	5.14	584333.0
2009-01-21	AB	Stock	16.87	17.9	15.45	17.74	693300.0
2009-01-21	ABAX-DELISTED	Stock	14.16	14.5096	13.67	14.41	260539.0
2009-01-21	ABB-DELISTED	Stock	12.43	12.6	12.07	12.56	4836015.0
2009-01-21	ABBC-DELISTED	Stock	7.0	7.4	6.8	7.34	93259.0
2009-01-21	ABBNY-DELISTED	Stock	12.43	12.6	12.07	12.55	4987915.0
2009-01-21	ABC-DELISTED	Stock	18.47	18.67	18.12	18.57	7925304.0
2009-01-21	ABCB	Stock	7.606	8.355	7.2948	8.355	50275.0
2009-01-21	ABCO-DELISTED	Stock	10.138	10.383	9.837	10.097	149906.0
2009-01-21	ABCW-DELISTED	Stock	2.27	2.6113	2.14	2.56	160000.0
2009-01-21	ABD-DELISTED	Stock	2.45	2.54	1.85	2.23	750640.0
2009-01-21	ABE-DELISTED	Stock	11.65	12.28	11.65	12.28	23433.0
2009-01-21	ABEO	Stock	1000.0	1125.0	962.5	1125.0	2.0
2009-01-21	ABFS-DELISTED	Stock	22.9	24.06	22.51	23.86	591831.0
2009-01-21	ABG	Stock	3.3	3.58	3.17	3.54	314800.0
2009-01-21	ABII-DELISTED	Stock	70.0	70.5	64.55	67.8489	27651.0
2009-01-21	ABK-DELISTED	Stock	1.08	1.09	1.0	1.085	8966139.0
2009-01-21	ABM	Stock	16.65	17.08	15.66	17.06	592200.0
2009-01-21	ABMD-DELISTED	Stock	12.32	13.01	11.77	12.82	340479.0
2009-01-21	ABR	Stock	2.38	2.5	2.16	2.4	164400.0
2009-01-21	ABT	Stock	24.1339	25.1895	23.8605	25.1031	28385160.0
2009-01-21	ABTL-DELISTED	Stock	2.35	2.35	2.044	2.05	2500.0
2009-01-21	ABV-DELISTED	Stock	40.39	41.63	39.06	41.42	920512.0
2009-01-21	ABVA-DELISTED	Stock	1.45	1.45	1.45	1.45	600.0
2009-01-21	ABX-DELISTED	Stock	34.79	36.61	33.83	36.61	18077961.0
2009-01-21	ACAD	Stock	1.06	1.11	1.03	1.1	68700.0
2009-01-21	ACAP-DELISTED	Stock	40.5	41.62	38.1485	41.45	116431.0
2009-01-21	ACAS-DELISTED	Stock	3.7648	4.17	3.7547	4.16	3890556.0
2009-01-21	ACAT-DELISTED	Stock	5.01	5.25	4.807	5.25	29841.0
2009-01-21	ACC-DELISTED	Stock	19.522	20.83	18.813	20.74	1850104.0

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

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