PREVIEW / stock_daily / 2011-05-20

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-20.parquet
  size:    198 KB
  rows:    6,102
  symbols: 3,548

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-05-20	AAPL	Stock	12.1271	12.1768	11.965	11.9721	337968400.0
2011-05-20	MSFT	Stock	24.72	24.87	24.44	24.49	45451500.0
2011-05-20	NVDA	Stock	0.4435	0.4532	0.4415	0.4522	575820000.0
2011-05-20	AMZN	Stock	9.8975	9.99	9.862	9.9325	67620000.0
2011-05-20	TSLA	Stock	1.884	1.8853	1.8233	1.8647	12637500.0
2011-05-20	TLT	Stock	95.02	95.41	94.7205	95.32	5602558.0
2011-05-20	ES	Stock	36.19	36.23	35.88	36.1	1200000.0
2011-05-20	CL	Stock	43.39	43.495	43.225	43.275	3543400.0
2011-05-20	A	Stock	36.588	36.6309	36.073	36.2661	4684418.0
2011-05-20	AABA-DELISTED	Stock	16.3	16.44	16.15	16.3	23469854.0
2011-05-20	AACC-DELISTED	Stock	4.44	4.52	4.11	4.44	16708.0
2011-05-20	AACG	Stock	10.35	10.95	10.31	10.34	23600.0
2011-05-20	AAIC-DELISTED	Stock	27.0	27.5	27.0	27.06	43998.0
2011-05-20	AAME	Stock	2.04	2.05	2.04	2.05	200.0
2011-05-20	AAON	Stock	6.4632	6.4889	6.3664	6.4198	152887.0
2011-05-20	AAP	Stock	63.4	64.12	61.63	63.27	2618200.0
2011-05-20	AAT	Stock	21.86	22.02	21.54	21.81	114900.0
2011-05-20	AATI-DELISTED	Stock	3.79	3.85	3.73	3.76	263908.0
2011-05-20	AAU-DELISTED	Stock	3.63	3.8	3.41	3.77	366416.0
2011-05-20	AAUAF-DELISTED	Stock	3.63	3.8	3.41	3.75	367016.0
2011-05-20	AAV-DELISTED	Stock	8.02	8.095	7.84	8.03	357266.0
2011-05-20	AAWW-DELISTED	Stock	63.8	64.26	63.55	63.97	208346.0
2011-05-20	AAXJ	Stock	62.91	62.99	62.36	62.58	333320.0
2011-05-20	AAXN-DELISTED	Stock	4.55	4.55	4.46	4.48	344946.0
2011-05-20	AB	Stock	21.53	21.73	21.48	21.53	230500.0
2011-05-20	ABAC-DELISTED	Stock	2.69	2.8899	2.69	2.85	14989.0
2011-05-20	ABAX-DELISTED	Stock	31.22	31.69	30.1	30.86	244782.0
2011-05-20	ABB-DELISTED	Stock	26.47	26.54	26.18	26.32	3914048.0
2011-05-20	ABBC-DELISTED	Stock	11.59	11.82	11.34	11.36	83855.0
2011-05-20	ABBNY-DELISTED	Stock	26.47	26.54	26.18	26.32	4076308.0
2011-05-20	ABC-DELISTED	Stock	41.75	41.77	41.49	41.56	1661297.0
2011-05-20	ABCB	Stock	8.98	9.17	8.98	8.98	41300.0
2011-05-20	ABCD-DELISTED	Stock	3.04	3.12	3.0	3.0	24667.0
2011-05-20	ABCO-DELISTED	Stock	25.44	25.7	24.86	25.45	121381.0
2011-05-20	ABCW-DELISTED	Stock	0.75	0.83	0.75	0.8	33520.0
2011-05-20	ABD-DELISTED	Stock	8.725	8.795	8.515	8.715	222590.0
2011-05-20	ABE-DELISTED	Stock	18.72	18.72	18.53	18.62	8552.0
2011-05-20	ABEO	Stock	2750.0	2750.0	2600.0	2750.0	3.0
2011-05-20	ABFS-DELISTED	Stock	25.05	25.55	24.37	25.35	641320.0
2011-05-20	ABG	Stock	16.51	16.51	15.89	15.9	806300.0
2011-05-20	ABH-DELISTED	Stock	24.69	25.12	24.59	24.84	341909.0
2011-05-20	ABM	Stock	23.52	23.59	23.23	23.3	300900.0
2011-05-20	ABMD-DELISTED	Stock	17.52	18.05	17.52	17.9495	522204.0
2011-05-20	ABR	Stock	5.01	5.01	4.9	4.94	24300.0
2011-05-20	ABT	Stock	25.6213	25.866	25.3958	25.6741	15512088.0
2011-05-20	ABTL-DELISTED	Stock	5.7	5.8	5.5	5.5	14543.0
2011-05-20	ABUS	Stock	2.77	2.89	2.75	2.89	16300.0
2011-05-20	ABV-DELISTED	Stock	31.27	31.33	30.84	31.12	1931383.0
2011-05-20	ABVA-DELISTED	Stock	6.01	6.01	5.5	5.5	25916.0
2011-05-20	ABVT-DELISTED	Stock	63.88	64.66	63.5	64.19	80939.0

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

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