PREVIEW / stock_daily / 2009-01-29

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-29.parquet
  size:    174 KB
  rows:    5,677
  symbols: 3,394

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-29	AAPL	Stock	3.3246	3.3693	3.3071	3.3214	592729200.0
2009-01-29	MSFT	Stock	17.78	17.96	17.56	17.59	49192800.0
2009-01-29	NVDA	Stock	0.2125	0.215	0.206	0.207	413128000.0
2009-01-29	AMZN	Stock	2.498	2.5925	2.457	2.5	359336000.0
2009-01-29	TLT	Stock	105.56	106.31	103.66	104.08	3724397.0
2009-01-29	CL	Stock	32.25	33.5	32.215	32.61	10304400.0
2009-01-29	A	Stock	13.4335	13.4835	13.1831	13.2833	4583623.0
2009-01-29	AABA-DELISTED	Stock	12.05	12.24	11.73	11.74	24351589.0
2009-01-29	AACC-DELISTED	Stock	4.39	4.59	4.26	4.29	29706.0
2009-01-29	AACG	Stock	3.88	3.92	3.49	3.58	6900.0
2009-01-29	AAI-DELISTED	Stock	4.49	4.85	4.41	4.49	3919890.0
2009-01-29	AAIC-DELISTED	Stock	4.0	4.4	3.6	3.6	295920.0
2009-01-29	AAME	Stock	0.81	0.95	0.71	0.71	1500.0
2009-01-29	AAON	Stock	3.7531	3.7531	3.5852	3.6089	225281.0
2009-01-29	AAP	Stock	34.04	34.39	33.25	33.37	1025600.0
2009-01-29	AATI-DELISTED	Stock	3.39	3.48	3.24	3.29	90529.0
2009-01-29	AAU-DELISTED	Stock	0.72	0.8099	0.7	0.78	266230.0
2009-01-29	AAUAF-DELISTED	Stock	0.72	0.8099	0.7	0.78	266530.0
2009-01-29	AAV-DELISTED	Stock	4.36	4.36	4.22	4.25	400603.0
2009-01-29	AAWW-DELISTED	Stock	17.18	17.56	15.67	15.78	150701.0
2009-01-29	AAXJ	Stock	32.44	32.44	30.58	31.245	26994.0
2009-01-29	AAXN-DELISTED	Stock	5.26	5.41	5.14	5.25	481430.0
2009-01-29	AB	Stock	19.13	19.13	17.59	17.68	475400.0
2009-01-29	ABAX-DELISTED	Stock	14.54	14.75	14.01	14.01	269252.0
2009-01-29	ABB-DELISTED	Stock	12.97	13.23	12.81	12.94	5111041.0
2009-01-29	ABBC-DELISTED	Stock	7.5	7.5	6.76	7.49	110101.0
2009-01-29	ABBNY-DELISTED	Stock	12.97	13.23	12.81	12.94	5122541.0
2009-01-29	ABC-DELISTED	Stock	18.82	18.92	17.99	18.5	3141536.0
2009-01-29	ABCB	Stock	9.2985	9.6486	8.8803	9.3471	26526.0
2009-01-29	ABCO-DELISTED	Stock	8.965	9.105	8.895	8.93	183729.0
2009-01-29	ABCW-DELISTED	Stock	2.2873	2.2873	2.0606	2.1	154500.0
2009-01-29	ABD-DELISTED	Stock	1.64	2.0	1.61	1.92	300960.0
2009-01-29	ABE-DELISTED	Stock	12.35	12.9	12.26	12.5	10654.0
2009-01-29	ABEO	Stock	1125.0	1125.0	1025.0	1125.0	5.0
2009-01-29	ABFS-DELISTED	Stock	21.09	24.63	20.69	23.85	2156422.0
2009-01-29	ABG	Stock	4.09	4.11	3.62	3.64	180900.0
2009-01-29	ABII-DELISTED	Stock	66.47	69.12	64.9601	67.0	21841.0
2009-01-29	ABK-DELISTED	Stock	1.2	1.42	1.16	1.24	15297148.0
2009-01-29	ABM	Stock	16.35	16.35	15.59	15.63	165200.0
2009-01-29	ABMD-DELISTED	Stock	14.03	14.08	13.44	13.55	317732.0
2009-01-29	ABR	Stock	2.01	2.19	1.91	2.03	162300.0
2009-01-29	ABT	Stock	26.1923	26.6193	26.0435	26.5857	29034806.0
2009-01-29	ABTL-DELISTED	Stock	1.7	2.0	1.7	1.95	1421.0
2009-01-29	ABV-DELISTED	Stock	41.09	41.5	40.59	40.76	656229.0
2009-01-29	ABVA-DELISTED	Stock	1.64	1.65	1.25	1.26	2975.0
2009-01-29	ABX-DELISTED	Stock	35.7	38.86	35.59	38.55	18792636.0
2009-01-29	ACAD	Stock	1.16	1.16	1.02	1.02	40600.0
2009-01-29	ACAP-DELISTED	Stock	43.18	43.62	42.18	42.72	69655.0
2009-01-29	ACAS-DELISTED	Stock	3.94	3.94	3.07	3.14	6225568.0
2009-01-29	ACAT-DELISTED	Stock	4.2	4.5	4.2	4.34	50610.0

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

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