PREVIEW / stock_daily / 2009-01-13

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-13.parquet
  size:    176 KB
  rows:    5,743
  symbols: 3,431

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-13	AAPL	Stock	3.1514	3.205	3.0839	3.1325	798397600.0
2009-01-13	MSFT	Stock	19.52	19.99	19.52	19.82	65843500.0
2009-01-13	NVDA	Stock	0.1838	0.1985	0.1803	0.1913	1824424000.0
2009-01-13	AMZN	Stock	2.548	2.6645	2.5375	2.5725	157664000.0
2009-01-13	TLT	Stock	113.5	114.08	112.96	114.02	1767358.0
2009-01-13	CL	Stock	32.825	33.035	31.995	32.225	7967000.0
2009-01-13	A	Stock	13.0186	13.8484	13.0186	13.6338	9102238.0
2009-01-13	AABA-DELISTED	Stock	12.09	12.79	11.78	12.1	25601391.0
2009-01-13	AACC-DELISTED	Stock	4.62	5.06	4.56	5.06	61020.0
2009-01-13	AACG	Stock	4.25	4.49	4.02	4.06	38900.0
2009-01-13	AAI-DELISTED	Stock	4.39	4.4908	4.27	4.38	1584123.0
2009-01-13	AAIC-DELISTED	Stock	5.002	5.4	4.4	4.4	447037.0
2009-01-13	AAME	Stock	0.77	0.84	0.75	0.75	7500.0
2009-01-13	AAON	Stock	3.9091	3.9091	3.7531	3.7946	644962.0
2009-01-13	AAP	Stock	30.67	31.27	30.46	31.12	1141800.0
2009-01-13	AATI-DELISTED	Stock	2.97	3.08	2.97	3.06	180476.0
2009-01-13	AAU-DELISTED	Stock	0.72	0.72	0.65	0.65	41100.0
2009-01-13	AAUAF-DELISTED	Stock	0.72	0.72	0.65	0.65	41200.0
2009-01-13	AAV-DELISTED	Stock	4.49	4.6399	4.37	4.53	512601.0
2009-01-13	AAWW-DELISTED	Stock	21.34	21.93	20.16	20.62	243076.0
2009-01-13	AAXJ	Stock	31.32	32.1699	31.32	31.74	39110.0
2009-01-13	AAXN-DELISTED	Stock	5.16	5.31	5.03	5.21	642838.0
2009-01-13	AB	Stock	20.01	20.52	19.51	20.07	287400.0
2009-01-13	ABAX-DELISTED	Stock	14.55	14.92	14.53	14.85	156950.0
2009-01-13	ABB-DELISTED	Stock	12.91	13.19	12.88	13.12	4008550.0
2009-01-13	ABBC-DELISTED	Stock	8.5	8.73	8.5	8.7	39085.0
2009-01-13	ABBNY-DELISTED	Stock	12.91	13.19	12.88	13.09	4008786.0
2009-01-13	ABC-DELISTED	Stock	17.92	18.18	17.8	18.02	3203672.0
2009-01-13	ABCB	Stock	9.8237	10.3586	9.775	9.9696	26114.0
2009-01-13	ABCO-DELISTED	Stock	10.41	10.525	10.19	10.435	112595.0
2009-01-13	ABCW-DELISTED	Stock	2.6711	2.7997	2.5919	2.77	164210.0
2009-01-13	ABD-DELISTED	Stock	3.41	3.75	3.27	3.57	295200.0
2009-01-13	ABE-DELISTED	Stock	12.81	13.0	12.48	12.8757	29055.0
2009-01-13	ABEO	Stock	1100.0	1100.0	1100.0	1100.0	8.0
2009-01-13	ABFS-DELISTED	Stock	25.17	26.03	24.84	25.47	436663.0
2009-01-13	ABG	Stock	4.35	4.71	4.23	4.55	212700.0
2009-01-13	ABII-DELISTED	Stock	66.5	69.97	66.5	69.97	5216.0
2009-01-13	ABK-DELISTED	Stock	1.32	1.37	1.22	1.25	14919707.0
2009-01-13	ABM	Stock	17.93	18.31	17.66	18.01	332300.0
2009-01-13	ABMD-DELISTED	Stock	13.16	13.73	12.95	13.36	327969.0
2009-01-13	ABR	Stock	2.74	2.9	2.74	2.87	49300.0
2009-01-13	ABT	Stock	23.7453	24.1771	23.587	24.0188	17532305.0
2009-01-13	ABTL-DELISTED	Stock	2.5	2.55	2.45	2.5	3140.0
2009-01-13	ABV-DELISTED	Stock	42.99	44.41	42.68	43.43	519081.0
2009-01-13	ABVA-DELISTED	Stock	1.5	1.5	1.45	1.45	5032.0
2009-01-13	ABX-DELISTED	Stock	31.2	32.95	30.92	32.7	16914320.0
2009-01-13	ACAD	Stock	1.16	1.23	1.05	1.14	155500.0
2009-01-13	ACAP-DELISTED	Stock	43.49	45.0	43.02	44.9	48839.0
2009-01-13	ACAS-DELISTED	Stock	4.95	5.59	4.55	5.2	5165090.0
2009-01-13	ACAT-DELISTED	Stock	5.06	5.22	4.99	4.99	26883.0

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

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