PREVIEW / stock_daily / 2011-07-08

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-08.parquet
  size:    197 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-07-08	AAPL	Stock	12.6193	12.8571	12.5786	12.8468	489633200.0
2011-07-08	MSFT	Stock	26.54	26.98	26.51	26.92	58320700.0
2011-07-08	NVDA	Stock	0.3878	0.3905	0.3825	0.3858	619516000.0
2011-07-08	AMZN	Stock	10.715	10.916	10.6625	10.914	74158000.0
2011-07-08	TSLA	Stock	1.9927	1.9927	1.906	1.9207	18609000.0
2011-07-08	TLT	Stock	94.84	95.61	94.83	95.37	12129235.0
2011-07-08	ES	Stock	35.24	35.35	35.13	35.31	838700.0
2011-07-08	CL	Stock	44.17	44.375	43.915	44.21	3548800.0
2011-07-08	A	Stock	36.5165	37.0243	34.8784	35.9299	11101238.0
2011-07-08	AABA-DELISTED	Stock	15.62	15.69	15.44	15.62	14229332.0
2011-07-08	AACC-DELISTED	Stock	3.89	4.09	3.89	4.09	23139.0
2011-07-08	AACG	Stock	11.18	11.18	10.83	11.02	5400.0
2011-07-08	AAIC-DELISTED	Stock	30.15	31.16	29.55	30.94	53892.0
2011-07-08	AAME	Stock	2.02	2.05	2.02	2.05	500.0
2011-07-08	AAON	Stock	6.7881	6.8711	6.7585	6.7911	145125.0
2011-07-08	AAP	Stock	59.2	60.0	59.03	59.12	1091800.0
2011-07-08	AAT	Stock	22.75	23.09	22.66	23.01	93100.0
2011-07-08	AATI-DELISTED	Stock	6.07	6.09	6.06	6.07	126221.0
2011-07-08	AAU-DELISTED	Stock	3.61	3.82	3.54	3.8	276288.0
2011-07-08	AAUAF-DELISTED	Stock	3.61	3.82	3.54	3.8	276488.0
2011-07-08	AAV-DELISTED	Stock	7.8	7.82	7.71	7.76	134826.0
2011-07-08	AAWW-DELISTED	Stock	62.46	63.5	62.28	63.23	125684.0
2011-07-08	AAXJ	Stock	62.78	62.85	62.31	62.83	335232.0
2011-07-08	AAXN-DELISTED	Stock	4.44	4.52	4.41	4.51	151624.0
2011-07-08	AB	Stock	19.71	20.05	19.58	20.02	355200.0
2011-07-08	ABAC-DELISTED	Stock	2.8	2.8794	2.61	2.67	20883.0
2011-07-08	ABAX-DELISTED	Stock	29.86	30.18	29.47	29.69	52570.0
2011-07-08	ABB-DELISTED	Stock	26.29	26.46	26.15	26.34	1678560.0
2011-07-08	ABBC-DELISTED	Stock	10.6	10.68	10.54	10.62	17700.0
2011-07-08	ABBNY-DELISTED	Stock	26.29	26.46	26.15	26.34	1681378.0
2011-07-08	ABC-DELISTED	Stock	42.68	42.77	42.36	42.66	1496716.0
2011-07-08	ABCB	Stock	9.07	9.19	8.95	9.03	15700.0
2011-07-08	ABCD-DELISTED	Stock	3.34	3.44	3.34	3.38	15082.0
2011-07-08	ABCO-DELISTED	Stock	28.29	28.55	28.21	28.41	53160.0
2011-07-08	ABCW-DELISTED	Stock	0.681	0.7066	0.669	0.679	34310.0
2011-07-08	ABD-DELISTED	Stock	8.16	8.3	8.04	8.26	173460.0
2011-07-08	ABE-DELISTED	Stock	19.22	19.22	19.05	19.09	22901.0
2011-07-08	ABEO	Stock	2125.0	2175.0	2087.5	2175.0	3.0
2011-07-08	ABFS-DELISTED	Stock	26.58	26.75	26.2001	26.42	435961.0
2011-07-08	ABG	Stock	18.87	19.7	18.7	19.64	436400.0
2011-07-08	ABH-DELISTED	Stock	20.75	21.07	20.5	21.02	285179.0
2011-07-08	ABM	Stock	23.44	23.61	23.4	23.6	212700.0
2011-07-08	ABMD-DELISTED	Stock	16.65	17.09	16.5	16.69	192530.0
2011-07-08	ABR	Stock	4.68	4.76	4.67	4.75	25500.0
2011-07-08	ABT	Stock	25.5494	25.6453	25.3958	25.5877	10738850.0
2011-07-08	ABTL-DELISTED	Stock	5.7	5.85	5.6	5.8	8075.0
2011-07-08	ABUS	Stock	2.36	2.45	2.27	2.45	14500.0
2011-07-08	ABV-DELISTED	Stock	33.5	33.53	32.88	33.03	3257858.0
2011-07-08	ABVA-DELISTED	Stock	4.67	4.83	4.67	4.83	1416.0
2011-07-08	ABVT-DELISTED	Stock	67.76	68.65	66.83	68.53	269022.0

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

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