PREVIEW / stock_daily / 2011-09-21

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-21.parquet
  size:    194 KB
  rows:    6,069
  symbols: 3,514

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-21	AAPL	Stock	14.9871	15.0568	14.7143	14.7193	605976000.0
2011-09-21	MSFT	Stock	27.05	27.06	25.97	25.99	72750700.0
2011-09-21	NVDA	Stock	0.3708	0.3773	0.3615	0.3618	715252000.0
2011-09-21	AMZN	Stock	11.7255	12.026	11.5905	11.5935	117630000.0
2011-09-21	TSLA	Stock	1.73	1.7967	1.7133	1.7233	14814000.0
2011-09-21	TLT	Stock	114.63	118.7862	114.2	118.66	18687066.0
2011-09-21	ES	Stock	34.77	35.13	34.23	34.25	1703500.0
2011-09-21	CL	Stock	46.945	46.97	44.99	44.995	8199000.0
2011-09-21	A	Stock	25.1001	25.1073	23.0258	23.0687	11669525.0
2011-09-21	AABA-DELISTED	Stock	14.38	14.6	13.96	13.96	31638385.0
2011-09-21	AACC-DELISTED	Stock	3.81	3.85	3.81	3.84	2090.0
2011-09-21	AACG	Stock	9.74	9.74	9.22	9.33	6600.0
2011-09-21	AAIC-DELISTED	Stock	25.56	26.2092	25.06	25.1	61135.0
2011-09-21	AAME	Stock	1.98	1.99	1.92	1.99	1100.0
2011-09-21	AAON	Stock	4.7022	4.7763	4.5748	4.5926	256500.0
2011-09-21	AAP	Stock	61.6	62.17	59.74	59.79	836400.0
2011-09-21	AAT	Stock	18.85	19.12	18.37	18.55	207100.0
2011-09-21	AATI-DELISTED	Stock	4.1	4.18	4.0	4.11	1021699.0
2011-09-21	AAU-DELISTED	Stock	3.47	3.48	3.27	3.33	296924.0
2011-09-21	AAUAF-DELISTED	Stock	3.47	3.48	3.27	3.33	297924.0
2011-09-21	AAV-DELISTED	Stock	5.07	5.1	4.71	4.73	417619.0
2011-09-21	AAWW-DELISTED	Stock	42.2	42.28	36.13	37.65	1780357.0
2011-09-21	AAXJ	Stock	51.63	51.69	50.14	50.14	453509.0
2011-09-21	AAXN-DELISTED	Stock	4.4	4.49	4.22	4.24	350528.0
2011-09-21	AB	Stock	15.53	15.67	14.65	14.76	302000.0
2011-09-21	ABAC-DELISTED	Stock	1.87	1.9	1.71	1.8	75749.0
2011-09-21	ABAX-DELISTED	Stock	24.75	25.19	24.14	24.22	126816.0
2011-09-21	ABB-DELISTED	Stock	18.31	18.34	17.65	17.65	2384472.0
2011-09-21	ABBC-DELISTED	Stock	7.98	7.99	7.38	7.39	43353.0
2011-09-21	ABBNY-DELISTED	Stock	18.31	18.34	17.65	17.66	2386997.0
2011-09-21	ABC-DELISTED	Stock	39.76	39.95	38.35	38.35	1826283.0
2011-09-21	ABCB	Stock	9.02	9.07	8.6	8.62	95500.0
2011-09-21	ABCD-DELISTED	Stock	3.0	3.07	2.98	3.01	60456.0
2011-09-21	ABCO-DELISTED	Stock	30.56	31.16	29.96	30.0	107158.0
2011-09-21	ABCW-DELISTED	Stock	0.52	0.55	0.52	0.53	6850.0
2011-09-21	ABD-DELISTED	Stock	5.55	5.66	5.21	5.23	217230.0
2011-09-21	ABE-DELISTED	Stock	17.81	17.81	17.45	17.45	7373.0
2011-09-21	ABEO	Stock	2625.0	2625.0	2325.0	2500.0	5.0
2011-09-21	ABFS-DELISTED	Stock	20.04	20.21	18.22	18.34	473054.0
2011-09-21	ABG	Stock	17.76	18.25	16.84	16.91	403200.0
2011-09-21	ABH-DELISTED	Stock	15.71	15.71	15.24	15.28	338606.0
2011-09-21	ABM	Stock	18.37	18.72	18.0	18.35	448600.0
2011-09-21	ABMD-DELISTED	Stock	11.46	11.65	11.05	11.07	130713.0
2011-09-21	ABR	Stock	3.97	4.06	3.97	4.01	18900.0
2011-09-21	ABT	Stock	25.3718	25.5637	24.8153	24.8249	15926428.0
2011-09-21	ABTL-DELISTED	Stock	4.4078	4.4579	4.3202	4.3422	11282.0
2011-09-21	ABV-DELISTED	Stock	32.26	32.34	31.16	31.18	3597827.0
2011-09-21	ABVA-DELISTED	Stock	5.1	5.1	5.01	5.01	8115.0
2011-09-21	ABVT-DELISTED	Stock	54.15	54.15	51.53	51.57	263690.0
2011-09-21	ABX-DELISTED	Stock	54.0	55.24	53.29	53.31	9139288.0

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

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