PREVIEW / stock_daily / 2009-08-07

all stock daily files

  file:    by_date/stock_daily/2009/2009-08-07.parquet
  size:    185 KB
  rows:    5,821
  symbols: 3,465

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-08-07	AAPL	Stock	5.9104	5.95	5.8857	5.9111	387354800.0
2009-08-07	MSFT	Stock	23.75	23.82	23.5	23.56	46169700.0
2009-08-07	NVDA	Stock	0.3458	0.3558	0.338	0.3428	1401872000.0
2009-08-07	AMZN	Stock	4.205	4.298	4.205	4.266	112560000.0
2009-08-07	TLT	Stock	90.42	90.93	90.219	90.49	3543111.0
2009-08-07	ES	Stock	23.05	23.51	22.86	23.38	1281700.0
2009-08-07	CL	Stock	35.83	36.05	35.44	35.51	5716800.0
2009-08-07	A	Stock	16.917	17.0529	16.8026	16.9742	3289774.0
2009-08-07	AABA-DELISTED	Stock	14.86	14.9	14.56	14.61	28243740.0
2009-08-07	AACC-DELISTED	Stock	7.44	7.729	7.31	7.55	48158.0
2009-08-07	AACG	Stock	7.9	8.01	7.9	7.9	1700.0
2009-08-07	AAI-DELISTED	Stock	6.86	7.07	6.76	6.95	1931580.0
2009-08-07	AAIC-DELISTED	Stock	9.2	9.4	9.2	9.2	328060.0
2009-08-07	AAME	Stock	0.83	0.84	0.83	0.84	1000.0
2009-08-07	AAON	Stock	4.0573	4.1877	4.0138	4.1086	368044.0
2009-08-07	AAP	Stock	45.87	47.08	45.51	46.96	1022400.0
2009-08-07	AATI-DELISTED	Stock	4.73	4.78	4.64	4.69	107224.0
2009-08-07	AAU-DELISTED	Stock	0.62	0.66	0.62	0.66	63114.0
2009-08-07	AAUAF-DELISTED	Stock	0.62	0.66	0.62	0.66	63514.0
2009-08-07	AAV-DELISTED	Stock	5.17	5.31	4.97	5.13	859078.0
2009-08-07	AAWW-DELISTED	Stock	28.05	28.74	28.05	28.1	628660.0
2009-08-07	AAXJ	Stock	50.5	50.5063	49.79	50.26	675899.0
2009-08-07	AAXN-DELISTED	Stock	5.09	5.22	5.0	5.18	493942.0
2009-08-07	AB	Stock	21.15	21.72	20.27	21.42	948900.0
2009-08-07	ABAX-DELISTED	Stock	27.25	27.81	27.1701	27.61	258470.0
2009-08-07	ABB-DELISTED	Stock	18.38	18.5	18.2	18.33	2275477.0
2009-08-07	ABBC-DELISTED	Stock	8.2	8.35	8.01	8.28	56117.0
2009-08-07	ABBNY-DELISTED	Stock	18.38	18.5	18.2	18.33	2281977.0
2009-08-07	ABC-DELISTED	Stock	20.62	20.62	20.24	20.33	5216850.0
2009-08-07	ABCB	Stock	6.4584	6.7113	6.4097	6.6918	24161.0
2009-08-07	ABCO-DELISTED	Stock	13.078	13.915	12.848	13.677	342759.0
2009-08-07	ABCW-DELISTED	Stock	1.4923	1.6078	1.4923	1.5877	153590.0
2009-08-07	ABD-DELISTED	Stock	4.53	5.06	4.44	4.83	741500.0
2009-08-07	ABE-DELISTED	Stock	16.89	16.95	16.64	16.85	16700.0
2009-08-07	ABEO	Stock	5875.0	5950.0	5487.5	5750.0	16.0
2009-08-07	ABFS-DELISTED	Stock	27.45	28.99	27.05	28.74	682249.0
2009-08-07	ABG	Stock	13.82	14.42	13.66	14.17	235700.0
2009-08-07	ABII-DELISTED	Stock	31.11	31.52	30.45	31.52	23610.0
2009-08-07	ABK-DELISTED	Stock	1.1	1.19	1.01	1.03	48053548.0
2009-08-07	ABM	Stock	21.39	22.36	21.35	22.0	353700.0
2009-08-07	ABMD-DELISTED	Stock	7.21	7.55	6.87	7.3	280419.0
2009-08-07	ABR	Stock	2.12	2.12	1.82	2.05	615800.0
2009-08-07	ABT	Stock	21.092	21.1256	20.9769	21.0344	14732805.0
2009-08-07	ABTL-DELISTED	Stock	2.5	2.5	2.4	2.45	7135.0
2009-08-07	ABV-DELISTED	Stock	74.7	75.07	73.61	73.81	419285.0
2009-08-07	ABVT-DELISTED	Stock	85.94	87.3399	85.0	86.71	45721.0
2009-08-07	ABX-DELISTED	Stock	35.51	35.86	34.71	34.74	7170775.0
2009-08-07	ACAD	Stock	4.5	4.76	4.37	4.62	1302500.0
2009-08-07	ACAP-DELISTED	Stock	32.99	33.5	31.53	32.67	86989.0
2009-08-07	ACAS-DELISTED	Stock	2.93	3.1	2.85	3.08	7802762.0

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

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