PREVIEW / stock_daily / 2012-11-13

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-13.parquet
  size:    199 KB
  rows:    6,175
  symbols: 3,475

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-11-13	AAPL	Stock	19.2468	19.66	19.1557	19.3893	532949200.0
2012-11-13	MSFT	Stock	27.02	27.3	26.75	27.09	131689200.0
2012-11-13	NVDA	Stock	0.2965	0.3032	0.2955	0.2958	492120000.0
2012-11-13	AMZN	Stock	11.256	11.395	11.2355	11.33	52596000.0
2012-11-13	META	Stock	19.61	20.11	19.56	19.86	71775100.0
2012-11-13	TSLA	Stock	2.086	2.1333	2.048	2.1073	14974500.0
2012-11-13	TLT	Stock	126.8	126.82	125.99	126.61	2863861.0
2012-11-13	ES	Stock	37.83	38.44	37.75	38.23	1136800.0
2012-11-13	CL	Stock	51.97	52.695	51.9	52.14	3007800.0
2012-11-13	A	Stock	26.2232	26.3591	25.9585	25.9871	4949759.0
2012-11-13	AABA-DELISTED	Stock	17.42	17.85	17.38	17.84	28344908.0
2012-11-13	AACC-DELISTED	Stock	5.23	5.35	4.8	5.07	7137.0
2012-11-13	AACG	Stock	4.65	4.8	4.64	4.75	5700.0
2012-11-13	AAIC-DELISTED	Stock	20.43	20.47	19.8	19.84	231803.0
2012-11-13	AAME	Stock	2.91	2.92	2.9	2.92	2200.0
2012-11-13	AAMRQ-DELISTED	Stock	0.3785	0.383	0.3625	0.371	676277.0
2012-11-13	AAON	Stock	5.7748	5.7956	5.6948	5.7393	110025.0
2012-11-13	AAP	Stock	78.01	80.56	78.01	79.27	1464200.0
2012-11-13	AAT	Stock	27.48	27.5	26.96	27.1	110100.0
2012-11-13	AAU-DELISTED	Stock	2.63	2.6685	2.5	2.55	102951.0
2012-11-13	AAUAF-DELISTED	Stock	2.63	2.6685	2.5	2.56	103351.0
2012-11-13	AAV-DELISTED	Stock	3.37	3.44	3.32	3.4	176405.0
2012-11-13	AAWW-DELISTED	Stock	42.46	42.76	41.45	41.52	468947.0
2012-11-13	AAXJ	Stock	55.86	56.39	55.86	56.09	272399.0
2012-11-13	AAXN-DELISTED	Stock	7.91	8.05	7.83	7.95	470150.0
2012-11-13	AB	Stock	16.48	16.88	16.26	16.6	501500.0
2012-11-13	ABAC-DELISTED	Stock	0.9	0.98	0.9	0.97	17738.0
2012-11-13	ABAX-DELISTED	Stock	35.96	36.7	35.59	35.9	79108.0
2012-11-13	ABB-DELISTED	Stock	17.9	18.17	17.88	18.0	2667654.0
2012-11-13	ABBNY-DELISTED	Stock	17.9	18.17	17.88	17.99	3002465.0
2012-11-13	ABC-DELISTED	Stock	40.0	40.99	39.9	40.71	2836232.0
2012-11-13	ABCB	Stock	10.49	10.62	10.26	10.52	21900.0
2012-11-13	ABCD-DELISTED	Stock	0.9	0.9	0.81	0.81	1600.0
2012-11-13	ABCO-DELISTED	Stock	45.71	46.85	45.6	46.54	254678.0
2012-11-13	ABCW-DELISTED	Stock	0.4	0.43	0.38	0.43	29858.0
2012-11-13	ABE-DELISTED	Stock	20.0	20.02	19.84	20.02	417196.0
2012-11-13	ABEO	Stock	337.5	337.5	325.0	337.5	29.0
2012-11-13	ABFS-DELISTED	Stock	7.19	7.39	7.15	7.19	213458.0
2012-11-13	ABG	Stock	28.94	29.68	28.94	29.22	229500.0
2012-11-13	ABM	Stock	18.84	19.01	18.78	18.84	368300.0
2012-11-13	ABMD-DELISTED	Stock	13.56	13.73	13.47	13.53	585372.0
2012-11-13	ABR	Stock	5.31	5.5	5.24	5.24	212000.0
2012-11-13	ABT	Stock	31.0095	31.3645	31.0047	31.0335	12303668.0
2012-11-13	ABTL-DELISTED	Stock	4.05	4.1403	3.898	4.11	15348.0
2012-11-13	ABUS	Stock	6.45	6.78	5.56	5.6	1123400.0
2012-11-13	ABV-DELISTED	Stock	39.11	39.735	38.9	39.41	1834950.0
2012-11-13	ABVA-DELISTED	Stock	4.4199	4.75	4.4	4.74	11100.0
2012-11-13	ABX-DELISTED	Stock	35.36	35.67	35.25	35.28	6099182.0
2012-11-13	ACAD	Stock	2.12	2.2	2.1	2.11	1235300.0
2012-11-13	ACAS-DELISTED	Stock	11.49	11.66	11.33	11.575	3499385.0

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

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