PREVIEW / stock_daily / 2011-09-08

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-08.parquet
  size:    194 KB
  rows:    6,055
  symbols: 3,513

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-09-08	AAPL	Stock	13.6571	13.8789	13.6539	13.7193	416158400.0
2011-09-08	MSFT	Stock	26.0	26.66	25.95	26.22	65811900.0
2011-09-08	NVDA	Stock	0.3528	0.3612	0.3488	0.3545	880164000.0
2011-09-08	AMZN	Stock	10.915	11.032	10.817	10.863	87958000.0
2011-09-08	TSLA	Stock	1.572	1.602	1.552	1.574	7585500.0
2011-09-08	TLT	Stock	112.3	112.63	111.34	112.51	11481570.0
2011-09-08	ES	Stock	33.61	34.24	33.56	33.82	1365900.0
2011-09-08	CL	Stock	45.605	46.0	45.2	45.23	7282000.0
2011-09-08	A	Stock	25.329	25.4006	24.2418	24.4206	8666062.0
2011-09-08	AABA-DELISTED	Stock	13.57	14.49	13.37	14.45	87772858.0
2011-09-08	AACC-DELISTED	Stock	4.15	4.15	4.0	4.03	18773.0
2011-09-08	AACG	Stock	9.7	9.86	9.7	9.77	4400.0
2011-09-08	AAIC-DELISTED	Stock	25.42	25.4644	24.93	24.94	64688.0
2011-09-08	AAME	Stock	1.99	2.03	1.99	2.03	1100.0
2011-09-08	AAON	Stock	5.0667	5.1111	4.9096	4.9363	143438.0
2011-09-08	AAP	Stock	60.67	61.7	60.55	60.86	996100.0
2011-09-08	AAT	Stock	19.62	19.69	19.31	19.45	91700.0
2011-09-08	AATI-DELISTED	Stock	5.93	5.96	5.93	5.94	588402.0
2011-09-08	AAU-DELISTED	Stock	3.4	3.4926	3.34	3.46	189071.0
2011-09-08	AAUAF-DELISTED	Stock	3.4	3.4926	3.34	3.46	189271.0
2011-09-08	AAV-DELISTED	Stock	5.4	5.48	5.25	5.33	344428.0
2011-09-08	AAWW-DELISTED	Stock	45.84	46.24	44.66	45.26	441489.0
2011-09-08	AAXJ	Stock	55.0	55.62	54.72	54.93	213024.0
2011-09-08	AAXN-DELISTED	Stock	4.4	4.46	4.35	4.4	308331.0
2011-09-08	AB	Stock	16.96	17.0	16.73	16.9	354100.0
2011-09-08	ABAC-DELISTED	Stock	2.2	2.2	2.09	2.13	19501.0
2011-09-08	ABAX-DELISTED	Stock	24.99	25.35	24.71	24.88	88939.0
2011-09-08	ABB-DELISTED	Stock	19.04	19.31	18.78	18.88	4144055.0
2011-09-08	ABBC-DELISTED	Stock	8.46	8.53	8.14	8.23	27109.0
2011-09-08	ABBNY-DELISTED	Stock	19.04	19.31	18.78	18.9	4158684.0
2011-09-08	ABC-DELISTED	Stock	39.88	40.31	39.57	39.74	2034975.0
2011-09-08	ABCB	Stock	8.97	9.2	8.64	8.67	61200.0
2011-09-08	ABCD-DELISTED	Stock	3.01	3.04	2.91	2.95	83015.0
2011-09-08	ABCO-DELISTED	Stock	30.29	30.29	29.78	30.08	298675.0
2011-09-08	ABCW-DELISTED	Stock	0.62	0.62	0.56	0.57	64110.0
2011-09-08	ABD-DELISTED	Stock	6.18	6.32	5.88	5.91	250740.0
2011-09-08	ABE-DELISTED	Stock	18.56	18.61	18.31	18.31	7305.0
2011-09-08	ABEO	Stock	2562.5	2625.0	2450.0	2562.5	2.0
2011-09-08	ABFS-DELISTED	Stock	18.91	19.39	18.64	18.98	346299.0
2011-09-08	ABG	Stock	18.73	19.31	18.31	18.38	381800.0
2011-09-08	ABH-DELISTED	Stock	16.12	16.67	15.9	15.98	283641.0
2011-09-08	ABM	Stock	20.24	20.4	19.75	19.84	241500.0
2011-09-08	ABMD-DELISTED	Stock	11.49	11.68	11.11	11.25	182551.0
2011-09-08	ABR	Stock	4.18	4.22	4.18	4.19	22100.0
2011-09-08	ABT	Stock	24.9448	25.0312	24.6665	24.6809	18484577.0
2011-09-08	ABTL-DELISTED	Stock	4.5037	4.6963	4.5037	4.6963	2698.0
2011-09-08	ABUS	Stock	2.01	2.03	2.0	2.0	21400.0
2011-09-08	ABV-DELISTED	Stock	33.69	33.85	33.33	33.4	3116206.0
2011-09-08	ABVA-DELISTED	Stock	4.72	4.78	4.72	4.78	1400.0
2011-09-08	ABVT-DELISTED	Stock	58.65	58.66	55.89	56.22	216468.0

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

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