PREVIEW / stock_daily / 2010-06-29

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-29.parquet
  size:    189 KB
  rows:    5,943
  symbols: 3,491

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-06-29	AAPL	Stock	9.4329	9.4425	9.0821	9.1489	1133344800.0
2010-06-29	MSFT	Stock	24.13	24.2	23.11	23.31	119882100.0
2010-06-29	NVDA	Stock	0.2715	0.2718	0.2603	0.262	660808000.0
2010-06-29	AMZN	Stock	5.813	5.824	5.3005	5.4305	257326000.0
2010-06-29	TLT	Stock	100.32	101.125	100.16	101.07	7340714.0
2010-06-29	ES	Stock	25.78	25.78	25.29	25.53	1514300.0
2010-06-29	CL	Stock	39.35	39.42	38.71	39.0	6413600.0
2010-06-29	A	Stock	21.4807	21.5951	20.7368	20.8941	6626240.0
2010-06-29	AABA-DELISTED	Stock	14.53	14.54	13.88	14.05	31510794.0
2010-06-29	AACC-DELISTED	Stock	4.52	4.71	4.3	4.33	222223.0
2010-06-29	AACG	Stock	3.09	3.09	2.82	2.99	16800.0
2010-06-29	AAI-DELISTED	Stock	5.04	5.04	4.8375	4.97	4411311.0
2010-06-29	AAIC-DELISTED	Stock	18.98	19.15	18.62	18.77	39550.0
2010-06-29	AAME	Stock	1.39	1.39	1.35	1.35	6600.0
2010-06-29	AAON	Stock	4.636	4.7348	4.5965	4.6281	330075.0
2010-06-29	AAP	Stock	50.1	50.58	49.2	50.28	1098100.0
2010-06-29	AATI-DELISTED	Stock	3.37	3.37	3.18	3.21	153494.0
2010-06-29	AAU-DELISTED	Stock	0.94	0.945	0.8905	0.9099	240704.0
2010-06-29	AAUAF-DELISTED	Stock	0.94	0.945	0.8905	0.9099	241404.0
2010-06-29	AAV-DELISTED	Stock	6.34	6.34	5.9192	5.95	590014.0
2010-06-29	AAWW-DELISTED	Stock	50.14	50.69	47.95	48.41	400013.0
2010-06-29	AAXJ	Stock	52.81	52.95	52.04	52.2	835784.0
2010-06-29	AAXN-DELISTED	Stock	3.9	3.95	3.79	3.8	824152.0
2010-06-29	AB	Stock	27.34	27.34	26.1	26.64	592200.0
2010-06-29	ABAX-DELISTED	Stock	21.58	22.15	21.41	21.62	204345.0
2010-06-29	ABB-DELISTED	Stock	17.73	17.73	17.32	17.5	4727605.0
2010-06-29	ABBC-DELISTED	Stock	8.75	8.85	8.69	8.8	92279.0
2010-06-29	ABBNY-DELISTED	Stock	17.73	17.73	17.32	17.49	4731204.0
2010-06-29	ABC-DELISTED	Stock	32.21	32.21	31.6	31.74	8520007.0
2010-06-29	ABCB	Stock	10.0	10.02	9.53	9.6	230100.0
2010-06-29	ABCD-DELISTED	Stock	3.95	3.95	3.5	3.535	144725.0
2010-06-29	ABCO-DELISTED	Stock	21.35	21.6	21.08	21.34	150491.0
2010-06-29	ABCW-DELISTED	Stock	0.43	0.51	0.42	0.47	124770.0
2010-06-29	ABD-DELISTED	Stock	5.37	5.37	5.03	5.22	945270.0
2010-06-29	ABE-DELISTED	Stock	15.86	15.87	15.26	15.51	18022.0
2010-06-29	ABEO	Stock	2625.0	2625.0	2562.5	2562.5	16.0
2010-06-29	ABFS-DELISTED	Stock	20.82	20.95	20.26	20.68	680860.0
2010-06-29	ABG	Stock	10.68	10.88	10.32	10.71	569800.0
2010-06-29	ABII-DELISTED	Stock	63.38	63.575	60.8	61.32	84010.0
2010-06-29	ABK-DELISTED	Stock	0.6611	0.6884	0.65	0.659	9211258.0
2010-06-29	ABM	Stock	21.76	21.91	21.1	21.23	221500.0
2010-06-29	ABMD-DELISTED	Stock	9.65	9.71	9.573	9.63	170306.0
2010-06-29	ABR	Stock	5.0	5.0	4.87	4.95	93900.0
2010-06-29	ABT	Stock	22.5506	22.5506	22.1908	22.3827	17382659.0
2010-06-29	ABTL-DELISTED	Stock	6.0046	6.0046	5.4495	5.5	56474.0
2010-06-29	ABV-DELISTED	Stock	106.15	106.34	103.88	104.33	1021055.0
2010-06-29	ABVA-DELISTED	Stock	2.7	2.7	2.4	2.45	1709.0
2010-06-29	ABVT-DELISTED	Stock	48.27	48.44	47.0	47.3	396022.0
2010-06-29	ABX-DELISTED	Stock	45.48	45.74	44.72	45.05	9638025.0
2010-06-29	ACAD	Stock	1.19	1.2	1.13	1.13	380100.0

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

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