PREVIEW / stock_daily / 2012-07-02

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-02.parquet
  size:    198 KB
  rows:    6,133
  symbols: 3,500

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-07-02	AAPL	Stock	20.8832	21.1954	20.8429	21.1614	400092000.0
2012-07-02	MSFT	Stock	30.62	30.62	30.21	30.56	30589100.0
2012-07-02	NVDA	Stock	0.3473	0.3475	0.3335	0.3362	581684000.0
2012-07-02	AMZN	Stock	11.465	11.467	11.317	11.466	46614000.0
2012-07-02	META	Stock	31.25	31.73	30.55	30.77	14122000.0
2012-07-02	TSLA	Stock	2.09	2.12	2.0127	2.0267	19734000.0
2012-07-02	TLT	Stock	125.45	127.21	125.3701	126.22	7818429.0
2012-07-02	ES	Stock	38.81	39.18	38.77	39.1	1180100.0
2012-07-02	CL	Stock	51.705	51.915	51.5	51.86	3448000.0
2012-07-02	A	Stock	28.2761	28.3333	27.5393	27.8326	2429025.0
2012-07-02	AABA-DELISTED	Stock	15.8	15.94	15.76	15.845	6793885.0
2012-07-02	AACC-DELISTED	Stock	6.89	7.61	6.83	7.27	165534.0
2012-07-02	AACG	Stock	4.19	4.4	4.17	4.35	3000.0
2012-07-02	AAIC-DELISTED	Stock	21.72	22.5	21.59	22.5	118206.0
2012-07-02	AAME	Stock	2.75	2.76	2.75	2.76	800.0
2012-07-02	AAMRQ-DELISTED	Stock	0.54	0.56	0.53	0.543	1090919.0
2012-07-02	AAON	Stock	5.6207	5.6444	5.5289	5.6415	558563.0
2012-07-02	AAP	Stock	68.4	68.4	67.33	67.67	1149500.0
2012-07-02	AAT	Stock	24.38	24.66	24.22	24.65	130500.0
2012-07-02	AAU-DELISTED	Stock	2.09	2.1	2.03	2.1	22871.0
2012-07-02	AAUAF-DELISTED	Stock	2.12	2.13	2.06	2.1	22980.0
2012-07-02	AAV-DELISTED	Stock	2.96	2.97	2.84	2.96	362362.0
2012-07-02	AAWW-DELISTED	Stock	43.75	44.3	43.13	44.26	147391.0
2012-07-02	AAXJ	Stock	52.51	52.65	52.2	52.58	200617.0
2012-07-02	AAXN-DELISTED	Stock	5.21	5.29	5.11	5.29	266827.0
2012-07-02	AB	Stock	12.74	12.87	12.59	12.8	234900.0
2012-07-02	ABAC-DELISTED	Stock	1.21	1.22	1.18	1.2	8050.0
2012-07-02	ABAX-DELISTED	Stock	37.18	38.97	37.06	38.94	136108.0
2012-07-02	ABB-DELISTED	Stock	16.47	16.47	16.24	16.42	2524875.0
2012-07-02	ABBNY-DELISTED	Stock	16.47	16.47	16.24	16.42	2609187.0
2012-07-02	ABC-DELISTED	Stock	39.67	39.87	39.4	39.845	1947331.0
2012-07-02	ABCB	Stock	12.63	12.78	12.47	12.67	48600.0
2012-07-02	ABCD-DELISTED	Stock	1.05	1.08	0.9515	0.99	16570.0
2012-07-02	ABCO-DELISTED	Stock	49.14	51.26	49.14	51.24	210081.0
2012-07-02	ABCW-DELISTED	Stock	0.45	0.45	0.45	0.45	350.0
2012-07-02	ABE-DELISTED	Stock	18.95	18.95	18.744	18.94	7873.0
2012-07-02	ABEO	Stock	737.5	812.5	737.5	812.5	3.0
2012-07-02	ABFS-DELISTED	Stock	12.66	12.71	12.12	12.3	371964.0
2012-07-02	ABG	Stock	23.9	24.89	23.64	24.89	633200.0
2012-07-02	ABM	Stock	19.38	19.5	18.95	19.26	681100.0
2012-07-02	ABMD-DELISTED	Stock	22.96	23.55	22.81	23.46	643545.0
2012-07-02	ABR	Stock	5.37	5.39	5.32	5.38	57000.0
2012-07-02	ABT	Stock	30.8128	31.0287	30.7072	31.0095	11760108.0
2012-07-02	ABTL-DELISTED	Stock	3.6	3.6317	3.48	3.6	10711.0
2012-07-02	ABUS	Stock	2.05	2.11	2.05	2.11	1600.0
2012-07-02	ABV-DELISTED	Stock	38.49	38.82	38.04	38.2	1902167.0
2012-07-02	ABX-DELISTED	Stock	37.66	37.91	37.08	37.46	4142283.0
2012-07-02	ACAD	Stock	1.75	1.85	1.71	1.81	539200.0
2012-07-02	ACAS-DELISTED	Stock	10.04	10.21	10.04	10.15	2623102.0
2012-07-02	ACAT-DELISTED	Stock	36.66	37.95	35.96	37.89	228083.0

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

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