PREVIEW / stock_daily / 2011-11-17

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-17.parquet
  size:    194 KB
  rows:    6,063
  symbols: 3,509

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-11-17	AAPL	Stock	13.7136	13.735	13.4107	13.4789	479900400.0
2011-11-17	MSFT	Stock	26.01	26.04	25.44	25.54	70977500.0
2011-11-17	NVDA	Stock	0.3638	0.3648	0.345	0.3515	657504000.0
2011-11-17	AMZN	Stock	10.6255	10.645	10.105	10.226	159662000.0
2011-11-17	TSLA	Stock	2.3	2.3267	2.2127	2.2453	20239500.0
2011-11-17	TLT	Stock	118.04	120.161	118.04	119.37	9907881.0
2011-11-17	ES	Stock	34.28	34.56	33.85	33.93	2325000.0
2011-11-17	CL	Stock	44.135	44.36	43.73	44.02	4001200.0
2011-11-17	A	Stock	27.4249	27.5823	26.3948	26.6166	6292118.0
2011-11-17	AABA-DELISTED	Stock	15.74	15.77	15.2	15.34	17327687.0
2011-11-17	AACC-DELISTED	Stock	3.0	3.0	2.85	3.0	45881.0
2011-11-17	AACG	Stock	9.7	9.75	9.7	9.75	3400.0
2011-11-17	AAIC-DELISTED	Stock	22.34	22.52	21.42	21.5	46784.0
2011-11-17	AAME	Stock	1.95	1.95	1.82	1.9	6600.0
2011-11-17	AAON	Stock	6.2341	6.3407	5.8904	6.2696	243338.0
2011-11-17	AAP	Stock	67.16	67.8	67.01	67.56	1288100.0
2011-11-17	AAT	Stock	20.79	21.34	20.33	20.48	296700.0
2011-11-17	AATI-DELISTED	Stock	4.245	4.26	4.22	4.22	775924.0
2011-11-17	AAU-DELISTED	Stock	2.71	2.71	2.5312	2.61	216152.0
2011-11-17	AAUAF-DELISTED	Stock	2.75	2.75	2.57	2.61	213271.0
2011-11-17	AAV-DELISTED	Stock	5.14	5.25	5.0085	5.04	263063.0
2011-11-17	AAWW-DELISTED	Stock	38.6	39.84	38.26	39.38	366334.0
2011-11-17	AAXJ	Stock	51.97	52.04	50.39	50.66	349348.0
2011-11-17	AAXN-DELISTED	Stock	5.71	5.86	5.704	5.77	628800.0
2011-11-17	AB	Stock	13.01	13.36	13.01	13.22	494400.0
2011-11-17	ABAC-DELISTED	Stock	1.9	1.98	1.9	1.97	9120.0
2011-11-17	ABAX-DELISTED	Stock	27.1	27.21	26.46	26.59	83169.0
2011-11-17	ABB-DELISTED	Stock	18.15	18.21	17.7	17.83	2972596.0
2011-11-17	ABBNY-DELISTED	Stock	18.15	18.21	17.7	17.82	2997796.0
2011-11-17	ABC-DELISTED	Stock	38.03	38.18	37.36	37.54	1958764.0
2011-11-17	ABCB	Stock	10.04	10.19	9.96	10.02	39700.0
2011-11-17	ABCD-DELISTED	Stock	3.04	3.1	2.97	2.99	31870.0
2011-11-17	ABCO-DELISTED	Stock	34.97	35.54	34.46	34.56	90909.0
2011-11-17	ABCW-DELISTED	Stock	0.48	0.5	0.47	0.49	43550.0
2011-11-17	ABD-DELISTED	Stock	8.31	8.88	7.81	8.81	4684880.0
2011-11-17	ABE-DELISTED	Stock	17.8117	17.9	17.58	17.9	14721.0
2011-11-17	ABEO	Stock	1687.5	1687.5	1625.0	1675.0	9.0
2011-11-17	ABFS-DELISTED	Stock	19.96	20.18	18.59	18.78	779733.0
2011-11-17	ABG	Stock	18.88	19.13	18.57	18.74	407400.0
2011-11-17	ABH-DELISTED	Stock	15.34	15.68	15.3	15.48	214147.0
2011-11-17	ABM	Stock	20.44	20.74	20.19	20.33	155900.0
2011-11-17	ABMD-DELISTED	Stock	18.73	19.27	18.66	18.74	221612.0
2011-11-17	ABR	Stock	3.72	3.72	3.6	3.6	17900.0
2011-11-17	ABT	Stock	25.7125	25.89	25.3766	25.6261	11980200.0
2011-11-17	ABTL-DELISTED	Stock	4.0549	4.0549	3.8577	3.9451	16494.0
2011-11-17	ABUS	Stock	1.73	1.73	1.58	1.62	13100.0
2011-11-17	ABV-DELISTED	Stock	33.47	33.77	32.9	33.19	1664212.0
2011-11-17	ABVA-DELISTED	Stock	5.12	5.2321	5.1	5.12	9656.0
2011-11-17	ABVT-DELISTED	Stock	58.61	59.18	57.13	57.88	95797.0
2011-11-17	ABX-DELISTED	Stock	50.86	51.12	49.2	49.29	7355392.0

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

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