PREVIEW / stock_daily / 2009-06-26

all stock daily files

  file:    by_date/stock_daily/2009/2009-06-26.parquet
  size:    181 KB
  rows:    5,739
  symbols: 3,420

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-06-26	AAPL	Stock	4.9925	5.1271	4.9907	5.0871	439384400.0
2009-06-26	MSFT	Stock	23.57	23.69	23.32	23.35	65126400.0
2009-06-26	NVDA	Stock	0.2842	0.2902	0.2818	0.2892	513956000.0
2009-06-26	AMZN	Stock	4.095	4.207	4.0565	4.194	175506000.0
2009-06-26	TLT	Stock	94.62	94.9	94.21	94.59	4050306.0
2009-06-26	ES	Stock	22.14	22.19	21.75	22.12	1305800.0
2009-06-26	CL	Stock	35.62	36.095	35.56	35.88	5538600.0
2009-06-26	A	Stock	14.2275	14.628	14.1488	14.578	4788569.0
2009-06-26	AABA-DELISTED	Stock	15.6	15.8	15.48	15.72	25346235.0
2009-06-26	AACC-DELISTED	Stock	8.46	8.5	8.23	8.47	273640.0
2009-06-26	AACG	Stock	9.71	9.72	9.2	9.5	10600.0
2009-06-26	AAI-DELISTED	Stock	5.79	6.06	5.71	5.96	4195030.0
2009-06-26	AAIC-DELISTED	Stock	8.2	9.0	6.4	6.4	14353948.0
2009-06-26	AAON	Stock	3.9249	4.0336	3.7432	4.0059	766462.0
2009-06-26	AAP	Stock	42.08	42.42	41.66	41.77	1181800.0
2009-06-26	AATI-DELISTED	Stock	4.58	4.65	4.52	4.61	576681.0
2009-06-26	AAU-DELISTED	Stock	0.6997	0.7	0.66	0.6603	32885.0
2009-06-26	AAUAF-DELISTED	Stock	0.7	0.7	0.66	0.6606	32972.0
2009-06-26	AAV-DELISTED	Stock	4.49	4.49	4.2699	4.37	987495.0
2009-06-26	AAWW-DELISTED	Stock	22.47	24.05	21.38	24.01	905969.0
2009-06-26	AAXJ	Stock	44.48	44.63	44.2	44.26	543387.0
2009-06-26	AAXN-DELISTED	Stock	4.5	4.72	4.44	4.72	737843.0
2009-06-26	AB	Stock	18.86	20.09	18.8	19.84	359500.0
2009-06-26	ABAX-DELISTED	Stock	20.34	20.52	20.01	20.31	280269.0
2009-06-26	ABB-DELISTED	Stock	15.4	15.51	15.28	15.43	4819095.0
2009-06-26	ABBC-DELISTED	Stock	8.2	8.24	8.01	8.15	218888.0
2009-06-26	ABBNY-DELISTED	Stock	15.4	15.51	15.28	15.44	5150120.0
2009-06-26	ABC-DELISTED	Stock	18.35	18.35	17.9	18.13	5451029.0
2009-06-26	ABCB	Stock	6.0012	6.2249	5.9428	6.0498	209738.0
2009-06-26	ABCO-DELISTED	Stock	12.963	13.033	12.812	12.947	588000.0
2009-06-26	ABCW-DELISTED	Stock	1.6684	1.6684	1.2777	1.51	2950660.0
2009-06-26	ABD-DELISTED	Stock	2.84	3.33	2.77	3.27	818300.0
2009-06-26	ABE-DELISTED	Stock	15.1	15.1	14.91	15.0	5007.0
2009-06-26	ABEO	Stock	2812.5	2812.5	2575.0	2812.5	11.0
2009-06-26	ABFS-DELISTED	Stock	27.87	28.34	27.53	28.17	1074111.0
2009-06-26	ABG	Stock	10.96	11.85	10.88	11.4	711500.0
2009-06-26	ABII-DELISTED	Stock	37.46	37.51	35.6015	37.04	54678.0
2009-06-26	ABK-DELISTED	Stock	0.96	0.99	0.91	0.97	6326748.0
2009-06-26	ABM	Stock	17.44	18.01	17.27	17.96	844500.0
2009-06-26	ABMD-DELISTED	Stock	8.36	8.67	8.06	8.55	517358.0
2009-06-26	ABR	Stock	2.02	2.02	1.65	1.68	2115600.0
2009-06-26	ABT	Stock	22.9728	23.0928	22.6897	22.7569	17072530.0
2009-06-26	ABTL-DELISTED	Stock	2.15	2.1945	2.05	2.1	37646.0
2009-06-26	ABV-DELISTED	Stock	66.18	66.69	65.77	66.41	474378.0
2009-06-26	ABVA-DELISTED	Stock	2.5	2.5001	2.5	2.5001	400.0
2009-06-26	ABVT-DELISTED	Stock	83.25	83.25	79.92	81.31	769070.0
2009-06-26	ABX-DELISTED	Stock	35.5	35.8	34.93	34.95	6441991.0
2009-06-26	ACAD	Stock	2.18	2.22	1.99	2.08	5107400.0
2009-06-26	ACAP-DELISTED	Stock	39.66	40.41	39.22	40.08	77972.0
2009-06-26	ACAS-DELISTED	Stock	2.6718	3.18	2.6518	3.178	34151311.0

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

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