PREVIEW / stock_daily / 2009-04-01

all stock daily files

  file:    by_date/stock_daily/2009/2009-04-01.parquet
  size:    174 KB
  rows:    5,711
  symbols: 3,411

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-04-01	AAPL	Stock	3.7175	3.8929	3.7104	3.8818	589372000.0
2009-04-01	MSFT	Stock	18.23	19.36	18.18	19.31	96438900.0
2009-04-01	NVDA	Stock	0.2435	0.255	0.2342	0.2527	887920000.0
2009-04-01	AMZN	Stock	3.651	3.7545	3.5855	3.675	140828000.0
2009-04-01	TLT	Stock	106.12	106.56	105.5273	106.37	2383328.0
2009-04-01	ES	Stock	21.38	21.66	21.1	21.4	1829100.0
2009-04-01	CL	Stock	29.065	29.53	28.5	29.4	10762400.0
2009-04-01	A	Stock	10.8155	11.5379	10.7439	11.4449	5530768.0
2009-04-01	AABA-DELISTED	Stock	12.63	13.12	12.6	12.74	14110649.0
2009-04-01	AACC-DELISTED	Stock	5.22	6.34	5.22	5.8	53976.0
2009-04-01	AACG	Stock	4.25	4.6	4.25	4.58	41500.0
2009-04-01	AAI-DELISTED	Stock	4.48	4.85	4.4	4.792	1842331.0
2009-04-01	AAIC-DELISTED	Stock	4.0	4.2	3.8	4.2	280517.0
2009-04-01	AAME	Stock	0.56	0.58	0.46	0.46	24400.0
2009-04-01	AAON	Stock	3.4963	3.6662	3.4469	3.6207	459169.0
2009-04-01	AAP	Stock	40.52	42.24	40.4	42.09	1973000.0
2009-04-01	AATI-DELISTED	Stock	3.54	3.74	3.53	3.73	179778.0
2009-04-01	AAU-DELISTED	Stock	0.77	0.78	0.77	0.77	33602.0
2009-04-01	AAUAF-DELISTED	Stock	0.77	0.78	0.77	0.77	33702.0
2009-04-01	AAV-DELISTED	Stock	2.4	2.48	2.2801	2.43	878769.0
2009-04-01	AAWW-DELISTED	Stock	17.04	18.05	16.55	17.96	191620.0
2009-04-01	AAXJ	Stock	33.37	34.31	33.26	34.25	71178.0
2009-04-01	AAXN-DELISTED	Stock	4.56	4.88	4.4	4.76	575729.0
2009-04-01	AB	Stock	14.39	15.65	14.28	15.2	427700.0
2009-04-01	ABAX-DELISTED	Stock	17.18	17.76	16.75	17.49	226359.0
2009-04-01	ABB-DELISTED	Stock	13.63	14.4202	13.63	14.34	4200476.0
2009-04-01	ABBC-DELISTED	Stock	8.16	8.51	7.52	8.24	58562.0
2009-04-01	ABBNY-DELISTED	Stock	13.63	14.4202	13.63	14.33	4203226.0
2009-04-01	ABC-DELISTED	Stock	16.18	16.42	15.9	16.34	3422996.0
2009-04-01	ABCB	Stock	4.5423	5.1453	4.4061	5.1453	23338.0
2009-04-01	ABCO-DELISTED	Stock	8.195	8.81	8.02	8.52	171744.0
2009-04-01	ABCW-DELISTED	Stock	1.35	1.4	1.19	1.33	110760.0
2009-04-01	ABD-DELISTED	Stock	0.9864	1.2203	0.9864	1.2	230150.0
2009-04-01	ABE-DELISTED	Stock	12.2099	12.5968	11.91	12.56	20409.0
2009-04-01	ABEO	Stock	1937.5	1937.5	1875.0	1875.0	1.0
2009-04-01	ABFS-DELISTED	Stock	18.81	19.27	18.27	19.18	410158.0
2009-04-01	ABG	Stock	4.18	4.98	3.94	4.74	351400.0
2009-04-01	ABII-DELISTED	Stock	47.3	48.82	46.32	48.03	17997.0
2009-04-01	ABK-DELISTED	Stock	0.7646	0.84	0.71	0.8299	3840342.0
2009-04-01	ABM	Stock	16.1	16.1	15.49	15.75	401200.0
2009-04-01	ABMD-DELISTED	Stock	4.84	5.06	4.78	4.95	406622.0
2009-04-01	ABR	Stock	0.8	0.8	0.69	0.73	177500.0
2009-04-01	ABT	Stock	22.6082	22.613	22.0708	22.4067	25387453.0
2009-04-01	ABTL-DELISTED	Stock	1.4	1.4	1.25	1.35	5509.0
2009-04-01	ABV-DELISTED	Stock	47.3	49.33	47.2	49.02	543737.0
2009-04-01	ABVA-DELISTED	Stock	1.97	1.98	1.97	1.98	800.0
2009-04-01	ABVT-DELISTED	Stock	45.0	45.0	44.0	44.0	200.0
2009-04-01	ABX-DELISTED	Stock	33.07	34.04	32.82	33.89	10771051.0
2009-04-01	ACAD	Stock	0.95	1.08	0.93	1.08	108700.0
2009-04-01	ACAP-DELISTED	Stock	39.0	42.05	39.0	41.2	68651.0

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

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