PREVIEW / stock_daily / 2011-06-10

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-10.parquet
  size:    198 KB
  rows:    6,109
  symbols: 3,554

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
2011-06-10	AAPL	Stock	11.8054	11.845	11.6254	11.6393	433955200.0
2011-06-10	MSFT	Stock	24.02	24.02	23.69	23.71	49327200.0
2011-06-10	NVDA	Stock	0.435	0.4378	0.4245	0.428	493548000.0
2011-06-10	AMZN	Stock	9.4625	9.5385	9.314	9.3265	75208000.0
2011-06-10	TSLA	Stock	1.8347	1.8867	1.8233	1.8573	23499000.0
2011-06-10	TLT	Stock	96.91	97.39	96.8	97.14	7710729.0
2011-06-10	ES	Stock	33.96	34.08	33.87	33.88	1139100.0
2011-06-10	CL	Stock	42.05	42.515	41.955	42.35	6594200.0
2011-06-10	A	Stock	34.6567	35.0072	34.4278	34.4707	5479321.0
2011-06-10	AABA-DELISTED	Stock	15.26	15.73	15.11	15.19	19391219.0
2011-06-10	AACC-DELISTED	Stock	3.29	3.35	3.25	3.29	50258.0
2011-06-10	AACG	Stock	11.01	11.24	10.54	10.63	67900.0
2011-06-10	AAIC-DELISTED	Stock	28.32	29.03	27.58	28.61	78054.0
2011-06-10	AAME	Stock	2.05	2.05	2.0	2.04	900.0
2011-06-10	AAON	Stock	6.2281	6.24	6.0464	6.0642	219206.0
2011-06-10	AAP	Stock	58.15	58.5	57.6	57.97	1201000.0
2011-06-10	AAT	Stock	21.5	21.7	21.4	21.52	218600.0
2011-06-10	AATI-DELISTED	Stock	6.04	6.05	6.03	6.05	809472.0
2011-06-10	AAU-DELISTED	Stock	3.27	3.33	3.12	3.16	268301.0
2011-06-10	AAUAF-DELISTED	Stock	3.27	3.33	3.12	3.16	276001.0
2011-06-10	AAV-DELISTED	Stock	8.02	8.05	7.8233	7.91	339584.0
2011-06-10	AAWW-DELISTED	Stock	57.3	57.74	56.99	57.14	169733.0
2011-06-10	AAXJ	Stock	61.45	61.48	60.675	60.88	350171.0
2011-06-10	AAXN-DELISTED	Stock	4.27	4.35	4.26	4.3	503461.0
2011-06-10	AB	Stock	19.12	19.63	19.12	19.47	488500.0
2011-06-10	ABAC-DELISTED	Stock	2.34	2.34	2.13	2.14	47257.0
2011-06-10	ABAX-DELISTED	Stock	28.73	29.09	27.86	28.0	88397.0
2011-06-10	ABB-DELISTED	Stock	25.83	25.87	25.41	25.55	2346193.0
2011-06-10	ABBC-DELISTED	Stock	10.47	10.47	10.19	10.26	29455.0
2011-06-10	ABBNY-DELISTED	Stock	25.83	25.87	25.41	25.53	2348759.0
2011-06-10	ABC-DELISTED	Stock	41.46	41.47	40.82	41.07	2942886.0
2011-06-10	ABCB	Stock	8.58	8.6	8.49	8.49	45300.0
2011-06-10	ABCD-DELISTED	Stock	3.11	3.17	3.08	3.14	14719.0
2011-06-10	ABCO-DELISTED	Stock	24.32	24.42	23.94	23.94	81412.0
2011-06-10	ABCW-DELISTED	Stock	0.7	0.7023	0.65	0.65	113810.0
2011-06-10	ABD-DELISTED	Stock	7.22	7.26	7.02	7.08	253230.0
2011-06-10	ABE-DELISTED	Stock	18.67	18.67	18.42	18.42	2755.0
2011-06-10	ABEO	Stock	2587.5	2712.5	2562.5	2687.5	14.0
2011-06-10	ABFS-DELISTED	Stock	21.78	22.2	21.6	21.76	345523.0
2011-06-10	ABG	Stock	15.51	15.75	15.19	15.45	419100.0
2011-06-10	ABH-DELISTED	Stock	23.15	23.37	22.61	22.64	526772.0
2011-06-10	ABM	Stock	22.17	22.22	21.74	21.97	412600.0
2011-06-10	ABMD-DELISTED	Stock	16.89	16.89	16.17	16.49	180095.0
2011-06-10	ABR	Stock	5.09	5.29	5.03	5.24	81100.0
2011-06-10	ABT	Stock	24.6377	24.6953	24.4218	24.4218	15587536.0
2011-06-10	ABTL-DELISTED	Stock	5.6	5.8	5.5	5.6	33461.0
2011-06-10	ABUS	Stock	2.86	2.88	2.58	2.66	9800.0
2011-06-10	ABV-DELISTED	Stock	32.36	32.44	31.56	31.67	1602337.0
2011-06-10	ABVA-DELISTED	Stock	5.03	5.27	5.0	5.25	3602.0
2011-06-10	ABVT-DELISTED	Stock	72.76	74.04	72.76	73.36	150483.0

> showing 50 of 6,109 rows — these rows as CSV

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