PREVIEW / stock_daily / 2012-11-15

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-15.parquet
  size:    201 KB
  rows:    6,218
  symbols: 3,503

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-15	AAPL	Stock	19.1975	19.2679	18.665	18.7721	789910800.0
2012-11-15	MSFT	Stock	26.88	26.97	26.63	26.66	50955600.0
2012-11-15	NVDA	Stock	0.2902	0.2978	0.2878	0.2898	466688000.0
2012-11-15	AMZN	Stock	11.115	11.258	10.909	11.03	68094000.0
2012-11-15	META	Stock	22.34	22.5	21.65	22.17	78857700.0
2012-11-15	TSLA	Stock	2.0867	2.096	2.0333	2.0547	14760000.0
2012-11-15	TLT	Stock	126.1	127.02	126.0	126.4844	5550929.0
2012-11-15	ES	Stock	38.0	38.34	37.64	37.86	1506900.0
2012-11-15	CL	Stock	51.67	52.075	51.625	51.885	2772600.0
2012-11-15	A	Stock	25.8512	26.2089	25.5293	25.5722	7306088.0
2012-11-15	AABA-DELISTED	Stock	17.82	18.16	17.74	17.9	34796145.0
2012-11-15	AACC-DELISTED	Stock	4.63	4.63	4.28	4.39	28777.0
2012-11-15	AACG	Stock	4.65	4.65	4.48	4.62	7400.0
2012-11-15	AAIC-DELISTED	Stock	18.37	19.49	18.37	19.44	226663.0
2012-11-15	AAME	Stock	2.9	2.92	2.89	2.92	5000.0
2012-11-15	AAMRQ-DELISTED	Stock	0.38	0.38	0.375	0.376	532864.0
2012-11-15	AAON	Stock	5.6326	5.8963	5.5704	5.6059	257175.0
2012-11-15	AAP	Stock	77.49	78.05	76.77	77.5	937700.0
2012-11-15	AAT	Stock	26.16	26.47	24.87	26.03	131500.0
2012-11-15	AAU-DELISTED	Stock	2.54	2.54	2.5	2.5	217979.0
2012-11-15	AAUAF-DELISTED	Stock	2.54	2.54	2.5	2.5	222846.0
2012-11-15	AAV-DELISTED	Stock	3.33	3.37	3.25	3.32	199363.0
2012-11-15	AAWW-DELISTED	Stock	40.3	40.66	39.3	40.4	180877.0
2012-11-15	AAXJ	Stock	55.62	55.82	55.3806	55.68	159530.0
2012-11-15	AAXN-DELISTED	Stock	7.86	7.94	7.55	7.67	656726.0
2012-11-15	AB	Stock	16.39	16.61	15.75	15.86	385800.0
2012-11-15	ABAC-DELISTED	Stock	0.83	0.83	0.82	0.82	7227.0
2012-11-15	ABAX-DELISTED	Stock	35.37	35.85	34.58	34.98	122849.0
2012-11-15	ABB-DELISTED	Stock	17.92	17.98	17.7	17.76	2589925.0
2012-11-15	ABBNY-DELISTED	Stock	17.92	17.98	17.7	17.75	2668630.0
2012-11-15	ABC-DELISTED	Stock	40.15	40.36	39.9	40.16	2213787.0
2012-11-15	ABCB	Stock	10.46	10.7	10.45	10.5	19500.0
2012-11-15	ABCD-DELISTED	Stock	0.84	0.9	0.84	0.9	4000.0
2012-11-15	ABCO-DELISTED	Stock	45.29	45.31	44.51	44.87	150941.0
2012-11-15	ABCW-DELISTED	Stock	0.3801	0.43	0.38	0.43	20091.0
2012-11-15	ABE-DELISTED	Stock	19.2151	19.568	19.2151	19.5	13029.0
2012-11-15	ABEO	Stock	312.5	312.5	300.0	312.5	67.0
2012-11-15	ABFS-DELISTED	Stock	6.92	6.999	6.48	6.57	516785.0
2012-11-15	ABG	Stock	27.7	28.55	27.6	28.43	224600.0
2012-11-15	ABM	Stock	18.71	18.73	18.22	18.27	165100.0
2012-11-15	ABMD-DELISTED	Stock	13.51	13.93	13.4	13.88	721605.0
2012-11-15	ABR	Stock	5.13	5.13	4.96	5.0	294800.0
2012-11-15	ABT	Stock	30.6256	30.6784	30.1938	30.3234	13172363.0
2012-11-15	ABTL-DELISTED	Stock	4.05	4.05	3.8748	3.96	735.0
2012-11-15	ABUS	Stock	5.82	5.82	5.25	5.32	96700.0
2012-11-15	ABV-DELISTED	Stock	39.31	39.5008	38.8	39.3	1457316.0
2012-11-15	ABVA-DELISTED	Stock	4.39	4.39	4.3501	4.3501	1150.0
2012-11-15	ABX-DELISTED	Stock	34.02	34.03	33.03	33.24	10925096.0
2012-11-15	ACAD	Stock	1.94	2.0	1.8	1.95	1581700.0
2012-11-15	ACAS-DELISTED	Stock	11.21	11.49	11.17	11.43	5204383.0

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

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