PREVIEW / stock_daily / 2009-05-04

all stock daily files

  file:    by_date/stock_daily/2009/2009-05-04.parquet
  size:    181 KB
  rows:    5,806
  symbols: 3,473

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-05-04	AAPL	Stock	4.58	4.7232	4.56	4.7168	609358400.0
2009-05-04	MSFT	Stock	20.37	20.4	19.98	20.19	54313400.0
2009-05-04	NVDA	Stock	0.2968	0.3098	0.2928	0.3075	927704000.0
2009-05-04	AMZN	Stock	4.013	4.0675	3.9425	3.9885	140386000.0
2009-05-04	TLT	Stock	97.36	97.82	96.79	97.43	2246608.0
2009-05-04	ES	Stock	21.52	21.78	21.35	21.65	2483200.0
2009-05-04	CL	Stock	30.905	31.25	30.745	31.135	8247400.0
2009-05-04	A	Stock	13.4549	13.8913	13.412	13.8913	3885042.0
2009-05-04	AABA-DELISTED	Stock	14.2	14.25	13.96	14.18	24596334.0
2009-05-04	AACC-DELISTED	Stock	8.31	8.88	8.31	8.85	46863.0
2009-05-04	AACG	Stock	5.0	5.94	4.85	5.94	73800.0
2009-05-04	AAI-DELISTED	Stock	7.12	7.77	7.12	7.66	4200811.0
2009-05-04	AAIC-DELISTED	Stock	5.6	6.0	5.22	5.6	559986.0
2009-05-04	AAON	Stock	3.7965	3.8894	3.6879	3.842	408544.0
2009-05-04	AAP	Stock	42.84	44.01	42.63	43.78	1186600.0
2009-05-04	AATI-DELISTED	Stock	4.82	4.98	4.82	4.88	593405.0
2009-05-04	AAU-DELISTED	Stock	0.64	0.68	0.64	0.64	115073.0
2009-05-04	AAUAF-DELISTED	Stock	0.64	0.68	0.64	0.64	116073.0
2009-05-04	AAV-DELISTED	Stock	2.86	3.02	2.85	3.01	1062925.0
2009-05-04	AAWW-DELISTED	Stock	28.32	30.05	28.25	28.93	282592.0
2009-05-04	AAXJ	Stock	40.62	42.44	40.62	42.4299	237733.0
2009-05-04	AAXN-DELISTED	Stock	4.86	5.02	4.85	5.02	499224.0
2009-05-04	AB	Stock	18.1	19.48	17.59	19.35	673000.0
2009-05-04	ABAX-DELISTED	Stock	15.2	16.15	15.05	16.14	531643.0
2009-05-04	ABB-DELISTED	Stock	14.96	15.97	14.94	15.94	8317415.0
2009-05-04	ABBC-DELISTED	Stock	8.75	9.08	8.7	8.89	40980.0
2009-05-04	ABBNY-DELISTED	Stock	14.96	15.98	14.94	15.98	10402725.0
2009-05-04	ABC-DELISTED	Stock	17.14	17.55	17.13	17.55	3319697.0
2009-05-04	ABCB	Stock	6.5653	6.6723	6.361	6.6723	19637.0
2009-05-04	ABCO-DELISTED	Stock	9.485	9.665	9.19	9.265	321844.0
2009-05-04	ABCW-DELISTED	Stock	1.66	1.78	1.58	1.78	99110.0
2009-05-04	ABD-DELISTED	Stock	2.23	2.71	2.23	2.69	357300.0
2009-05-04	ABE-DELISTED	Stock	14.25	14.8	14.25	14.77	45964.0
2009-05-04	ABEO	Stock	1762.5	1875.0	1700.0	1762.5	3.0
2009-05-04	ABFS-DELISTED	Stock	23.74	25.38	23.72	25.23	712343.0
2009-05-04	ABG	Stock	10.18	10.81	9.74	10.15	820100.0
2009-05-04	ABII-DELISTED	Stock	47.8	49.8	46.9	49.78	13560.0
2009-05-04	ABK-DELISTED	Stock	0.94	0.98	0.92	0.9718	6254765.0
2009-05-04	ABM	Stock	17.68	17.76	16.98	17.43	208700.0
2009-05-04	ABMD-DELISTED	Stock	6.42	6.56	6.28	6.53	291679.0
2009-05-04	ABR	Stock	3.48	4.23	3.3	3.94	772900.0
2009-05-04	ABT	Stock	20.3291	20.7609	20.1996	20.7178	24357232.0
2009-05-04	ABTL-DELISTED	Stock	2.5025	2.5025	2.4775	2.4975	7327.0
2009-05-04	ABV-DELISTED	Stock	58.44	59.97	57.86	59.84	661913.0
2009-05-04	ABVA-DELISTED	Stock	2.25	2.3	2.18	2.3	6216.0
2009-05-04	ABVT-DELISTED	Stock	48.0	49.0	48.0	48.5	30724.0
2009-05-04	ABX-DELISTED	Stock	29.53	30.91	29.39	30.88	8060021.0
2009-05-04	ACAD	Stock	1.88	2.97	1.87	2.34	2927700.0
2009-05-04	ACAP-DELISTED	Stock	41.16	41.91	40.44	41.91	49047.0
2009-05-04	ACAS-DELISTED	Stock	4.1483	4.86	4.0971	4.64	11043575.0

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

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