PREVIEW / stock_daily / 2012-10-31

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-31.parquet
  size:    200 KB
  rows:    6,208
  symbols: 3,519

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
2012-10-31	AAPL	Stock	21.2457	21.4986	20.9893	21.2614	510003200.0
2012-10-31	MSFT	Stock	28.55	28.88	28.5	28.54	69464100.0
2012-10-31	NVDA	Stock	0.3025	0.305	0.2988	0.2995	347112000.0
2012-10-31	AMZN	Stock	11.816	11.935	11.525	11.6445	95952000.0
2012-10-31	META	Stock	20.82	21.5	20.73	21.11	99378200.0
2012-10-31	TSLA	Stock	1.8467	1.89	1.8247	1.8753	11628000.0
2012-10-31	TLT	Stock	122.68	123.704	122.63	123.36	5025519.0
2012-10-31	ES	Stock	39.86	40.38	38.72	39.3	1303600.0
2012-10-31	CL	Stock	51.98	52.61	51.78	52.48	4664400.0
2012-10-31	A	Stock	25.7511	26.0014	25.6509	25.7439	4775987.0
2012-10-31	AABA-DELISTED	Stock	16.81	16.89	16.6	16.84	20840297.0
2012-10-31	AACC-DELISTED	Stock	6.63	6.87	6.27	6.39	20542.0
2012-10-31	AACG	Stock	4.96	5.48	4.61	4.68	2400.0
2012-10-31	AAIC-DELISTED	Stock	21.91	22.2999	21.91	22.25	143212.0
2012-10-31	AAME	Stock	2.9	3.0	2.85	2.86	6500.0
2012-10-31	AAMRQ-DELISTED	Stock	0.361	0.4	0.361	0.38	1351077.0
2012-10-31	AAON	Stock	6.1215	6.3141	6.0741	6.2163	250763.0
2012-10-31	AAP	Stock	68.65	71.12	68.17	70.94	819800.0
2012-10-31	AAT	Stock	26.95	27.35	26.95	27.17	102700.0
2012-10-31	AAU-DELISTED	Stock	2.505	2.5846	2.5	2.58	142630.0
2012-10-31	AAUAF-DELISTED	Stock	2.5	2.58	2.5	2.58	143603.0
2012-10-31	AAV-DELISTED	Stock	3.49	3.65	3.47	3.62	258135.0
2012-10-31	AAWW-DELISTED	Stock	54.45	55.038	53.84	54.92	142386.0
2012-10-31	AAXJ	Stock	56.8	56.8	56.19	56.3	276033.0
2012-10-31	AAXN-DELISTED	Stock	8.0	8.15	7.76	7.81	1606264.0
2012-10-31	AB	Stock	16.93	17.28	16.77	16.82	398700.0
2012-10-31	ABAC-DELISTED	Stock	1.2	1.37	1.2	1.22	7911.0
2012-10-31	ABAX-DELISTED	Stock	36.18	37.03	36.09	36.77	131571.0
2012-10-31	ABB-DELISTED	Stock	18.28	18.29	17.979	18.07	2051787.0
2012-10-31	ABBNY-DELISTED	Stock	18.28	18.29	17.979	18.06	2117655.0
2012-10-31	ABC-DELISTED	Stock	39.62	39.89	39.28	39.44	3221463.0
2012-10-31	ABCB	Stock	10.66	10.75	10.53	10.67	99200.0
2012-10-31	ABCD-DELISTED	Stock	0.89	0.93	0.86	0.93	48916.0
2012-10-31	ABCO-DELISTED	Stock	46.2	47.53	45.03	47.49	178418.0
2012-10-31	ABCW-DELISTED	Stock	0.357	0.37	0.357	0.37	5201.0
2012-10-31	ABE-DELISTED	Stock	20.62	20.65	20.5	20.65	16524.0
2012-10-31	ABEO	Stock	575.0	575.0	437.5	437.5	85.0
2012-10-31	ABFS-DELISTED	Stock	7.52	8.19	7.5	8.05	559149.0
2012-10-31	ABG	Stock	30.47	31.98	30.41	31.72	295500.0
2012-10-31	ABM	Stock	18.93	19.13	18.91	19.0	534100.0
2012-10-31	ABMD-DELISTED	Stock	18.89	20.0	18.825	19.84	699361.0
2012-10-31	ABR	Stock	5.44	5.51	5.44	5.5	39600.0
2012-10-31	ABT	Stock	31.5756	31.7148	31.2878	31.4269	14188203.0
2012-10-31	ABTL-DELISTED	Stock	3.98	3.9901	3.98	3.99	4861.0
2012-10-31	ABUS	Stock	3.99	4.09	3.82	4.04	38500.0
2012-10-31	ABV-DELISTED	Stock	41.42	41.5	40.5	40.8	2144721.0
2012-10-31	ABVA-DELISTED	Stock	4.4	4.5	4.1	4.5	11302.0
2012-10-31	ABX-DELISTED	Stock	40.24	40.8	39.95	40.5	8278262.0
2012-10-31	ACAD	Stock	2.28	2.37	2.24	2.35	776600.0
2012-10-31	ACAS-DELISTED	Stock	11.8	12.02	11.695	11.795	4533085.0

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

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