PREVIEW / stock_daily / 2011-10-31

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-31.parquet
  size:    195 KB
  rows:    6,110
  symbols: 3,542

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-10-31	AAPL	Stock	14.3721	14.6189	14.3232	14.4564	385501200.0
2011-10-31	MSFT	Stock	26.76	27.0	26.62	26.63	46799000.0
2011-10-31	NVDA	Stock	0.3775	0.3798	0.37	0.37	519984000.0
2011-10-31	AMZN	Stock	10.7895	10.9445	10.652	10.6755	146866000.0
2011-10-31	TSLA	Stock	1.9667	1.9673	1.9167	1.958	17010000.0
2011-10-31	TLT	Stock	113.61	115.88	113.46	115.88	15242448.0
2011-10-31	ES	Stock	34.38	34.9	34.22	34.57	1518900.0
2011-10-31	CL	Stock	45.39	45.795	45.175	45.185	5125200.0
2011-10-31	A	Stock	28.505	28.5908	26.5165	26.5165	10448512.0
2011-10-31	AABA-DELISTED	Stock	16.05	16.07	15.45	15.66	39534681.0
2011-10-31	AACC-DELISTED	Stock	2.9994	3.05	2.9994	3.04	4898.0
2011-10-31	AACG	Stock	9.3	9.9	9.3	9.86	27100.0
2011-10-31	AAIC-DELISTED	Stock	24.02	24.064	23.08	23.08	64755.0
2011-10-31	AAME	Stock	1.8	1.83	1.77	1.83	5200.0
2011-10-31	AAON	Stock	6.3556	6.5422	6.1037	6.2726	218025.0
2011-10-31	AAP	Stock	65.31	66.09	64.95	65.07	485700.0
2011-10-31	AAT	Stock	20.58	21.07	20.14	20.27	160600.0
2011-10-31	AATI-DELISTED	Stock	4.41	4.4401	4.33	4.36	162837.0
2011-10-31	AAU-DELISTED	Stock	2.91	2.91	2.75	2.77	177872.0
2011-10-31	AAUAF-DELISTED	Stock	2.91	2.91	2.75	2.77	179172.0
2011-10-31	AAV-DELISTED	Stock	5.39	5.43	5.22	5.28	384706.0
2011-10-31	AAWW-DELISTED	Stock	42.0	42.02	38.5	38.55	338561.0
2011-10-31	AAXJ	Stock	54.54	54.62	53.56	53.56	659595.0
2011-10-31	AAXN-DELISTED	Stock	4.85	5.04	4.84	4.97	682913.0
2011-10-31	AB	Stock	14.38	14.91	14.06	14.17	343100.0
2011-10-31	ABAC-DELISTED	Stock	1.83	1.86	1.68	1.8	35095.0
2011-10-31	ABAX-DELISTED	Stock	28.06	28.65	27.87	28.11	101679.0
2011-10-31	ABB-DELISTED	Stock	19.58	19.59	18.82	18.8299	3939314.0
2011-10-31	ABBNY-DELISTED	Stock	19.58	19.59	18.81	18.81	3943609.0
2011-10-31	ABC-DELISTED	Stock	41.82	41.96	40.72	40.76	2933908.0
2011-10-31	ABCB	Stock	10.3	10.47	10.01	10.03	179300.0
2011-10-31	ABCD-DELISTED	Stock	3.42	3.5	3.28	3.3	19151.0
2011-10-31	ABCO-DELISTED	Stock	30.61	30.91	30.35	30.63	243730.0
2011-10-31	ABCW-DELISTED	Stock	0.5	0.53	0.5	0.51	64140.0
2011-10-31	ABD-DELISTED	Stock	6.98	7.16	6.87	6.87	424770.0
2011-10-31	ABE-DELISTED	Stock	18.1	18.15	17.97	18.03	20490.0
2011-10-31	ABEO	Stock	2075.0	2212.5	2075.0	2212.5	13.0
2011-10-31	ABFS-DELISTED	Stock	20.5	20.79	19.88	20.59	626562.0
2011-10-31	ABG	Stock	19.01	19.26	18.65	18.65	506000.0
2011-10-31	ABH-DELISTED	Stock	18.2	18.2	16.62	17.01	465689.0
2011-10-31	ABM	Stock	20.55	20.69	20.19	20.22	179800.0
2011-10-31	ABMD-DELISTED	Stock	14.96	15.53	14.56	15.07	367382.0
2011-10-31	ABR	Stock	3.66	3.72	3.61	3.61	14200.0
2011-10-31	ABT	Stock	25.6933	26.1059	25.6933	25.8468	16954148.0
2011-10-31	ABTL-DELISTED	Stock	4.3563	4.4942	4.2495	4.4937	1422.0
2011-10-31	ABUS	Stock	1.63	1.7	1.63	1.7	500.0
2011-10-31	ABV-DELISTED	Stock	34.27	34.35	33.69	33.69	2171905.0
2011-10-31	ABVA-DELISTED	Stock	5.5	5.5	5.361	5.4	14757.0
2011-10-31	ABVT-DELISTED	Stock	59.06	60.1	59.06	59.36	81988.0
2011-10-31	ABX-DELISTED	Stock	50.1002	50.28	49.48	49.48	6261404.0

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

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