PREVIEW / stock_daily / 2011-09-15

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-15.parquet
  size:    193 KB
  rows:    6,068
  symbols: 3,518

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-15	AAPL	Stock	13.9796	14.0593	13.925	14.0343	417818800.0
2011-09-15	MSFT	Stock	26.73	27.03	26.31	26.99	67808300.0
2011-09-15	NVDA	Stock	0.3905	0.3925	0.384	0.3875	752908000.0
2011-09-15	AMZN	Stock	11.1995	11.36	11.0625	11.339	112176000.0
2011-09-15	TSLA	Stock	1.6387	1.662	1.622	1.6547	8439000.0
2011-09-15	TLT	Stock	111.98	112.49	111.43	111.43	8883989.0
2011-09-15	ES	Stock	34.29	34.6	34.17	34.46	1098500.0
2011-09-15	CL	Stock	45.995	46.16	45.465	46.145	5005400.0
2011-09-15	A	Stock	26.5522	26.6309	25.8083	26.495	6804485.0
2011-09-15	AABA-DELISTED	Stock	14.73	15.4	14.51	14.9	58034747.0
2011-09-15	AACC-DELISTED	Stock	4.14	4.14	3.85	3.99	27172.0
2011-09-15	AACG	Stock	9.99	9.99	9.2	9.2	3500.0
2011-09-15	AAIC-DELISTED	Stock	24.46	24.46	24.15	24.35	31087.0
2011-09-15	AAME	Stock	2.02	2.02	1.96	2.0	1900.0
2011-09-15	AAON	Stock	4.9719	5.2178	4.8474	5.1911	261225.0
2011-09-15	AAP	Stock	61.88	62.73	61.55	62.67	923200.0
2011-09-15	AAT	Stock	19.16	19.26	18.81	19.0	82000.0
2011-09-15	AATI-DELISTED	Stock	4.52	4.52	4.37	4.48	1248864.0
2011-09-15	AAU-DELISTED	Stock	3.26	3.26	3.1	3.19	324996.0
2011-09-15	AAUAF-DELISTED	Stock	3.26	3.26	3.1	3.19	325496.0
2011-09-15	AAV-DELISTED	Stock	5.27	5.37	5.21	5.31	410053.0
2011-09-15	AAWW-DELISTED	Stock	46.5	47.36	46.5	47.07	327348.0
2011-09-15	AAXJ	Stock	53.03	53.37	52.65	53.22	219830.0
2011-09-15	AAXN-DELISTED	Stock	4.49	4.56	4.45	4.54	250997.0
2011-09-15	AB	Stock	16.43	16.6	15.68	16.03	707100.0
2011-09-15	ABAC-DELISTED	Stock	2.02	2.0899	1.99	2.0	86900.0
2011-09-15	ABAX-DELISTED	Stock	25.13	25.28	24.45	25.0	111211.0
2011-09-15	ABB-DELISTED	Stock	19.08	19.15	18.9	19.12	3448738.0
2011-09-15	ABBC-DELISTED	Stock	8.48	8.55	8.33	8.5	29528.0
2011-09-15	ABBNY-DELISTED	Stock	19.08	19.15	18.9	19.11	3451310.0
2011-09-15	ABC-DELISTED	Stock	39.58	39.63	37.61	38.57	4209460.0
2011-09-15	ABCB	Stock	9.06	9.31	8.89	9.24	32000.0
2011-09-15	ABCD-DELISTED	Stock	3.12	3.12	3.0	3.05	42575.0
2011-09-15	ABCO-DELISTED	Stock	29.76	30.19	29.47	30.12	87344.0
2011-09-15	ABCW-DELISTED	Stock	0.62	0.62	0.58	0.58	7580.0
2011-09-15	ABD-DELISTED	Stock	5.87	6.03	5.8	6.02	300850.0
2011-09-15	ABE-DELISTED	Stock	17.9	18.0	17.8001	17.83	3230.0
2011-09-15	ABEO	Stock	2250.0	2725.0	2250.0	2500.0	89.0
2011-09-15	ABFS-DELISTED	Stock	20.8	21.23	20.59	21.16	605744.0
2011-09-15	ABG	Stock	19.85	19.93	18.98	19.07	493300.0
2011-09-15	ABH-DELISTED	Stock	16.47	16.94	16.24	16.38	164678.0
2011-09-15	ABM	Stock	19.35	19.45	18.98	19.42	236700.0
2011-09-15	ABMD-DELISTED	Stock	11.35	11.91	11.33	11.85	176721.0
2011-09-15	ABR	Stock	4.22	4.23	4.0	4.06	60700.0
2011-09-15	ABT	Stock	24.6425	24.7049	24.4026	24.6089	13929762.0
2011-09-15	ABTL-DELISTED	Stock	4.6	4.75	4.551	4.65	23313.0
2011-09-15	ABUS	Stock	2.0	2.0	2.0	2.0	800.0
2011-09-15	ABV-DELISTED	Stock	33.13	33.39	32.59	32.97	2281683.0
2011-09-15	ABVA-DELISTED	Stock	4.7616	4.85	4.7	4.81	31246.0
2011-09-15	ABVT-DELISTED	Stock	57.63	58.1	56.68	58.1	153908.0

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

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