PREVIEW / stock_daily / 2009-01-15

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-15.parquet
  size:    176 KB
  rows:    5,723
  symbols: 3,423

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-15	AAPL	Stock	2.8775	3.0043	2.8589	2.9779	1831634000.0
2009-01-15	MSFT	Stock	19.07	19.3	18.52	19.24	96169800.0
2009-01-15	NVDA	Stock	0.1838	0.1923	0.18	0.1893	998204000.0
2009-01-15	AMZN	Stock	2.428	2.6115	2.3815	2.572	232346000.0
2009-01-15	TLT	Stock	116.2	116.92	115.5766	116.09	2827282.0
2009-01-15	CL	Stock	31.37	31.625	30.835	31.53	6604400.0
2009-01-15	A	Stock	13.2117	13.834	13.0114	13.6767	9169901.0
2009-01-15	AABA-DELISTED	Stock	12.32	12.35	11.22	11.6	25573652.0
2009-01-15	AACC-DELISTED	Stock	4.57	4.98	4.5	4.95	57912.0
2009-01-15	AACG	Stock	3.92	3.92	3.26	3.66	36600.0
2009-01-15	AAI-DELISTED	Stock	4.03	4.46	3.79	4.29	3705118.0
2009-01-15	AAIC-DELISTED	Stock	3.8	4.0	3.012	3.2	894171.0
2009-01-15	AAME	Stock	0.76	0.8	0.76	0.8	300.0
2009-01-15	AAON	Stock	3.6089	3.7017	3.443	3.6998	692550.0
2009-01-15	AAP	Stock	30.13	31.12	29.5	30.59	1612400.0
2009-01-15	AATI-DELISTED	Stock	2.83	2.95	2.7	2.77	160075.0
2009-01-15	AAU-DELISTED	Stock	0.61	0.7	0.61	0.62	31390.0
2009-01-15	AAUAF-DELISTED	Stock	0.61	0.7	0.61	0.62	31615.0
2009-01-15	AAV-DELISTED	Stock	4.28	4.42	4.14	4.33	554937.0
2009-01-15	AAWW-DELISTED	Stock	18.55	19.47	17.2	18.95	248931.0
2009-01-15	AAXJ	Stock	30.97	31.344	29.83	30.67	36477.0
2009-01-15	AAXN-DELISTED	Stock	5.11	5.15	4.68	4.99	649071.0
2009-01-15	AB	Stock	18.6	19.32	17.75	18.37	517100.0
2009-01-15	ABAX-DELISTED	Stock	14.15	14.62	13.52	14.55	192887.0
2009-01-15	ABB-DELISTED	Stock	12.34	12.68	11.9	12.56	5828607.0
2009-01-15	ABBC-DELISTED	Stock	8.17	8.24	7.85	8.04	75442.0
2009-01-15	ABBNY-DELISTED	Stock	12.34	12.68	11.9	12.58	5829807.0
2009-01-15	ABC-DELISTED	Stock	18.56	18.61	18.035	18.4	5899424.0
2009-01-15	ABCB	Stock	9.2498	9.775	8.6663	9.7653	49453.0
2009-01-15	ABCO-DELISTED	Stock	9.965	10.315	9.8	10.3	163170.0
2009-01-15	ABCW-DELISTED	Stock	2.47	2.53	2.26	2.49	196500.0
2009-01-15	ABD-DELISTED	Stock	3.44	3.44	2.8	3.27	764430.0
2009-01-15	ABE-DELISTED	Stock	12.1	12.4	11.73	12.28	34688.0
2009-01-15	ABEO	Stock	1037.5	1037.5	1037.5	1037.5	1.0
2009-01-15	ABFS-DELISTED	Stock	23.92	24.75	22.97	24.26	566267.0
2009-01-15	ABG	Stock	3.56	4.17	3.45	4.17	346800.0
2009-01-15	ABII-DELISTED	Stock	66.5	72.1	66.5	70.0	23363.0
2009-01-15	ABK-DELISTED	Stock	1.19	1.25	1.0	1.2	15403726.0
2009-01-15	ABM	Stock	17.04	18.1	16.81	17.97	337900.0
2009-01-15	ABMD-DELISTED	Stock	12.78	13.17	12.31	13.13	209529.0
2009-01-15	ABR	Stock	2.75	3.3	2.67	2.95	297400.0
2009-01-15	ABT	Stock	23.7501	23.8029	23.112	23.6158	21325552.0
2009-01-15	ABTL-DELISTED	Stock	2.4253	2.6274	2.4	2.4	115124.0
2009-01-15	ABV-DELISTED	Stock	41.7	41.98	40.55	41.77	1421390.0
2009-01-15	ABVA-DELISTED	Stock	1.45	1.45	1.35	1.45	3780.0
2009-01-15	ABX-DELISTED	Stock	32.13	33.67	31.0	33.48	16383842.0
2009-01-15	ACAD	Stock	1.12	1.19	1.04	1.19	74300.0
2009-01-15	ACAP-DELISTED	Stock	41.39	43.0	40.69	42.29	59751.0
2009-01-15	ACAS-DELISTED	Stock	4.74	4.77	4.07	4.46	4501709.0
2009-01-15	ACAT-DELISTED	Stock	4.78	5.22	4.69	5.1	52328.0

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

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