PREVIEW / stock_daily / 2011-07-15

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-15.parquet
  size:    197 KB
  rows:    6,098
  symbols: 3,538

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-07-15	AAPL	Stock	12.8989	13.0357	12.8275	13.0329	484467200.0
2011-07-15	MSFT	Stock	26.47	26.93	26.47	26.78	49132400.0
2011-07-15	NVDA	Stock	0.354	0.3562	0.3453	0.3525	827736000.0
2011-07-15	AMZN	Stock	10.654	10.7265	10.4645	10.6435	81452000.0
2011-07-15	TSLA	Stock	1.8527	1.8553	1.8267	1.8387	10635000.0
2011-07-15	TLT	Stock	95.29	96.2	95.2405	96.17	7086625.0
2011-07-15	ES	Stock	34.85	34.97	34.67	34.96	1220600.0
2011-07-15	CL	Stock	43.505	44.55	43.335	44.505	8058600.0
2011-07-15	A	Stock	34.0558	34.0558	33.3119	33.6767	5284859.0
2011-07-15	AABA-DELISTED	Stock	14.75	14.94	14.61	14.69	19079127.0
2011-07-15	AACC-DELISTED	Stock	4.42	4.42	4.39	4.4	7173.0
2011-07-15	AACG	Stock	11.0	11.0	10.67	10.67	1000.0
2011-07-15	AAIC-DELISTED	Stock	30.82	30.94	30.61	30.86	39757.0
2011-07-15	AAME	Stock	2.05	2.05	2.02	2.05	5300.0
2011-07-15	AAON	Stock	6.963	7.0281	6.8711	6.9393	131625.0
2011-07-15	AAP	Stock	56.68	56.73	55.15	55.49	1459000.0
2011-07-15	AAT	Stock	21.8	22.82	21.73	22.71	226800.0
2011-07-15	AATI-DELISTED	Stock	6.08	6.09	6.07	6.08	220234.0
2011-07-15	AAU-DELISTED	Stock	3.92	3.95	3.8	3.895	192227.0
2011-07-15	AAUAF-DELISTED	Stock	3.91	3.94	3.8	3.9	193468.0
2011-07-15	AAV-DELISTED	Stock	7.48	7.65	7.46	7.6	227791.0
2011-07-15	AAWW-DELISTED	Stock	57.79	58.1162	56.14	56.68	239471.0
2011-07-15	AAXJ	Stock	61.82	61.85	61.24	61.64	211975.0
2011-07-15	AAXN-DELISTED	Stock	4.27	4.32	4.25	4.3	220058.0
2011-07-15	AB	Stock	18.62	18.74	18.27	18.48	329200.0
2011-07-15	ABAC-DELISTED	Stock	2.84	2.8808	2.8	2.82	19192.0
2011-07-15	ABAX-DELISTED	Stock	28.83	29.06	28.766	28.86	62715.0
2011-07-15	ABB-DELISTED	Stock	25.47	25.59	25.29	25.52	1583300.0
2011-07-15	ABBC-DELISTED	Stock	10.33	10.42	10.16	10.24	31710.0
2011-07-15	ABBNY-DELISTED	Stock	25.47	25.59	25.29	25.52	1582600.0
2011-07-15	ABC-DELISTED	Stock	42.36	42.36	41.74	42.01	1221542.0
2011-07-15	ABCB	Stock	9.15	9.29	9.15	9.23	39000.0
2011-07-15	ABCD-DELISTED	Stock	3.36	3.38	3.27	3.35	29965.0
2011-07-15	ABCO-DELISTED	Stock	27.68	28.26	27.68	27.86	82724.0
2011-07-15	ABCW-DELISTED	Stock	0.69	0.69	0.68	0.68	10600.0
2011-07-15	ABD-DELISTED	Stock	7.71	7.98	7.71	7.8	221390.0
2011-07-15	ABE-DELISTED	Stock	19.06	19.13	18.96	19.05	13519.0
2011-07-15	ABEO	Stock	2612.5	2625.0	2375.0	2562.5	18.0
2011-07-15	ABFS-DELISTED	Stock	26.2	26.548	26.0	26.33	392913.0
2011-07-15	ABG	Stock	18.93	19.52	18.3	19.52	378300.0
2011-07-15	ABH-DELISTED	Stock	19.67	19.9	19.37	19.72	530138.0
2011-07-15	ABM	Stock	23.3	23.5	23.21	23.37	244200.0
2011-07-15	ABMD-DELISTED	Stock	16.38	16.71	16.22	16.4	409290.0
2011-07-15	ABR	Stock	4.51	4.53	4.44	4.47	35400.0
2011-07-15	ABT	Stock	25.5685	25.6309	25.3334	25.4486	11707795.0
2011-07-15	ABTL-DELISTED	Stock	5.35	5.55	5.25	5.5	2960.0
2011-07-15	ABUS	Stock	2.3	2.4	2.25	2.25	4900.0
2011-07-15	ABV-DELISTED	Stock	31.93	32.05	31.2663	31.41	2866404.0
2011-07-15	ABVA-DELISTED	Stock	4.84	4.84	4.7	4.72	2200.0
2011-07-15	ABVT-DELISTED	Stock	67.39	67.39	65.96	66.15	176258.0

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

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