PREVIEW / stock_daily / 2009-02-04

all stock daily files

  file:    by_date/stock_daily/2009/2009-02-04.parquet
  size:    174 KB
  rows:    5,696
  symbols: 3,406

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-02-04	AAPL	Stock	3.3293	3.4375	3.325	3.3411	808421600.0
2009-02-04	MSFT	Stock	18.54	19.0	18.5	18.63	75618000.0
2009-02-04	NVDA	Stock	0.2125	0.2288	0.2125	0.218	779232000.0
2009-02-04	AMZN	Stock	3.169	3.172	3.0415	3.053	274526000.0
2009-02-04	TLT	Stock	102.75	102.87	101.62	102.52	2305310.0
2009-02-04	CL	Stock	33.04	33.44	31.865	32.03	8991200.0
2009-02-04	A	Stock	13.0615	13.5551	13.0186	13.2189	3865051.0
2009-02-04	AABA-DELISTED	Stock	12.65	13.23	12.55	13.0	22845654.0
2009-02-04	AACC-DELISTED	Stock	4.55	4.85	4.55	4.69	49445.0
2009-02-04	AAI-DELISTED	Stock	4.2	4.35	4.04	4.05	2720907.0
2009-02-04	AAIC-DELISTED	Stock	4.4	4.4	4.0	4.0	358937.0
2009-02-04	AAON	Stock	3.6207	3.7511	3.6207	3.6385	247556.0
2009-02-04	AAP	Stock	33.89	34.0	32.9	33.38	1947500.0
2009-02-04	AATI-DELISTED	Stock	3.3	3.5	3.18	3.22	225922.0
2009-02-04	AAU-DELISTED	Stock	0.77	0.77	0.7	0.74	96275.0
2009-02-04	AAUAF-DELISTED	Stock	0.77	0.77	0.7	0.74	97275.0
2009-02-04	AAV-DELISTED	Stock	3.99	3.99	3.86	3.9	744530.0
2009-02-04	AAWW-DELISTED	Stock	11.68	13.69	11.67	12.97	288921.0
2009-02-04	AAXJ	Stock	31.11	31.944	31.11	31.29	30568.0
2009-02-04	AAXN-DELISTED	Stock	5.47	5.6	5.36	5.52	721202.0
2009-02-04	AB	Stock	17.0	17.33	16.25	16.53	493500.0
2009-02-04	ABAX-DELISTED	Stock	17.22	17.93	17.01	17.52	203028.0
2009-02-04	ABB-DELISTED	Stock	13.24	13.55	13.07	13.14	3781455.0
2009-02-04	ABBC-DELISTED	Stock	7.03	7.06	6.58	6.63	121381.0
2009-02-04	ABBNY-DELISTED	Stock	13.24	13.55	13.07	13.13	3790955.0
2009-02-04	ABC-DELISTED	Stock	18.86	19.1517	18.67	18.96	3696640.0
2009-02-04	ABCB	Stock	7.8297	8.2091	7.7131	7.7909	34442.0
2009-02-04	ABCO-DELISTED	Stock	8.752	9.023	8.727	8.828	180340.0
2009-02-04	ABCW-DELISTED	Stock	1.93	1.98	1.5972	1.64	198850.0
2009-02-04	ABD-DELISTED	Stock	2.11	2.12	1.6896	1.75	223760.0
2009-02-04	ABE-DELISTED	Stock	12.3	12.61	12.29	12.61	48706.0
2009-02-04	ABEO	Stock	1062.5	1062.5	1000.0	1000.0	5.0
2009-02-04	ABFS-DELISTED	Stock	24.66	25.2	23.9	23.9	314376.0
2009-02-04	ABG	Stock	3.49	3.61	3.25	3.28	139200.0
2009-02-04	ABII-DELISTED	Stock	70.0	71.64	69.65	70.5	17980.0
2009-02-04	ABK-DELISTED	Stock	1.09	1.11	1.04	1.04	5259117.0
2009-02-04	ABM	Stock	14.69	15.1	14.18	14.33	331800.0
2009-02-04	ABMD-DELISTED	Stock	13.09	13.53	12.75	12.84	192337.0
2009-02-04	ABR	Stock	1.88	1.88	1.58	1.63	141700.0
2009-02-04	ABT	Stock	27.4206	27.4925	26.7536	26.8256	23438724.0
2009-02-04	ABTL-DELISTED	Stock	2.15	2.2	1.75	1.95	1631.0
2009-02-04	ABV-DELISTED	Stock	42.66	44.2	42.2	42.48	773053.0
2009-02-04	ABVA-DELISTED	Stock	1.1	1.1	1.1	1.1	1900.0
2009-02-04	ABX-DELISTED	Stock	36.69	37.6	36.41	37.08	12616556.0
2009-02-04	ACAD	Stock	1.0	1.03	0.99	0.99	30400.0
2009-02-04	ACAP-DELISTED	Stock	44.98	45.36	43.0	43.56	57442.0
2009-02-04	ACAS-DELISTED	Stock	2.69	2.7	2.28	2.45	4793561.0
2009-02-04	ACAT-DELISTED	Stock	4.06	4.59	4.06	4.24	25432.0
2009-02-04	ACC-DELISTED	Stock	21.39	21.89	20.84	20.88	809132.0
2009-02-04	ACCL-DELISTED	Stock	4.06	4.29	3.98	4.09	85181.0

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

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