PREVIEW / stock_daily / 2010-01-29

all stock daily files

  file:    by_date/stock_daily/2010/2010-01-29.parquet
  size:    188 KB
  rows:    5,874
  symbols: 3,486

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
2010-01-29	AAPL	Stock	7.1814	7.2214	6.7946	6.8593	1245952400.0
2010-01-29	MSFT	Stock	29.9	29.92	27.66	28.18	193888500.0
2010-01-29	NVDA	Stock	0.4068	0.4112	0.3788	0.3848	774700000.0
2010-01-29	AMZN	Stock	6.4885	6.5925	6.207	6.2705	589426000.0
2010-01-29	TLT	Stock	91.41	92.36	91.25	92.31	4930563.0
2010-01-29	ES	Stock	25.61	25.68	25.28	25.32	1910800.0
2010-01-29	CL	Stock	40.235	40.43	39.65	40.015	6692600.0
2010-01-29	A	Stock	20.6938	20.8655	19.9714	20.0501	5923046.0
2010-01-29	AABA-DELISTED	Stock	15.51	15.67	14.9	15.02	39061418.0
2010-01-29	AACC-DELISTED	Stock	5.93	6.1	5.8	5.82	17851.0
2010-01-29	AACG	Stock	3.71	3.72	2.92	3.0	123500.0
2010-01-29	AAI-DELISTED	Stock	5.17	5.26	4.82	4.83	5847934.0
2010-01-29	AAIC-DELISTED	Stock	15.29	15.37	14.9	15.1	13622.0
2010-01-29	AAME	Stock	1.36	1.39	1.3	1.39	1100.0
2010-01-29	AAON	Stock	4.1225	4.1857	4.0652	4.0672	453600.0
2010-01-29	AAP	Stock	39.99	40.4	39.42	39.45	948500.0
2010-01-29	AATI-DELISTED	Stock	3.39	3.45	3.3	3.34	238929.0
2010-01-29	AAU-DELISTED	Stock	0.88	0.9	0.86	0.87	175818.0
2010-01-29	AAUAF-DELISTED	Stock	0.88	0.9	0.86	0.87	179318.0
2010-01-29	AAV-DELISTED	Stock	6.36	6.5	6.31	6.36	756195.0
2010-01-29	AAWW-DELISTED	Stock	36.76	37.56	36.38	36.67	318584.0
2010-01-29	AAXJ	Stock	53.18	53.5	51.9201	52.07	262747.0
2010-01-29	AAXN-DELISTED	Stock	5.91	6.0	5.56	5.64	1257763.0
2010-01-29	AB	Stock	27.01	27.2	25.71	25.74	787500.0
2010-01-29	ABAX-DELISTED	Stock	23.74	25.23	23.64	24.06	565462.0
2010-01-29	ABB-DELISTED	Stock	18.33	18.51	17.975	18.06	3879761.0
2010-01-29	ABBC-DELISTED	Stock	7.05	7.17	7.05	7.15	40788.0
2010-01-29	ABBNY-DELISTED	Stock	18.33	18.51	17.975	18.03	3880011.0
2010-01-29	ABC-DELISTED	Stock	27.41	27.61	27.25	27.25	4097326.0
2010-01-29	ABCB	Stock	9.1359	9.3631	9.0865	9.2248	44550.0
2010-01-29	ABCD-DELISTED	Stock	3.8701	4.0	3.8701	3.94	37062.0
2010-01-29	ABCO-DELISTED	Stock	16.2	16.425	16.065	16.145	234228.0
2010-01-29	ABCW-DELISTED	Stock	1.28	1.28	1.21	1.25	125990.0
2010-01-29	ABD-DELISTED	Stock	7.79	7.96	7.63	7.7	421320.0
2010-01-29	ABE-DELISTED	Stock	16.08	16.11	15.85	15.87	74920.0
2010-01-29	ABEO	Stock	3500.0	3500.0	3375.0	3487.5	4.0
2010-01-29	ABFS-DELISTED	Stock	22.78	23.29	22.1	22.53	1206185.0
2010-01-29	ABG	Stock	11.27	11.56	10.95	11.07	203800.0
2010-01-29	ABII-DELISTED	Stock	40.96	41.5	40.2	40.85	94582.0
2010-01-29	ABK-DELISTED	Stock	0.7	0.7	0.68	0.69	4841385.0
2010-01-29	ABM	Stock	19.55	19.9	19.42	19.42	135500.0
2010-01-29	ABMD-DELISTED	Stock	8.075	8.3723	7.92	7.93	870675.0
2010-01-29	ABR	Stock	2.05	2.08	1.99	2.0	116200.0
2010-01-29	ABT	Stock	25.9476	25.9476	25.3766	25.4006	19832013.0
2010-01-29	ABTL-DELISTED	Stock	5.5	5.55	5.3	5.45	12356.0
2010-01-29	ABV-DELISTED	Stock	96.52	96.52	91.89	92.56	656672.0
2010-01-29	ABVA-DELISTED	Stock	2.8	2.9599	2.8	2.9599	689.0
2010-01-29	ABVT-DELISTED	Stock	60.58	61.26	58.58	58.7	140796.0
2010-01-29	ABX-DELISTED	Stock	35.8	36.38	34.63	34.8399	14227645.0
2010-01-29	ACAD	Stock	1.3	1.3	1.24	1.25	498100.0

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

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