PREVIEW / stock_daily / 2011-11-10

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-10.parquet
  size:    195 KB
  rows:    6,068
  symbols: 3,505

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-11-10	AAPL	Stock	14.1796	14.1861	13.6482	13.7579	744752400.0
2011-11-10	MSFT	Stock	26.47	26.5	26.12	26.28	32514400.0
2011-11-10	NVDA	Stock	0.3668	0.3705	0.3528	0.3618	990484000.0
2011-11-10	AMZN	Stock	10.675	10.703	10.405	10.5395	100892000.0
2011-11-10	TSLA	Stock	2.0627	2.1	2.0433	2.0887	11209500.0
2011-11-10	TLT	Stock	116.78	117.61	115.21	116.36	11644981.0
2011-11-10	ES	Stock	34.05	34.36	33.88	34.27	2950900.0
2011-11-10	CL	Stock	44.01	44.19	43.595	44.07	3877600.0
2011-11-10	A	Stock	26.3948	26.8169	26.0229	26.3662	5333650.0
2011-11-10	AABA-DELISTED	Stock	16.19	16.22	15.84	15.94	15346436.0
2011-11-10	AACC-DELISTED	Stock	3.25	3.34	3.0	3.13	24583.0
2011-11-10	AACG	Stock	9.99	10.3	9.81	9.81	73800.0
2011-11-10	AAIC-DELISTED	Stock	21.87	21.91	21.416	21.88	34204.0
2011-11-10	AAME	Stock	1.8	1.8	1.8	1.8	1600.0
2011-11-10	AAON	Stock	6.4889	6.5096	6.2815	6.4178	185288.0
2011-11-10	AAP	Stock	67.4	71.0	67.0	69.51	2918700.0
2011-11-10	AAT	Stock	19.94	20.06	19.32	19.85	310600.0
2011-11-10	AATI-DELISTED	Stock	3.78	4.45	3.78	3.99	1226500.0
2011-11-10	AAU-DELISTED	Stock	2.86	2.87	2.74	2.798	107151.0
2011-11-10	AAUAF-DELISTED	Stock	2.86	2.87	2.74	2.798	108951.0
2011-11-10	AAV-DELISTED	Stock	5.13	5.24	5.03	5.17	320146.0
2011-11-10	AAWW-DELISTED	Stock	36.64	37.17	35.29	36.46	191890.0
2011-11-10	AAXJ	Stock	52.44	52.76	51.94	52.47	740769.0
2011-11-10	AAXN-DELISTED	Stock	5.46	5.53	5.4	5.44	334773.0
2011-11-10	AB	Stock	13.06	13.49	13.0	13.19	489500.0
2011-11-10	ABAC-DELISTED	Stock	2.293	2.3	2.23	2.3	6405.0
2011-11-10	ABAX-DELISTED	Stock	27.05	27.05	26.54	26.58	75230.0
2011-11-10	ABB-DELISTED	Stock	18.34	18.34	17.88	18.11	2295894.0
2011-11-10	ABBNY-DELISTED	Stock	18.34	18.34	17.88	18.1	2296894.0
2011-11-10	ABC-DELISTED	Stock	38.67	38.91	38.09	38.71	1892899.0
2011-11-10	ABCB	Stock	10.16	10.22	10.03	10.08	42800.0
2011-11-10	ABCD-DELISTED	Stock	3.31	3.31	3.14	3.26	22258.0
2011-11-10	ABCO-DELISTED	Stock	34.69	34.99	33.87	34.42	172564.0
2011-11-10	ABCW-DELISTED	Stock	0.48	0.5	0.47	0.48	34960.0
2011-11-10	ABD-DELISTED	Stock	7.19	7.31	6.94	7.08	151980.0
2011-11-10	ABE-DELISTED	Stock	18.14	18.15	17.71	17.733	10737.0
2011-11-10	ABEO	Stock	1600.0	1650.0	1587.5	1650.0	37.0
2011-11-10	ABFS-DELISTED	Stock	20.0	20.39	19.68	20.14	292975.0
2011-11-10	ABG	Stock	18.18	18.58	17.8	18.46	455500.0
2011-11-10	ABH-DELISTED	Stock	15.68	15.9	15.41	15.89	193480.0
2011-11-10	ABM	Stock	19.92	20.5	19.86	19.95	429600.0
2011-11-10	ABMD-DELISTED	Stock	18.7	18.99	18.256	18.54	241547.0
2011-11-10	ABR	Stock	3.74	3.79	3.63	3.66	31700.0
2011-11-10	ABT	Stock	25.5494	25.9524	25.5062	25.8852	11266986.0
2011-11-10	ABTL-DELISTED	Stock	4.4925	4.5075	4.4073	4.5075	8108.0
2011-11-10	ABUS	Stock	1.59	1.71	1.59	1.71	5500.0
2011-11-10	ABV-DELISTED	Stock	33.42	33.48	32.865	33.16	2871263.0
2011-11-10	ABVA-DELISTED	Stock	5.0	5.15	5.0	5.1	13838.0
2011-11-10	ABVT-DELISTED	Stock	59.95	60.49	59.175	60.01	104040.0
2011-11-10	ABX-DELISTED	Stock	51.19	51.73	50.1	51.09	6528755.0

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

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